PREVIEW / etf_1hour / 2016-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-01.parquet
  size:    252 KB
  rows:    8,100

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-09-01 04:00:00	SPY	ETF	217.98	218.15	217.98	218.13	12241.0
2016-09-01 05:00:00	SPY	ETF	218.06	218.07	217.69	217.71	12559.0
2016-09-01 06:00:00	SPY	ETF	217.74	217.89	217.74	217.84	7148.0
2016-09-01 07:00:00	SPY	ETF	217.87	217.89	217.78	217.84	44541.0
2016-09-01 08:00:00	SPY	ETF	217.81	217.88	217.44	217.54	524298.0
2016-09-01 09:00:00	SPY	ETF	217.54	217.73	217.06	217.23	7567214.0
2016-09-01 10:00:00	SPY	ETF	217.25	217.4638	216.17	216.35	24293054.0
2016-09-01 11:00:00	SPY	ETF	216.35	216.59	216.03	216.44	13626402.0
2016-09-01 12:00:00	SPY	ETF	216.44	217.375	216.36	217.05	12740763.0
2016-09-01 13:00:00	SPY	ETF	217.06	217.31	217.01	217.1	4128753.0
2016-09-01 14:00:00	SPY	ETF	217.1	217.29	216.76	217.129	9389120.0
2016-09-01 15:00:00	SPY	ETF	217.129	217.42	216.74	217.41	16518972.0
2016-09-01 16:00:00	SPY	ETF	217.4	217.4435	217.16	217.19	7657938.0
2016-09-01 17:00:00	SPY	ETF	217.18	217.22	216.3201	217.18	140253.0
2016-09-01 18:00:00	SPY	ETF	217.19	217.31	217.19	217.25	63676.0
2016-09-01 19:00:00	SPY	ETF	217.26	217.29	217.26	217.27	15974.0
2016-09-01 04:00:00	QQQ	ETF	116.91	116.95	116.86	116.93	12200.0
2016-09-01 05:00:00	QQQ	ETF	116.91	116.91	116.76	116.76	450.0
2016-09-01 06:00:00	QQQ	ETF	116.87	116.87	116.85	116.85	5348.0
2016-09-01 07:00:00	QQQ	ETF	116.84	116.84	116.8	116.82	17607.0
2016-09-01 08:00:00	QQQ	ETF	116.81	116.84	116.44	116.63	90574.0
2016-09-01 09:00:00	QQQ	ETF	116.63	116.81	116.47	116.6	2101060.0
2016-09-01 10:00:00	QQQ	ETF	116.59	116.66	115.93	116.11	4127233.0
2016-09-01 11:00:00	QQQ	ETF	116.1	116.29	115.91	116.2335	2121061.0
2016-09-01 12:00:00	QQQ	ETF	116.23	116.8	116.18	116.67	3188758.0
2016-09-01 13:00:00	QQQ	ETF	116.674	116.88	116.67	116.73	1338034.0
2016-09-01 14:00:00	QQQ	ETF	116.735	116.79	116.6	116.72	2628281.0
2016-09-01 15:00:00	QQQ	ETF	116.73	116.78	116.41	116.74	2529592.0
2016-09-01 16:00:00	QQQ	ETF	116.74	116.75	116.56	116.56	623463.0
2016-09-01 17:00:00	QQQ	ETF	116.57	116.57	116.57	116.57	520.0
2016-09-01 18:00:00	QQQ	ETF	116.6	116.63	116.58	116.61	5409.0
2016-09-01 19:00:00	QQQ	ETF	116.61	116.63	116.61	116.62	2500.0
2016-09-01 04:00:00	IWM	ETF	123.89	123.92	123.86	123.92	338.0
2016-09-01 06:00:00	IWM	ETF	123.78	123.78	123.78	123.78	500.0
2016-09-01 07:00:00	IWM	ETF	123.75	123.79	123.73	123.73	4954.0
2016-09-01 08:00:00	IWM	ETF	123.73	123.75	123.22	123.52	49428.0
2016-09-01 09:00:00	IWM	ETF	123.55	123.63	122.85	122.97	2686508.0
2016-09-01 10:00:00	IWM	ETF	122.95	123.15	122.08	122.21	5201437.0
2016-09-01 11:00:00	IWM	ETF	122.21	122.7	122.02	122.51	2873904.0
2016-09-01 12:00:00	IWM	ETF	122.515	123.33	122.42	122.95	2740652.0
2016-09-01 13:00:00	IWM	ETF	122.96	123.0599	122.765	122.785	1297234.0
2016-09-01 14:00:00	IWM	ETF	122.79	122.92	122.55	122.82	1729279.0
2016-09-01 15:00:00	IWM	ETF	122.82	123.34	122.58	123.31	3803161.0
2016-09-01 16:00:00	IWM	ETF	123.3	123.34	123.11	123.11	1111670.0
2016-09-01 17:00:00	IWM	ETF	123.11	123.18	123.1	123.12	4817.0
2016-09-01 18:00:00	IWM	ETF	123.2	123.2	123.15	123.15	800.0
2016-09-01 19:00:00	IWM	ETF	123.15	123.15	123.15	123.15	400.0
2016-09-01 08:00:00	DIA	ETF	184.35	184.35	183.94	183.94	4661.0
2016-09-01 09:00:00	DIA	ETF	183.73	184.28	183.73	183.91	426210.0
2016-09-01 10:00:00	DIA	ETF	183.91	184.03	183.05	183.16	705558.0

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

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