PREVIEW / etf_1hour / 2012-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-25.parquet
  size:    185 KB
  rows:    5,730

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-25 04:00:00	SPY	ETF	132.5	132.5	132.31	132.37	14419.0
2012-06-25 05:00:00	SPY	ETF	132.32	132.32	132.18	132.25	34187.0
2012-06-25 06:00:00	SPY	ETF	132.17	132.27	132.1	132.24	37720.0
2012-06-25 07:00:00	SPY	ETF	132.27	132.32	131.97	132.15	475206.0
2012-06-25 08:00:00	SPY	ETF	132.2	132.27	131.98	132.05	2067397.0
2012-06-25 09:00:00	SPY	ETF	132.04	132.36	131.44	131.66	24962053.0
2012-06-25 10:00:00	SPY	ETF	131.66	131.85	131.2	131.36	26013314.0
2012-06-25 11:00:00	SPY	ETF	131.36	131.4	130.88	130.91	15810712.0
2012-06-25 12:00:00	SPY	ETF	130.9	131.21	130.85	131.07	10735232.0
2012-06-25 13:00:00	SPY	ETF	131.07	131.41	130.94	131.33	11877947.0
2012-06-25 14:00:00	SPY	ETF	131.32	131.48	131.04	131.08	13911033.0
2012-06-25 15:00:00	SPY	ETF	131.08	131.62	131.055	131.28	26397026.0
2012-06-25 16:00:00	SPY	ETF	131.27	131.804	130.85	131.29	8997415.0
2012-06-25 17:00:00	SPY	ETF	131.27	131.31	131.23	131.23	1179381.0
2012-06-25 18:00:00	SPY	ETF	131.25	131.3	131.15	131.3	26279.0
2012-06-25 19:00:00	SPY	ETF	131.29	131.44	131.27	131.35	100855.0
2012-06-25 04:00:00	QQQ	ETF	63.0	63.0	63.0	63.0	200.0
2012-06-25 05:00:00	QQQ	ETF	62.95	62.95	62.83	62.83	500.0
2012-06-25 06:00:00	QQQ	ETF	62.81	62.85	62.8	62.85	1300.0
2012-06-25 07:00:00	QQQ	ETF	62.86	62.86	62.74	62.81	25620.0
2012-06-25 08:00:00	QQQ	ETF	62.83	62.89	62.76	62.78	179777.0
2012-06-25 09:00:00	QQQ	ETF	62.8	62.87	62.49	62.59	5535577.0
2012-06-25 10:00:00	QQQ	ETF	62.58	62.69	62.19	62.31	5406915.0
2012-06-25 11:00:00	QQQ	ETF	62.31	62.32	61.96	61.98	3653895.0
2012-06-25 12:00:00	QQQ	ETF	61.97	62.185	61.95	62.11	2070988.0
2012-06-25 13:00:00	QQQ	ETF	62.11	62.28	62.02	62.19	2354831.0
2012-06-25 14:00:00	QQQ	ETF	62.18	62.25	61.98	62.03	3416862.0
2012-06-25 15:00:00	QQQ	ETF	62.03	62.32	62.02	62.1	6817027.0
2012-06-25 16:00:00	QQQ	ETF	62.1	62.2538	62.05	62.16	1043168.0
2012-06-25 17:00:00	QQQ	ETF	62.15	62.18	62.11	62.15	5202.0
2012-06-25 18:00:00	QQQ	ETF	62.15	62.18	62.13	62.18	17396.0
2012-06-25 19:00:00	QQQ	ETF	62.18	62.23	62.16	62.21	21270.0
2012-06-25 05:00:00	IWM	ETF	76.75	76.75	76.75	76.75	135.0
2012-06-25 06:00:00	IWM	ETF	76.66	76.66	76.63	76.66	1600.0
2012-06-25 07:00:00	IWM	ETF	76.71	76.71	76.5	76.62	31734.0
2012-06-25 08:00:00	IWM	ETF	76.65	76.72	76.42	76.43	283950.0
2012-06-25 09:00:00	IWM	ETF	76.43	76.56	76.11	76.49	9205996.0
2012-06-25 10:00:00	IWM	ETF	76.49	76.7	76.15	76.28	8225080.0
2012-06-25 11:00:00	IWM	ETF	76.2799	76.31	76.0	76.07	4031915.0
2012-06-25 12:00:00	IWM	ETF	76.06	76.32	76.035	76.205	1959540.0
2012-06-25 13:00:00	IWM	ETF	76.21	76.48	76.13	76.371	2793987.0
2012-06-25 14:00:00	IWM	ETF	76.37	76.44	76.16	76.185	3450230.0
2012-06-25 15:00:00	IWM	ETF	76.18	76.48	76.145	76.32	7675988.0
2012-06-25 16:00:00	IWM	ETF	76.33	76.33	76.0	76.22	2300846.0
2012-06-25 17:00:00	IWM	ETF	76.21	76.3	76.21	76.22	38437.0
2012-06-25 18:00:00	IWM	ETF	76.22	76.24	76.21	76.24	2468.0
2012-06-25 19:00:00	IWM	ETF	76.25	76.32	76.25	76.28	6200.0
2012-06-25 07:00:00	DIA	ETF	125.44	125.44	125.25	125.25	1222.0
2012-06-25 08:00:00	DIA	ETF	125.19	125.37	125.09	125.09	6400.0
2012-06-25 09:00:00	DIA	ETF	125.19	125.19	124.53	124.75	784716.0

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

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