PREVIEW / etf_1hour / 2011-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-07.parquet
  size:    183 KB
  rows:    5,593

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
2011-12-07 04:00:00	SPY	ETF	127.35	127.35	126.86	126.86	3333.0
2011-12-07 05:00:00	SPY	ETF	126.87	127.11	126.7	126.78	49460.0
2011-12-07 06:00:00	SPY	ETF	126.7	126.83	126.53	126.7	203500.0
2011-12-07 07:00:00	SPY	ETF	126.73	126.76	126.17	126.25	1746349.0
2011-12-07 08:00:00	SPY	ETF	126.22	126.68	125.5	125.86	7722117.0
2011-12-07 09:00:00	SPY	ETF	125.84	126.11	125.13	125.51	23154424.0
2011-12-07 10:00:00	SPY	ETF	125.51	125.55	124.97	125.51	31395873.0
2011-12-07 11:00:00	SPY	ETF	125.51	125.99	125.44	125.95	23756200.0
2011-12-07 12:00:00	SPY	ETF	125.94	126.43	125.79	126.37	20529428.0
2011-12-07 13:00:00	SPY	ETF	126.36	126.4	125.99	126.115	20309818.0
2011-12-07 14:00:00	SPY	ETF	126.12	126.21	125.68	125.81	22625401.0
2011-12-07 15:00:00	SPY	ETF	125.82	127.26	125.75	126.65	51585487.0
2011-12-07 16:00:00	SPY	ETF	126.65	127.04	125.25	126.88	25570928.0
2011-12-07 17:00:00	SPY	ETF	126.88	127.21	126.88	127.16	332260.0
2011-12-07 18:00:00	SPY	ETF	127.16	127.19	126.75	126.89	531396.0
2011-12-07 19:00:00	SPY	ETF	126.89	127.14	126.83	127.11	448289.0
2011-12-07 04:00:00	QQQ	ETF	57.57	57.58	57.49	57.49	3400.0
2011-12-07 05:00:00	QQQ	ETF	57.5	57.5	57.5	57.5	1800.0
2011-12-07 06:00:00	QQQ	ETF	57.37	57.37	57.29	57.34	6600.0
2011-12-07 07:00:00	QQQ	ETF	57.29	57.29	57.1	57.11	13578.0
2011-12-07 08:00:00	QQQ	ETF	57.11	57.13	56.83	56.94	1138097.0
2011-12-07 09:00:00	QQQ	ETF	56.91	57.0	56.365	56.53	8088236.0
2011-12-07 10:00:00	QQQ	ETF	56.53	56.64	56.35	56.63	4956927.0
2011-12-07 11:00:00	QQQ	ETF	56.63	56.95	56.61	56.92	6371996.0
2011-12-07 12:00:00	QQQ	ETF	56.92	57.1	56.81	57.06	4252905.0
2011-12-07 13:00:00	QQQ	ETF	57.07	57.09	56.87	56.9225	2680789.0
2011-12-07 14:00:00	QQQ	ETF	56.92	56.96	56.68	56.73	3887135.0
2011-12-07 15:00:00	QQQ	ETF	56.73	57.34	56.69	57.06	8282860.0
2011-12-07 16:00:00	QQQ	ETF	57.06	57.1731	57.01	57.11	1808825.0
2011-12-07 17:00:00	QQQ	ETF	57.12	57.25	57.11	57.21	21589.0
2011-12-07 18:00:00	QQQ	ETF	57.21	57.21	57.16	57.16	7672.0
2011-12-07 19:00:00	QQQ	ETF	57.2	57.24	57.2	57.23	16400.0
2011-12-07 04:00:00	IWM	ETF	75.25	75.31	75.14	75.14	1508.0
2011-12-07 05:00:00	IWM	ETF	75.04	75.08	74.99	74.99	300.0
2011-12-07 06:00:00	IWM	ETF	74.84	75.01	74.79	74.95	60300.0
2011-12-07 07:00:00	IWM	ETF	74.95	74.95	74.42	74.48	655282.0
2011-12-07 08:00:00	IWM	ETF	74.46	74.9595	73.94	74.24	1511493.0
2011-12-07 09:00:00	IWM	ETF	74.23	74.4	73.5	73.7001	5921633.0
2011-12-07 10:00:00	IWM	ETF	73.68	73.73	73.13	73.46	7872877.0
2011-12-07 11:00:00	IWM	ETF	73.47	74.27	73.41	74.23	8023186.0
2011-12-07 12:00:00	IWM	ETF	74.24	74.86	74.09	74.68	4243803.0
2011-12-07 13:00:00	IWM	ETF	74.69	74.73	74.2701	74.4284	3265386.0
2011-12-07 14:00:00	IWM	ETF	74.4299	74.48	73.93	74.0	4569231.0
2011-12-07 15:00:00	IWM	ETF	74.0	75.06	73.92	74.69	10784129.0
2011-12-07 16:00:00	IWM	ETF	74.72	74.84	74.52	74.75	919779.0
2011-12-07 17:00:00	IWM	ETF	74.75	74.89	74.75	74.87	4092.0
2011-12-07 18:00:00	IWM	ETF	74.87	74.87	74.79	74.79	1800.0
2011-12-07 19:00:00	IWM	ETF	74.76	74.87	74.76	74.87	8123.0
2011-12-07 07:00:00	DIA	ETF	122.12	122.13	121.41	121.42	1845.0
2011-12-07 08:00:00	DIA	ETF	121.45	121.45	120.61	120.98	19536.0

> showing 50 of 5,593 rows — these rows as CSV

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