PREVIEW / etf_1hour / 2002-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-31.parquet
  size:    13 KB
  rows:    257

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-01-31 08:00:00	SPY	ETF	111.7943	112.2389	111.7943	112.15	28500.0
2002-01-31 09:00:00	SPY	ETF	112.1322	113.0148	112.0611	112.7984	2123160.0
2002-01-31 10:00:00	SPY	ETF	112.811	113.3541	111.738	111.9169	3481210.0
2002-01-31 11:00:00	SPY	ETF	111.9323	112.47	111.62	112.3687	2846190.0
2002-01-31 12:00:00	SPY	ETF	112.3818	113.2317	112.1422	112.7764	1800940.0
2002-01-31 13:00:00	SPY	ETF	112.8432	113.3563	112.3006	112.666	1601120.0
2002-01-31 14:00:00	SPY	ETF	112.6612	113.1054	111.8737	112.4508	1628270.0
2002-01-31 15:00:00	SPY	ETF	112.4283	113.3379	112.1934	113.18	3238470.0
2002-01-31 16:00:00	SPY	ETF	113.1622	113.5175	111.972	113.18	2233450.0
2002-01-31 17:00:00	SPY	ETF	113.18	113.2511	112.8958	112.9846	240590.0
2002-01-31 18:00:00	SPY	ETF	112.9846	113.18	112.8958	113.1622	1290.0
2002-01-31 09:00:00	QQQ	ETF	38.57	38.71	38.34	38.61	10321300.0
2002-01-31 10:00:00	QQQ	ETF	38.61	38.72	38.02	38.12	12390600.0
2002-01-31 11:00:00	QQQ	ETF	38.06	38.33	38.05	38.31	4997400.0
2002-01-31 12:00:00	QQQ	ETF	38.31	38.51	38.21	38.48	5945200.0
2002-01-31 13:00:00	QQQ	ETF	38.46	38.69	38.38	38.49	6544800.0
2002-01-31 14:00:00	QQQ	ETF	38.49	38.58	38.21	38.41	7901700.0
2002-01-31 15:00:00	QQQ	ETF	38.41	38.75	38.38	38.55	18302300.0
2002-01-31 16:00:00	QQQ	ETF	38.56	38.68	38.43	38.55	2427100.0
2002-01-31 17:00:00	QQQ	ETF	38.55	38.55	38.45	38.48	61400.0
2002-01-31 18:00:00	QQQ	ETF	38.48	38.5	38.48	38.5	3000.0
2002-01-31 09:00:00	IWM	ETF	47.8	47.9	47.505	47.7	156000.0
2002-01-31 10:00:00	IWM	ETF	47.76	47.82	47.53	47.57	148200.0
2002-01-31 11:00:00	IWM	ETF	47.56	47.67	47.55	47.58	73400.0
2002-01-31 12:00:00	IWM	ETF	47.6	47.845	47.6	47.845	51800.0
2002-01-31 13:00:00	IWM	ETF	47.86	47.92	47.76	47.87	35800.0
2002-01-31 14:00:00	IWM	ETF	47.885	47.91	47.69	47.8	65600.0
2002-01-31 15:00:00	IWM	ETF	47.8	47.96	47.78	47.955	173400.0
2002-01-31 16:00:00	IWM	ETF	47.96	48.1	47.94	48.1	1966000.0
2002-01-31 09:00:00	DIA	ETF	98.05	98.16	97.8	98.12	1114800.0
2002-01-31 10:00:00	DIA	ETF	98.12	98.46	97.79	97.99	432700.0
2002-01-31 11:00:00	DIA	ETF	98.0	98.34	97.94	98.12	130700.0
2002-01-31 12:00:00	DIA	ETF	98.17	98.49	98.08	98.4	171200.0
2002-01-31 13:00:00	DIA	ETF	98.43	98.6	98.28	98.4	919600.0
2002-01-31 14:00:00	DIA	ETF	98.43	98.71	98.35	98.62	376700.0
2002-01-31 15:00:00	DIA	ETF	98.68	99.31	98.64	99.18	695100.0
2002-01-31 16:00:00	DIA	ETF	99.2	99.24	99.05	99.15	97300.0
2002-01-31 17:00:00	DIA	ETF	99.16	99.16	99.16	99.16	100.0

> showing 38 of 257 rows — these rows as CSV

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