PREVIEW / etf_1hour / 2012-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-31.parquet
  size:    209 KB
  rows:    6,449

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-12-31 04:00:00	SPY	ETF	139.45	139.48	139.24	139.24	3183.0
2012-12-31 05:00:00	SPY	ETF	139.14	139.15	139.1	139.15	7109.0
2012-12-31 06:00:00	SPY	ETF	139.18	139.35	139.18	139.34	4516.0
2012-12-31 07:00:00	SPY	ETF	139.3	139.3	138.8	139.19	276843.0
2012-12-31 08:00:00	SPY	ETF	139.19	140.04	138.95	139.86	2351042.0
2012-12-31 09:00:00	SPY	ETF	139.88	140.56	139.54	140.43	23152481.0
2012-12-31 10:00:00	SPY	ETF	140.42	140.74	140.17	140.29	29338785.0
2012-12-31 11:00:00	SPY	ETF	140.29	140.73	140.23	140.359	20457131.0
2012-12-31 12:00:00	SPY	ETF	140.37	141.45	140.33	140.97	25350888.0
2012-12-31 13:00:00	SPY	ETF	140.97	141.64	140.63	140.92	36155233.0
2012-12-31 14:00:00	SPY	ETF	140.93	142.1399	140.85	142.029	20648547.0
2012-12-31 15:00:00	SPY	ETF	142.03	142.56	141.41	142.46	57704179.0
2012-12-31 16:00:00	SPY	ETF	142.45	142.82	140.0259	142.59	23689347.0
2012-12-31 17:00:00	SPY	ETF	142.59	142.82	142.52	142.8	674753.0
2012-12-31 18:00:00	SPY	ETF	142.82	142.88	142.48	142.48	500263.0
2012-12-31 19:00:00	SPY	ETF	142.53	142.6	142.48	142.55	82403.0
2012-12-31 06:00:00	QQQ	ETF	63.46	63.46	63.46	63.46	300.0
2012-12-31 07:00:00	QQQ	ETF	63.46	63.46	63.31	63.37	72912.0
2012-12-31 08:00:00	QQQ	ETF	63.41	63.84	63.38	63.8	284041.0
2012-12-31 09:00:00	QQQ	ETF	63.82	64.35	63.58	64.28	6529261.0
2012-12-31 10:00:00	QQQ	ETF	64.28	64.45	64.15	64.19	6367604.0
2012-12-31 11:00:00	QQQ	ETF	64.19	64.39	64.11	64.2299	4057312.0
2012-12-31 12:00:00	QQQ	ETF	64.225	64.74	64.15	64.51	6120075.0
2012-12-31 13:00:00	QQQ	ETF	64.51	64.83	64.35	64.49	8243073.0
2012-12-31 14:00:00	QQQ	ETF	64.49	65.22	64.45	65.14	5796780.0
2012-12-31 15:00:00	QQQ	ETF	65.1313	65.2521	64.82	65.12	14242538.0
2012-12-31 16:00:00	QQQ	ETF	65.12	65.33	64.8636	65.17	3252549.0
2012-12-31 17:00:00	QQQ	ETF	65.18	65.3	65.18	65.26	7650.0
2012-12-31 18:00:00	QQQ	ETF	65.29	65.3	65.18	65.18	12267.0
2012-12-31 19:00:00	QQQ	ETF	65.17	65.2	65.14	65.15	7100.0
2012-12-31 04:00:00	IWM	ETF	82.0	82.25	82.0	82.25	2200.0
2012-12-31 06:00:00	IWM	ETF	82.25	82.25	82.25	82.25	2000.0
2012-12-31 07:00:00	IWM	ETF	82.19	82.23	82.11	82.21	32711.0
2012-12-31 08:00:00	IWM	ETF	82.22	82.77	82.13	82.69	314580.0
2012-12-31 09:00:00	IWM	ETF	82.72	82.86	82.35	82.805	7506701.0
2012-12-31 10:00:00	IWM	ETF	82.8	83.35	82.76	83.0	7978794.0
2012-12-31 11:00:00	IWM	ETF	83.0	83.47	82.97	83.35	5735091.0
2012-12-31 12:00:00	IWM	ETF	83.35	83.81	83.33	83.44	6567369.0
2012-12-31 13:00:00	IWM	ETF	83.44	83.83	83.25	83.47	7810212.0
2012-12-31 14:00:00	IWM	ETF	83.47	84.12	83.405	84.03	6428148.0
2012-12-31 15:00:00	IWM	ETF	84.03	84.43	83.71	84.25	16179413.0
2012-12-31 16:00:00	IWM	ETF	84.24	84.64	84.02	84.34	4144450.0
2012-12-31 17:00:00	IWM	ETF	84.37	84.41	84.37	84.41	2000.0
2012-12-31 18:00:00	IWM	ETF	84.41	84.41	84.36	84.38	6200.0
2012-12-31 19:00:00	IWM	ETF	84.37	84.37	84.37	84.37	4900.0
2012-12-31 04:00:00	DIA	ETF	128.65	128.65	128.65	128.65	100.0
2012-12-31 05:00:00	DIA	ETF	128.11	128.11	128.11	128.11	400.0
2012-12-31 07:00:00	DIA	ETF	128.22	128.22	128.2	128.2	1100.0
2012-12-31 08:00:00	DIA	ETF	128.5	129.15	128.35	129.02	48261.0
2012-12-31 09:00:00	DIA	ETF	129.01	129.28	128.543	129.12	1279141.0

> showing 50 of 6,449 rows — these rows as CSV

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