PREVIEW / etf_1hour / 2016-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-07.parquet
  size:    256 KB
  rows:    8,205

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-10-07 04:00:00	SPY	ETF	215.53	215.61	215.5	215.56	4150.0
2016-10-07 05:00:00	SPY	ETF	215.6	215.73	215.55	215.56	10607.0
2016-10-07 06:00:00	SPY	ETF	215.5	215.5	215.2	215.35	115116.0
2016-10-07 07:00:00	SPY	ETF	215.35	215.6	215.34	215.51	239446.0
2016-10-07 08:00:00	SPY	ETF	215.39	216.49	215.35	216.13	3907295.0
2016-10-07 09:00:00	SPY	ETF	216.14	216.3	215.04	215.22	13092007.0
2016-10-07 10:00:00	SPY	ETF	215.22	215.56	215.12	215.16	9178906.0
2016-10-07 11:00:00	SPY	ETF	215.16	215.37	214.19	214.42	14188866.0
2016-10-07 12:00:00	SPY	ETF	214.41	214.85	214.25	214.595	9935091.0
2016-10-07 13:00:00	SPY	ETF	214.6	215.36	214.34	215.19	9346513.0
2016-10-07 14:00:00	SPY	ETF	215.19	215.49	215.07	215.37	9049368.0
2016-10-07 15:00:00	SPY	ETF	215.37	215.44	215.03	215.05	13885337.0
2016-10-07 16:00:00	SPY	ETF	215.05	215.1317	214.94	215.0	4931014.0
2016-10-07 17:00:00	SPY	ETF	214.99	215.06	214.91	214.95	363384.0
2016-10-07 18:00:00	SPY	ETF	214.92	216.04	214.87	215.03	143002.0
2016-10-07 19:00:00	SPY	ETF	214.96	215.0	214.94	214.94	10492.0
2016-10-07 04:00:00	QQQ	ETF	118.48	118.48	118.48	118.48	200.0
2016-10-07 06:00:00	QQQ	ETF	118.46	118.46	118.36	118.42	33598.0
2016-10-07 07:00:00	QQQ	ETF	118.45	118.58	118.45	118.53	22596.0
2016-10-07 08:00:00	QQQ	ETF	118.53	119.03	118.41	118.85	434967.0
2016-10-07 09:00:00	QQQ	ETF	118.86	119.01	118.3	118.47	2970704.0
2016-10-07 10:00:00	QQQ	ETF	118.47	118.73	118.425	118.44	1837818.0
2016-10-07 11:00:00	QQQ	ETF	118.44	118.6	117.89	118.02	2866438.0
2016-10-07 12:00:00	QQQ	ETF	118.015	118.24	117.95	118.13	2222982.0
2016-10-07 13:00:00	QQQ	ETF	118.12	118.585	118.01	118.5	1930785.0
2016-10-07 14:00:00	QQQ	ETF	118.5	118.64	118.4243	118.58	1044483.0
2016-10-07 15:00:00	QQQ	ETF	118.59	118.63	118.45	118.47	2750292.0
2016-10-07 16:00:00	QQQ	ETF	118.46	118.51	118.42	118.49	521201.0
2016-10-07 17:00:00	QQQ	ETF	118.46	118.49	118.46	118.47	462132.0
2016-10-07 18:00:00	QQQ	ETF	118.46	118.46	118.45	118.45	1450.0
2016-10-07 19:00:00	QQQ	ETF	118.47	118.4928	118.45	118.46	431950.0
2016-10-07 05:00:00	IWM	ETF	123.58	123.59	123.55	123.59	2000.0
2016-10-07 06:00:00	IWM	ETF	123.5	123.54	123.5	123.54	1850.0
2016-10-07 07:00:00	IWM	ETF	123.57	123.65	123.54	123.65	8369.0
2016-10-07 08:00:00	IWM	ETF	123.64	124.24	123.54	124.03	178552.0
2016-10-07 09:00:00	IWM	ETF	124.06	124.32	123.16	123.31	4424778.0
2016-10-07 10:00:00	IWM	ETF	123.31	123.665	123.27	123.35	2142808.0
2016-10-07 11:00:00	IWM	ETF	123.34	123.385	122.23	122.41	3989835.0
2016-10-07 12:00:00	IWM	ETF	122.4	122.71	122.25	122.54	3662113.0
2016-10-07 13:00:00	IWM	ETF	122.55	123.09	122.25	122.93	2364725.0
2016-10-07 14:00:00	IWM	ETF	122.93	123.065	122.81	122.94	1645597.0
2016-10-07 15:00:00	IWM	ETF	122.94	123.05	122.8	122.81	3480912.0
2016-10-07 16:00:00	IWM	ETF	122.81	122.8532	122.53	122.59	2107435.0
2016-10-07 17:00:00	IWM	ETF	122.6	122.83	122.57	122.6	1179150.0
2016-10-07 18:00:00	IWM	ETF	122.62	122.62	122.62	122.62	500.0
2016-10-07 19:00:00	IWM	ETF	122.62	122.8532	122.5	122.51	323316.0
2016-10-07 08:00:00	DIA	ETF	183.0	183.0	182.55	182.82	1500.0
2016-10-07 09:00:00	DIA	ETF	183.09	183.09	181.87	182.03	504950.0
2016-10-07 10:00:00	DIA	ETF	182.07	182.41	182.02	182.1124	313822.0
2016-10-07 11:00:00	DIA	ETF	182.09	182.29	181.32	181.57	412149.0

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

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