PREVIEW / etf_1hour / 2016-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-01.parquet
  size:    257 KB
  rows:    8,246

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-07-01 04:00:00	SPY	ETF	208.85	209.12	208.76	208.81	71685.0
2016-07-01 05:00:00	SPY	ETF	208.8	208.91	208.69	208.83	50355.0
2016-07-01 06:00:00	SPY	ETF	208.88	209.27	208.66	209.18	98573.0
2016-07-01 07:00:00	SPY	ETF	209.15	209.56	209.13	209.54	374333.0
2016-07-01 08:00:00	SPY	ETF	209.53	209.55	209.13	209.3	858165.0
2016-07-01 09:00:00	SPY	ETF	209.3	210.15	209.28	210.03	12707183.0
2016-07-01 10:00:00	SPY	ETF	210.04	210.49	210.035	210.39	15858898.0
2016-07-01 11:00:00	SPY	ETF	210.39	210.46	209.92	210.12	12429232.0
2016-07-01 12:00:00	SPY	ETF	210.12	210.19	209.71	209.92	10391081.0
2016-07-01 13:00:00	SPY	ETF	209.92	210.14	209.59	209.82	8274107.0
2016-07-01 14:00:00	SPY	ETF	209.82	209.95	209.51	209.74	7891700.0
2016-07-01 15:00:00	SPY	ETF	209.74	210.18	209.71	209.83	22255080.0
2016-07-01 16:00:00	SPY	ETF	209.83	210.09	209.74	210.02	12582490.0
2016-07-01 17:00:00	SPY	ETF	210.03	210.15	210.0	210.12	270613.0
2016-07-01 18:00:00	SPY	ETF	210.12	210.12	209.99	210.03	54706.0
2016-07-01 19:00:00	SPY	ETF	210.03	210.05	209.99	209.99	25246.0
2016-07-01 04:00:00	QQQ	ETF	107.21	107.31	107.16	107.25	2387.0
2016-07-01 05:00:00	QQQ	ETF	107.22	107.25	107.17	107.22	43600.0
2016-07-01 06:00:00	QQQ	ETF	107.24	107.38	107.2	107.38	3850.0
2016-07-01 07:00:00	QQQ	ETF	107.39	107.6	107.37	107.6	28615.0
2016-07-01 08:00:00	QQQ	ETF	107.56	107.58	107.46	107.5	32029.0
2016-07-01 09:00:00	QQQ	ETF	107.48	108.16	107.45	108.11	2882068.0
2016-07-01 10:00:00	QQQ	ETF	108.11	108.47	108.11	108.43	3887196.0
2016-07-01 11:00:00	QQQ	ETF	108.43	108.48	108.14	108.285	2699445.0
2016-07-01 12:00:00	QQQ	ETF	108.28	108.32	108.06	108.18	1803675.0
2016-07-01 13:00:00	QQQ	ETF	108.17	108.285	107.92	108.0371	2089553.0
2016-07-01 14:00:00	QQQ	ETF	108.04	108.11	107.85	108.02	1609917.0
2016-07-01 15:00:00	QQQ	ETF	108.02	108.24	107.98	108.05	3248334.0
2016-07-01 16:00:00	QQQ	ETF	108.05	108.19	108.03	108.19	467427.0
2016-07-01 17:00:00	QQQ	ETF	108.09	108.15	108.09	108.11	7237.0
2016-07-01 18:00:00	QQQ	ETF	108.16	108.16	108.11	108.11	3550.0
2016-07-01 19:00:00	QQQ	ETF	108.12	108.15	108.12	108.15	690.0
2016-07-01 05:00:00	IWM	ETF	114.84	114.84	114.84	114.84	700.0
2016-07-01 06:00:00	IWM	ETF	114.75	114.75	114.65	114.65	9895.0
2016-07-01 07:00:00	IWM	ETF	114.99	115.11	114.92	115.11	22400.0
2016-07-01 08:00:00	IWM	ETF	115.01	115.11	114.88	114.98	34147.0
2016-07-01 09:00:00	IWM	ETF	114.95	115.82	114.95	115.62	3337108.0
2016-07-01 10:00:00	IWM	ETF	115.63	115.95	115.57	115.88	4194678.0
2016-07-01 11:00:00	IWM	ETF	115.86	115.91	115.18	115.42	2855686.0
2016-07-01 12:00:00	IWM	ETF	115.42	115.51	114.95	115.19	1750595.0
2016-07-01 13:00:00	IWM	ETF	115.19	115.23	114.8	115.05	1601163.0
2016-07-01 14:00:00	IWM	ETF	115.06	115.16	114.93	115.08	1547686.0
2016-07-01 15:00:00	IWM	ETF	115.09	115.56	115.09	115.4	3424234.0
2016-07-01 16:00:00	IWM	ETF	115.4	115.62	115.39	115.54	1876597.0
2016-07-01 17:00:00	IWM	ETF	115.51	115.55	115.48	115.5	1498.0
2016-07-01 19:00:00	IWM	ETF	115.47	115.47	115.42	115.47	3821.0
2016-07-01 04:00:00	DIA	ETF	178.6	178.6	178.6	178.6	100.0
2016-07-01 05:00:00	DIA	ETF	178.59	178.59	178.53	178.53	8500.0
2016-07-01 06:00:00	DIA	ETF	178.53	178.53	178.53	178.53	1500.0
2016-07-01 07:00:00	DIA	ETF	179.0	179.0	179.0	179.0	1000.0

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

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