PREVIEW / etf_1hour / 2002-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-09-30.parquet
  size:    16 KB
  rows:    371

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-09-30 08:00:00	SPY	ETF	82.0	82.04	81.88	81.92	7400.0
2002-09-30 09:00:00	SPY	ETF	81.85	82.0	80.22	80.69	8322000.0
2002-09-30 10:00:00	SPY	ETF	80.69	80.99	80.01	80.95	14799900.0
2002-09-30 11:00:00	SPY	ETF	80.94	81.71	80.58	81.45	10195700.0
2002-09-30 12:00:00	SPY	ETF	81.48	81.58	80.9	81.32	7787700.0
2002-09-30 13:00:00	SPY	ETF	81.31	81.88	81.03	81.8	4610200.0
2002-09-30 14:00:00	SPY	ETF	81.8	82.32	81.19	82.16	8538700.0
2002-09-30 15:00:00	SPY	ETF	82.18	82.8	81.44	81.6	11774200.0
2002-09-30 16:00:00	SPY	ETF	81.59	81.97	80.79	81.79	4325800.0
2002-09-30 17:00:00	SPY	ETF	81.82	82.48	81.41	81.49	121600.0
2002-09-30 18:00:00	SPY	ETF	81.78	81.85	81.74	81.84	21200.0
2002-09-30 08:00:00	QQQ	ETF	21.24	21.24	21.09	21.09	10200.0
2002-09-30 09:00:00	QQQ	ETF	21.09	21.11	20.64	20.67	17315600.0
2002-09-30 10:00:00	QQQ	ETF	20.71	20.82	20.49	20.78	20582500.0
2002-09-30 11:00:00	QQQ	ETF	20.77	20.99	20.65	20.9	10136800.0
2002-09-30 12:00:00	QQQ	ETF	20.91	20.97	20.74	20.83	5677400.0
2002-09-30 13:00:00	QQQ	ETF	20.82	20.96	20.75	20.93	5985800.0
2002-09-30 14:00:00	QQQ	ETF	20.91	21.06	20.76	21.03	10992700.0
2002-09-30 15:00:00	QQQ	ETF	21.03	21.24	20.65	20.72	17214200.0
2002-09-30 16:00:00	QQQ	ETF	20.72	20.96	20.66	20.72	2806800.0
2002-09-30 17:00:00	QQQ	ETF	20.74	20.75	20.7	20.72	62700.0
2002-09-30 18:00:00	QQQ	ETF	20.72	20.78	20.72	20.75	73600.0
2002-09-30 19:00:00	QQQ	ETF	20.77	20.78	20.76	20.76	1200.0
2002-09-30 09:00:00	IWM	ETF	35.65	35.8	35.5	35.5	217200.0
2002-09-30 10:00:00	IWM	ETF	35.485	35.5	35.24	35.46	817400.0
2002-09-30 11:00:00	IWM	ETF	35.46	35.805	35.445	35.77	297200.0
2002-09-30 12:00:00	IWM	ETF	35.745	35.805	35.66	35.7	130200.0
2002-09-30 13:00:00	IWM	ETF	35.7	35.875	35.65	35.86	359000.0
2002-09-30 14:00:00	IWM	ETF	35.875	36.2	35.8	36.2	358000.0
2002-09-30 15:00:00	IWM	ETF	36.15	36.29	35.85	35.85	1002200.0
2002-09-30 16:00:00	IWM	ETF	35.89	36.11	35.775	36.11	807800.0
2002-09-30 08:00:00	DIA	ETF	76.1	76.3	75.96	76.1	2300.0
2002-09-30 09:00:00	DIA	ETF	76.02	76.2	74.85	74.85	1893400.0
2002-09-30 10:00:00	DIA	ETF	75.13	75.46	74.65	75.4	3877000.0
2002-09-30 11:00:00	DIA	ETF	75.5	76.0	75.05	75.76	2980500.0
2002-09-30 12:00:00	DIA	ETF	75.79	75.88	75.25	75.6	905600.0
2002-09-30 13:00:00	DIA	ETF	75.63	76.2	75.38	76.1	1610000.0
2002-09-30 14:00:00	DIA	ETF	76.1	76.5	75.51	76.33	2320800.0
2002-09-30 15:00:00	DIA	ETF	76.33	76.96	75.65	75.9	3236300.0
2002-09-30 16:00:00	DIA	ETF	75.83	76.1	75.74	76.05	156000.0
2002-09-30 17:00:00	DIA	ETF	76.05	76.1	75.9	75.95	13700.0
2002-09-30 18:00:00	DIA	ETF	75.95	76.1	75.8	76.1	3700.0
2002-09-30 19:00:00	DIA	ETF	76.03	76.09	76.03	76.09	1500.0
2002-09-30 09:00:00	TLT	ETF	90.66	90.69	90.5	90.63	43400.0
2002-09-30 10:00:00	TLT	ETF	90.55	90.9	90.55	90.72	122200.0
2002-09-30 11:00:00	TLT	ETF	90.6	90.76	90.38	90.49	71600.0
2002-09-30 12:00:00	TLT	ETF	90.5	90.75	90.5	90.75	1500.0
2002-09-30 13:00:00	TLT	ETF	90.75	90.75	90.5	90.57	2400.0
2002-09-30 14:00:00	TLT	ETF	90.44	90.6	90.34	90.34	45200.0
2002-09-30 15:00:00	TLT	ETF	90.36	90.4	90.08	90.4	11500.0

> showing 50 of 371 rows — these rows as CSV

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