PREVIEW / etf_1hour / 2002-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-16.parquet
  size:    16 KB
  rows:    372

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-10-16 08:00:00	SPY	ETF	87.67	87.69	87.5	87.5	7000.0
2002-10-16 09:00:00	SPY	ETF	87.5	87.8	87.15	87.7	8549300.0
2002-10-16 10:00:00	SPY	ETF	87.7	87.78	86.6	86.92	12826800.0
2002-10-16 11:00:00	SPY	ETF	86.91	87.06	86.42	86.55	7714200.0
2002-10-16 12:00:00	SPY	ETF	86.55	86.63	86.1	86.43	6427100.0
2002-10-16 13:00:00	SPY	ETF	86.39	86.56	86.08	86.13	4407500.0
2002-10-16 14:00:00	SPY	ETF	86.13	86.59	85.92	86.32	6958500.0
2002-10-16 15:00:00	SPY	ETF	86.33	86.7	86.0	86.32	8510300.0
2002-10-16 16:00:00	SPY	ETF	86.4	87.68	86.3	86.88	5727200.0
2002-10-16 17:00:00	SPY	ETF	86.94	87.75	86.09	87.66	1489300.0
2002-10-16 18:00:00	SPY	ETF	87.72	88.15	87.7	87.73	62900.0
2002-10-16 19:00:00	SPY	ETF	87.85	87.93	87.82	87.93	1000.0
2002-10-16 08:00:00	QQQ	ETF	22.84	22.9	22.82	22.89	17700.0
2002-10-16 09:00:00	QQQ	ETF	22.79	23.14	22.69	22.99	18790900.0
2002-10-16 10:00:00	QQQ	ETF	23.09	23.16	22.74	22.87	17423700.0
2002-10-16 11:00:00	QQQ	ETF	22.86	22.93	22.68	22.75	9125200.0
2002-10-16 12:00:00	QQQ	ETF	22.75	22.76	22.58	22.69	7684500.0
2002-10-16 13:00:00	QQQ	ETF	22.67	22.73	22.55	22.58	6044300.0
2002-10-16 14:00:00	QQQ	ETF	22.58	22.75	22.52	22.65	11019200.0
2002-10-16 15:00:00	QQQ	ETF	22.63	22.8	22.58	22.66	13791100.0
2002-10-16 16:00:00	QQQ	ETF	22.68	23.3	22.63	22.92	7069000.0
2002-10-16 17:00:00	QQQ	ETF	22.92	23.28	22.9	23.2	2878500.0
2002-10-16 18:00:00	QQQ	ETF	23.2	23.29	23.2	23.22	276300.0
2002-10-16 19:00:00	QQQ	ETF	23.22	23.25	23.16	23.25	19700.0
2002-10-16 09:00:00	IWM	ETF	35.5	35.665	35.335	35.63	191600.0
2002-10-16 10:00:00	IWM	ETF	35.59	35.6	35.085	35.105	460600.0
2002-10-16 11:00:00	IWM	ETF	35.215	35.225	35.0	35.095	117200.0
2002-10-16 12:00:00	IWM	ETF	35.065	35.075	34.9	35.035	275200.0
2002-10-16 13:00:00	IWM	ETF	35.045	35.045	34.93	34.985	30600.0
2002-10-16 14:00:00	IWM	ETF	34.91	35.12	34.86	34.99	499200.0
2002-10-16 15:00:00	IWM	ETF	35.03	35.135	34.925	35.1	188200.0
2002-10-16 16:00:00	IWM	ETF	35.1	35.31	34.995	34.995	1010400.0
2002-10-16 17:00:00	IWM	ETF	35.0	35.0	35.0	35.0	10000.0
2002-10-16 18:00:00	IWM	ETF	35.35	35.35	35.35	35.35	10000.0
2002-10-16 08:00:00	DIA	ETF	81.7	81.87	81.7	81.82	1800.0
2002-10-16 09:00:00	DIA	ETF	81.77	81.98	81.48	81.95	2570000.0
2002-10-16 10:00:00	DIA	ETF	81.9	82.1	80.94	81.24	3218100.0
2002-10-16 11:00:00	DIA	ETF	81.22	81.39	80.77	80.81	2118300.0
2002-10-16 12:00:00	DIA	ETF	80.82	81.01	80.48	80.72	1456900.0
2002-10-16 13:00:00	DIA	ETF	80.77	80.93	80.5	80.59	1541400.0
2002-10-16 14:00:00	DIA	ETF	80.58	80.94	80.32	80.58	2102400.0
2002-10-16 15:00:00	DIA	ETF	80.63	80.94	80.22	80.55	2221500.0
2002-10-16 16:00:00	DIA	ETF	80.55	81.33	80.52	81.0	593700.0
2002-10-16 17:00:00	DIA	ETF	81.19	82.1	81.08	82.1	141400.0
2002-10-16 18:00:00	DIA	ETF	82.0	82.25	81.85	82.25	5500.0
2002-10-16 19:00:00	DIA	ETF	82.01	82.01	82.0	82.0	700.0
2002-10-16 09:00:00	TLT	ETF	86.6	86.6	85.89	85.89	21500.0
2002-10-16 10:00:00	TLT	ETF	85.97	86.28	85.89	86.13	43700.0
2002-10-16 11:00:00	TLT	ETF	86.14	86.5	86.05	86.5	9100.0
2002-10-16 12:00:00	TLT	ETF	86.5	86.5	86.28	86.38	9700.0

> showing 50 of 372 rows — these rows as CSV

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