PREVIEW / etf_1hour / 2015-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-29.parquet
  size:    241 KB
  rows:    7,728

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-10-29 04:00:00	SPY	ETF	208.49	208.5	208.25	208.25	83042.0
2015-10-29 05:00:00	SPY	ETF	208.22	208.24	207.99	208.21	253754.0
2015-10-29 06:00:00	SPY	ETF	208.16	208.42	208.12	208.26	76705.0
2015-10-29 07:00:00	SPY	ETF	208.32	208.35	208.1	208.12	242127.0
2015-10-29 08:00:00	SPY	ETF	208.12	208.95	208.0	208.38	963287.0
2015-10-29 09:00:00	SPY	ETF	208.37	208.92	208.28	208.5889	10161758.0
2015-10-29 10:00:00	SPY	ETF	208.58	209.1	208.21	208.3682	18300227.0
2015-10-29 11:00:00	SPY	ETF	208.37	208.84	208.21	208.78	8324178.0
2015-10-29 12:00:00	SPY	ETF	208.7899	208.98	208.48	208.75	6427413.0
2015-10-29 13:00:00	SPY	ETF	208.755	208.98	208.4	208.415	6238376.0
2015-10-29 14:00:00	SPY	ETF	208.4101	208.84	208.38	208.7	9970156.0
2015-10-29 15:00:00	SPY	ETF	208.7	209.27	208.55	208.87	19410683.0
2015-10-29 16:00:00	SPY	ETF	208.88	209.1	208.44	209.08	6023679.0
2015-10-29 17:00:00	SPY	ETF	209.08	209.16	209.04	209.1	1684120.0
2015-10-29 18:00:00	SPY	ETF	209.13	209.2	208.9	208.95	156114.0
2015-10-29 19:00:00	SPY	ETF	208.96	209.12	208.96	209.11	62793.0
2015-10-29 04:00:00	QQQ	ETF	113.55	113.57	113.52	113.52	6550.0
2015-10-29 05:00:00	QQQ	ETF	113.45	113.54	113.45	113.54	6950.0
2015-10-29 06:00:00	QQQ	ETF	113.54	113.54	113.52	113.54	5480.0
2015-10-29 07:00:00	QQQ	ETF	113.56	113.56	113.36	113.41	103712.0
2015-10-29 08:00:00	QQQ	ETF	113.42	113.52	113.38	113.5	141908.0
2015-10-29 09:00:00	QQQ	ETF	113.51	113.77	113.38	113.4402	3715755.0
2015-10-29 10:00:00	QQQ	ETF	113.452	113.76	113.38	113.53	4490334.0
2015-10-29 11:00:00	QQQ	ETF	113.54	113.84	113.465	113.7599	3003763.0
2015-10-29 12:00:00	QQQ	ETF	113.75	113.93	113.6	113.86	1932631.0
2015-10-29 13:00:00	QQQ	ETF	113.851	113.91	113.62	113.67	1801022.0
2015-10-29 14:00:00	QQQ	ETF	113.67	113.92	113.6401	113.8399	2284358.0
2015-10-29 15:00:00	QQQ	ETF	113.82	114.03	113.74	113.83	3778238.0
2015-10-29 16:00:00	QQQ	ETF	113.83	113.9	113.75	113.9	273433.0
2015-10-29 17:00:00	QQQ	ETF	113.83	113.93	113.83	113.91	25166.0
2015-10-29 18:00:00	QQQ	ETF	113.91	113.94	113.8	113.81	21299.0
2015-10-29 19:00:00	QQQ	ETF	113.83	113.97	113.83	113.95	12514.0
2015-10-29 05:00:00	IWM	ETF	116.59	116.6	116.59	116.6	330.0
2015-10-29 07:00:00	IWM	ETF	116.75	116.77	116.67	116.7	10020.0
2015-10-29 08:00:00	IWM	ETF	116.7	116.74	116.61	116.7	49883.0
2015-10-29 09:00:00	IWM	ETF	116.7	117.1127	116.52	116.58	2898050.0
2015-10-29 10:00:00	IWM	ETF	116.57	117.02	116.33	116.393	4541743.0
2015-10-29 11:00:00	IWM	ETF	116.4	116.73	116.22	116.53	2436138.0
2015-10-29 12:00:00	IWM	ETF	116.53	116.74	116.19	116.33	2351571.0
2015-10-29 13:00:00	IWM	ETF	116.32	116.38	115.6	115.6	2734158.0
2015-10-29 14:00:00	IWM	ETF	115.602	115.97	115.56	115.74	2778892.0
2015-10-29 15:00:00	IWM	ETF	115.74	115.95	115.58	115.85	5229539.0
2015-10-29 16:00:00	IWM	ETF	115.86	115.87	115.64	115.79	1048498.0
2015-10-29 17:00:00	IWM	ETF	115.82	115.87	115.82	115.87	3600.0
2015-10-29 18:00:00	IWM	ETF	115.84	115.85	115.78	115.83	4434.0
2015-10-29 19:00:00	IWM	ETF	115.83	115.93	115.83	115.93	2400.0
2015-10-29 07:00:00	DIA	ETF	177.0	177.0	176.85	176.88	1400.0
2015-10-29 08:00:00	DIA	ETF	176.92	177.1	176.8	177.06	7125.0
2015-10-29 09:00:00	DIA	ETF	177.14	177.38	177.01	177.14	658872.0
2015-10-29 10:00:00	DIA	ETF	177.13	177.43	176.69	176.79	1033806.0

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

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