PREVIEW / etf_1hour / 2009-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-09.parquet
  size:    124 KB
  rows:    3,787

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-01-09 04:00:00	SPY	ETF	90.54	90.69	90.52	90.54	2301.0
2009-01-09 05:00:00	SPY	ETF	90.62	90.79	90.62	90.79	3500.0
2009-01-09 06:00:00	SPY	ETF	90.85	90.85	90.62	90.63	9494.0
2009-01-09 07:00:00	SPY	ETF	90.74	90.9	90.69	90.84	158524.0
2009-01-09 08:00:00	SPY	ETF	90.83	91.85	90.65	91.45	10951307.0
2009-01-09 09:00:00	SPY	ETF	91.44	91.46	89.14	89.42	50524650.0
2009-01-09 10:00:00	SPY	ETF	89.4	89.75	89.03	89.48	49426260.0
2009-01-09 11:00:00	SPY	ETF	89.47	89.94	89.32	89.57	38486140.0
2009-01-09 12:00:00	SPY	ETF	89.57	89.91	89.4	89.5	25750393.0
2009-01-09 13:00:00	SPY	ETF	89.51	89.82	89.2	89.41	30638623.0
2009-01-09 14:00:00	SPY	ETF	89.41	90.9969	89.4	89.94	34655047.0
2009-01-09 15:00:00	SPY	ETF	89.94	90.12	88.81	89.01	65940917.0
2009-01-09 16:00:00	SPY	ETF	89.03	90.9969	88.67	88.85	17283372.0
2009-01-09 17:00:00	SPY	ETF	88.85	88.97	88.74	88.95	197868.0
2009-01-09 18:00:00	SPY	ETF	88.95	89.18	88.91	89.04	236859.0
2009-01-09 19:00:00	SPY	ETF	89.04	89.1	89.01	89.07	34304.0
2009-01-09 04:00:00	QQQ	ETF	30.55	30.55	30.51	30.51	400.0
2009-01-09 06:00:00	QQQ	ETF	30.53	30.55	30.53	30.55	600.0
2009-01-09 07:00:00	QQQ	ETF	30.59	30.68	30.59	30.66	59266.0
2009-01-09 08:00:00	QQQ	ETF	30.65	30.9	30.54	30.85	4493597.0
2009-01-09 09:00:00	QQQ	ETF	30.83	30.83	29.92	29.99	19931510.0
2009-01-09 10:00:00	QQQ	ETF	30.0	30.18	29.94	30.1	18822566.0
2009-01-09 11:00:00	QQQ	ETF	30.1	30.28	30.05	30.1701	11095990.0
2009-01-09 12:00:00	QQQ	ETF	30.1701	30.32	30.15	30.18	8688553.0
2009-01-09 13:00:00	QQQ	ETF	30.18	30.3	30.09	30.17	10191249.0
2009-01-09 14:00:00	QQQ	ETF	30.18	30.47	30.17	30.4	11502963.0
2009-01-09 15:00:00	QQQ	ETF	30.39	30.44	30.01	30.08	26222818.0
2009-01-09 16:00:00	QQQ	ETF	30.08	30.2145	29.95	30.02	2997639.0
2009-01-09 17:00:00	QQQ	ETF	30.04	30.06	30.01	30.05	69630.0
2009-01-09 18:00:00	QQQ	ETF	30.04	30.07	30.0	30.07	29110.0
2009-01-09 19:00:00	QQQ	ETF	30.06	30.12	30.06	30.12	15508.0
2009-01-09 07:00:00	IWM	ETF	50.02	50.1	50.0	50.06	5900.0
2009-01-09 08:00:00	IWM	ETF	50.0	50.38	49.94	50.17	621114.0
2009-01-09 09:00:00	IWM	ETF	50.19	50.23	48.4105	48.65	9510115.0
2009-01-09 10:00:00	IWM	ETF	48.64	48.96	48.29	48.51	11544058.0
2009-01-09 11:00:00	IWM	ETF	48.5	48.85	48.42	48.72	5745153.0
2009-01-09 12:00:00	IWM	ETF	48.72	49.12	48.67	48.73	5328329.0
2009-01-09 13:00:00	IWM	ETF	48.73	48.91	48.41	48.5	6586035.0
2009-01-09 14:00:00	IWM	ETF	48.5	48.83	48.48	48.69	8460594.0
2009-01-09 15:00:00	IWM	ETF	48.68	48.77	47.92	48.0	19784282.0
2009-01-09 16:00:00	IWM	ETF	47.99	50.0881	47.68	47.8	13895589.0
2009-01-09 17:00:00	IWM	ETF	47.82	47.88	47.74	47.81	34449.0
2009-01-09 18:00:00	IWM	ETF	47.85	47.9	47.85	47.9	2500.0
2009-01-09 19:00:00	IWM	ETF	47.9	47.9	47.77	47.77	1823.0
2009-01-09 06:00:00	DIA	ETF	87.18	87.25	87.1	87.1	300.0
2009-01-09 07:00:00	DIA	ETF	87.17	87.27	87.1	87.19	7436.0
2009-01-09 08:00:00	DIA	ETF	87.2	87.99	87.09	87.85	135067.0
2009-01-09 09:00:00	DIA	ETF	87.78	87.78	86.04	86.28	3787309.0
2009-01-09 10:00:00	DIA	ETF	86.28	86.51	85.98	86.32	4813897.0
2009-01-09 11:00:00	DIA	ETF	86.32	86.74	86.19	86.5	2907152.0

> showing 50 of 3,787 rows — these rows as CSV

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