PREVIEW / etf_1hour / 2002-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-02-20.parquet
  size:    13 KB
  rows:    286

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-20 09:00:00	SPY	ETF	109.05	109.25	108.8	109.25	2849800.0
2002-02-20 10:00:00	SPY	ETF	109.27	109.37	108.67	108.96	3942100.0
2002-02-20 11:00:00	SPY	ETF	108.95	109.0	108.46	108.64	1602800.0
2002-02-20 12:00:00	SPY	ETF	108.62	108.65	107.82	108.17	3499600.0
2002-02-20 13:00:00	SPY	ETF	108.16	108.81	108.11	108.68	3440800.0
2002-02-20 14:00:00	SPY	ETF	108.67	110.2	108.66	110.16	6785300.0
2002-02-20 15:00:00	SPY	ETF	110.18	110.38	109.65	110.32	5374200.0
2002-02-20 16:00:00	SPY	ETF	110.35	110.6	110.26	110.52	1504300.0
2002-02-20 17:00:00	SPY	ETF	110.55	110.55	110.49	110.49	2300.0
2002-02-20 18:00:00	SPY	ETF	110.53	110.55	110.46	110.54	4700.0
2002-02-20 09:00:00	QQQ	ETF	34.9	35.05	34.57	35.05	14638200.0
2002-02-20 10:00:00	QQQ	ETF	35.03	35.06	34.4	34.6	17506300.0
2002-02-20 11:00:00	QQQ	ETF	34.64	34.64	34.3	34.4	8393500.0
2002-02-20 12:00:00	QQQ	ETF	34.4	34.43	33.93	34.18	15427100.0
2002-02-20 13:00:00	QQQ	ETF	34.16	34.45	34.03	34.35	10331200.0
2002-02-20 14:00:00	QQQ	ETF	34.36	35.09	34.34	34.97	18308900.0
2002-02-20 15:00:00	QQQ	ETF	34.97	35.17	34.64	35.09	15319800.0
2002-02-20 16:00:00	QQQ	ETF	35.09	35.23	35.07	35.19	2232600.0
2002-02-20 17:00:00	QQQ	ETF	35.18	35.19	35.13	35.18	71000.0
2002-02-20 18:00:00	QQQ	ETF	35.2	35.2	35.16	35.2	19700.0
2002-02-20 09:00:00	IWM	ETF	45.7	46.0	45.7	46.0	312600.0
2002-02-20 10:00:00	IWM	ETF	46.045	46.07	45.7	45.805	72600.0
2002-02-20 11:00:00	IWM	ETF	45.845	45.845	45.58	45.635	26400.0
2002-02-20 12:00:00	IWM	ETF	45.695	45.695	45.44	45.49	48000.0
2002-02-20 13:00:00	IWM	ETF	45.52	45.76	45.5	45.735	80800.0
2002-02-20 14:00:00	IWM	ETF	45.78	46.265	45.75	46.265	256600.0
2002-02-20 15:00:00	IWM	ETF	46.245	46.445	46.065	46.445	147400.0
2002-02-20 16:00:00	IWM	ETF	46.485	46.55	46.485	46.55	423000.0
2002-02-20 09:00:00	DIA	ETF	97.97	98.26	97.76	98.26	523400.0
2002-02-20 10:00:00	DIA	ETF	98.2	98.38	97.95	98.3	475200.0
2002-02-20 11:00:00	DIA	ETF	98.29	98.29	97.86	98.0	689700.0
2002-02-20 12:00:00	DIA	ETF	98.01	98.04	97.4	97.83	637400.0
2002-02-20 13:00:00	DIA	ETF	97.79	98.39	97.79	98.2	344400.0
2002-02-20 14:00:00	DIA	ETF	98.17	99.58	98.17	99.52	1394700.0
2002-02-20 15:00:00	DIA	ETF	99.5	99.79	99.11	99.67	2936000.0
2002-02-20 16:00:00	DIA	ETF	99.68	99.92	99.61	99.65	102000.0

> showing 36 of 286 rows — these rows as CSV

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