PREVIEW / etf_30min / 2011-01-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-20.parquet
  size:    283 KB
  rows:    9,332

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-01-20 04:00:00	SPY	ETF	128.05	128.36	128.05	128.36	1650.0
2011-01-20 04:30:00	SPY	ETF	128.21	128.21	128.21	128.21	200.0
2011-01-20 05:00:00	SPY	ETF	128.23	128.23	128.14	128.14	800.0
2011-01-20 05:30:00	SPY	ETF	128.12	128.12	128.02	128.02	1600.0
2011-01-20 06:00:00	SPY	ETF	127.96	128.14	127.89	128.09	13500.0
2011-01-20 06:30:00	SPY	ETF	128.01	128.1	127.99	128.1	14070.0
2011-01-20 07:00:00	SPY	ETF	128.04	128.17	127.78	127.85	135827.0
2011-01-20 07:30:00	SPY	ETF	127.84	128.06	127.8	127.83	349415.0
2011-01-20 08:00:00	SPY	ETF	127.81	128.01	127.8	127.85	896608.0
2011-01-20 08:30:00	SPY	ETF	127.86	128.27	127.86	128.21	1519676.0
2011-01-20 09:00:00	SPY	ETF	128.22	128.23	127.91	127.96	1432284.0
2011-01-20 09:30:00	SPY	ETF	127.96	128.08	127.48	128.0	23247763.0
2011-01-20 10:00:00	SPY	ETF	128.0	128.2	127.43	127.65	19883129.0
2011-01-20 10:30:00	SPY	ETF	127.66	127.75	127.22	127.28	15003612.0
2011-01-20 11:00:00	SPY	ETF	127.29	127.49	127.18	127.28	10905155.0
2011-01-20 11:30:00	SPY	ETF	127.28	127.52	127.13	127.505	9744528.0
2011-01-20 12:00:00	SPY	ETF	127.5072	127.77	127.5	127.6677	8011318.0
2011-01-20 12:30:00	SPY	ETF	127.66	127.93	127.6302	127.88	5668746.0
2011-01-20 13:00:00	SPY	ETF	127.88	127.88	127.62	127.6838	5674952.0
2011-01-20 13:30:00	SPY	ETF	127.69	128.0	127.68	127.999	5862396.0
2011-01-20 14:00:00	SPY	ETF	127.99	128.25	127.925	128.16	9552100.0
2011-01-20 14:30:00	SPY	ETF	128.16	128.4	128.15	128.25	11407409.0
2011-01-20 15:00:00	SPY	ETF	128.25	128.26	127.89	127.93	12191123.0
2011-01-20 15:30:00	SPY	ETF	127.93	128.1	127.79	128.09	20633960.0
2011-01-20 16:00:00	SPY	ETF	128.1	128.3	127.25	128.03	7738248.0
2011-01-20 16:30:00	SPY	ETF	128.03	128.2264	127.9602	128.14	3661821.0
2011-01-20 17:00:00	SPY	ETF	128.14	128.17	128.12	128.14	306499.0
2011-01-20 17:30:00	SPY	ETF	128.08	128.13	128.08	128.12	5672.0
2011-01-20 18:00:00	SPY	ETF	128.12	128.14	128.05	128.07	35140.0
2011-01-20 18:30:00	SPY	ETF	128.09	128.14	127.98	127.98	68569.0
2011-01-20 19:00:00	SPY	ETF	127.98	127.98	127.86	127.93	71795.0
2011-01-20 19:30:00	SPY	ETF	127.92	127.92	127.8	127.84	71660.0
2011-01-20 04:00:00	QQQ	ETF	56.37	56.37	56.37	56.37	2000.0
2011-01-20 05:00:00	QQQ	ETF	56.34	56.34	56.34	56.34	6000.0
2011-01-20 05:30:00	QQQ	ETF	56.39	56.39	56.32	56.32	3500.0
2011-01-20 06:00:00	QQQ	ETF	56.28	56.33	56.25	56.25	3500.0
2011-01-20 06:30:00	QQQ	ETF	56.3	56.3	56.3	56.3	2500.0
2011-01-20 07:00:00	QQQ	ETF	56.28	56.32	56.2	56.2	94671.0
2011-01-20 07:30:00	QQQ	ETF	56.23	56.3	56.2	56.21	186835.0
2011-01-20 08:00:00	QQQ	ETF	56.21	56.28	56.2	56.22	181701.0
2011-01-20 08:30:00	QQQ	ETF	56.24	56.38	56.04	56.38	572421.0
2011-01-20 09:00:00	QQQ	ETF	56.38	56.38	56.25	56.31	330300.0
2011-01-20 09:30:00	QQQ	ETF	56.3	56.35	56.04	56.16	12873139.0
2011-01-20 10:00:00	QQQ	ETF	56.16	56.24	55.97	56.09	9187648.0
2011-01-20 10:30:00	QQQ	ETF	56.09	56.13	55.79	55.83	7723180.0
2011-01-20 11:00:00	QQQ	ETF	55.83	55.9	55.73	55.76	4192616.0
2011-01-20 11:30:00	QQQ	ETF	55.76	55.86	55.68	55.841	3824639.0
2011-01-20 12:00:00	QQQ	ETF	55.84	55.96	55.82	55.92	4700570.0
2011-01-20 12:30:00	QQQ	ETF	55.92	56.02	55.91	56.0	2551142.0
2011-01-20 13:00:00	QQQ	ETF	56.0	56.01	55.85	55.87	3752746.0

> showing 50 of 9,332 rows — these rows as CSV

> unlock the full archive -- $79 one-time