PREVIEW / etf_1hour / 2002-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-07-23.parquet
  size:    15 KB
  rows:    332

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-07-23 09:00:00	SPY	ETF	82.55	83.24	81.95	82.99	7784100.0
2002-07-23 10:00:00	SPY	ETF	82.99	83.0	81.1	81.88	11597600.0
2002-07-23 11:00:00	SPY	ETF	81.89	82.37	81.3	81.75	5210800.0
2002-07-23 12:00:00	SPY	ETF	81.79	82.27	80.94	81.16	6354900.0
2002-07-23 13:00:00	SPY	ETF	81.14	81.62	79.88	80.67	9616000.0
2002-07-23 14:00:00	SPY	ETF	80.67	81.83	79.9	80.61	10887600.0
2002-07-23 15:00:00	SPY	ETF	80.6	81.4	79.75	80.0	9949500.0
2002-07-23 16:00:00	SPY	ETF	80.14	80.2	79.8	79.95	1785100.0
2002-07-23 09:00:00	QQQ	ETF	23.45	23.75	23.2	23.68	24381300.0
2002-07-23 10:00:00	QQQ	ETF	23.75	23.75	23.18	23.37	26976400.0
2002-07-23 11:00:00	QQQ	ETF	23.39	23.44	23.14	23.31	10790600.0
2002-07-23 12:00:00	QQQ	ETF	23.32	23.39	22.93	23.02	17473100.0
2002-07-23 13:00:00	QQQ	ETF	22.99	23.06	22.66	22.88	21871600.0
2002-07-23 14:00:00	QQQ	ETF	22.87	23.24	22.68	22.88	21831200.0
2002-07-23 15:00:00	QQQ	ETF	22.88	23.04	22.28	22.29	21219900.0
2002-07-23 16:00:00	QQQ	ETF	22.33	22.5	22.28	22.4	864900.0
2002-07-23 09:00:00	IWM	ETF	38.075	38.075	37.53	37.945	483000.0
2002-07-23 10:00:00	IWM	ETF	37.95	37.955	37.38	37.475	384200.0
2002-07-23 11:00:00	IWM	ETF	37.475	37.5	37.21	37.25	120400.0
2002-07-23 12:00:00	IWM	ETF	37.22	37.275	36.565	36.81	325800.0
2002-07-23 13:00:00	IWM	ETF	36.605	36.74	36.2	36.355	385000.0
2002-07-23 14:00:00	IWM	ETF	36.365	36.725	36.205	36.405	808600.0
2002-07-23 15:00:00	IWM	ETF	36.4	36.55	35.955	36.235	668200.0
2002-07-23 16:00:00	IWM	ETF	35.875	35.875	35.875	35.875	200.0
2002-07-23 09:00:00	DIA	ETF	78.33	79.21	77.8	78.96	2411300.0
2002-07-23 10:00:00	DIA	ETF	78.96	79.15	77.34	78.37	3926100.0
2002-07-23 11:00:00	DIA	ETF	78.35	79.0	77.81	78.42	1480500.0
2002-07-23 12:00:00	DIA	ETF	78.41	79.05	77.68	77.95	2077800.0
2002-07-23 13:00:00	DIA	ETF	77.98	78.2	76.76	77.54	2081300.0
2002-07-23 14:00:00	DIA	ETF	77.6	78.76	76.9	77.55	3895000.0
2002-07-23 15:00:00	DIA	ETF	77.58	78.55	76.9	77.16	4172400.0
2002-07-23 16:00:00	DIA	ETF	77.13	77.4	77.01	77.17	81800.0

> showing 32 of 332 rows — these rows as CSV

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