PREVIEW / etf_1hour / 2002-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-23.parquet
  size:    16 KB
  rows:    383

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-23 08:00:00	SPY	ETF	89.53	89.53	89.42	89.49	23800.0
2002-12-23 09:00:00	SPY	ETF	89.45	89.85	89.31	89.52	2690600.0
2002-12-23 10:00:00	SPY	ETF	89.52	90.33	89.36	90.27	4445600.0
2002-12-23 11:00:00	SPY	ETF	90.28	90.47	90.14	90.14	3535500.0
2002-12-23 12:00:00	SPY	ETF	90.17	90.19	89.89	89.95	1684200.0
2002-12-23 13:00:00	SPY	ETF	89.97	90.05	89.65	89.65	1616700.0
2002-12-23 14:00:00	SPY	ETF	89.7	89.86	89.51	89.77	1704000.0
2002-12-23 15:00:00	SPY	ETF	89.78	90.01	89.64	89.93	2779900.0
2002-12-23 16:00:00	SPY	ETF	89.87	90.19	89.87	90.05	2005800.0
2002-12-23 17:00:00	SPY	ETF	90.1	90.14	90.02	90.02	421400.0
2002-12-23 18:00:00	SPY	ETF	90.07	90.07	90.07	90.07	100.0
2002-12-23 08:00:00	QQQ	ETF	25.29	25.29	25.2	25.25	27100.0
2002-12-23 09:00:00	QQQ	ETF	25.23	25.5	25.13	25.39	7120200.0
2002-12-23 10:00:00	QQQ	ETF	25.39	25.75	25.34	25.69	9506400.0
2002-12-23 11:00:00	QQQ	ETF	25.68	25.76	25.59	25.63	6839500.0
2002-12-23 12:00:00	QQQ	ETF	25.64	25.68	25.57	25.59	3381600.0
2002-12-23 13:00:00	QQQ	ETF	25.59	25.67	25.5	25.53	3324900.0
2002-12-23 14:00:00	QQQ	ETF	25.53	25.61	25.44	25.59	3925900.0
2002-12-23 15:00:00	QQQ	ETF	25.6	25.69	25.51	25.67	6130700.0
2002-12-23 16:00:00	QQQ	ETF	25.69	25.69	25.55	25.67	1786300.0
2002-12-23 17:00:00	QQQ	ETF	25.66	25.66	25.6	25.61	76500.0
2002-12-23 18:00:00	QQQ	ETF	25.64	25.68	25.6	25.61	4000.0
2002-12-23 19:00:00	QQQ	ETF	25.65	25.69	25.65	25.69	8700.0
2002-12-23 09:00:00	IWM	ETF	38.45	38.625	38.355	38.53	543400.0
2002-12-23 10:00:00	IWM	ETF	38.51	38.815	38.48	38.73	320800.0
2002-12-23 11:00:00	IWM	ETF	38.76	38.83	38.73	38.735	160600.0
2002-12-23 12:00:00	IWM	ETF	38.73	38.75	38.62	38.665	97200.0
2002-12-23 13:00:00	IWM	ETF	38.65	38.725	38.6	38.635	245200.0
2002-12-23 14:00:00	IWM	ETF	38.55	38.675	38.53	38.615	243600.0
2002-12-23 15:00:00	IWM	ETF	38.615	38.855	38.52	38.845	159600.0
2002-12-23 16:00:00	IWM	ETF	38.845	38.845	38.775	38.775	18200.0
2002-12-23 08:00:00	DIA	ETF	84.83	84.91	84.82	84.82	1300.0
2002-12-23 09:00:00	DIA	ETF	84.89	85.15	84.72	84.87	657400.0
2002-12-23 10:00:00	DIA	ETF	84.8	85.46	84.68	85.38	1042100.0
2002-12-23 11:00:00	DIA	ETF	85.39	85.7	85.25	85.25	750200.0
2002-12-23 12:00:00	DIA	ETF	85.28	85.34	85.01	85.08	449100.0
2002-12-23 13:00:00	DIA	ETF	85.08	85.19	84.85	84.9	251700.0
2002-12-23 14:00:00	DIA	ETF	84.86	85.11	84.7	84.92	421200.0
2002-12-23 15:00:00	DIA	ETF	84.95	85.12	84.78	85.09	386900.0
2002-12-23 16:00:00	DIA	ETF	85.08	85.22	85.05	85.14	120700.0
2002-12-23 09:00:00	TLT	ETF	87.34	87.34	86.25	87.21	31800.0
2002-12-23 10:00:00	TLT	ETF	87.25	87.25	87.14	87.17	12500.0
2002-12-23 11:00:00	TLT	ETF	87.17	87.21	87.13	87.21	6600.0
2002-12-23 12:00:00	TLT	ETF	87.2	87.3	87.2	87.3	3500.0
2002-12-23 13:00:00	TLT	ETF	87.3	87.3	87.23	87.23	700.0
2002-12-23 15:00:00	TLT	ETF	87.32	87.35	87.24	87.35	8700.0
2002-12-23 16:00:00	TLT	ETF	87.4	87.4	87.4	87.4	3500.0

> showing 47 of 383 rows — these rows as CSV

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