PREVIEW / etf_1hour / 2002-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-31.parquet
  size:    16 KB
  rows:    388

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-12-31 08:00:00	SPY	ETF	88.18	88.18	88.13	88.13	700.0
2002-12-31 09:00:00	SPY	ETF	88.21	88.23	87.89	88.1	2777400.0
2002-12-31 10:00:00	SPY	ETF	88.06	88.06	87.11	87.31	6704800.0
2002-12-31 11:00:00	SPY	ETF	87.31	87.93	87.18	87.77	3518800.0
2002-12-31 12:00:00	SPY	ETF	87.76	88.22	87.65	88.02	2387400.0
2002-12-31 13:00:00	SPY	ETF	88.0	88.42	87.94	88.03	2823400.0
2002-12-31 14:00:00	SPY	ETF	88.01	88.35	87.93	88.3	2941900.0
2002-12-31 15:00:00	SPY	ETF	88.28	88.43	87.88	88.16	4618200.0
2002-12-31 16:00:00	SPY	ETF	88.2	88.43	88.11	88.23	2805500.0
2002-12-31 17:00:00	SPY	ETF	88.23	88.25	88.23	88.25	1200.0
2002-12-31 18:00:00	SPY	ETF	88.26	88.26	88.25	88.26	700.0
2002-12-31 19:00:00	SPY	ETF	88.26	88.31	88.26	88.31	800.0
2002-12-31 08:00:00	QQQ	ETF	24.56	24.62	24.56	24.57	39100.0
2002-12-31 09:00:00	QQQ	ETF	24.58	24.71	24.5	24.65	4281000.0
2002-12-31 10:00:00	QQQ	ETF	24.65	24.65	24.28	24.35	11092700.0
2002-12-31 11:00:00	QQQ	ETF	24.35	24.54	24.28	24.5	4427300.0
2002-12-31 12:00:00	QQQ	ETF	24.51	24.59	24.45	24.53	4336000.0
2002-12-31 13:00:00	QQQ	ETF	24.52	24.68	24.46	24.49	3911700.0
2002-12-31 14:00:00	QQQ	ETF	24.5	24.62	24.48	24.56	3509800.0
2002-12-31 15:00:00	QQQ	ETF	24.55	24.61	24.37	24.43	6176400.0
2002-12-31 16:00:00	QQQ	ETF	24.42	24.5	24.37	24.41	1750200.0
2002-12-31 17:00:00	QQQ	ETF	24.41	24.45	24.4	24.41	13400.0
2002-12-31 18:00:00	QQQ	ETF	24.44	24.46	24.41	24.44	13600.0
2002-12-31 19:00:00	QQQ	ETF	24.41	24.46	24.41	24.46	1400.0
2002-12-31 09:00:00	IWM	ETF	38.07	38.2	37.935	38.16	1006400.0
2002-12-31 10:00:00	IWM	ETF	38.125	38.125	37.8	37.925	855000.0
2002-12-31 11:00:00	IWM	ETF	37.9	38.225	37.845	38.19	510000.0
2002-12-31 12:00:00	IWM	ETF	38.215	38.42	38.14	38.385	311600.0
2002-12-31 13:00:00	IWM	ETF	38.385	38.565	38.37	38.465	196000.0
2002-12-31 14:00:00	IWM	ETF	38.455	38.575	38.42	38.55	602000.0
2002-12-31 15:00:00	IWM	ETF	38.54	38.555	37.985	37.995	1064000.0
2002-12-31 16:00:00	IWM	ETF	38.0	38.02	37.905	37.905	199200.0
2002-12-31 17:00:00	IWM	ETF	38.115	38.115	38.115	38.115	313600.0
2002-12-31 08:00:00	DIA	ETF	83.45	83.47	83.45	83.47	1400.0
2002-12-31 09:00:00	DIA	ETF	83.47	83.52	83.2	83.42	486900.0
2002-12-31 10:00:00	DIA	ETF	83.42	83.43	82.48	82.72	1235300.0
2002-12-31 11:00:00	DIA	ETF	82.7	83.23	82.6	83.11	521600.0
2002-12-31 12:00:00	DIA	ETF	83.1	83.55	82.97	83.36	531400.0
2002-12-31 13:00:00	DIA	ETF	83.42	83.73	83.33	83.38	677100.0
2002-12-31 14:00:00	DIA	ETF	83.37	83.63	83.27	83.63	468200.0
2002-12-31 15:00:00	DIA	ETF	83.63	83.71	83.23	83.48	961700.0
2002-12-31 16:00:00	DIA	ETF	83.49	83.65	83.47	83.52	165800.0
2002-12-31 09:00:00	TLT	ETF	88.95	88.98	88.9	88.98	5900.0
2002-12-31 10:00:00	TLT	ETF	89.01	89.33	88.98	89.33	10200.0
2002-12-31 11:00:00	TLT	ETF	89.15	89.25	89.0	89.0	10100.0
2002-12-31 12:00:00	TLT	ETF	88.93	89.02	88.32	88.5	21200.0
2002-12-31 13:00:00	TLT	ETF	88.5	88.59	88.5	88.5	15600.0
2002-12-31 14:00:00	TLT	ETF	88.59	88.64	88.5	88.6	2800.0
2002-12-31 15:00:00	TLT	ETF	88.6	88.64	88.52	88.57	27800.0

> showing 49 of 388 rows — these rows as CSV

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