PREVIEW / etf_30min / 2017-09-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-27.parquet
  size:    447 KB
  rows:    15,391

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-09-27 04:00:00	SPY	ETF	249.52	249.54	249.48	249.48	5584.0
2017-09-27 04:30:00	SPY	ETF	249.52	249.52	249.37	249.37	22501.0
2017-09-27 05:00:00	SPY	ETF	249.37	249.43	249.37	249.43	3000.0
2017-09-27 05:30:00	SPY	ETF	249.47	249.47	249.24	249.3	11700.0
2017-09-27 06:00:00	SPY	ETF	249.24	249.38	249.24	249.38	6202.0
2017-09-27 06:30:00	SPY	ETF	249.33	249.47	249.33	249.45	35233.0
2017-09-27 07:00:00	SPY	ETF	249.45	249.56	249.42	249.56	40804.0
2017-09-27 07:30:00	SPY	ETF	249.54	249.6	249.54	249.6	44379.0
2017-09-27 08:00:00	SPY	ETF	249.08	249.65	249.08	249.63	121465.0
2017-09-27 08:30:00	SPY	ETF	249.58	249.65	249.51	249.63	126396.0
2017-09-27 09:00:00	SPY	ETF	249.63	249.92	249.6	249.88	414937.0
2017-09-27 09:30:00	SPY	ETF	249.88	250.05	249.73	249.755	6682923.0
2017-09-27 10:00:00	SPY	ETF	249.75	249.86	249.505	249.53	4009979.0
2017-09-27 10:30:00	SPY	ETF	249.53	249.57	248.87	249.11	4686215.0
2017-09-27 11:00:00	SPY	ETF	249.1	249.4	249.03	249.35	4493325.0
2017-09-27 11:30:00	SPY	ETF	249.3589	249.38	249.18	249.3	1586506.0
2017-09-27 12:00:00	SPY	ETF	249.29	249.33	249.13	249.25	1630034.0
2017-09-27 12:30:00	SPY	ETF	249.255	249.49	249.14	249.485	3447477.0
2017-09-27 13:00:00	SPY	ETF	249.48	249.55	249.44	249.49	1460072.0
2017-09-27 13:30:00	SPY	ETF	249.49	249.775	249.44	249.736	2159809.0
2017-09-27 14:00:00	SPY	ETF	249.74	250.35	249.7399	250.145	6717541.0
2017-09-27 14:30:00	SPY	ETF	250.15	250.24	250.07	250.2262	4504646.0
2017-09-27 15:00:00	SPY	ETF	250.22	250.48	250.22	250.42	6751038.0
2017-09-27 15:30:00	SPY	ETF	250.42	250.49	249.965	250.02	11917504.0
2017-09-27 16:00:00	SPY	ETF	250.02	250.1012	249.6453	249.99	8359683.0
2017-09-27 16:30:00	SPY	ETF	249.97	250.05	249.93	249.93	5375645.0
2017-09-27 17:00:00	SPY	ETF	249.94	250.05	249.4559	249.98	3485065.0
2017-09-27 17:30:00	SPY	ETF	249.97	249.97	249.92	249.92	36472.0
2017-09-27 18:00:00	SPY	ETF	249.92	249.92	249.75	249.8	142897.0
2017-09-27 18:30:00	SPY	ETF	249.82	249.84	249.79	249.82	69028.0
2017-09-27 19:00:00	SPY	ETF	249.82	249.88	249.81	249.86	10559.0
2017-09-27 19:30:00	SPY	ETF	249.85	249.86	249.84	249.86	8990.0
2017-09-27 04:00:00	QQQ	ETF	143.6	143.69	143.6	143.65	1500.0
2017-09-27 04:30:00	QQQ	ETF	143.65	143.65	143.57	143.57	16200.0
2017-09-27 05:00:00	QQQ	ETF	143.59	143.62	143.59	143.62	8700.0
2017-09-27 05:30:00	QQQ	ETF	143.61	143.61	143.48	143.48	3830.0
2017-09-27 06:00:00	QQQ	ETF	143.5	143.55	143.5	143.55	500.0
2017-09-27 06:30:00	QQQ	ETF	143.55	143.68	143.55	143.67	4196.0
2017-09-27 07:00:00	QQQ	ETF	143.61	143.69	143.51	143.69	49358.0
2017-09-27 07:30:00	QQQ	ETF	143.65	143.7	143.63	143.67	11537.0
2017-09-27 08:00:00	QQQ	ETF	143.63	143.79	143.63	143.72	25470.0
2017-09-27 08:30:00	QQQ	ETF	143.68	143.73	143.62	143.72	80251.0
2017-09-27 09:00:00	QQQ	ETF	143.72	143.95	143.67	143.92	119894.0
2017-09-27 09:30:00	QQQ	ETF	143.93	144.38	143.89	144.105	3889891.0
2017-09-27 10:00:00	QQQ	ETF	144.1	144.25	143.8	143.98	3489404.0
2017-09-27 10:30:00	QQQ	ETF	143.98	144.01	143.57	143.75	3188164.0
2017-09-27 11:00:00	QQQ	ETF	143.75	144.07	143.63	143.97	1563024.0
2017-09-27 11:30:00	QQQ	ETF	143.97	143.9865	143.7585	143.86	719054.0
2017-09-27 12:00:00	QQQ	ETF	143.86	143.9545	143.71	143.92	490133.0
2017-09-27 12:30:00	QQQ	ETF	143.92	144.025	143.79	144.0215	553116.0

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

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