PREVIEW / etf_1hour / 2002-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-23.parquet
  size:    13 KB
  rows:    283

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-23 09:00:00	SPY	ETF	112.63	112.67	112.37	112.42	1456500.0
2002-01-23 10:00:00	SPY	ETF	112.37	112.75	112.02	112.74	2734200.0
2002-01-23 11:00:00	SPY	ETF	112.71	112.95	112.42	112.81	1498300.0
2002-01-23 12:00:00	SPY	ETF	112.82	113.11	112.6	113.04	909400.0
2002-01-23 13:00:00	SPY	ETF	113.04	113.55	112.98	113.42	1476700.0
2002-01-23 14:00:00	SPY	ETF	113.4	113.52	113.09	113.18	941300.0
2002-01-23 15:00:00	SPY	ETF	113.18	113.44	112.92	113.14	1853100.0
2002-01-23 16:00:00	SPY	ETF	113.18	113.26	113.05	113.2	1052600.0
2002-01-23 17:00:00	SPY	ETF	113.18	113.18	113.15	113.15	2200.0
2002-01-23 18:00:00	SPY	ETF	113.26	113.26	113.2	113.2	200.0
2002-01-23 09:00:00	QQQ	ETF	37.65	37.94	37.6	37.6	9082900.0
2002-01-23 10:00:00	QQQ	ETF	37.62	38.04	37.35	38.0	18864500.0
2002-01-23 11:00:00	QQQ	ETF	38.04	38.21	37.79	38.14	10064500.0
2002-01-23 12:00:00	QQQ	ETF	38.12	38.36	38.0	38.3	6915000.0
2002-01-23 13:00:00	QQQ	ETF	38.29	38.68	38.23	38.57	11000200.0
2002-01-23 14:00:00	QQQ	ETF	38.54	38.66	38.32	38.43	6937100.0
2002-01-23 15:00:00	QQQ	ETF	38.44	38.69	38.35	38.53	8683000.0
2002-01-23 16:00:00	QQQ	ETF	38.51	38.59	38.3	38.48	1290300.0
2002-01-23 17:00:00	QQQ	ETF	38.49	38.5	38.28	38.32	443900.0
2002-01-23 18:00:00	QQQ	ETF	38.3	38.44	38.3	38.44	16600.0
2002-01-23 09:00:00	IWM	ETF	46.825	46.905	46.785	46.785	20600.0
2002-01-23 10:00:00	IWM	ETF	46.79	46.79	46.4	46.75	339200.0
2002-01-23 11:00:00	IWM	ETF	46.71	46.85	46.665	46.85	302000.0
2002-01-23 12:00:00	IWM	ETF	46.775	46.95	46.755	46.945	95000.0
2002-01-23 13:00:00	IWM	ETF	46.955	47.29	46.925	47.275	149800.0
2002-01-23 14:00:00	IWM	ETF	47.175	47.3	47.125	47.205	242800.0
2002-01-23 15:00:00	IWM	ETF	47.215	47.425	47.16	47.315	370400.0
2002-01-23 16:00:00	IWM	ETF	47.35	47.39	46.775	46.775	439800.0
2002-01-23 09:00:00	DIA	ETF	97.45	97.49	97.2	97.26	178100.0
2002-01-23 10:00:00	DIA	ETF	97.29	97.4	96.88	97.37	787600.0
2002-01-23 11:00:00	DIA	ETF	97.35	97.41	97.02	97.22	692100.0
2002-01-23 12:00:00	DIA	ETF	97.26	97.38	96.95	97.33	514100.0
2002-01-23 13:00:00	DIA	ETF	97.34	97.83	97.23	97.67	836100.0
2002-01-23 14:00:00	DIA	ETF	97.67	97.82	97.48	97.57	201300.0
2002-01-23 15:00:00	DIA	ETF	97.6	97.74	97.17	97.38	415300.0
2002-01-23 16:00:00	DIA	ETF	97.39	97.43	97.39	97.43	23300.0

> showing 36 of 283 rows — these rows as CSV

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