PREVIEW / etf_1hour / 2009-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-23.parquet
  size:    145 KB
  rows:    4,562

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
2009-12-23 04:00:00	SPY	ETF	112.07	112.07	112.07	112.07	200.0
2009-12-23 05:00:00	SPY	ETF	112.2	112.2	112.2	112.2	300.0
2009-12-23 06:00:00	SPY	ETF	111.86	112.18	111.86	112.15	700.0
2009-12-23 07:00:00	SPY	ETF	112.17	112.23	112.09	112.22	253494.0
2009-12-23 08:00:00	SPY	ETF	112.21	112.26	111.96	112.05	2378200.0
2009-12-23 09:00:00	SPY	ETF	112.04	112.1	111.9	111.95	11731379.0
2009-12-23 10:00:00	SPY	ETF	111.93	111.948	111.5	111.75	23474574.0
2009-12-23 11:00:00	SPY	ETF	111.75	111.96	111.72	111.895	9157200.0
2009-12-23 12:00:00	SPY	ETF	111.91	112.03	111.815	111.97	5779123.0
2009-12-23 13:00:00	SPY	ETF	111.9609	112.11	111.9	112.0225	11459823.0
2009-12-23 14:00:00	SPY	ETF	112.03	112.1	111.98	112.0	10348864.0
2009-12-23 15:00:00	SPY	ETF	112.0099	112.08	111.7	111.97	18986809.0
2009-12-23 16:00:00	SPY	ETF	111.95	112.07	111.5897	111.96	16445363.0
2009-12-23 17:00:00	SPY	ETF	111.98	112.04	111.97	112.02	1031297.0
2009-12-23 18:00:00	SPY	ETF	112.02	112.02	111.95	111.97	25737.0
2009-12-23 19:00:00	SPY	ETF	111.97	111.99	111.92	111.95	16899.0
2009-12-23 04:00:00	QQQ	ETF	45.32	45.32	45.32	45.32	250.0
2009-12-23 07:00:00	QQQ	ETF	45.45	45.47	45.4	45.46	25450.0
2009-12-23 08:00:00	QQQ	ETF	45.46	45.47	45.34	45.36	2532209.0
2009-12-23 09:00:00	QQQ	ETF	45.35	45.42	45.26	45.3776	9593121.0
2009-12-23 10:00:00	QQQ	ETF	45.37	45.42	45.21	45.37	16823436.0
2009-12-23 11:00:00	QQQ	ETF	45.37	45.47	45.32	45.44	7264891.0
2009-12-23 12:00:00	QQQ	ETF	45.44	45.5	45.41	45.46	3005314.0
2009-12-23 13:00:00	QQQ	ETF	45.46	45.53	45.45	45.509	5450569.0
2009-12-23 14:00:00	QQQ	ETF	45.5	45.57	45.2289	45.53	4912186.0
2009-12-23 15:00:00	QQQ	ETF	45.53	45.57	45.45	45.56	8321129.0
2009-12-23 16:00:00	QQQ	ETF	45.55	45.6185	45.5	45.59	4343084.0
2009-12-23 17:00:00	QQQ	ETF	45.59	45.63	45.2289	45.61	6036804.0
2009-12-23 18:00:00	QQQ	ETF	45.61	45.61	45.57	45.6	25028.0
2009-12-23 19:00:00	QQQ	ETF	45.61	45.63	45.58	45.63	38824.0
2009-12-23 04:00:00	IWM	ETF	62.8	62.8	62.8	62.8	1000.0
2009-12-23 06:00:00	IWM	ETF	62.97	63.0	62.7	63.0	189200.0
2009-12-23 07:00:00	IWM	ETF	62.81	62.81	62.71	62.75	451956.0
2009-12-23 08:00:00	IWM	ETF	62.75	62.81	62.65	62.68	901711.0
2009-12-23 09:00:00	IWM	ETF	62.68	62.82	62.46	62.7	8211102.0
2009-12-23 10:00:00	IWM	ETF	62.7	62.7	62.31	62.49	8411861.0
2009-12-23 11:00:00	IWM	ETF	62.4878	62.87	62.48	62.84	5606317.0
2009-12-23 12:00:00	IWM	ETF	62.83	62.95	62.74	62.8598	3353126.0
2009-12-23 13:00:00	IWM	ETF	62.859	63.13	62.81	63.05	6620199.0
2009-12-23 14:00:00	IWM	ETF	63.06	63.15	62.98	63.06	2523145.0
2009-12-23 15:00:00	IWM	ETF	63.06	63.16	62.91	63.14	6851954.0
2009-12-23 16:00:00	IWM	ETF	63.13	63.22	62.4	63.2	2262547.0
2009-12-23 17:00:00	IWM	ETF	63.2	63.25	63.2	63.23	11420.0
2009-12-23 18:00:00	IWM	ETF	63.24	63.27	63.22	63.25	4300.0
2009-12-23 08:00:00	DIA	ETF	104.74	104.75	104.63	104.64	2300.0
2009-12-23 09:00:00	DIA	ETF	104.64	104.719	104.51	104.55	920921.0
2009-12-23 10:00:00	DIA	ETF	104.54	104.54	104.17	104.35	1536280.0
2009-12-23 11:00:00	DIA	ETF	104.34	104.49	104.29	104.4499	593589.0
2009-12-23 12:00:00	DIA	ETF	104.45	104.54	104.402	104.47	224119.0
2009-12-23 13:00:00	DIA	ETF	104.47	104.61	104.4	104.54	365202.0

> showing 50 of 4,562 rows — these rows as CSV

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