PREVIEW / etf_1hour / 2012-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-05.parquet
  size:    183 KB
  rows:    5,666

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
2012-06-05 04:00:00	SPY	ETF	128.29	128.29	127.54	127.69	4348.0
2012-06-05 05:00:00	SPY	ETF	127.75	127.84	127.53	127.64	30532.0
2012-06-05 06:00:00	SPY	ETF	127.69	127.71	127.58	127.62	27890.0
2012-06-05 07:00:00	SPY	ETF	127.6	127.77	127.35	127.74	190034.0
2012-06-05 08:00:00	SPY	ETF	127.72	128.15	127.53	127.9	1707273.0
2012-06-05 09:00:00	SPY	ETF	127.88	128.47	127.75	128.42	16853419.0
2012-06-05 10:00:00	SPY	ETF	128.41	129.03	128.32	128.47	32631503.0
2012-06-05 11:00:00	SPY	ETF	128.48	128.8	128.22	128.26	19273489.0
2012-06-05 12:00:00	SPY	ETF	128.26	128.89	128.24	128.62	19251509.0
2012-06-05 13:00:00	SPY	ETF	128.62	128.99	128.43	128.86	11564179.0
2012-06-05 14:00:00	SPY	ETF	128.86	129.06	128.77	128.979	16631165.0
2012-06-05 15:00:00	SPY	ETF	128.98	129.26	128.82	129.019	27806772.0
2012-06-05 16:00:00	SPY	ETF	129.01	129.19	128.8	129.07	12814277.0
2012-06-05 17:00:00	SPY	ETF	129.1	129.11	128.96	129.07	87389.0
2012-06-05 18:00:00	SPY	ETF	129.09	129.13	128.93	129.13	86904.0
2012-06-05 19:00:00	SPY	ETF	129.14	129.6	129.12	129.4	375385.0
2012-06-05 04:00:00	QQQ	ETF	60.9	60.91	60.62	60.62	3000.0
2012-06-05 05:00:00	QQQ	ETF	60.68	60.68	60.68	60.68	1500.0
2012-06-05 06:00:00	QQQ	ETF	60.57	60.6	60.57	60.59	6600.0
2012-06-05 07:00:00	QQQ	ETF	60.54	60.64	60.46	60.63	30270.0
2012-06-05 08:00:00	QQQ	ETF	60.62	60.88	60.55	60.72	217952.0
2012-06-05 09:00:00	QQQ	ETF	60.72	61.0	60.62	60.9	4408246.0
2012-06-05 10:00:00	QQQ	ETF	60.9	61.18	60.74	60.82	9222531.0
2012-06-05 11:00:00	QQQ	ETF	60.8177	61.035	60.66	60.67	5031570.0
2012-06-05 12:00:00	QQQ	ETF	60.67	60.94	60.65	60.84	3984767.0
2012-06-05 13:00:00	QQQ	ETF	60.83	61.05	60.72	60.99	3241215.0
2012-06-05 14:00:00	QQQ	ETF	60.995	61.17	60.95	61.11	5612709.0
2012-06-05 15:00:00	QQQ	ETF	61.12	61.24	60.98	61.12	8783873.0
2012-06-05 16:00:00	QQQ	ETF	61.12	61.22	61.06	61.2	2807235.0
2012-06-05 17:00:00	QQQ	ETF	61.17	61.19	61.14	61.15	5520.0
2012-06-05 18:00:00	QQQ	ETF	61.15	61.16	61.13	61.13	16487.0
2012-06-05 19:00:00	QQQ	ETF	61.21	61.41	61.2	61.31	34063.0
2012-06-05 04:00:00	IWM	ETF	73.41	73.41	73.19	73.19	1422.0
2012-06-05 07:00:00	IWM	ETF	73.13	73.31	73.05	73.29	61400.0
2012-06-05 08:00:00	IWM	ETF	73.28	73.57	73.22	73.36	366783.0
2012-06-05 09:00:00	IWM	ETF	73.36	73.95	73.21	73.92	4871609.0
2012-06-05 10:00:00	IWM	ETF	73.91	74.54	73.83	73.98	11841749.0
2012-06-05 11:00:00	IWM	ETF	73.98	74.29	73.76	73.77	7500803.0
2012-06-05 12:00:00	IWM	ETF	73.78	74.36	73.78	74.2001	4588137.0
2012-06-05 13:00:00	IWM	ETF	74.2001	74.44	74.02	74.36	2394609.0
2012-06-05 14:00:00	IWM	ETF	74.36	74.59	74.27	74.52	4256580.0
2012-06-05 15:00:00	IWM	ETF	74.53	74.67	74.43	74.61	7931502.0
2012-06-05 16:00:00	IWM	ETF	74.6	74.66	74.0	74.63	1168468.0
2012-06-05 17:00:00	IWM	ETF	74.56	74.56	74.55	74.55	21000.0
2012-06-05 18:00:00	IWM	ETF	74.63	74.63	74.63	74.63	100.0
2012-06-05 19:00:00	IWM	ETF	74.6	74.87	74.6	74.87	4933.0
2012-06-05 06:00:00	DIA	ETF	120.52	120.52	120.51	120.51	200.0
2012-06-05 07:00:00	DIA	ETF	120.46	120.61	120.35	120.61	21000.0
2012-06-05 08:00:00	DIA	ETF	120.61	120.9	120.58	120.73	18849.0
2012-06-05 09:00:00	DIA	ETF	120.71	120.94	120.52	120.93	525160.0

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

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