PREVIEW / etf_1hour / 2012-01-05

all etf 1-hour files

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

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-01-05 04:00:00	SPY	ETF	127.32	127.33	126.95	126.95	9983.0
2012-01-05 05:00:00	SPY	ETF	126.9	127.0	126.59	126.59	31500.0
2012-01-05 06:00:00	SPY	ETF	126.68	126.83	126.49	126.74	186482.0
2012-01-05 07:00:00	SPY	ETF	126.81	127.01	126.77	126.9	499829.0
2012-01-05 08:00:00	SPY	ETF	126.93	127.9	126.85	127.22	4639013.0
2012-01-05 09:00:00	SPY	ETF	127.23	127.27	126.47	126.75	25885210.0
2012-01-05 10:00:00	SPY	ETF	126.75	127.12	126.43	126.87	32048707.0
2012-01-05 11:00:00	SPY	ETF	126.86	127.53	126.79	127.35	18849784.0
2012-01-05 12:00:00	SPY	ETF	127.36	127.89	127.31	127.87	16668233.0
2012-01-05 13:00:00	SPY	ETF	127.87	128.23	127.75	128.07	14599329.0
2012-01-05 14:00:00	SPY	ETF	128.08	128.17	127.82	127.865	18720247.0
2012-01-05 15:00:00	SPY	ETF	127.865	128.14	127.78	128.06	24043513.0
2012-01-05 16:00:00	SPY	ETF	128.05	128.14	127.6535	127.73	13064674.0
2012-01-05 17:00:00	SPY	ETF	127.73	127.73	127.59	127.65	788162.0
2012-01-05 18:00:00	SPY	ETF	127.67	128.1	127.62	127.78	385045.0
2012-01-05 19:00:00	SPY	ETF	127.74	127.85	127.64	127.66	124283.0
2012-01-05 04:00:00	QQQ	ETF	56.95	56.95	56.94	56.94	4500.0
2012-01-05 05:00:00	QQQ	ETF	56.91	56.92	56.79	56.79	27000.0
2012-01-05 06:00:00	QQQ	ETF	56.75	56.86	56.75	56.85	14200.0
2012-01-05 07:00:00	QQQ	ETF	56.85	56.96	56.85	56.95	125169.0
2012-01-05 08:00:00	QQQ	ETF	56.95	57.44	56.9	57.08	660585.0
2012-01-05 09:00:00	QQQ	ETF	57.08	57.21	56.8	57.0	6382084.0
2012-01-05 10:00:00	QQQ	ETF	56.99	57.2	56.89	57.05	6621060.0
2012-01-05 11:00:00	QQQ	ETF	57.06	57.32	57.0	57.2434	4145780.0
2012-01-05 12:00:00	QQQ	ETF	57.249	57.439	57.22	57.43	4880109.0
2012-01-05 13:00:00	QQQ	ETF	57.42	57.66	57.38	57.585	4186011.0
2012-01-05 14:00:00	QQQ	ETF	57.58	57.62	57.48	57.4871	2524539.0
2012-01-05 15:00:00	QQQ	ETF	57.4825	57.63	57.45	57.61	6836682.0
2012-01-05 16:00:00	QQQ	ETF	57.61	57.62	57.47	57.49	1355792.0
2012-01-05 17:00:00	QQQ	ETF	57.49	57.49	57.44	57.46	73725.0
2012-01-05 18:00:00	QQQ	ETF	57.49	57.53	57.46	57.52	10305.0
2012-01-05 19:00:00	QQQ	ETF	57.52	57.53	57.45	57.48	29690.0
2012-01-05 04:00:00	IWM	ETF	74.29	74.29	74.08	74.08	335.0
2012-01-05 05:00:00	IWM	ETF	73.88	73.88	73.88	73.88	200.0
2012-01-05 07:00:00	IWM	ETF	73.84	73.9	73.76	73.85	29881.0
2012-01-05 08:00:00	IWM	ETF	73.86	75.07	73.84	74.16	423474.0
2012-01-05 09:00:00	IWM	ETF	74.16	74.22	73.5	73.74	5950059.0
2012-01-05 10:00:00	IWM	ETF	73.73	74.04	73.37	73.77	8439196.0
2012-01-05 11:00:00	IWM	ETF	73.76	74.48	73.705	74.32	4466362.0
2012-01-05 12:00:00	IWM	ETF	74.325	74.99	74.29	74.95	6717670.0
2012-01-05 13:00:00	IWM	ETF	74.95	75.34	74.859	75.16	3940194.0
2012-01-05 14:00:00	IWM	ETF	75.16	75.23	74.87	74.905	4475942.0
2012-01-05 15:00:00	IWM	ETF	74.894	75.15	74.82	74.98	6370999.0
2012-01-05 16:00:00	IWM	ETF	74.98	75.0	74.5455	74.7	5056997.0
2012-01-05 17:00:00	IWM	ETF	74.69	74.99	74.62	74.65	95651.0
2012-01-05 18:00:00	IWM	ETF	74.69	74.7	74.66	74.66	950.0
2012-01-05 19:00:00	IWM	ETF	74.68	74.68	74.68	74.68	200.0
2012-01-05 07:00:00	DIA	ETF	123.41	123.41	123.15	123.15	1700.0
2012-01-05 08:00:00	DIA	ETF	123.55	123.89	123.21	123.7	61270.0
2012-01-05 09:00:00	DIA	ETF	123.5	123.5	122.77	122.93	833046.0

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

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