PREVIEW / etf_1hour / 2013-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-24.parquet
  size:    209 KB
  rows:    6,618

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
2013-10-24 04:00:00	SPY	ETF	175.15	175.38	174.93	175.23	35425.0
2013-10-24 05:00:00	SPY	ETF	175.21	175.24	175.11	175.24	12390.0
2013-10-24 06:00:00	SPY	ETF	175.26	175.55	175.25	175.43	216600.0
2013-10-24 07:00:00	SPY	ETF	175.43	175.47	175.19	175.23	273374.0
2013-10-24 08:00:00	SPY	ETF	175.25	175.41	174.98	174.98	828334.0
2013-10-24 09:00:00	SPY	ETF	174.98	175.12	174.51	174.777	11078161.0
2013-10-24 10:00:00	SPY	ETF	174.78	175.02	174.56	174.9008	12167033.0
2013-10-24 11:00:00	SPY	ETF	174.91	175.16	174.85	175.05	8856899.0
2013-10-24 12:00:00	SPY	ETF	175.06	175.23	174.83	175.21	6365488.0
2013-10-24 13:00:00	SPY	ETF	175.21	175.22	174.95	175.055	6083767.0
2013-10-24 14:00:00	SPY	ETF	175.06	175.36	175.01	175.35	5655231.0
2013-10-24 15:00:00	SPY	ETF	175.35	175.37	175.03	175.15	13123580.0
2013-10-24 16:00:00	SPY	ETF	175.17	175.5	174.77	175.4	4503583.0
2013-10-24 17:00:00	SPY	ETF	175.4	175.43	175.35	175.35	219840.0
2013-10-24 18:00:00	SPY	ETF	175.35	175.43	175.32	175.37	171360.0
2013-10-24 19:00:00	SPY	ETF	175.37	175.4	175.36	175.39	48487.0
2013-10-24 04:00:00	QQQ	ETF	82.22	82.26	82.2	82.25	62000.0
2013-10-24 05:00:00	QQQ	ETF	82.24	82.26	82.19	82.26	11768.0
2013-10-24 06:00:00	QQQ	ETF	82.25	82.37	82.25	82.32	77750.0
2013-10-24 07:00:00	QQQ	ETF	82.32	82.32	82.22	82.23	45860.0
2013-10-24 08:00:00	QQQ	ETF	82.24	82.29	82.03	82.04	123422.0
2013-10-24 09:00:00	QQQ	ETF	82.04	82.13	81.88	82.11	3646715.0
2013-10-24 10:00:00	QQQ	ETF	82.1	82.23	82.02	82.22	3772579.0
2013-10-24 11:00:00	QQQ	ETF	82.2199	82.44	82.19	82.35	3311413.0
2013-10-24 12:00:00	QQQ	ETF	82.34	82.48	82.2901	82.46	1941424.0
2013-10-24 13:00:00	QQQ	ETF	82.47	82.47	82.31	82.33	1493006.0
2013-10-24 14:00:00	QQQ	ETF	82.33	82.48	82.315	82.47	1600324.0
2013-10-24 15:00:00	QQQ	ETF	82.47	82.48	82.24	82.32	4031543.0
2013-10-24 16:00:00	QQQ	ETF	82.33	82.96	81.9522	82.91	2445105.0
2013-10-24 17:00:00	QQQ	ETF	82.9	82.93	82.8	82.89	47072.0
2013-10-24 18:00:00	QQQ	ETF	82.88	82.92	82.83	82.88	31538.0
2013-10-24 19:00:00	QQQ	ETF	82.87	82.89	82.86	82.88	56530.0
2013-10-24 07:00:00	IWM	ETF	110.82	110.82	110.73	110.77	55639.0
2013-10-24 08:00:00	IWM	ETF	110.76	110.775	110.38	110.56	121554.0
2013-10-24 09:00:00	IWM	ETF	110.57	110.65	110.33	110.59	2916924.0
2013-10-24 10:00:00	IWM	ETF	110.595	110.77	110.4	110.77	3071407.0
2013-10-24 11:00:00	IWM	ETF	110.77	110.95	110.7	110.88	2768214.0
2013-10-24 12:00:00	IWM	ETF	110.88	111.09	110.78	111.07	1948515.0
2013-10-24 13:00:00	IWM	ETF	111.08	111.0801	110.85	110.99	1570484.0
2013-10-24 14:00:00	IWM	ETF	111.0	111.22	110.96	111.17	2100724.0
2013-10-24 15:00:00	IWM	ETF	111.17	111.26	110.97	111.0	5673057.0
2013-10-24 16:00:00	IWM	ETF	111.01	111.26	110.3135	111.15	1769396.0
2013-10-24 17:00:00	IWM	ETF	111.13	111.15	111.11	111.15	11600.0
2013-10-24 18:00:00	IWM	ETF	111.24	111.24	111.24	111.24	2000.0
2013-10-24 19:00:00	IWM	ETF	111.16	111.2	111.16	111.2	2000.0
2013-10-24 06:00:00	DIA	ETF	154.52	154.52	154.52	154.52	200.0
2013-10-24 07:00:00	DIA	ETF	154.39	154.39	154.39	154.39	100.0
2013-10-24 08:00:00	DIA	ETF	154.32	154.32	154.22	154.22	2200.0
2013-10-24 09:00:00	DIA	ETF	154.28	154.48	154.095	154.35	633719.0
2013-10-24 10:00:00	DIA	ETF	154.33	154.55	154.16	154.55	848897.0

> showing 50 of 6,618 rows — these rows as CSV

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