PREVIEW / etf_1hour / 2012-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-21.parquet
  size:    189 KB
  rows:    5,850

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-21 04:00:00	SPY	ETF	130.6	130.82	130.58	130.58	53138.0
2012-05-21 05:00:00	SPY	ETF	130.58	130.67	130.34	130.44	15300.0
2012-05-21 06:00:00	SPY	ETF	130.42	130.69	130.37	130.62	170686.0
2012-05-21 07:00:00	SPY	ETF	130.62	130.69	130.34	130.41	618697.0
2012-05-21 08:00:00	SPY	ETF	130.39	130.48	130.08	130.16	2150198.0
2012-05-21 09:00:00	SPY	ETF	130.17	130.49	129.95	130.36	26041269.0
2012-05-21 10:00:00	SPY	ETF	130.35	131.46	130.23	131.36	35608202.0
2012-05-21 11:00:00	SPY	ETF	131.35	131.37	131.0	131.06	20970123.0
2012-05-21 12:00:00	SPY	ETF	131.05	131.56	131.0	131.338	14977964.0
2012-05-21 13:00:00	SPY	ETF	131.34	131.63	131.28	131.489	11614141.0
2012-05-21 14:00:00	SPY	ETF	131.485	131.75	131.25	131.66	14109169.0
2012-05-21 15:00:00	SPY	ETF	131.66	132.02	131.645	131.95	26632828.0
2012-05-21 16:00:00	SPY	ETF	131.98	132.16	131.94	132.02	17613057.0
2012-05-21 17:00:00	SPY	ETF	132.02	132.05	131.96	132.0	146481.0
2012-05-21 18:00:00	SPY	ETF	131.98	132.15	131.97	132.04	96928.0
2012-05-21 19:00:00	SPY	ETF	132.04	132.14	132.03	132.14	30390.0
2012-05-21 04:00:00	QQQ	ETF	61.01	61.21	61.01	61.15	3200.0
2012-05-21 06:00:00	QQQ	ETF	61.07	61.15	61.06	61.15	13013.0
2012-05-21 07:00:00	QQQ	ETF	61.16	61.18	61.03	61.05	117395.0
2012-05-21 08:00:00	QQQ	ETF	61.06	61.07	60.81	60.91	3584895.0
2012-05-21 09:00:00	QQQ	ETF	60.91	61.2	60.81	61.11	8024705.0
2012-05-21 10:00:00	QQQ	ETF	61.1	61.87	61.05	61.82	11919734.0
2012-05-21 11:00:00	QQQ	ETF	61.81	61.84	61.63	61.78	4319772.0
2012-05-21 12:00:00	QQQ	ETF	61.78	62.32	61.73	62.2	7429353.0
2012-05-21 13:00:00	QQQ	ETF	62.2	62.3	62.1	62.21	3081579.0
2012-05-21 14:00:00	QQQ	ETF	62.21	62.36	62.07	62.3101	3854558.0
2012-05-21 15:00:00	QQQ	ETF	62.3199	62.57	62.29	62.49	8723792.0
2012-05-21 16:00:00	QQQ	ETF	62.48	62.6	60.8704	62.52	3761424.0
2012-05-21 17:00:00	QQQ	ETF	62.52	62.55	62.49	62.52	19900.0
2012-05-21 18:00:00	QQQ	ETF	62.52	62.58	62.51	62.53	51713.0
2012-05-21 19:00:00	QQQ	ETF	62.54	62.58	62.53	62.58	50545.0
2012-05-21 04:00:00	IWM	ETF	75.14	75.3	75.14	75.3	2100.0
2012-05-21 05:00:00	IWM	ETF	75.16	75.16	75.16	75.16	2000.0
2012-05-21 06:00:00	IWM	ETF	75.07	75.18	75.07	75.18	9400.0
2012-05-21 07:00:00	IWM	ETF	75.15	75.2	75.01	75.01	23309.0
2012-05-21 08:00:00	IWM	ETF	75.01	75.16	74.79	74.86	358836.0
2012-05-21 09:00:00	IWM	ETF	74.85	75.01	74.41	74.85	9726702.0
2012-05-21 10:00:00	IWM	ETF	74.84	75.95	74.8	75.93	14370421.0
2012-05-21 11:00:00	IWM	ETF	75.92	75.9301	75.45	75.53	6296468.0
2012-05-21 12:00:00	IWM	ETF	75.535	76.26	75.5	75.89	6497686.0
2012-05-21 13:00:00	IWM	ETF	75.89	76.19	75.85	76.1001	2934898.0
2012-05-21 14:00:00	IWM	ETF	76.1	76.21	75.89	76.165	3758901.0
2012-05-21 15:00:00	IWM	ETF	76.165	76.43	76.13	76.38	10620793.0
2012-05-21 16:00:00	IWM	ETF	76.38	76.45	75.8	76.26	2092893.0
2012-05-21 17:00:00	IWM	ETF	76.25	76.28	76.2	76.27	27400.0
2012-05-21 18:00:00	IWM	ETF	76.3	76.38	76.3	76.32	19175.0
2012-05-21 19:00:00	IWM	ETF	76.28	76.35	76.28	76.35	5402.0
2012-05-21 06:00:00	DIA	ETF	124.0	124.1	124.0	124.1	600.0
2012-05-21 07:00:00	DIA	ETF	124.05	124.11	123.92	123.92	1800.0
2012-05-21 08:00:00	DIA	ETF	123.87	123.91	123.73	123.73	13915.0

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

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