PREVIEW / etf_30min / 2014-09-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-03.parquet
  size:    355 KB
  rows:    12,187

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-09-03 04:00:00	SPY	ETF	200.8	201.65	200.8	201.65	32183.0
2014-09-03 04:30:00	SPY	ETF	201.54	201.71	201.0	201.0	20842.0
2014-09-03 05:00:00	SPY	ETF	201.35	201.38	201.18	201.18	23557.0
2014-09-03 05:30:00	SPY	ETF	201.23	201.3	201.18	201.25	12613.0
2014-09-03 06:00:00	SPY	ETF	201.26	201.4	201.26	201.32	31696.0
2014-09-03 06:30:00	SPY	ETF	201.32	201.44	201.32	201.38	24536.0
2014-09-03 07:00:00	SPY	ETF	201.41	201.44	201.24	201.28	224082.0
2014-09-03 07:30:00	SPY	ETF	201.23	201.23	201.08	201.15	188722.0
2014-09-03 08:00:00	SPY	ETF	201.15	201.41	201.1	201.25	384358.0
2014-09-03 08:30:00	SPY	ETF	201.25	201.29	200.61	201.28	848403.0
2014-09-03 09:00:00	SPY	ETF	201.29	201.46	201.26	201.38	935684.0
2014-09-03 09:30:00	SPY	ETF	201.38	201.41	201.07	201.13	8306935.0
2014-09-03 10:00:00	SPY	ETF	201.12	201.24	200.86	200.96	4205142.0
2014-09-03 10:30:00	SPY	ETF	200.965	201.14	200.93	201.03	3516912.0
2014-09-03 11:00:00	SPY	ETF	201.03	201.099	200.58	200.595	3380567.0
2014-09-03 11:30:00	SPY	ETF	200.61	200.73	200.38	200.4064	4368543.0
2014-09-03 12:00:00	SPY	ETF	200.4	200.7	200.32	200.65	4532179.0
2014-09-03 12:30:00	SPY	ETF	200.65	201.15	200.6	200.775	3171735.0
2014-09-03 13:00:00	SPY	ETF	200.78	200.86	200.7	200.82	1752067.0
2014-09-03 13:30:00	SPY	ETF	200.82	200.89	200.58	200.74	2440380.0
2014-09-03 14:00:00	SPY	ETF	200.7338	200.77	200.5	200.6	2024725.0
2014-09-03 14:30:00	SPY	ETF	200.6	200.68	200.35	200.36	2881182.0
2014-09-03 15:00:00	SPY	ETF	200.35	200.54	200.22	200.44	3504692.0
2014-09-03 15:30:00	SPY	ETF	200.435	200.56	200.305	200.51	6552978.0
2014-09-03 16:00:00	SPY	ETF	200.52	200.67	200.43	200.47	3396752.0
2014-09-03 16:30:00	SPY	ETF	200.45	200.48	200.43	200.48	161577.0
2014-09-03 17:00:00	SPY	ETF	200.48	200.5	200.43	200.5	54231.0
2014-09-03 17:30:00	SPY	ETF	200.5	200.5	200.46	200.47	8747.0
2014-09-03 18:00:00	SPY	ETF	200.48	200.51	200.48	200.51	1825.0
2014-09-03 18:30:00	SPY	ETF	200.5	200.52	200.48	200.52	38487.0
2014-09-03 19:00:00	SPY	ETF	200.52	200.52	200.46	200.48	30100.0
2014-09-03 19:30:00	SPY	ETF	200.47	200.48	200.44	200.44	11925.0
2014-09-03 04:00:00	QQQ	ETF	100.25	100.49	100.25	100.48	26400.0
2014-09-03 04:30:00	QQQ	ETF	100.52	100.53	100.52	100.52	13320.0
2014-09-03 05:30:00	QQQ	ETF	100.35	100.35	100.34	100.34	45700.0
2014-09-03 06:00:00	QQQ	ETF	100.4	100.4	100.4	100.4	5000.0
2014-09-03 06:30:00	QQQ	ETF	100.39	100.43	100.39	100.42	5200.0
2014-09-03 07:00:00	QQQ	ETF	100.44	100.44	100.29	100.29	36251.0
2014-09-03 07:30:00	QQQ	ETF	100.29	100.32	100.28	100.32	16355.0
2014-09-03 08:00:00	QQQ	ETF	100.44	100.44	100.3	100.34	62415.0
2014-09-03 08:30:00	QQQ	ETF	100.32	100.34	100.07	100.34	260996.0
2014-09-03 09:00:00	QQQ	ETF	100.34	100.41	100.3	100.33	264781.0
2014-09-03 09:30:00	QQQ	ETF	100.32	100.34	99.95	100.03	4512520.0
2014-09-03 10:00:00	QQQ	ETF	100.01	100.12	99.83	99.8772	1855794.0
2014-09-03 10:30:00	QQQ	ETF	99.875	99.978	99.85	99.88	1313688.0
2014-09-03 11:00:00	QQQ	ETF	99.89	99.92	99.58	99.58	2235675.0
2014-09-03 11:30:00	QQQ	ETF	99.59	99.65	99.36	99.4	2617085.0
2014-09-03 12:00:00	QQQ	ETF	99.41	99.57	99.34	99.55	1930591.0
2014-09-03 12:30:00	QQQ	ETF	99.55	99.7099	99.51	99.67	1425471.0
2014-09-03 13:00:00	QQQ	ETF	99.67	99.73	99.58	99.6963	514093.0

> showing 50 of 12,187 rows — these rows as CSV

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