PREVIEW / etf_1hour / 2015-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-04.parquet
  size:    242 KB
  rows:    7,753

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
2015-11-04 04:00:00	SPY	ETF	211.27	211.4	211.1	211.21	4315.0
2015-11-04 05:00:00	SPY	ETF	211.06	211.13	210.9	211.07	9291.0
2015-11-04 06:00:00	SPY	ETF	211.07	211.26	211.07	211.15	45911.0
2015-11-04 07:00:00	SPY	ETF	211.2	211.35	211.17	211.35	138560.0
2015-11-04 08:00:00	SPY	ETF	211.11	211.63	209.95	211.56	634294.0
2015-11-04 09:00:00	SPY	ETF	211.5535	211.5535	210.41	210.669	13121331.0
2015-11-04 10:00:00	SPY	ETF	210.67	211.17	210.35	210.5299	18961934.0
2015-11-04 11:00:00	SPY	ETF	210.53	210.53	210.01	210.251	12382841.0
2015-11-04 12:00:00	SPY	ETF	210.25	210.7	210.12	210.34	6934731.0
2015-11-04 13:00:00	SPY	ETF	210.34	210.37	209.7201	210.109	11634071.0
2015-11-04 14:00:00	SPY	ETF	210.1	210.66	210.03	210.43	8816394.0
2015-11-04 15:00:00	SPY	ETF	210.43	210.48	209.95	210.38	15332477.0
2015-11-04 16:00:00	SPY	ETF	210.35	210.4	209.8667	210.28	7206775.0
2015-11-04 17:00:00	SPY	ETF	210.27	210.34	210.2	210.23	134173.0
2015-11-04 18:00:00	SPY	ETF	210.21	210.36	209.98	210.02	437100.0
2015-11-04 19:00:00	SPY	ETF	210.02	210.13	209.98	210.08	65999.0
2015-11-04 04:00:00	QQQ	ETF	115.3	115.3	115.22	115.23	7400.0
2015-11-04 05:00:00	QQQ	ETF	115.17	115.21	115.12	115.21	2400.0
2015-11-04 06:00:00	QQQ	ETF	115.26	115.31	115.26	115.27	16100.0
2015-11-04 07:00:00	QQQ	ETF	115.3	115.36	115.3	115.36	17475.0
2015-11-04 08:00:00	QQQ	ETF	115.36	115.48	115.01	115.46	67963.0
2015-11-04 09:00:00	QQQ	ETF	115.46	115.47	114.9065	115.0046	5459004.0
2015-11-04 10:00:00	QQQ	ETF	115.01	115.26	114.756	114.76	6357993.0
2015-11-04 11:00:00	QQQ	ETF	114.7672	114.9162	114.54	114.8	3505379.0
2015-11-04 12:00:00	QQQ	ETF	114.8	115.093	114.73	114.95	1796489.0
2015-11-04 13:00:00	QQQ	ETF	114.9501	114.97	114.57	114.83	2301405.0
2015-11-04 14:00:00	QQQ	ETF	114.8267	115.22	114.78	115.05	2219807.0
2015-11-04 15:00:00	QQQ	ETF	115.0465	115.08	114.79	115.03	3520792.0
2015-11-04 16:00:00	QQQ	ETF	115.03	115.15	114.83	115.02	419598.0
2015-11-04 17:00:00	QQQ	ETF	115.0	115.07	114.95	114.97	7385.0
2015-11-04 18:00:00	QQQ	ETF	114.96	114.96	114.84	114.87	66126.0
2015-11-04 19:00:00	QQQ	ETF	114.91	114.94	114.87	114.92	8803.0
2015-11-04 07:00:00	IWM	ETF	118.48	118.54	118.48	118.54	3000.0
2015-11-04 08:00:00	IWM	ETF	118.55	118.69	118.54	118.67	45112.0
2015-11-04 09:00:00	IWM	ETF	118.66	118.86	118.03	118.24	2997629.0
2015-11-04 10:00:00	IWM	ETF	118.25	119.0	118.08	118.38	5729830.0
2015-11-04 11:00:00	IWM	ETF	118.36	118.36	117.76	118.05	4444985.0
2015-11-04 12:00:00	IWM	ETF	118.05	118.34	117.95	118.18	1570087.0
2015-11-04 13:00:00	IWM	ETF	118.18	118.18	117.69	118.15	1679931.0
2015-11-04 14:00:00	IWM	ETF	118.15	118.47	118.09	118.19	2076819.0
2015-11-04 15:00:00	IWM	ETF	118.21	118.32	118.01	118.31	3147442.0
2015-11-04 16:00:00	IWM	ETF	118.31	118.34	118.13	118.29	1694803.0
2015-11-04 18:00:00	IWM	ETF	118.28	118.28	118.28	118.28	4200.0
2015-11-04 19:00:00	IWM	ETF	118.31	118.32	118.28	118.32	400.0
2015-11-04 07:00:00	DIA	ETF	179.3	179.3	179.3	179.3	100.0
2015-11-04 08:00:00	DIA	ETF	179.33	179.63	179.07	179.62	5155.0
2015-11-04 09:00:00	DIA	ETF	179.6665	179.6665	178.78	178.93	954846.0
2015-11-04 10:00:00	DIA	ETF	178.94	179.35	178.72	178.79	883028.0
2015-11-04 11:00:00	DIA	ETF	178.79	178.79	178.44	178.59	679379.0
2015-11-04 12:00:00	DIA	ETF	178.59	178.97	178.48	178.58	403699.0

> showing 50 of 7,753 rows — these rows as CSV

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