PREVIEW / etf_1hour / 2012-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-04.parquet
  size:    180 KB
  rows:    5,617

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-04 04:00:00	SPY	ETF	127.5	127.6	127.5	127.6	420.0
2012-01-04 05:00:00	SPY	ETF	127.84	127.84	127.66	127.66	200.0
2012-01-04 06:00:00	SPY	ETF	127.5	127.5	127.29	127.43	85700.0
2012-01-04 07:00:00	SPY	ETF	127.25	127.53	127.2	127.31	506957.0
2012-01-04 08:00:00	SPY	ETF	127.34	127.6029	127.03	127.08	1851710.0
2012-01-04 09:00:00	SPY	ETF	127.08	127.45	127.04	127.35	18185896.0
2012-01-04 10:00:00	SPY	ETF	127.35	127.36	126.71	127.0	21643730.0
2012-01-04 11:00:00	SPY	ETF	127.0	127.38	126.98	127.29	13093000.0
2012-01-04 12:00:00	SPY	ETF	127.29	127.65	127.27	127.61	9851274.0
2012-01-04 13:00:00	SPY	ETF	127.61	127.73	127.35	127.67	11029339.0
2012-01-04 14:00:00	SPY	ETF	127.68	127.81	127.45	127.71	14892534.0
2012-01-04 15:00:00	SPY	ETF	127.71	127.81	127.52	127.68	24080845.0
2012-01-04 16:00:00	SPY	ETF	127.65	127.8	126.97	127.76	9393134.0
2012-01-04 17:00:00	SPY	ETF	127.75	127.78	127.7	127.76	206024.0
2012-01-04 18:00:00	SPY	ETF	127.73	127.73	127.63	127.67	236613.0
2012-01-04 19:00:00	SPY	ETF	127.67	127.7	127.62	127.67	261178.0
2012-01-04 07:00:00	QQQ	ETF	56.84	56.96	56.84	56.88	7800.0
2012-01-04 08:00:00	QQQ	ETF	56.9	56.9	56.76	56.77	304718.0
2012-01-04 09:00:00	QQQ	ETF	56.77	56.88	56.62	56.79	4600024.0
2012-01-04 10:00:00	QQQ	ETF	56.79	56.79	56.56	56.76	4431904.0
2012-01-04 11:00:00	QQQ	ETF	56.76	57.015	56.75	56.95	3335280.0
2012-01-04 12:00:00	QQQ	ETF	56.96	57.13	56.94	57.11	3044477.0
2012-01-04 13:00:00	QQQ	ETF	57.119	57.17	56.98	57.13	2619736.0
2012-01-04 14:00:00	QQQ	ETF	57.121	57.22	57.0	57.165	3389693.0
2012-01-04 15:00:00	QQQ	ETF	57.17	57.17	57.03	57.14	4901646.0
2012-01-04 16:00:00	QQQ	ETF	57.14	57.22	57.1132	57.2	892048.0
2012-01-04 17:00:00	QQQ	ETF	57.2	57.22	57.18	57.2	13294.0
2012-01-04 18:00:00	QQQ	ETF	57.2	57.2	57.18	57.18	23435.0
2012-01-04 19:00:00	QQQ	ETF	57.19	57.19	57.16	57.18	11100.0
2012-01-04 07:00:00	IWM	ETF	74.78	74.84	74.74	74.75	6150.0
2012-01-04 08:00:00	IWM	ETF	74.78	74.78	74.5	74.54	74438.0
2012-01-04 09:00:00	IWM	ETF	74.54	74.65	74.26	74.6	6599698.0
2012-01-04 10:00:00	IWM	ETF	74.59	74.61	74.07	74.32	4942113.0
2012-01-04 11:00:00	IWM	ETF	74.33	74.64	74.33	74.5	3798529.0
2012-01-04 12:00:00	IWM	ETF	74.5	74.78	74.47	74.67	2809410.0
2012-01-04 13:00:00	IWM	ETF	74.67	74.68	74.42	74.575	4454489.0
2012-01-04 14:00:00	IWM	ETF	74.59	74.86	74.43	74.74	4320159.0
2012-01-04 15:00:00	IWM	ETF	74.73	74.78	74.53	74.61	5344958.0
2012-01-04 16:00:00	IWM	ETF	74.59	74.802	74.54	74.66	597308.0
2012-01-04 17:00:00	IWM	ETF	74.67	74.7	74.56	74.7	95670.0
2012-01-04 18:00:00	IWM	ETF	74.71	74.71	74.62	74.63	2101.0
2012-01-04 19:00:00	IWM	ETF	74.63	74.65	74.62	74.62	2700.0
2012-01-04 08:00:00	DIA	ETF	123.32	123.47	123.29	123.29	481700.0
2012-01-04 09:00:00	DIA	ETF	123.37	123.75	123.33	123.7	397016.0
2012-01-04 10:00:00	DIA	ETF	123.69	123.7	123.11	123.35	1390827.0
2012-01-04 11:00:00	DIA	ETF	123.34	123.67	123.32	123.5674	477555.0
2012-01-04 12:00:00	DIA	ETF	123.5674	123.8	123.53	123.7685	388757.0
2012-01-04 13:00:00	DIA	ETF	123.75	123.97	123.57	123.92	1544579.0
2012-01-04 14:00:00	DIA	ETF	123.92	123.99	123.74	123.9	505111.0
2012-01-04 15:00:00	DIA	ETF	123.89	124.05	123.79	123.96	866640.0

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

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