PREVIEW / etf_1hour / 2012-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-25.parquet
  size:    175 KB
  rows:    5,412

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-25 04:00:00	SPY	ETF	133.12	133.5	133.12	133.25	8105.0
2012-05-25 05:00:00	SPY	ETF	133.23	133.33	133.04	133.14	70952.0
2012-05-25 06:00:00	SPY	ETF	133.16	133.28	132.72	132.84	231470.0
2012-05-25 07:00:00	SPY	ETF	132.85	133.02	132.79	132.83	295028.0
2012-05-25 08:00:00	SPY	ETF	132.85	133.0601	132.42	132.43	3003929.0
2012-05-25 09:00:00	SPY	ETF	132.42	132.85	132.36	132.7	17229248.0
2012-05-25 10:00:00	SPY	ETF	132.7	132.8	132.26	132.36	21389967.0
2012-05-25 11:00:00	SPY	ETF	132.36	132.76	132.35	132.64	16442279.0
2012-05-25 12:00:00	SPY	ETF	132.63	132.66	132.3	132.405	15407396.0
2012-05-25 13:00:00	SPY	ETF	132.41	132.53	132.32	132.415	11405065.0
2012-05-25 14:00:00	SPY	ETF	132.42	132.45	132.0	132.12	11960549.0
2012-05-25 15:00:00	SPY	ETF	132.129	132.27	131.78	132.14	23968991.0
2012-05-25 16:00:00	SPY	ETF	132.14	132.7	131.5355	132.18	10255472.0
2012-05-25 17:00:00	SPY	ETF	132.18	132.18	131.96	132.0	206817.0
2012-05-25 18:00:00	SPY	ETF	132.0	132.04	131.95	131.98	59072.0
2012-05-25 19:00:00	SPY	ETF	132.0	132.04	131.96	132.04	13282.0
2012-05-25 04:00:00	QQQ	ETF	62.5	62.65	62.5	62.64	600.0
2012-05-25 06:00:00	QQQ	ETF	62.59	62.59	62.43	62.43	6100.0
2012-05-25 07:00:00	QQQ	ETF	62.39	62.46	62.35	62.37	169600.0
2012-05-25 08:00:00	QQQ	ETF	62.38	62.41	62.15	62.15	463915.0
2012-05-25 09:00:00	QQQ	ETF	62.15	62.3201	62.11	62.23	4273113.0
2012-05-25 10:00:00	QQQ	ETF	62.23	62.26	61.94	61.97	6474124.0
2012-05-25 11:00:00	QQQ	ETF	61.97	62.16	61.96	62.08	3934319.0
2012-05-25 12:00:00	QQQ	ETF	62.08	62.1301	61.99	62.09	2392975.0
2012-05-25 13:00:00	QQQ	ETF	62.08	62.27	62.04	62.18	2149203.0
2012-05-25 14:00:00	QQQ	ETF	62.18	62.2	61.98	62.02	3069545.0
2012-05-25 15:00:00	QQQ	ETF	62.02	62.1	61.8899	62.05	7093496.0
2012-05-25 16:00:00	QQQ	ETF	62.05	62.11	61.97	62.08	1305849.0
2012-05-25 17:00:00	QQQ	ETF	62.05	62.08	62.01	62.03	13315.0
2012-05-25 18:00:00	QQQ	ETF	62.03	62.03	62.03	62.03	4142.0
2012-05-25 19:00:00	QQQ	ETF	62.04	62.04	62.04	62.04	258.0
2012-05-25 04:00:00	IWM	ETF	77.07	77.33	77.07	77.33	868.0
2012-05-25 05:00:00	IWM	ETF	77.13	77.19	76.98	76.98	2300.0
2012-05-25 06:00:00	IWM	ETF	77.19	77.19	76.97	76.97	2500.0
2012-05-25 07:00:00	IWM	ETF	76.8	76.96	76.8	76.91	4014.0
2012-05-25 08:00:00	IWM	ETF	76.85	76.9	76.53	76.63	481359.0
2012-05-25 09:00:00	IWM	ETF	76.62	76.82	76.42	76.66	5327072.0
2012-05-25 10:00:00	IWM	ETF	76.65	76.7	76.2699	76.48	6262012.0
2012-05-25 11:00:00	IWM	ETF	76.4744	76.8901	76.4744	76.8101	6899276.0
2012-05-25 12:00:00	IWM	ETF	76.81	76.84	76.6	76.69	1854254.0
2012-05-25 13:00:00	IWM	ETF	76.688	76.83	76.61	76.73	1322231.0
2012-05-25 14:00:00	IWM	ETF	76.73	76.75	76.38	76.47	2993244.0
2012-05-25 15:00:00	IWM	ETF	76.47	76.65	76.3	76.59	5861482.0
2012-05-25 16:00:00	IWM	ETF	76.59	76.85	76.49	76.85	1083328.0
2012-05-25 17:00:00	IWM	ETF	76.53	76.53	76.53	76.53	10812.0
2012-05-25 18:00:00	IWM	ETF	76.53	76.55	76.53	76.55	1757.0
2012-05-25 19:00:00	IWM	ETF	76.59	76.59	76.53	76.53	500.0
2012-05-25 07:00:00	DIA	ETF	125.34	125.34	125.34	125.34	600.0
2012-05-25 08:00:00	DIA	ETF	125.24	125.24	124.85	124.85	4700.0
2012-05-25 09:00:00	DIA	ETF	124.88	125.07	124.6837	124.95	519286.0

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

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