PREVIEW / etf_1hour / 2002-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-06-21.parquet
  size:    14 KB
  rows:    311

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-06-21 09:00:00	SPY	ETF	100.47	100.57	99.9	100.45	5004300.0
2002-06-21 10:00:00	SPY	ETF	100.41	100.93	100.13	100.39	5494000.0
2002-06-21 11:00:00	SPY	ETF	100.41	100.46	99.52	99.85	3508900.0
2002-06-21 12:00:00	SPY	ETF	99.85	99.91	99.33	99.55	2363600.0
2002-06-21 13:00:00	SPY	ETF	99.53	99.88	99.31	99.85	2077200.0
2002-06-21 14:00:00	SPY	ETF	99.88	99.97	99.41	99.62	2115700.0
2002-06-21 15:00:00	SPY	ETF	99.62	99.88	98.68	99.19	4719700.0
2002-06-21 16:00:00	SPY	ETF	99.27	99.5	99.02	99.5	2425400.0
2002-06-21 17:00:00	SPY	ETF	99.4	99.4	99.4	99.4	1808000.0
2002-06-21 18:00:00	SPY	ETF	99.42	99.42	99.38	99.38	700.0
2002-06-21 09:00:00	QQQ	ETF	26.36	26.53	26.27	26.47	14314600.0
2002-06-21 10:00:00	QQQ	ETF	26.46	26.78	26.2	26.36	21114700.0
2002-06-21 11:00:00	QQQ	ETF	26.36	26.44	25.99	26.16	14748900.0
2002-06-21 12:00:00	QQQ	ETF	26.16	26.2	25.91	26.06	9339000.0
2002-06-21 13:00:00	QQQ	ETF	26.05	26.25	25.99	26.22	8653200.0
2002-06-21 14:00:00	QQQ	ETF	26.22	26.27	25.96	26.04	8296700.0
2002-06-21 15:00:00	QQQ	ETF	26.06	26.17	25.65	25.8	19988500.0
2002-06-21 16:00:00	QQQ	ETF	25.8	25.98	25.75	25.8	3915800.0
2002-06-21 17:00:00	QQQ	ETF	25.8	25.82	25.75	25.75	44000.0
2002-06-21 18:00:00	QQQ	ETF	25.77	25.81	25.75	25.8	26800.0
2002-06-21 09:00:00	IWM	ETF	45.9	46.2	45.865	46.16	124200.0
2002-06-21 10:00:00	IWM	ETF	46.16	46.32	46.03	46.14	273000.0
2002-06-21 11:00:00	IWM	ETF	46.14	46.16	45.81	45.93	160600.0
2002-06-21 12:00:00	IWM	ETF	45.9	45.925	45.6	45.665	326000.0
2002-06-21 13:00:00	IWM	ETF	45.66	45.85	45.63	45.85	138200.0
2002-06-21 14:00:00	IWM	ETF	45.85	45.89	45.785	45.875	125800.0
2002-06-21 15:00:00	IWM	ETF	45.88	46.0	45.62	45.945	500200.0
2002-06-21 16:00:00	IWM	ETF	45.945	46.025	45.8	45.8	55600.0
2002-06-21 18:00:00	IWM	ETF	45.86	45.86	45.86	45.86	294400.0
2002-06-21 09:00:00	DIA	ETF	93.77	94.19	93.6	93.98	954700.0
2002-06-21 10:00:00	DIA	ETF	93.96	94.41	93.61	93.84	789300.0
2002-06-21 11:00:00	DIA	ETF	93.84	93.98	93.12	93.48	594800.0
2002-06-21 12:00:00	DIA	ETF	93.49	93.52	92.85	93.08	460000.0
2002-06-21 13:00:00	DIA	ETF	93.04	93.38	92.83	93.3	321200.0
2002-06-21 14:00:00	DIA	ETF	93.31	93.36	92.85	93.16	186100.0
2002-06-21 15:00:00	DIA	ETF	93.16	93.48	92.15	92.8	1098100.0
2002-06-21 16:00:00	DIA	ETF	92.65	92.95	92.65	92.84	118300.0
2002-06-21 17:00:00	DIA	ETF	92.84	92.84	92.84	92.84	300.0
2002-06-21 18:00:00	DIA	ETF	92.71	92.82	92.62	92.62	800.0

> showing 39 of 311 rows — these rows as CSV

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