PREVIEW / etf_1hour / 2012-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-11.parquet
  size:    181 KB
  rows:    5,597

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-05-11 04:00:00	SPY	ETF	135.7	135.76	135.7	135.76	600.0
2012-05-11 05:00:00	SPY	ETF	135.7	135.7	135.48	135.6	5950.0
2012-05-11 06:00:00	SPY	ETF	135.6	135.83	135.49	135.49	31630.0
2012-05-11 07:00:00	SPY	ETF	135.49	135.78	135.38	135.68	523437.0
2012-05-11 08:00:00	SPY	ETF	135.67	135.9	135.17	135.3	1735147.0
2012-05-11 09:00:00	SPY	ETF	135.3	135.89	135.11	135.68	21479727.0
2012-05-11 10:00:00	SPY	ETF	135.6814	136.7	135.681	136.45	32357946.0
2012-05-11 11:00:00	SPY	ETF	136.45	136.87	136.34	136.5699	15686102.0
2012-05-11 12:00:00	SPY	ETF	136.5668	136.61	136.32	136.36	8419508.0
2012-05-11 13:00:00	SPY	ETF	136.38	136.38	136.07	136.185	12526351.0
2012-05-11 14:00:00	SPY	ETF	136.1883	136.25	135.88	135.97	16769787.0
2012-05-11 15:00:00	SPY	ETF	135.97	136.05	135.53	135.57	28841496.0
2012-05-11 16:00:00	SPY	ETF	135.56	136.4511	135.363	135.51	11986149.0
2012-05-11 17:00:00	SPY	ETF	135.5	135.57	135.43	135.54	95125.0
2012-05-11 18:00:00	SPY	ETF	135.53	135.56	135.5	135.56	6136.0
2012-05-11 19:00:00	SPY	ETF	135.52	135.6	135.51	135.58	37921.0
2012-05-11 20:00:00	SPY	ETF	135.6	135.6	135.6	135.6	200.0
2012-05-11 04:00:00	QQQ	ETF	64.0	64.0	64.0	64.0	314.0
2012-05-11 07:00:00	QQQ	ETF	64.06	64.29	64.06	64.22	24830.0
2012-05-11 08:00:00	QQQ	ETF	64.2	64.2	63.87	63.91	746838.0
2012-05-11 09:00:00	QQQ	ETF	63.92	64.43	63.82	64.33	7432583.0
2012-05-11 10:00:00	QQQ	ETF	64.33	64.86	64.33	64.73	12457154.0
2012-05-11 11:00:00	QQQ	ETF	64.73	64.8486	64.65	64.71	4149960.0
2012-05-11 12:00:00	QQQ	ETF	64.7	64.72	64.55	64.5971	2799583.0
2012-05-11 13:00:00	QQQ	ETF	64.59	64.66	64.48	64.6	2788101.0
2012-05-11 14:00:00	QQQ	ETF	64.6	64.619	64.39	64.43	3334555.0
2012-05-11 15:00:00	QQQ	ETF	64.44	64.4883	64.16	64.17	7567596.0
2012-05-11 16:00:00	QQQ	ETF	64.18	64.6756	64.12	64.25	1677930.0
2012-05-11 17:00:00	QQQ	ETF	64.23	64.24	64.2	64.24	12850.0
2012-05-11 18:00:00	QQQ	ETF	64.19	64.22	64.18	64.18	5111.0
2012-05-11 19:00:00	QQQ	ETF	64.15	64.15	64.13	64.15	4639.0
2012-05-11 04:00:00	IWM	ETF	78.58	78.58	78.58	78.58	500.0
2012-05-11 06:00:00	IWM	ETF	78.8	78.8	78.8	78.8	1000.0
2012-05-11 07:00:00	IWM	ETF	78.6	78.85	78.6	78.82	50189.0
2012-05-11 08:00:00	IWM	ETF	78.79	78.79	78.41	78.49	124918.0
2012-05-11 09:00:00	IWM	ETF	78.49	79.19	78.42	78.89	5605677.0
2012-05-11 10:00:00	IWM	ETF	78.89	79.56	78.83	79.16	10437464.0
2012-05-11 11:00:00	IWM	ETF	79.16	79.34	78.97	79.1	5515666.0
2012-05-11 12:00:00	IWM	ETF	79.09	79.36	79.06	79.18	2417282.0
2012-05-11 13:00:00	IWM	ETF	79.19	79.19	78.95	79.06	3106176.0
2012-05-11 14:00:00	IWM	ETF	79.07	79.1	78.85	78.88	3612889.0
2012-05-11 15:00:00	IWM	ETF	78.89	78.98	78.68	78.86	9294126.0
2012-05-11 16:00:00	IWM	ETF	78.86	79.1013	78.78	78.86	1964128.0
2012-05-11 17:00:00	IWM	ETF	78.85	78.88	78.85	78.88	500.0
2012-05-11 18:00:00	IWM	ETF	78.93	78.93	78.93	78.93	200.0
2012-05-11 19:00:00	IWM	ETF	78.85	78.88	78.85	78.88	734.0
2012-05-11 07:00:00	DIA	ETF	127.76	128.21	127.76	128.21	1893.0
2012-05-11 08:00:00	DIA	ETF	128.09	128.1	127.76	127.86	7193.0
2012-05-11 09:00:00	DIA	ETF	127.9	128.26	127.73	128.1385	476598.0
2012-05-11 10:00:00	DIA	ETF	128.16	129.0	128.16	128.85	1071556.0

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

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