PREVIEW / etf_30min / 2014-10-20

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-20.parquet
  size:    365 KB
  rows:    12,166

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-10-20 04:00:00	SPY	ETF	188.9	189.38	188.88	189.38	15479.0
2014-10-20 04:30:00	SPY	ETF	189.2	189.24	188.75	188.75	4040.0
2014-10-20 05:00:00	SPY	ETF	188.81	189.23	188.77	189.19	42530.0
2014-10-20 05:30:00	SPY	ETF	189.08	189.26	189.04	189.09	9928.0
2014-10-20 06:00:00	SPY	ETF	189.19	189.2	188.9	188.95	112295.0
2014-10-20 06:30:00	SPY	ETF	188.94	189.11	188.44	188.44	305826.0
2014-10-20 07:00:00	SPY	ETF	188.44	188.68	187.94	188.12	1025835.0
2014-10-20 07:30:00	SPY	ETF	188.12	188.5	188.1	188.14	568983.0
2014-10-20 08:00:00	SPY	ETF	188.15	189.0284	188.1	188.48	894326.0
2014-10-20 08:30:00	SPY	ETF	188.48	188.72	188.35	188.46	800583.0
2014-10-20 09:00:00	SPY	ETF	188.48	189.44	187.86	188.13	1920583.0
2014-10-20 09:30:00	SPY	ETF	188.13	189.15	188.07	188.9799	18168118.0
2014-10-20 10:00:00	SPY	ETF	188.98	189.46	188.53	189.23	14779474.0
2014-10-20 10:30:00	SPY	ETF	189.23	189.5	189.001	189.13	8366624.0
2014-10-20 11:00:00	SPY	ETF	189.13	189.58	188.895	189.38	6363553.0
2014-10-20 11:30:00	SPY	ETF	189.39	189.47	189.11	189.3967	6133108.0
2014-10-20 12:00:00	SPY	ETF	189.39	189.64	189.33	189.39	5081792.0
2014-10-20 12:30:00	SPY	ETF	189.38	189.43	189.05	189.14	4351074.0
2014-10-20 13:00:00	SPY	ETF	189.1399	189.74	189.05	189.645	4556965.0
2014-10-20 13:30:00	SPY	ETF	189.645	189.71	189.43	189.54	4186204.0
2014-10-20 14:00:00	SPY	ETF	189.53	190.03	189.515	189.8	4855076.0
2014-10-20 14:30:00	SPY	ETF	189.8	190.0	189.75	189.97	4347946.0
2014-10-20 15:00:00	SPY	ETF	189.97	190.33	189.93	190.01	9210380.0
2014-10-20 15:30:00	SPY	ETF	190.0	190.45	189.98	190.32	13583330.0
2014-10-20 16:00:00	SPY	ETF	190.32	191.0	188.4955	190.58	7770223.0
2014-10-20 16:30:00	SPY	ETF	190.62	190.82	190.3	190.77	1525793.0
2014-10-20 17:00:00	SPY	ETF	190.75	191.0	189.34	190.89	216724.0
2014-10-20 17:30:00	SPY	ETF	190.88	190.97	190.87	190.93	204770.0
2014-10-20 18:00:00	SPY	ETF	190.93	190.93	190.81	190.89	135143.0
2014-10-20 18:30:00	SPY	ETF	190.87	190.89	190.78	190.8	14622.0
2014-10-20 19:00:00	SPY	ETF	190.78	190.89	190.76	190.81	28407.0
2014-10-20 19:30:00	SPY	ETF	190.81	190.81	190.4	190.47	224304.0
2014-10-20 04:00:00	QQQ	ETF	93.29	93.29	93.29	93.29	100.0
2014-10-20 04:30:00	QQQ	ETF	93.3	93.3	93.3	93.3	200.0
2014-10-20 05:00:00	QQQ	ETF	93.23	93.34	93.22	93.34	4700.0
2014-10-20 05:30:00	QQQ	ETF	93.37	93.37	93.37	93.37	2200.0
2014-10-20 06:00:00	QQQ	ETF	93.34	93.34	93.25	93.25	12800.0
2014-10-20 06:30:00	QQQ	ETF	93.28	93.28	93.11	93.14	2500.0
2014-10-20 07:00:00	QQQ	ETF	93.04	93.08	92.62	92.85	392669.0
2014-10-20 07:30:00	QQQ	ETF	92.85	93.03	92.83	92.89	191824.0
2014-10-20 08:00:00	QQQ	ETF	92.92	93.16	92.77	92.98	135826.0
2014-10-20 08:30:00	QQQ	ETF	93.03	93.2	92.99	93.11	281474.0
2014-10-20 09:00:00	QQQ	ETF	93.11	93.11	92.76	92.96	532716.0
2014-10-20 09:30:00	QQQ	ETF	92.96	93.52	92.8	93.46	6226026.0
2014-10-20 10:00:00	QQQ	ETF	93.46	93.82	93.32	93.69	5694423.0
2014-10-20 10:30:00	QQQ	ETF	93.69	93.81	93.48	93.65	2594961.0
2014-10-20 11:00:00	QQQ	ETF	93.65	93.77	93.47	93.74	1609489.0
2014-10-20 11:30:00	QQQ	ETF	93.749	93.76	93.55	93.7	1174085.0
2014-10-20 12:00:00	QQQ	ETF	93.69	93.93	93.68	93.8	1179458.0
2014-10-20 12:30:00	QQQ	ETF	93.8	93.86	93.67	93.71	1109000.0

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

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