PREVIEW / etf_1hour / 2016-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-11.parquet
  size:    262 KB
  rows:    8,474

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-11 04:00:00	SPY	ETF	215.91	215.91	215.59	215.66	41002.0
2016-10-11 05:00:00	SPY	ETF	215.6	215.81	215.58	215.81	17338.0
2016-10-11 06:00:00	SPY	ETF	215.75	215.91	215.73	215.87	30584.0
2016-10-11 07:00:00	SPY	ETF	215.97	216.02	215.64	215.67	229134.0
2016-10-11 08:00:00	SPY	ETF	215.69	215.94	215.55	215.65	533052.0
2016-10-11 09:00:00	SPY	ETF	215.68	215.74	214.75	214.91	11732542.0
2016-10-11 10:00:00	SPY	ETF	214.91	215.0	214.1	214.125	15479108.0
2016-10-11 11:00:00	SPY	ETF	214.12	214.16	213.57	213.91	18854197.0
2016-10-11 12:00:00	SPY	ETF	213.92	214.33	213.73	214.05	12147387.0
2016-10-11 13:00:00	SPY	ETF	214.05	214.05	212.9	212.97	12770562.0
2016-10-11 14:00:00	SPY	ETF	212.99	213.24	212.58	212.991	17297820.0
2016-10-11 15:00:00	SPY	ETF	212.995	213.66	212.84	213.45	27239160.0
2016-10-11 16:00:00	SPY	ETF	213.46	213.86	213.2526	213.72	9725418.0
2016-10-11 17:00:00	SPY	ETF	213.72	213.72	213.64	213.65	93691.0
2016-10-11 18:00:00	SPY	ETF	213.66	213.79	213.52	213.79	130267.0
2016-10-11 19:00:00	SPY	ETF	213.75	213.89	213.64	213.86	42139.0
2016-10-11 04:00:00	QQQ	ETF	119.11	119.11	119.01	119.01	10243.0
2016-10-11 05:00:00	QQQ	ETF	118.97	119.12	118.97	119.12	11313.0
2016-10-11 06:00:00	QQQ	ETF	119.11	119.18	119.07	119.18	12408.0
2016-10-11 07:00:00	QQQ	ETF	119.21	119.28	119.16	119.16	23972.0
2016-10-11 08:00:00	QQQ	ETF	119.18	119.18	119.1	119.12	59378.0
2016-10-11 09:00:00	QQQ	ETF	119.11	119.14	118.44	118.54	2278947.0
2016-10-11 10:00:00	QQQ	ETF	118.55	118.575	117.99	118.0	4016542.0
2016-10-11 11:00:00	QQQ	ETF	118.0	118.055	117.73	117.86	3075046.0
2016-10-11 12:00:00	QQQ	ETF	117.86	118.0	117.67	117.8795	1780618.0
2016-10-11 13:00:00	QQQ	ETF	117.87	117.87	117.22	117.28	2701181.0
2016-10-11 14:00:00	QQQ	ETF	117.28	117.39	117.0	117.25	3235289.0
2016-10-11 15:00:00	QQQ	ETF	117.25	117.56	117.14	117.48	4366183.0
2016-10-11 16:00:00	QQQ	ETF	117.49	117.71	117.49	117.65	714341.0
2016-10-11 17:00:00	QQQ	ETF	117.6	117.63	117.6	117.6	7396.0
2016-10-11 18:00:00	QQQ	ETF	117.62	117.65	117.52	117.59	18052.0
2016-10-11 19:00:00	QQQ	ETF	117.63	117.71	117.62	117.67	11784.0
2016-10-11 04:00:00	IWM	ETF	124.14	124.14	124.07	124.09	820.0
2016-10-11 05:00:00	IWM	ETF	123.95	123.98	123.95	123.98	1600.0
2016-10-11 06:00:00	IWM	ETF	124.12	124.12	124.12	124.12	600.0
2016-10-11 07:00:00	IWM	ETF	124.13	124.21	124.05	124.05	33633.0
2016-10-11 08:00:00	IWM	ETF	124.05	124.1	123.99	124.1	72969.0
2016-10-11 09:00:00	IWM	ETF	124.09	124.11	123.31	123.55	3562703.0
2016-10-11 10:00:00	IWM	ETF	123.55	123.595	122.9	122.9099	4132831.0
2016-10-11 11:00:00	IWM	ETF	122.9	122.94	121.95	122.18	5278297.0
2016-10-11 12:00:00	IWM	ETF	122.18	122.4	122.03	122.18	2022532.0
2016-10-11 13:00:00	IWM	ETF	122.17	122.19	121.6	121.68	3354022.0
2016-10-11 14:00:00	IWM	ETF	121.67	121.8	121.34	121.68	3755874.0
2016-10-11 15:00:00	IWM	ETF	121.68	122.06	121.53	122.01	5496190.0
2016-10-11 16:00:00	IWM	ETF	122.0	122.23	121.96	122.11	943232.0
2016-10-11 17:00:00	IWM	ETF	122.09	122.1	122.03	122.03	4640.0
2016-10-11 18:00:00	IWM	ETF	122.06	122.07	121.92	122.07	3832.0
2016-10-11 19:00:00	IWM	ETF	122.07	122.15	122.07	122.15	1175.0
2016-10-11 08:00:00	DIA	ETF	182.78	182.78	182.78	182.78	500.0
2016-10-11 09:00:00	DIA	ETF	182.8	182.89	182.07	182.228	633938.0

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

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