PREVIEW / etf_30min / 2017-01-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-17.parquet
  size:    445 KB
  rows:    15,256

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-01-17 04:00:00	SPY	ETF	226.64	226.64	226.3	226.3	6594.0
2017-01-17 04:30:00	SPY	ETF	226.47	226.47	226.4	226.4	384.0
2017-01-17 05:00:00	SPY	ETF	226.35	226.37	226.19	226.31	2810.0
2017-01-17 05:30:00	SPY	ETF	226.25	226.28	226.0	226.01	15306.0
2017-01-17 06:00:00	SPY	ETF	226.08	226.1	225.98	226.09	16142.0
2017-01-17 06:30:00	SPY	ETF	226.1	226.25	225.82	226.16	36688.0
2017-01-17 07:00:00	SPY	ETF	226.18	226.55	226.17	226.52	36122.0
2017-01-17 07:30:00	SPY	ETF	226.46	226.69	226.4	226.65	110321.0
2017-01-17 08:00:00	SPY	ETF	226.66	226.68	226.19	226.5	307386.0
2017-01-17 08:30:00	SPY	ETF	226.46	226.63	226.38	226.52	133306.0
2017-01-17 09:00:00	SPY	ETF	226.51	226.52	226.26	226.32	621712.0
2017-01-17 09:30:00	SPY	ETF	226.31	226.52	226.07	226.17	6981874.0
2017-01-17 10:00:00	SPY	ETF	226.17	226.78	226.07	226.585	4043369.0
2017-01-17 10:30:00	SPY	ETF	226.5503	226.74	226.49	226.715	2811923.0
2017-01-17 11:00:00	SPY	ETF	226.72	226.73	226.29	226.46	2539777.0
2017-01-17 11:30:00	SPY	ETF	226.45	226.66	226.35	226.61	2236489.0
2017-01-17 12:00:00	SPY	ETF	226.6	226.7	226.39	226.56	2442520.0
2017-01-17 12:30:00	SPY	ETF	226.56	226.63	226.45	226.505	2016377.0
2017-01-17 13:00:00	SPY	ETF	226.51	226.72	226.48	226.6501	1393589.0
2017-01-17 13:30:00	SPY	ETF	226.66	226.71	226.54	226.61	2515395.0
2017-01-17 14:00:00	SPY	ETF	226.6	226.66	226.15	226.185	2932172.0
2017-01-17 14:30:00	SPY	ETF	226.19	226.22	225.85	226.0173	6156721.0
2017-01-17 15:00:00	SPY	ETF	226.02	226.06	225.8	225.96	4758002.0
2017-01-17 15:30:00	SPY	ETF	225.97	226.34	225.93	226.29	9896418.0
2017-01-17 16:00:00	SPY	ETF	226.29	226.35	226.2	226.26	5948551.0
2017-01-17 16:30:00	SPY	ETF	226.26	226.29	226.2	226.27	545827.0
2017-01-17 17:00:00	SPY	ETF	226.28	226.28	226.21	226.21	547032.0
2017-01-17 17:30:00	SPY	ETF	226.22	226.27	226.22	226.27	16579.0
2017-01-17 18:00:00	SPY	ETF	226.27	226.3	226.18	226.28	45428.0
2017-01-17 18:30:00	SPY	ETF	226.27	226.33	226.27	226.33	37710.0
2017-01-17 19:00:00	SPY	ETF	226.32	226.35	226.29	226.29	15980.0
2017-01-17 19:30:00	SPY	ETF	226.3	226.3	226.24	226.26	27350.0
2017-01-17 04:00:00	QQQ	ETF	123.0	123.0	122.87	122.93	1162.0
2017-01-17 05:00:00	QQQ	ETF	122.85	122.85	122.75	122.75	1550.0
2017-01-17 05:30:00	QQQ	ETF	122.73	122.73	122.69	122.69	2197.0
2017-01-17 06:00:00	QQQ	ETF	122.67	122.68	122.67	122.68	800.0
2017-01-17 06:30:00	QQQ	ETF	122.69	122.78	122.56	122.71	7692.0
2017-01-17 07:00:00	QQQ	ETF	122.82	122.92	122.81	122.9	9699.0
2017-01-17 07:30:00	QQQ	ETF	122.88	122.99	122.87	122.94	7381.0
2017-01-17 08:00:00	QQQ	ETF	122.95	122.96	122.81	122.87	77050.0
2017-01-17 08:30:00	QQQ	ETF	122.85	123.0	122.8	122.96	49239.0
2017-01-17 09:00:00	QQQ	ETF	122.93	122.93	122.77	122.78	85602.0
2017-01-17 09:30:00	QQQ	ETF	122.79	122.87	122.4342	122.5843	3223385.0
2017-01-17 10:00:00	QQQ	ETF	122.59	122.94	122.54	122.84	1405195.0
2017-01-17 10:30:00	QQQ	ETF	122.84	123.015	122.7835	123.01	599041.0
2017-01-17 11:00:00	QQQ	ETF	123.01	123.03	122.7427	122.8811	966736.0
2017-01-17 11:30:00	QQQ	ETF	122.88	122.985	122.7833	122.95	446255.0
2017-01-17 12:00:00	QQQ	ETF	122.94	122.95	122.745	122.83	543750.0
2017-01-17 12:30:00	QQQ	ETF	122.84	122.855	122.7601	122.788	322414.0
2017-01-17 13:00:00	QQQ	ETF	122.79	122.93	122.78	122.8651	387143.0

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

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