PREVIEW / etf_30min / 2016-08-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-23.parquet
  size:    393 KB
  rows:    13,444

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-08-23 04:00:00	SPY	ETF	218.8	219.19	218.8	219.17	16675.0
2016-08-23 04:30:00	SPY	ETF	219.14	219.19	218.99	218.99	3510.0
2016-08-23 05:00:00	SPY	ETF	219.05	219.05	218.97	218.99	3010.0
2016-08-23 05:30:00	SPY	ETF	219.11	219.17	219.08	219.14	12902.0
2016-08-23 06:00:00	SPY	ETF	219.2	219.25	219.11	219.14	10747.0
2016-08-23 06:30:00	SPY	ETF	219.11	219.15	219.02	219.02	2252.0
2016-08-23 07:00:00	SPY	ETF	219.05	219.18	219.05	219.13	38008.0
2016-08-23 07:30:00	SPY	ETF	219.13	219.13	219.06	219.09	40614.0
2016-08-23 08:00:00	SPY	ETF	219.08	219.14	218.576	219.09	254957.0
2016-08-23 08:30:00	SPY	ETF	219.04	219.17	219.04	219.17	86664.0
2016-08-23 09:00:00	SPY	ETF	219.17	219.3	219.15	219.23	245489.0
2016-08-23 09:30:00	SPY	ETF	219.25	219.58	219.23	219.5	8630343.0
2016-08-23 10:00:00	SPY	ETF	219.51	219.6	219.38	219.455	3738532.0
2016-08-23 10:30:00	SPY	ETF	219.46	219.54	219.32	219.4501	3330951.0
2016-08-23 11:00:00	SPY	ETF	219.45	219.47	219.2	219.32	3817872.0
2016-08-23 11:30:00	SPY	ETF	219.315	219.38	219.22	219.25	2655166.0
2016-08-23 12:00:00	SPY	ETF	219.25	219.29	219.09	219.19	2567103.0
2016-08-23 12:30:00	SPY	ETF	219.18	219.26	219.005	219.11	2297190.0
2016-08-23 13:00:00	SPY	ETF	219.11	219.29	219.07	219.23	3586111.0
2016-08-23 13:30:00	SPY	ETF	219.23	219.26	219.14	219.1977	1634062.0
2016-08-23 14:00:00	SPY	ETF	219.2	219.24	219.04	219.21	2640394.0
2016-08-23 14:30:00	SPY	ETF	219.2	219.22	219.05	219.13	2126765.0
2016-08-23 15:00:00	SPY	ETF	219.12	219.22	219.07	219.13	4610586.0
2016-08-23 15:30:00	SPY	ETF	219.13	219.13	218.9	218.94	6967967.0
2016-08-23 16:00:00	SPY	ETF	218.94	219.03	218.9	218.98	2792624.0
2016-08-23 16:30:00	SPY	ETF	218.99	219.04	218.98	219.01	434257.0
2016-08-23 17:00:00	SPY	ETF	219.01	219.02	218.96	219.01	28633.0
2016-08-23 17:30:00	SPY	ETF	219.0	219.02	219.0	219.01	21615.0
2016-08-23 18:00:00	SPY	ETF	219.01	219.03	218.95	218.95	45913.0
2016-08-23 18:30:00	SPY	ETF	218.96	218.98	218.95	218.98	17536.0
2016-08-23 19:00:00	SPY	ETF	218.97	219.02	218.97	219.01	3672.0
2016-08-23 19:30:00	SPY	ETF	219.01	219.08	219.01	219.08	21166.0
2016-08-23 04:00:00	QQQ	ETF	117.55	117.76	117.55	117.72	51310.0
2016-08-23 04:30:00	QQQ	ETF	117.75	117.75	117.72	117.72	4700.0
2016-08-23 05:00:00	QQQ	ETF	117.7	117.7	117.7	117.7	100.0
2016-08-23 05:30:00	QQQ	ETF	117.78	117.78	117.78	117.78	1000.0
2016-08-23 06:00:00	QQQ	ETF	117.81	117.81	117.77	117.77	1159.0
2016-08-23 06:30:00	QQQ	ETF	117.75	117.75	117.75	117.75	800.0
2016-08-23 07:00:00	QQQ	ETF	117.7	117.74	117.7	117.71	11800.0
2016-08-23 07:30:00	QQQ	ETF	117.73	117.74	117.69	117.74	7349.0
2016-08-23 08:00:00	QQQ	ETF	117.73	117.73	117.66	117.69	16558.0
2016-08-23 08:30:00	QQQ	ETF	117.7	117.72	117.7	117.71	11079.0
2016-08-23 09:00:00	QQQ	ETF	117.74	117.83	117.73	117.8	196408.0
2016-08-23 09:30:00	QQQ	ETF	117.79	118.0095	117.75	117.96	1945303.0
2016-08-23 10:00:00	QQQ	ETF	117.9697	118.0	117.85	117.8972	778522.0
2016-08-23 10:30:00	QQQ	ETF	117.89	117.94	117.78	117.84	678574.0
2016-08-23 11:00:00	QQQ	ETF	117.838	117.84	117.66	117.75	737804.0
2016-08-23 11:30:00	QQQ	ETF	117.75	117.83	117.72	117.73	533947.0
2016-08-23 12:00:00	QQQ	ETF	117.735	117.76	117.64	117.68	564690.0
2016-08-23 12:30:00	QQQ	ETF	117.67	117.709	117.51	117.585	607008.0

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

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