PREVIEW / etf_1hour / 2011-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-26.parquet
  size:    177 KB
  rows:    5,499

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-08-26 04:00:00	SPY	ETF	116.4	116.72	116.38	116.41	10700.0
2011-08-26 05:00:00	SPY	ETF	116.47	116.63	116.43	116.43	2800.0
2011-08-26 06:00:00	SPY	ETF	116.41	116.46	116.26	116.37	6300.0
2011-08-26 07:00:00	SPY	ETF	116.4	116.42	115.82	116.09	490313.0
2011-08-26 08:00:00	SPY	ETF	116.09	116.31	115.22	115.35	4615066.0
2011-08-26 09:00:00	SPY	ETF	115.37	115.93	114.96	115.47	30186475.0
2011-08-26 10:00:00	SPY	ETF	115.47	117.13	113.85	116.29	102412669.0
2011-08-26 11:00:00	SPY	ETF	116.29	117.68	116.07	117.41	36489130.0
2011-08-26 12:00:00	SPY	ETF	117.4	118.43	117.4	117.93	31201639.0
2011-08-26 13:00:00	SPY	ETF	117.93	118.51	117.7	118.36	16631705.0
2011-08-26 14:00:00	SPY	ETF	118.37	118.5	117.58	117.98	23325206.0
2011-08-26 15:00:00	SPY	ETF	117.985	118.07	117.19	117.97	42505187.0
2011-08-26 16:00:00	SPY	ETF	117.96	118.34	116.2911	118.09	22951989.0
2011-08-26 17:00:00	SPY	ETF	118.09	118.18	118.05	118.13	80502.0
2011-08-26 18:00:00	SPY	ETF	118.1	118.16	117.91	118.08	191327.0
2011-08-26 19:00:00	SPY	ETF	118.11	118.22	118.09	118.22	35017.0
2011-08-26 05:00:00	QQQ	ETF	52.0	52.0	52.0	52.0	500.0
2011-08-26 06:00:00	QQQ	ETF	51.9	51.9	51.9	51.9	200.0
2011-08-26 07:00:00	QQQ	ETF	51.89	51.95	51.73	51.82	36521.0
2011-08-26 08:00:00	QQQ	ETF	51.83	51.85	51.49	51.54	519749.0
2011-08-26 09:00:00	QQQ	ETF	51.55	51.9	51.45	51.67	10113811.0
2011-08-26 10:00:00	QQQ	ETF	51.67	52.79	51.15	52.37	36340753.0
2011-08-26 11:00:00	QQQ	ETF	52.36	52.97	52.27	52.819	9961425.0
2011-08-26 12:00:00	QQQ	ETF	52.82	53.19	52.82	53.0	7516511.0
2011-08-26 13:00:00	QQQ	ETF	52.99	53.28	52.89	53.25	4555542.0
2011-08-26 14:00:00	QQQ	ETF	53.25	53.31	52.94	53.14	5734643.0
2011-08-26 15:00:00	QQQ	ETF	53.14	53.14	52.74	53.091	9434219.0
2011-08-26 16:00:00	QQQ	ETF	53.12	53.3	53.11	53.2	1496855.0
2011-08-26 17:00:00	QQQ	ETF	53.23	53.26	53.17	53.25	9506.0
2011-08-26 18:00:00	QQQ	ETF	53.26	53.27	53.13	53.22	39680.0
2011-08-26 19:00:00	QQQ	ETF	53.22	53.25	53.17	53.24	13904.0
2011-08-26 05:00:00	IWM	ETF	67.44	67.44	67.44	67.44	388.0
2011-08-26 07:00:00	IWM	ETF	67.45	67.45	67.01	67.26	17901.0
2011-08-26 08:00:00	IWM	ETF	67.3	67.54	66.63	66.84	704677.0
2011-08-26 09:00:00	IWM	ETF	66.83	67.335	66.54	66.93	9356115.0
2011-08-26 10:00:00	IWM	ETF	66.95	68.53	66.06	67.57	25339151.0
2011-08-26 11:00:00	IWM	ETF	67.57	68.66	67.44	68.46	8656503.0
2011-08-26 12:00:00	IWM	ETF	68.47	69.16	68.47	68.78	8184701.0
2011-08-26 13:00:00	IWM	ETF	68.785	69.3	68.62	69.22	5285744.0
2011-08-26 14:00:00	IWM	ETF	69.23	69.32	68.7	69.1399	6074094.0
2011-08-26 15:00:00	IWM	ETF	69.14	69.16	68.54	69.08	9813875.0
2011-08-26 16:00:00	IWM	ETF	69.08	69.23	67.453	69.11	4907796.0
2011-08-26 17:00:00	IWM	ETF	69.08	69.17	69.07	69.17	11522.0
2011-08-26 18:00:00	IWM	ETF	69.18	69.18	69.13	69.15	1747.0
2011-08-26 19:00:00	IWM	ETF	69.14	69.19	69.14	69.19	2600.0
2011-08-26 04:00:00	DIA	ETF	111.08	111.28	111.08	111.28	200.0
2011-08-26 07:00:00	DIA	ETF	111.48	111.48	111.3	111.3	1134.0
2011-08-26 08:00:00	DIA	ETF	110.97	111.05	110.45	110.45	25166.0
2011-08-26 09:00:00	DIA	ETF	110.51	110.82	110.06	110.6	1643891.0
2011-08-26 10:00:00	DIA	ETF	110.64	111.74	109.09	111.09	4950070.0

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

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