PREVIEW / etf_1hour / 2002-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-23.parquet
  size:    15 KB
  rows:    336

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-08-23 09:00:00	SPY	ETF	96.01	96.15	95.72	95.89	4287100.0
2002-08-23 10:00:00	SPY	ETF	95.89	95.93	95.14	95.36	4960600.0
2002-08-23 11:00:00	SPY	ETF	95.4	95.49	95.0	95.06	2153300.0
2002-08-23 12:00:00	SPY	ETF	95.05	95.25	94.76	94.97	3543900.0
2002-08-23 13:00:00	SPY	ETF	94.98	95.32	94.7	95.11	1978300.0
2002-08-23 14:00:00	SPY	ETF	95.11	95.4	94.75	94.75	2362800.0
2002-08-23 15:00:00	SPY	ETF	94.78	94.84	94.15	94.52	6862700.0
2002-08-23 16:00:00	SPY	ETF	94.55	94.65	94.41	94.6	846500.0
2002-08-23 09:00:00	QQQ	ETF	25.8	25.81	25.61	25.65	9144100.0
2002-08-23 10:00:00	QQQ	ETF	25.66	25.69	25.35	25.42	14213800.0
2002-08-23 11:00:00	QQQ	ETF	25.41	25.47	25.22	25.33	8017500.0
2002-08-23 12:00:00	QQQ	ETF	25.32	25.39	25.15	25.2	6644800.0
2002-08-23 13:00:00	QQQ	ETF	25.2	25.37	25.16	25.28	7239500.0
2002-08-23 14:00:00	QQQ	ETF	25.28	25.38	25.16	25.17	7062100.0
2002-08-23 15:00:00	QQQ	ETF	25.18	25.19	24.95	25.13	18709500.0
2002-08-23 16:00:00	QQQ	ETF	25.13	25.2	25.11	25.15	560300.0
2002-08-23 09:00:00	IWM	ETF	40.6	40.85	40.555	40.645	253000.0
2002-08-23 10:00:00	IWM	ETF	40.715	40.715	40.465	40.6	105800.0
2002-08-23 11:00:00	IWM	ETF	40.515	40.59	40.365	40.365	247600.0
2002-08-23 12:00:00	IWM	ETF	40.355	40.38	40.025	40.22	601400.0
2002-08-23 13:00:00	IWM	ETF	40.17	40.375	40.165	40.325	247600.0
2002-08-23 14:00:00	IWM	ETF	40.3	40.39	40.245	40.3	235200.0
2002-08-23 15:00:00	IWM	ETF	40.215	40.26	39.9	40.025	374800.0
2002-08-23 16:00:00	IWM	ETF	39.975	40.0	39.825	39.825	110400.0
2002-08-23 09:00:00	DIA	ETF	89.89	91.0	89.78	89.93	726200.0
2002-08-23 10:00:00	DIA	ETF	89.99	89.99	89.34	89.52	1303800.0
2002-08-23 11:00:00	DIA	ETF	89.52	89.61	89.14	89.25	811200.0
2002-08-23 12:00:00	DIA	ETF	89.23	89.39	88.91	89.1	823200.0
2002-08-23 13:00:00	DIA	ETF	89.1	89.52	88.86	89.25	1401300.0
2002-08-23 14:00:00	DIA	ETF	89.25	89.5	88.96	88.96	799000.0
2002-08-23 15:00:00	DIA	ETF	89.0	89.01	88.4	88.77	1939700.0
2002-08-23 16:00:00	DIA	ETF	88.76	88.84	88.7	88.72	74300.0
2002-08-23 09:00:00	TLT	ETF	85.2	85.2	85.2	85.2	300.0
2002-08-23 10:00:00	TLT	ETF	85.3	85.38	85.25	85.38	4200.0
2002-08-23 11:00:00	TLT	ETF	85.62	85.62	85.57	85.57	300.0
2002-08-23 12:00:00	TLT	ETF	85.71	85.71	85.6	85.6	1600.0
2002-08-23 13:00:00	TLT	ETF	85.6	85.64	85.6	85.64	1100.0
2002-08-23 14:00:00	TLT	ETF	85.7	85.9	85.64	85.9	5100.0
2002-08-23 15:00:00	TLT	ETF	85.95	85.95	85.85	85.9	7500.0

> showing 39 of 336 rows — these rows as CSV

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