PREVIEW / etf_30min / 2017-09-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-21.parquet
  size:    427 KB
  rows:    14,678

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-21 04:00:00	SPY	ETF	249.87	249.87	249.75	249.78	7980.0
2017-09-21 04:30:00	SPY	ETF	249.83	249.88	249.8	249.88	1000.0
2017-09-21 05:00:00	SPY	ETF	249.85	249.86	249.83	249.83	1305.0
2017-09-21 05:30:00	SPY	ETF	249.9	249.9	249.85	249.9	705.0
2017-09-21 06:30:00	SPY	ETF	249.9	249.92	249.9	249.92	1980.0
2017-09-21 07:00:00	SPY	ETF	249.95	249.97	249.91	249.97	6593.0
2017-09-21 07:30:00	SPY	ETF	249.91	249.95	249.89	249.91	7168.0
2017-09-21 08:00:00	SPY	ETF	249.95	249.95	249.89	249.9	52935.0
2017-09-21 08:30:00	SPY	ETF	249.92	250.01	249.85	249.99	72162.0
2017-09-21 09:00:00	SPY	ETF	249.98	250.0	249.89	249.89	120948.0
2017-09-21 09:30:00	SPY	ETF	249.88	249.98	249.19	249.39	6122508.0
2017-09-21 10:00:00	SPY	ETF	249.395	249.5	249.185	249.37	5431571.0
2017-09-21 10:30:00	SPY	ETF	249.37	249.7	249.34	249.6099	3145425.0
2017-09-21 11:00:00	SPY	ETF	249.6	249.82	249.575	249.74	2365797.0
2017-09-21 11:30:00	SPY	ETF	249.74	249.795	249.635	249.675	1528308.0
2017-09-21 12:00:00	SPY	ETF	249.68	249.84	249.65	249.7853	3308230.0
2017-09-21 12:30:00	SPY	ETF	249.78	249.8	249.57	249.74	3319748.0
2017-09-21 13:00:00	SPY	ETF	249.745	249.825	249.71	249.775	1236844.0
2017-09-21 13:30:00	SPY	ETF	249.77	249.78	249.625	249.76	801628.0
2017-09-21 14:00:00	SPY	ETF	249.76	249.79	249.58	249.665	1115910.0
2017-09-21 14:30:00	SPY	ETF	249.67	249.67	249.42	249.64	2071343.0
2017-09-21 15:00:00	SPY	ETF	249.63	249.74	249.55	249.65	2068515.0
2017-09-21 15:30:00	SPY	ETF	249.655	249.74	249.32	249.4	8283050.0
2017-09-21 16:00:00	SPY	ETF	249.39	249.66	249.3421	249.57	5423350.0
2017-09-21 16:30:00	SPY	ETF	249.58	249.6847	249.39	249.57	808676.0
2017-09-21 17:00:00	SPY	ETF	249.57	249.59	249.48	249.5	53709.0
2017-09-21 17:30:00	SPY	ETF	249.54	249.54	249.5	249.5	31431.0
2017-09-21 18:00:00	SPY	ETF	249.53	249.56	249.48	249.51	46173.0
2017-09-21 18:30:00	SPY	ETF	249.52	249.55	249.49	249.49	8779.0
2017-09-21 19:00:00	SPY	ETF	249.53	249.57	249.52	249.57	8563.0
2017-09-21 19:30:00	SPY	ETF	249.55	249.58	249.42	249.46	46138.0
2017-09-21 04:00:00	QQQ	ETF	145.18	145.18	145.18	145.18	200.0
2017-09-21 04:30:00	QQQ	ETF	145.17	145.24	145.17	145.24	1100.0
2017-09-21 06:00:00	QQQ	ETF	145.24	145.24	145.2	145.2	10200.0
2017-09-21 06:30:00	QQQ	ETF	145.24	145.39	145.23	145.39	6177.0
2017-09-21 07:00:00	QQQ	ETF	145.34	145.35	145.32	145.32	5550.0
2017-09-21 07:30:00	QQQ	ETF	145.3	145.31	145.29	145.31	4450.0
2017-09-21 08:00:00	QQQ	ETF	145.35	145.35	145.29	145.3	16463.0
2017-09-21 08:30:00	QQQ	ETF	145.27	145.39	145.21	145.39	42724.0
2017-09-21 09:00:00	QQQ	ETF	145.34	145.35	145.23	145.23	30500.0
2017-09-21 09:30:00	QQQ	ETF	145.25	145.26	144.28	144.48	4454409.0
2017-09-21 10:00:00	QQQ	ETF	144.47	144.575	144.0	144.15	3581095.0
2017-09-21 10:30:00	QQQ	ETF	144.16	144.46	143.95	144.45	2347088.0
2017-09-21 11:00:00	QQQ	ETF	144.4455	144.79	144.41	144.68	1469202.0
2017-09-21 11:30:00	QQQ	ETF	144.67	144.81	144.6	144.6911	1216320.0
2017-09-21 12:00:00	QQQ	ETF	144.7	144.93	144.661	144.815	944962.0
2017-09-21 12:30:00	QQQ	ETF	144.81	144.879	144.59	144.8	652973.0
2017-09-21 13:00:00	QQQ	ETF	144.79	145.07	144.78	144.96	1769867.0
2017-09-21 13:30:00	QQQ	ETF	144.96	145.02	144.87	144.95	650400.0
2017-09-21 14:00:00	QQQ	ETF	144.96	145.01	144.76	144.7907	465674.0

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

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