PREVIEW / etf_1hour / 2012-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-30.parquet
  size:    184 KB
  rows:    5,766

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-30 04:00:00	SPY	ETF	133.0	133.18	132.88	132.99	4682.0
2012-05-30 05:00:00	SPY	ETF	132.85	132.95	132.67	132.95	48378.0
2012-05-30 06:00:00	SPY	ETF	132.86	132.93	132.5	132.57	192649.0
2012-05-30 07:00:00	SPY	ETF	132.57	133.68	132.57	132.98	2091356.0
2012-05-30 08:00:00	SPY	ETF	133.0	133.37	132.6	132.8	2004786.0
2012-05-30 09:00:00	SPY	ETF	132.8	133.25	132.02	132.17	23615941.0
2012-05-30 10:00:00	SPY	ETF	132.1759	132.3	131.81	131.839	25197379.0
2012-05-30 11:00:00	SPY	ETF	131.83	132.25	131.76	131.96	18197157.0
2012-05-30 12:00:00	SPY	ETF	131.96	132.03	131.55	131.86	14764928.0
2012-05-30 13:00:00	SPY	ETF	131.86	132.165	131.64	132.12	11911872.0
2012-05-30 14:00:00	SPY	ETF	132.13	133.6924	131.87	131.93	13748546.0
2012-05-30 15:00:00	SPY	ETF	131.92	133.6924	131.49	131.79	32025529.0
2012-05-30 16:00:00	SPY	ETF	131.79	132.3222	131.38	131.4	17751460.0
2012-05-30 17:00:00	SPY	ETF	131.41	131.43	131.31	131.37	228522.0
2012-05-30 18:00:00	SPY	ETF	131.35	131.46	131.27	131.41	108913.0
2012-05-30 19:00:00	SPY	ETF	131.41	131.48	131.38	131.46	107182.0
2012-05-30 05:00:00	QQQ	ETF	62.36	62.36	62.27	62.29	1447.0
2012-05-30 06:00:00	QQQ	ETF	62.39	62.39	62.21	62.21	14600.0
2012-05-30 07:00:00	QQQ	ETF	62.4	62.65	62.32	62.46	70974.0
2012-05-30 08:00:00	QQQ	ETF	62.46	62.47	62.32	62.37	196555.0
2012-05-30 09:00:00	QQQ	ETF	62.39	62.39	61.94	62.1	8344911.0
2012-05-30 10:00:00	QQQ	ETF	62.12	62.27	61.97	62.0	9314534.0
2012-05-30 11:00:00	QQQ	ETF	62.0	62.2801	61.97	62.2	5466349.0
2012-05-30 12:00:00	QQQ	ETF	62.2	62.24	61.96	62.21	3882189.0
2012-05-30 13:00:00	QQQ	ETF	62.21	62.46	62.06	62.44	5257903.0
2012-05-30 14:00:00	QQQ	ETF	62.4441	62.55	62.34	62.39	4746181.0
2012-05-30 15:00:00	QQQ	ETF	62.38	62.49	62.1	62.33	7251687.0
2012-05-30 16:00:00	QQQ	ETF	62.34	62.8585	62.15	62.18	4579847.0
2012-05-30 17:00:00	QQQ	ETF	62.18	62.18	62.13	62.14	54382.0
2012-05-30 18:00:00	QQQ	ETF	62.16	62.26	62.11	62.19	35160.0
2012-05-30 19:00:00	QQQ	ETF	62.21	62.21	62.17	62.18	8055.0
2012-05-30 07:00:00	IWM	ETF	77.7	77.7	77.12	77.27	21864.0
2012-05-30 08:00:00	IWM	ETF	77.27	77.27	76.81	77.14	186000.0
2012-05-30 09:00:00	IWM	ETF	77.13	77.15	76.37	76.7	8950802.0
2012-05-30 10:00:00	IWM	ETF	76.68	76.75	76.27	76.3101	8481356.0
2012-05-30 11:00:00	IWM	ETF	76.3	76.7	76.26	76.44	4348299.0
2012-05-30 12:00:00	IWM	ETF	76.43	76.5	76.11	76.3199	3722102.0
2012-05-30 13:00:00	IWM	ETF	76.33	76.53	76.16	76.47	2636917.0
2012-05-30 14:00:00	IWM	ETF	76.47	76.61	76.35	76.37	3215925.0
2012-05-30 15:00:00	IWM	ETF	76.3601	76.4901	76.11	76.23	8624045.0
2012-05-30 16:00:00	IWM	ETF	76.24	77.7046	76.02	76.03	2304557.0
2012-05-30 17:00:00	IWM	ETF	76.02	76.09	76.0	76.05	76840.0
2012-05-30 18:00:00	IWM	ETF	76.02	76.02	75.97	76.0	1800.0
2012-05-30 19:00:00	IWM	ETF	75.91	76.1	75.91	76.1	1000.0
2012-05-30 06:00:00	DIA	ETF	124.82	124.82	124.62	124.62	300.0
2012-05-30 07:00:00	DIA	ETF	125.03	125.2	124.75	124.89	2700.0
2012-05-30 08:00:00	DIA	ETF	124.87	124.94	124.62	124.62	9950.0
2012-05-30 09:00:00	DIA	ETF	124.61	124.61	124.18	124.29	776727.0
2012-05-30 10:00:00	DIA	ETF	124.292	124.375	123.97	123.9995	937244.0
2012-05-30 11:00:00	DIA	ETF	124.0	124.34	123.9299	124.12	624208.0

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

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