PREVIEW / etf_1hour / 2002-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-08.parquet
  size:    16 KB
  rows:    378

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-11-08 08:00:00	SPY	ETF	91.02	91.04	90.72	90.72	700.0
2002-11-08 09:00:00	SPY	ETF	90.65	91.11	90.4	91.07	3840100.0
2002-11-08 10:00:00	SPY	ETF	91.09	91.57	90.51	90.62	6666200.0
2002-11-08 11:00:00	SPY	ETF	90.62	90.62	89.52	89.91	8520000.0
2002-11-08 12:00:00	SPY	ETF	89.91	90.19	89.69	89.99	2392800.0
2002-11-08 13:00:00	SPY	ETF	89.99	90.2	89.62	89.7	2486400.0
2002-11-08 14:00:00	SPY	ETF	89.65	90.06	89.55	89.78	2816100.0
2002-11-08 15:00:00	SPY	ETF	89.77	90.2	89.58	89.87	5912400.0
2002-11-08 16:00:00	SPY	ETF	89.87	89.93	89.5	89.55	1811600.0
2002-11-08 17:00:00	SPY	ETF	89.52	89.52	89.46	89.46	2200.0
2002-11-08 18:00:00	SPY	ETF	89.54	89.54	89.54	89.54	100.0
2002-11-08 19:00:00	SPY	ETF	89.55	89.55	89.55	89.55	800.0
2002-11-08 08:00:00	QQQ	ETF	25.54	25.56	25.53	25.53	3100.0
2002-11-08 09:00:00	QQQ	ETF	25.45	25.71	25.44	25.7	10471900.0
2002-11-08 10:00:00	QQQ	ETF	25.7	25.87	25.39	25.41	13638900.0
2002-11-08 11:00:00	QQQ	ETF	25.41	25.43	24.96	25.06	18246600.0
2002-11-08 12:00:00	QQQ	ETF	25.07	25.21	25.0	25.13	4342200.0
2002-11-08 13:00:00	QQQ	ETF	25.13	25.28	25.05	25.07	8134000.0
2002-11-08 14:00:00	QQQ	ETF	25.05	25.25	25.01	25.12	4600500.0
2002-11-08 15:00:00	QQQ	ETF	25.1	25.31	25.03	25.11	8200300.0
2002-11-08 16:00:00	QQQ	ETF	25.07	25.16	25.01	25.06	1717500.0
2002-11-08 17:00:00	QQQ	ETF	25.06	25.07	24.99	24.99	104200.0
2002-11-08 18:00:00	QQQ	ETF	24.98	25.03	24.97	25.01	14500.0
2002-11-08 19:00:00	QQQ	ETF	25.03	25.04	25.0	25.0	5900.0
2002-11-08 09:00:00	IWM	ETF	38.325	38.415	38.115	38.275	42200.0
2002-11-08 10:00:00	IWM	ETF	38.43	38.495	38.0	38.015	401400.0
2002-11-08 11:00:00	IWM	ETF	38.005	38.005	37.67	37.675	574000.0
2002-11-08 12:00:00	IWM	ETF	37.75	37.82	37.675	37.765	24800.0
2002-11-08 13:00:00	IWM	ETF	37.765	37.885	37.745	37.805	92200.0
2002-11-08 14:00:00	IWM	ETF	37.72	37.875	37.72	37.79	327600.0
2002-11-08 15:00:00	IWM	ETF	37.835	37.905	37.72	37.725	207400.0
2002-11-08 16:00:00	IWM	ETF	37.725	38.325	37.275	37.275	62400.0
2002-11-08 08:00:00	DIA	ETF	86.09	86.09	86.09	86.09	1900.0
2002-11-08 09:00:00	DIA	ETF	85.87	86.55	85.8	86.51	953600.0
2002-11-08 10:00:00	DIA	ETF	86.55	86.94	86.0	86.09	1983500.0
2002-11-08 11:00:00	DIA	ETF	86.09	86.11	85.15	85.47	2031900.0
2002-11-08 12:00:00	DIA	ETF	85.46	85.76	85.3	85.62	796300.0
2002-11-08 13:00:00	DIA	ETF	85.62	85.85	85.22	85.23	662900.0
2002-11-08 14:00:00	DIA	ETF	85.2	85.59	85.15	85.3	695900.0
2002-11-08 15:00:00	DIA	ETF	85.3	85.75	85.14	85.41	1151600.0
2002-11-08 16:00:00	DIA	ETF	85.41	85.46	85.17	85.22	130200.0
2002-11-08 17:00:00	DIA	ETF	85.35	85.4	85.35	85.35	700.0
2002-11-08 18:00:00	DIA	ETF	85.1	85.1	85.1	85.1	100.0
2002-11-08 09:00:00	TLT	ETF	88.4	88.45	88.12	88.12	22800.0
2002-11-08 10:00:00	TLT	ETF	88.06	88.44	87.95	88.44	35500.0
2002-11-08 11:00:00	TLT	ETF	88.47	88.5	88.32	88.38	29500.0
2002-11-08 12:00:00	TLT	ETF	88.4	88.55	88.35	88.5	70700.0
2002-11-08 13:00:00	TLT	ETF	88.5	88.56	88.4	88.45	6000.0
2002-11-08 14:00:00	TLT	ETF	88.51	88.6	88.41	88.51	5700.0
2002-11-08 15:00:00	TLT	ETF	88.51	88.65	88.4	88.44	70200.0

> showing 50 of 378 rows — these rows as CSV

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