PREVIEW / etf_30min / 2017-05-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-24.parquet
  size:    427 KB
  rows:    14,600

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-05-24 04:00:00	SPY	ETF	240.1	240.17	240.1	240.17	1310.0
2017-05-24 04:30:00	SPY	ETF	240.19	240.19	240.19	240.19	4000.0
2017-05-24 05:00:00	SPY	ETF	240.17	240.17	240.17	240.17	800.0
2017-05-24 05:30:00	SPY	ETF	240.12	240.2	240.12	240.2	5533.0
2017-05-24 06:00:00	SPY	ETF	240.16	240.21	240.14	240.15	102600.0
2017-05-24 06:30:00	SPY	ETF	240.07	240.07	240.05	240.06	1800.0
2017-05-24 07:00:00	SPY	ETF	240.02	240.11	240.02	240.08	20781.0
2017-05-24 07:30:00	SPY	ETF	240.08	240.13	240.02	240.13	75866.0
2017-05-24 08:00:00	SPY	ETF	240.07	240.25	240.03	240.19	78411.0
2017-05-24 08:30:00	SPY	ETF	240.2	240.23	240.13	240.2	84697.0
2017-05-24 09:00:00	SPY	ETF	240.22	240.39	240.13	240.33	203457.0
2017-05-24 09:30:00	SPY	ETF	240.32	240.35	240.08	240.19	3450756.0
2017-05-24 10:00:00	SPY	ETF	240.185	240.27	240.02	240.24	3287003.0
2017-05-24 10:30:00	SPY	ETF	240.24	240.32	240.15	240.16	2303086.0
2017-05-24 11:00:00	SPY	ETF	240.16	240.235	240.03	240.215	1616723.0
2017-05-24 11:30:00	SPY	ETF	240.22	240.3	240.11	240.16	2972592.0
2017-05-24 12:00:00	SPY	ETF	240.155	240.25	240.095	240.24	1148534.0
2017-05-24 12:30:00	SPY	ETF	240.24	240.27	240.16	240.18	1116537.0
2017-05-24 13:00:00	SPY	ETF	240.175	240.21	240.06	240.11	2812667.0
2017-05-24 13:30:00	SPY	ETF	240.105	240.19	240.08	240.15	1298389.0
2017-05-24 14:00:00	SPY	ETF	240.15	240.53	239.93	240.42	5702130.0
2017-05-24 14:30:00	SPY	ETF	240.42	240.425	240.28	240.3412	2042705.0
2017-05-24 15:00:00	SPY	ETF	240.35	240.4298	240.17	240.42	3352951.0
2017-05-24 15:30:00	SPY	ETF	240.42	240.73	240.42	240.59	10070182.0
2017-05-24 16:00:00	SPY	ETF	240.58	240.61	240.48	240.51	5054293.0
2017-05-24 16:30:00	SPY	ETF	240.51	240.7	240.49	240.7	360473.0
2017-05-24 17:00:00	SPY	ETF	240.63	240.65	240.58	240.58	184753.0
2017-05-24 17:30:00	SPY	ETF	240.58	240.62	240.55	240.59	181423.0
2017-05-24 18:00:00	SPY	ETF	240.6	240.68	240.58	240.63	169388.0
2017-05-24 18:30:00	SPY	ETF	240.63	240.65	240.62	240.65	16070.0
2017-05-24 19:00:00	SPY	ETF	240.65	240.71	240.65	240.68	44542.0
2017-05-24 19:30:00	SPY	ETF	240.66	240.69	240.62	240.62	23655.0
2017-05-24 04:00:00	QQQ	ETF	139.35	139.4	139.33	139.4	2100.0
2017-05-24 04:30:00	QQQ	ETF	139.33	139.39	139.3	139.39	34200.0
2017-05-24 05:00:00	QQQ	ETF	139.41	139.41	139.39	139.39	3000.0
2017-05-24 05:30:00	QQQ	ETF	139.37	139.42	139.37	139.39	1000.0
2017-05-24 06:00:00	QQQ	ETF	139.44	139.47	139.44	139.47	700.0
2017-05-24 06:30:00	QQQ	ETF	139.41	139.43	139.39	139.43	2898.0
2017-05-24 07:00:00	QQQ	ETF	139.4	139.41	139.4	139.4	3500.0
2017-05-24 07:30:00	QQQ	ETF	139.4	139.45	139.39	139.43	25800.0
2017-05-24 08:00:00	QQQ	ETF	139.45	139.52	139.45	139.5	39224.0
2017-05-24 08:30:00	QQQ	ETF	139.5	139.54	139.5	139.52	18471.0
2017-05-24 09:00:00	QQQ	ETF	139.51	139.59	139.45	139.56	132571.0
2017-05-24 09:30:00	QQQ	ETF	139.56	139.58	139.25	139.31	1628083.0
2017-05-24 10:00:00	QQQ	ETF	139.31	139.42	139.17	139.345	1109581.0
2017-05-24 10:30:00	QQQ	ETF	139.35	139.399	139.27	139.33	586570.0
2017-05-24 11:00:00	QQQ	ETF	139.33	139.3547	139.1807	139.3258	495960.0
2017-05-24 11:30:00	QQQ	ETF	139.33	139.41	139.285	139.34	704995.0
2017-05-24 12:00:00	QQQ	ETF	139.335	139.43	139.33	139.4184	488544.0
2017-05-24 12:30:00	QQQ	ETF	139.415	139.46	139.4	139.42	372779.0

> showing 50 of 14,600 rows — these rows as CSV

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