PREVIEW / etf_1hour / 2002-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-02-01.parquet
  size:    13 KB
  rows:    271

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
2002-02-01 08:00:00	SPY	ETF	112.755	113.2663	112.2791	113.1253	142800.0
2002-02-01 09:00:00	SPY	ETF	113.0019	113.4315	112.1802	113.101	2789420.0
2002-02-01 10:00:00	SPY	ETF	113.0929	113.3075	112.4228	112.5383	2893960.0
2002-02-01 11:00:00	SPY	ETF	112.5282	112.888	111.7523	112.2846	1921070.0
2002-02-01 12:00:00	SPY	ETF	112.2921	112.3805	111.0405	111.6217	2408610.0
2002-02-01 13:00:00	SPY	ETF	111.6648	112.0855	111.1607	111.7035	1467860.0
2002-02-01 14:00:00	SPY	ETF	111.7111	112.8	111.5863	112.4	1014320.0
2002-02-01 15:00:00	SPY	ETF	112.41	112.64	112.32	112.6	2406800.0
2002-02-01 16:00:00	SPY	ETF	112.55	113.9085	112.2185	112.2185	961300.0
2002-02-01 17:00:00	SPY	ETF	112.5961	112.632	112.5601	112.632	1670.0
2002-02-01 09:00:00	QQQ	ETF	38.4	38.68	38.3	38.61	6203800.0
2002-02-01 10:00:00	QQQ	ETF	38.58	38.88	38.35	38.39	12820000.0
2002-02-01 11:00:00	QQQ	ETF	38.37	38.51	38.04	38.06	11266800.0
2002-02-01 12:00:00	QQQ	ETF	38.13	38.3	37.7	37.91	9238300.0
2002-02-01 13:00:00	QQQ	ETF	37.92	38.13	37.87	37.98	4609800.0
2002-02-01 14:00:00	QQQ	ETF	37.97	38.35	37.93	38.05	7586000.0
2002-02-01 15:00:00	QQQ	ETF	38.08	38.25	38.01	38.06	6904200.0
2002-02-01 16:00:00	QQQ	ETF	38.06	38.85	38.0	38.07	2323100.0
2002-02-01 17:00:00	QQQ	ETF	38.08	38.16	38.07	38.07	11000.0
2002-02-01 18:00:00	QQQ	ETF	38.14	38.14	38.08	38.08	4900.0
2002-02-01 09:00:00	IWM	ETF	47.75	48.075	47.735	48.075	45200.0
2002-02-01 10:00:00	IWM	ETF	47.9	48.185	47.84	47.98	31400.0
2002-02-01 11:00:00	IWM	ETF	48.035	48.035	47.81	47.815	82800.0
2002-02-01 12:00:00	IWM	ETF	47.815	47.815	47.615	47.735	110600.0
2002-02-01 13:00:00	IWM	ETF	47.7	47.895	47.655	47.8	32000.0
2002-02-01 14:00:00	IWM	ETF	47.86	47.975	47.785	47.835	17000.0
2002-02-01 15:00:00	IWM	ETF	47.885	47.985	47.65	47.65	242800.0
2002-02-01 16:00:00	IWM	ETF	47.75	47.825	47.705	47.825	203800.0
2002-02-01 09:00:00	DIA	ETF	99.11	99.56	99.06	99.38	238800.0
2002-02-01 10:00:00	DIA	ETF	99.35	99.54	99.01	99.01	1472900.0
2002-02-01 11:00:00	DIA	ETF	99.01	99.2	98.94	99.0	521200.0
2002-02-01 12:00:00	DIA	ETF	98.95	99.05	98.64	98.79	258600.0
2002-02-01 13:00:00	DIA	ETF	98.79	99.14	98.79	98.96	243600.0
2002-02-01 14:00:00	DIA	ETF	98.89	99.25	98.85	98.94	234900.0
2002-02-01 15:00:00	DIA	ETF	98.94	99.16	98.85	99.1	573900.0
2002-02-01 16:00:00	DIA	ETF	99.09	99.28	99.06	99.28	78300.0

> showing 36 of 271 rows — these rows as CSV

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