PREVIEW / etf_30min / 2014-03-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-18.parquet
  size:    342 KB
  rows:    11,363

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
2014-03-18 04:00:00	SPY	ETF	186.24	186.26	186.0	186.01	50850.0
2014-03-18 04:30:00	SPY	ETF	185.91	186.07	185.87	186.05	10400.0
2014-03-18 05:00:00	SPY	ETF	185.99	186.05	185.91	185.95	17019.0
2014-03-18 05:30:00	SPY	ETF	185.92	186.0	185.92	185.95	8830.0
2014-03-18 06:00:00	SPY	ETF	185.93	186.15	185.91	186.11	28462.0
2014-03-18 06:30:00	SPY	ETF	186.07	186.29	185.89	185.9	34874.0
2014-03-18 07:00:00	SPY	ETF	185.93	186.15	185.78	186.15	193574.0
2014-03-18 07:30:00	SPY	ETF	186.17	187.13	186.17	186.96	1271504.0
2014-03-18 08:00:00	SPY	ETF	187.06	187.07	185.9	186.9	651239.0
2014-03-18 08:30:00	SPY	ETF	186.91	187.05	186.82	186.82	552990.0
2014-03-18 09:00:00	SPY	ETF	186.82	186.86	186.6	186.68	1278231.0
2014-03-18 09:30:00	SPY	ETF	186.71	187.27	186.51	187.17	13396034.0
2014-03-18 10:00:00	SPY	ETF	187.18	187.66	187.03	187.62	8949276.0
2014-03-18 10:30:00	SPY	ETF	187.63	187.74	187.17	187.23	10419674.0
2014-03-18 11:00:00	SPY	ETF	187.22	187.58	187.19	187.55	6494142.0
2014-03-18 11:30:00	SPY	ETF	187.55	187.66	187.25	187.565	5249880.0
2014-03-18 12:00:00	SPY	ETF	187.57	187.68	187.34	187.41	4294605.0
2014-03-18 12:30:00	SPY	ETF	187.41	187.51	187.28	187.46	6389712.0
2014-03-18 13:00:00	SPY	ETF	187.46	187.72	187.39	187.66	4443503.0
2014-03-18 13:30:00	SPY	ETF	187.66	187.89	187.56	187.74	5393196.0
2014-03-18 14:00:00	SPY	ETF	187.747	187.81	187.65	187.785	3852584.0
2014-03-18 14:30:00	SPY	ETF	187.781	187.91	187.69	187.819	4298750.0
2014-03-18 15:00:00	SPY	ETF	187.81	187.84	187.64	187.7	3553335.0
2014-03-18 15:30:00	SPY	ETF	187.7	187.77	187.55	187.69	12544861.0
2014-03-18 16:00:00	SPY	ETF	187.69	187.8318	186.395	187.56	6677934.0
2014-03-18 16:30:00	SPY	ETF	187.59	187.67	187.59	187.63	312502.0
2014-03-18 17:00:00	SPY	ETF	187.61	187.66	187.61	187.65	8308.0
2014-03-18 17:30:00	SPY	ETF	187.65	187.66	186.395	187.63	507890.0
2014-03-18 18:00:00	SPY	ETF	187.63	187.63	187.48	187.5	96008.0
2014-03-18 18:30:00	SPY	ETF	187.5	187.53	187.45	187.53	43206.0
2014-03-18 19:00:00	SPY	ETF	187.53	187.58	187.52	187.58	11721.0
2014-03-18 19:30:00	SPY	ETF	187.59	187.69	187.59	187.69	26680.0
2014-03-18 04:00:00	QQQ	ETF	89.35	89.35	89.35	89.35	17000.0
2014-03-18 04:30:00	QQQ	ETF	89.19	89.19	89.19	89.19	1100.0
2014-03-18 05:00:00	QQQ	ETF	89.24	89.25	89.19	89.19	18800.0
2014-03-18 05:30:00	QQQ	ETF	89.22	89.22	89.22	89.22	200.0
2014-03-18 06:00:00	QQQ	ETF	89.17	89.3	89.17	89.3	2550.0
2014-03-18 06:30:00	QQQ	ETF	89.3	89.39	89.25	89.25	11600.0
2014-03-18 07:00:00	QQQ	ETF	89.19	89.23	89.15	89.23	13200.0
2014-03-18 07:30:00	QQQ	ETF	89.4	89.76	89.35	89.7	36500.0
2014-03-18 08:00:00	QQQ	ETF	89.7	89.77	89.19	89.66	35725.0
2014-03-18 08:30:00	QQQ	ETF	89.67	89.73	89.64	89.64	34379.0
2014-03-18 09:00:00	QQQ	ETF	89.64	89.66	89.45	89.54	272914.0
2014-03-18 09:30:00	QQQ	ETF	89.54	90.0699	89.53	90.02	4800754.0
2014-03-18 10:00:00	QQQ	ETF	90.03	90.28	89.93	90.24	3172855.0
2014-03-18 10:30:00	QQQ	ETF	90.25	90.33	90.15	90.19	2882836.0
2014-03-18 11:00:00	QQQ	ETF	90.2	90.39	90.18	90.3599	1756455.0
2014-03-18 11:30:00	QQQ	ETF	90.36	90.4	90.23	90.385	1380824.0
2014-03-18 12:00:00	QQQ	ETF	90.38	90.47	90.3032	90.34	1567161.0
2014-03-18 12:30:00	QQQ	ETF	90.34	90.39	90.27	90.35	726561.0

> showing 50 of 11,363 rows — these rows as CSV

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