PREVIEW / etf_30min / 2016-03-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-18.parquet
  size:    392 KB
  rows:    13,322

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-03-18 04:00:00	SPY	ETF	203.85	203.85	203.25	203.68	8333.0
2016-03-18 04:30:00	SPY	ETF	203.72	203.84	203.62	203.65	3583.0
2016-03-18 05:00:00	SPY	ETF	203.7	204.01	203.7	203.94	68698.0
2016-03-18 05:30:00	SPY	ETF	203.91	203.94	203.72	203.73	12528.0
2016-03-18 06:00:00	SPY	ETF	203.8	203.96	203.8	203.93	13007.0
2016-03-18 06:30:00	SPY	ETF	203.96	204.13	203.95	204.1	92593.0
2016-03-18 07:00:00	SPY	ETF	204.06	204.13	203.99	204.07	62513.0
2016-03-18 07:30:00	SPY	ETF	204.05	204.1	203.93	203.95	99993.0
2016-03-18 08:00:00	SPY	ETF	203.95	204.14	203.39	204.11	292152.0
2016-03-18 08:30:00	SPY	ETF	204.12	204.21	203.5	204.05	300452.0
2016-03-18 09:00:00	SPY	ETF	204.07	204.36	203.8	204.17	1617402.0
2016-03-18 09:30:00	SPY	ETF	204.17	204.42	203.96	204.36	17142820.0
2016-03-18 10:00:00	SPY	ETF	204.36	204.58	204.2	204.22	12114623.0
2016-03-18 10:30:00	SPY	ETF	204.22	204.5	204.13	204.44	12146179.0
2016-03-18 11:00:00	SPY	ETF	204.44	204.78	204.42	204.49	6530288.0
2016-03-18 11:30:00	SPY	ETF	204.495	204.59	204.28	204.48	5737721.0
2016-03-18 12:00:00	SPY	ETF	204.48	204.67	204.4	204.58	4816555.0
2016-03-18 12:30:00	SPY	ETF	204.585	204.595	204.34	204.45	5093762.0
2016-03-18 13:00:00	SPY	ETF	204.46	204.495	203.97	204.12	5862324.0
2016-03-18 13:30:00	SPY	ETF	204.115	204.16	203.8	204.128	4691332.0
2016-03-18 14:00:00	SPY	ETF	204.13	204.32	204.04	204.16	5672937.0
2016-03-18 14:30:00	SPY	ETF	204.155	204.285	204.06	204.0901	6059505.0
2016-03-18 15:00:00	SPY	ETF	204.095	204.69	204.09	204.58	12478499.0
2016-03-18 15:30:00	SPY	ETF	204.58	204.62	204.38	204.44	17681921.0
2016-03-18 16:00:00	SPY	ETF	204.44	204.5244	204.18	204.24	13282239.0
2016-03-18 16:30:00	SPY	ETF	204.24	204.52	204.16	204.44	543658.0
2016-03-18 17:00:00	SPY	ETF	204.4	204.5	204.19	204.2	423609.0
2016-03-18 17:30:00	SPY	ETF	204.2	204.26	204.12	204.26	2715816.0
2016-03-18 18:00:00	SPY	ETF	204.19	204.38	204.13	204.18	98313.0
2016-03-18 18:30:00	SPY	ETF	204.17	204.23	204.17	204.2	16424.0
2016-03-18 19:00:00	SPY	ETF	204.21	204.23	203.77	204.18	95706.0
2016-03-18 19:30:00	SPY	ETF	204.18	204.25	204.17	204.19	21210.0
2016-03-18 04:00:00	QQQ	ETF	107.14	107.14	107.14	107.14	100.0
2016-03-18 06:00:00	QQQ	ETF	107.27	107.36	107.27	107.36	699.0
2016-03-18 06:30:00	QQQ	ETF	107.4	107.4	107.4	107.4	100.0
2016-03-18 07:00:00	QQQ	ETF	107.46	107.5	107.45	107.45	3100.0
2016-03-18 07:30:00	QQQ	ETF	107.44	107.46	107.39	107.39	8145.0
2016-03-18 08:00:00	QQQ	ETF	107.39	107.46	107.35	107.46	25613.0
2016-03-18 08:30:00	QQQ	ETF	107.45	107.49	107.39	107.39	43872.0
2016-03-18 09:00:00	QQQ	ETF	107.4	107.49	107.19	107.48	378256.0
2016-03-18 09:30:00	QQQ	ETF	107.46	107.555	106.8	106.94	5586734.0
2016-03-18 10:00:00	QQQ	ETF	106.94	107.19	106.91	107.04	2469445.0
2016-03-18 10:30:00	QQQ	ETF	107.04	107.33	107.04	107.29	2246159.0
2016-03-18 11:00:00	QQQ	ETF	107.29	107.635	107.29	107.47	1358872.0
2016-03-18 11:30:00	QQQ	ETF	107.47	107.55	107.38	107.46	1038238.0
2016-03-18 12:00:00	QQQ	ETF	107.4666	107.61	107.44	107.55	1048691.0
2016-03-18 12:30:00	QQQ	ETF	107.55	107.57	107.4109	107.56	1069177.0
2016-03-18 13:00:00	QQQ	ETF	107.566	107.58	107.15	107.2129	1540785.0
2016-03-18 13:30:00	QQQ	ETF	107.22	107.24	106.866	107.09	2344194.0
2016-03-18 14:00:00	QQQ	ETF	107.09	107.23	107.05	107.15	1275740.0

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

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