PREVIEW / etf_30min / 2016-09-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-19.parquet
  size:    392 KB
  rows:    13,430

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
2016-09-19 04:00:00	SPY	ETF	214.28	214.45	214.2	214.4	24547.0
2016-09-19 04:30:00	SPY	ETF	214.42	214.6	214.41	214.45	9719.0
2016-09-19 05:00:00	SPY	ETF	214.42	214.63	214.42	214.63	6450.0
2016-09-19 05:30:00	SPY	ETF	214.53	214.53	214.43	214.43	7516.0
2016-09-19 06:00:00	SPY	ETF	214.43	214.43	214.35	214.36	92140.0
2016-09-19 06:30:00	SPY	ETF	214.37	214.42	214.35	214.35	14330.0
2016-09-19 07:00:00	SPY	ETF	214.34	214.43	214.25	214.41	200534.0
2016-09-19 07:30:00	SPY	ETF	214.4	214.55	214.37	214.47	112435.0
2016-09-19 08:00:00	SPY	ETF	214.46	214.52	214.26	214.49	216055.0
2016-09-19 08:30:00	SPY	ETF	214.5	214.55	214.34	214.36	228022.0
2016-09-19 09:00:00	SPY	ETF	214.36	214.37	214.09	214.12	450052.0
2016-09-19 09:30:00	SPY	ETF	214.13	214.81	214.1	214.7759	7844052.0
2016-09-19 10:00:00	SPY	ETF	214.78	214.88	214.5	214.58	6439558.0
2016-09-19 10:30:00	SPY	ETF	214.575	214.67	214.26	214.37	3223387.0
2016-09-19 11:00:00	SPY	ETF	214.3692	214.51	214.27	214.41	3177819.0
2016-09-19 11:30:00	SPY	ETF	214.41	214.59	214.295	214.535	2385223.0
2016-09-19 12:00:00	SPY	ETF	214.54	214.585	213.715	213.8894	5420405.0
2016-09-19 12:30:00	SPY	ETF	213.89	213.989	213.63	213.6799	2830871.0
2016-09-19 13:00:00	SPY	ETF	213.67	213.85	213.54	213.625	3144388.0
2016-09-19 13:30:00	SPY	ETF	213.62	213.63	213.03	213.531	6411526.0
2016-09-19 14:00:00	SPY	ETF	213.53	213.89	213.48	213.83	4104322.0
2016-09-19 14:30:00	SPY	ETF	213.825	214.1452	213.8	214.1158	5504840.0
2016-09-19 15:00:00	SPY	ETF	214.12	214.14	213.54	213.609	6899770.0
2016-09-19 15:30:00	SPY	ETF	213.605	213.72	213.2899	213.39	15736706.0
2016-09-19 16:00:00	SPY	ETF	213.4	213.6	213.36	213.58	3483128.0
2016-09-19 16:30:00	SPY	ETF	213.59	213.65	213.41	213.61	463681.0
2016-09-19 17:00:00	SPY	ETF	213.61	213.62	213.57	213.62	36971.0
2016-09-19 17:30:00	SPY	ETF	213.62	213.64	213.62	213.63	36638.0
2016-09-19 18:00:00	SPY	ETF	213.65	213.66	213.6	213.61	38692.0
2016-09-19 18:30:00	SPY	ETF	213.61	213.63	213.56	213.58	7378.0
2016-09-19 19:00:00	SPY	ETF	213.58	213.71	213.58	213.65	16562.0
2016-09-19 19:30:00	SPY	ETF	213.65	213.67	213.37	213.42	62101.0
2016-09-19 04:00:00	QQQ	ETF	117.7	117.86	117.7	117.86	1305.0
2016-09-19 05:00:00	QQQ	ETF	117.82	117.93	117.82	117.93	2799.0
2016-09-19 05:30:00	QQQ	ETF	117.86	117.86	117.82	117.82	1200.0
2016-09-19 06:00:00	QQQ	ETF	117.78	117.78	117.77	117.77	299.0
2016-09-19 06:30:00	QQQ	ETF	117.75	117.75	117.72	117.72	900.0
2016-09-19 07:00:00	QQQ	ETF	117.73	117.73	117.66	117.72	104697.0
2016-09-19 07:30:00	QQQ	ETF	117.72	117.76	117.71	117.74	18339.0
2016-09-19 08:00:00	QQQ	ETF	117.71	117.74	117.7	117.73	5680.0
2016-09-19 08:30:00	QQQ	ETF	117.77	117.78	117.64	117.67	30015.0
2016-09-19 09:00:00	QQQ	ETF	117.66	117.67	117.56	117.56	87365.0
2016-09-19 09:30:00	QQQ	ETF	117.565	117.9293	117.56	117.92	1962800.0
2016-09-19 10:00:00	QQQ	ETF	117.92	117.95	117.55	117.61	1215200.0
2016-09-19 10:30:00	QQQ	ETF	117.61	117.68	117.26	117.33	936153.0
2016-09-19 11:00:00	QQQ	ETF	117.34	117.48	117.2762	117.42	829829.0
2016-09-19 11:30:00	QQQ	ETF	117.43	117.53	117.35	117.51	551079.0
2016-09-19 12:00:00	QQQ	ETF	117.5007	117.53	116.91	117.05	1286227.0
2016-09-19 12:30:00	QQQ	ETF	117.03	117.1	116.92	116.94	528840.0
2016-09-19 13:00:00	QQQ	ETF	116.92	117.05	116.84	116.91	495623.0

> showing 50 of 13,430 rows — these rows as CSV

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