PREVIEW / etf_1hour / 2016-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-23.parquet
  size:    252 KB
  rows:    8,136

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	218.99	20185.0
2016-08-23 05:00:00	SPY	ETF	219.05	219.17	218.97	219.14	15912.0
2016-08-23 06:00:00	SPY	ETF	219.2	219.25	219.02	219.02	12999.0
2016-08-23 07:00:00	SPY	ETF	219.05	219.18	219.05	219.09	78622.0
2016-08-23 08:00:00	SPY	ETF	219.08	219.17	218.576	219.17	341621.0
2016-08-23 09:00:00	SPY	ETF	219.17	219.58	219.15	219.5	8875832.0
2016-08-23 10:00:00	SPY	ETF	219.51	219.6	219.32	219.4501	7069483.0
2016-08-23 11:00:00	SPY	ETF	219.45	219.47	219.2	219.25	6473038.0
2016-08-23 12:00:00	SPY	ETF	219.25	219.29	219.005	219.11	4864293.0
2016-08-23 13:00:00	SPY	ETF	219.11	219.29	219.07	219.1977	5220173.0
2016-08-23 14:00:00	SPY	ETF	219.2	219.24	219.04	219.13	4767159.0
2016-08-23 15:00:00	SPY	ETF	219.12	219.22	218.9	218.94	11578553.0
2016-08-23 16:00:00	SPY	ETF	218.94	219.04	218.9	219.01	3226881.0
2016-08-23 17:00:00	SPY	ETF	219.01	219.02	218.96	219.01	50248.0
2016-08-23 18:00:00	SPY	ETF	219.01	219.03	218.95	218.98	63449.0
2016-08-23 19:00:00	SPY	ETF	218.97	219.08	218.97	219.08	24838.0
2016-08-23 04:00:00	QQQ	ETF	117.55	117.76	117.55	117.72	56010.0
2016-08-23 05:00:00	QQQ	ETF	117.7	117.78	117.7	117.78	1100.0
2016-08-23 06:00:00	QQQ	ETF	117.81	117.81	117.75	117.75	1959.0
2016-08-23 07:00:00	QQQ	ETF	117.7	117.74	117.69	117.74	19149.0
2016-08-23 08:00:00	QQQ	ETF	117.73	117.73	117.66	117.71	27637.0
2016-08-23 09:00:00	QQQ	ETF	117.74	118.0095	117.73	117.96	2141711.0
2016-08-23 10:00:00	QQQ	ETF	117.9697	118.0	117.78	117.84	1457096.0
2016-08-23 11:00:00	QQQ	ETF	117.838	117.84	117.66	117.73	1271751.0
2016-08-23 12:00:00	QQQ	ETF	117.735	117.76	117.51	117.585	1171698.0
2016-08-23 13:00:00	QQQ	ETF	117.58	117.71	117.56	117.665	867405.0
2016-08-23 14:00:00	QQQ	ETF	117.67	117.76	117.58	117.66	1262350.0
2016-08-23 15:00:00	QQQ	ETF	117.65	117.71	117.54	117.56	2401744.0
2016-08-23 16:00:00	QQQ	ETF	117.56	117.59	117.5	117.58	484789.0
2016-08-23 17:00:00	QQQ	ETF	117.53	117.56	117.53	117.55	15121.0
2016-08-23 18:00:00	QQQ	ETF	117.52	117.59	117.52	117.57	16299.0
2016-08-23 19:00:00	QQQ	ETF	117.6	117.62	117.6	117.62	5758.0
2016-08-23 06:00:00	IWM	ETF	123.59	123.6	123.59	123.6	5100.0
2016-08-23 07:00:00	IWM	ETF	123.52	123.53	123.49	123.49	5114.0
2016-08-23 08:00:00	IWM	ETF	123.5	123.55	123.47	123.54	30014.0
2016-08-23 09:00:00	IWM	ETF	123.57	124.305	123.56	124.2111	3437660.0
2016-08-23 10:00:00	IWM	ETF	124.22	124.46	124.14	124.37	2047040.0
2016-08-23 11:00:00	IWM	ETF	124.36	124.3758	124.13	124.16	1491517.0
2016-08-23 12:00:00	IWM	ETF	124.15	124.25	124.04	124.14	1492298.0
2016-08-23 13:00:00	IWM	ETF	124.15	124.41	124.08	124.36	1512888.0
2016-08-23 14:00:00	IWM	ETF	124.35	124.44	124.24	124.27	1791125.0
2016-08-23 15:00:00	IWM	ETF	124.27	124.3	124.05	124.1	3262577.0
2016-08-23 16:00:00	IWM	ETF	124.09	124.1225	124.05	124.11	779311.0
2016-08-23 17:00:00	IWM	ETF	124.13	124.13	124.12	124.12	4514.0
2016-08-23 08:00:00	DIA	ETF	185.55	185.55	185.55	185.55	1981.0
2016-08-23 09:00:00	DIA	ETF	185.7	186.13	185.7	185.95	326468.0
2016-08-23 10:00:00	DIA	ETF	185.97	186.03	185.65	185.73	227302.0
2016-08-23 11:00:00	DIA	ETF	185.73	185.73	185.42	185.47	345057.0
2016-08-23 12:00:00	DIA	ETF	185.46	185.53	185.25	185.3	248413.0
2016-08-23 13:00:00	DIA	ETF	185.3	185.55	185.28	185.46	105287.0

> showing 50 of 8,136 rows — these rows as CSV

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