PREVIEW / etf_30min / 2017-12-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-20.parquet
  size:    456 KB
  rows:    15,880

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
2017-12-20 04:00:00	SPY	ETF	267.83	268.05	267.83	268.05	5600.0
2017-12-20 04:30:00	SPY	ETF	268.05	268.06	267.98	267.98	10800.0
2017-12-20 05:00:00	SPY	ETF	267.98	268.05	267.95	268.0	6933.0
2017-12-20 05:30:00	SPY	ETF	268.0	268.1	268.0	268.1	7750.0
2017-12-20 06:00:00	SPY	ETF	268.05	268.05	267.86	267.88	15712.0
2017-12-20 06:30:00	SPY	ETF	267.93	268.0	267.93	268.0	1789.0
2017-12-20 07:00:00	SPY	ETF	268.03	268.12	268.0	268.05	104705.0
2017-12-20 07:30:00	SPY	ETF	268.05	268.08	267.99	268.06	88094.0
2017-12-20 08:00:00	SPY	ETF	267.99	268.16	267.99	268.13	210294.0
2017-12-20 08:30:00	SPY	ETF	268.11	268.14	268.05	268.1	154119.0
2017-12-20 09:00:00	SPY	ETF	268.1	268.29	268.08	268.27	453278.0
2017-12-20 09:30:00	SPY	ETF	268.27	268.33	267.09	267.47	8382890.0
2017-12-20 10:00:00	SPY	ETF	267.47	267.6289	267.18	267.29	5828645.0
2017-12-20 10:30:00	SPY	ETF	267.29	267.31	266.69	267.0047	6446586.0
2017-12-20 11:00:00	SPY	ETF	267.01	267.335	266.87	267.2499	2722549.0
2017-12-20 11:30:00	SPY	ETF	267.24	267.41	267.14	267.16	3990270.0
2017-12-20 12:00:00	SPY	ETF	267.16	267.39	267.12	267.29	3193407.0
2017-12-20 12:30:00	SPY	ETF	267.28	267.365	266.99	267.27	2171006.0
2017-12-20 13:00:00	SPY	ETF	267.27	267.55	267.22	267.55	3936188.0
2017-12-20 13:30:00	SPY	ETF	267.54	267.6	267.4	267.41	2563202.0
2017-12-20 14:00:00	SPY	ETF	267.419	267.48	267.14	267.19	2984290.0
2017-12-20 14:30:00	SPY	ETF	267.2	267.26	266.945	267.11	4129425.0
2017-12-20 15:00:00	SPY	ETF	267.11	267.25	267.07	267.1433	3426019.0
2017-12-20 15:30:00	SPY	ETF	267.15	267.365	266.97	267.04	6871855.0
2017-12-20 16:00:00	SPY	ETF	267.05	267.458	266.9	266.94	16468664.0
2017-12-20 16:30:00	SPY	ETF	266.96	267.03	266.9	266.94	1015870.0
2017-12-20 17:00:00	SPY	ETF	266.98	266.98	266.87	266.89	204263.0
2017-12-20 17:30:00	SPY	ETF	266.88	266.91	266.88	266.91	25555.0
2017-12-20 18:00:00	SPY	ETF	266.94	267.03	266.94	267.03	79807.0
2017-12-20 18:30:00	SPY	ETF	267.01	267.03	266.88	267.02	12355.0
2017-12-20 19:00:00	SPY	ETF	267.03	267.16	267.03	267.16	13253.0
2017-12-20 19:30:00	SPY	ETF	267.13	267.13	266.96	267.01	17062.0
2017-12-20 04:00:00	QQQ	ETF	158.21	158.21	158.08	158.19	650.0
2017-12-20 05:00:00	QQQ	ETF	158.35	158.35	158.35	158.35	100.0
2017-12-20 05:30:00	QQQ	ETF	158.36	158.38	158.36	158.38	1206.0
2017-12-20 06:00:00	QQQ	ETF	158.27	158.27	158.26	158.26	3600.0
2017-12-20 06:30:00	QQQ	ETF	158.34	158.36	158.32	158.33	6625.0
2017-12-20 07:00:00	QQQ	ETF	158.34	158.43	158.33	158.41	25743.0
2017-12-20 07:30:00	QQQ	ETF	158.42	158.42	158.35	158.4	59826.0
2017-12-20 08:00:00	QQQ	ETF	158.33	158.46	158.33	158.45	46645.0
2017-12-20 08:30:00	QQQ	ETF	158.45	158.45	158.41	158.43	28931.0
2017-12-20 09:00:00	QQQ	ETF	158.43	158.44	158.22	158.25	104761.0
2017-12-20 09:30:00	QQQ	ETF	158.24	158.28	157.0	157.29	6193293.0
2017-12-20 10:00:00	QQQ	ETF	157.29	157.44	157.13	157.275	2806251.0
2017-12-20 10:30:00	QQQ	ETF	157.27	157.3	156.91	157.05	2257535.0
2017-12-20 11:00:00	QQQ	ETF	157.05	157.29	157.0	157.22	1732911.0
2017-12-20 11:30:00	QQQ	ETF	157.22	157.37	157.16	157.35	1124277.0
2017-12-20 12:00:00	QQQ	ETF	157.35	157.62	157.3337	157.545	907803.0
2017-12-20 12:30:00	QQQ	ETF	157.54	157.56	157.34	157.49	791061.0
2017-12-20 13:00:00	QQQ	ETF	157.5	157.82	157.47	157.77	733113.0

> showing 50 of 15,880 rows — these rows as CSV

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