PREVIEW / etf_1hour / 2002-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-04.parquet
  size:    16 KB
  rows:    398

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-04 08:00:00	SPY	ETF	91.54	91.77	91.53	91.72	26600.0
2002-11-04 09:00:00	SPY	ETF	91.83	91.97	91.6	91.84	4748000.0
2002-11-04 10:00:00	SPY	ETF	91.8	92.59	91.74	92.31	7969500.0
2002-11-04 11:00:00	SPY	ETF	92.3	92.7	92.13	92.5	5241600.0
2002-11-04 12:00:00	SPY	ETF	92.48	92.94	92.44	92.69	3587600.0
2002-11-04 13:00:00	SPY	ETF	92.7	92.78	92.32	92.45	4743900.0
2002-11-04 14:00:00	SPY	ETF	92.45	92.59	91.7	91.85	5673200.0
2002-11-04 15:00:00	SPY	ETF	91.82	91.9	90.9	91.15	9019800.0
2002-11-04 16:00:00	SPY	ETF	91.15	92.41	90.47	91.15	4882500.0
2002-11-04 17:00:00	SPY	ETF	91.15	91.18	91.1	91.18	9400.0
2002-11-04 18:00:00	SPY	ETF	91.15	91.15	91.01	91.01	900.0
2002-11-04 19:00:00	SPY	ETF	91.14	91.2	91.14	91.2	2100.0
2002-11-04 08:00:00	QQQ	ETF	25.89	26.1	25.89	26.07	120100.0
2002-11-04 09:00:00	QQQ	ETF	26.07	26.15	25.91	26.09	14106800.0
2002-11-04 10:00:00	QQQ	ETF	26.08	26.46	26.02	26.35	23219000.0
2002-11-04 11:00:00	QQQ	ETF	26.36	26.4	26.2	26.34	14751800.0
2002-11-04 12:00:00	QQQ	ETF	26.33	26.63	26.31	26.53	10876100.0
2002-11-04 13:00:00	QQQ	ETF	26.54	26.56	26.31	26.41	7013800.0
2002-11-04 14:00:00	QQQ	ETF	26.37	26.59	26.23	26.3	7212400.0
2002-11-04 15:00:00	QQQ	ETF	26.3	26.34	25.8	25.97	21898800.0
2002-11-04 16:00:00	QQQ	ETF	25.99	26.05	25.87	26.0	2227300.0
2002-11-04 17:00:00	QQQ	ETF	26.0	26.0	25.9	26.0	89600.0
2002-11-04 18:00:00	QQQ	ETF	26.0	26.0	25.97	25.98	15600.0
2002-11-04 19:00:00	QQQ	ETF	25.96	25.97	25.96	25.96	3400.0
2002-11-04 09:00:00	IWM	ETF	38.695	38.825	38.5	38.575	1261600.0
2002-11-04 10:00:00	IWM	ETF	38.67	38.965	38.55	38.9	730600.0
2002-11-04 11:00:00	IWM	ETF	38.9	39.025	38.815	38.87	209600.0
2002-11-04 12:00:00	IWM	ETF	38.91	39.15	38.91	39.0	207200.0
2002-11-04 13:00:00	IWM	ETF	39.0	39.065	38.845	38.905	298000.0
2002-11-04 14:00:00	IWM	ETF	38.955	39.05	38.775	38.8	547800.0
2002-11-04 15:00:00	IWM	ETF	38.8	38.825	38.4	38.455	997600.0
2002-11-04 16:00:00	IWM	ETF	38.465	38.575	38.425	38.455	15600.0
2002-11-04 08:00:00	DIA	ETF	86.35	86.59	86.35	86.5	12100.0
2002-11-04 09:00:00	DIA	ETF	86.6	86.7	86.3	86.42	1569100.0
2002-11-04 10:00:00	DIA	ETF	86.47	87.14	86.4	86.98	2112100.0
2002-11-04 11:00:00	DIA	ETF	86.94	87.26	86.79	87.05	1905900.0
2002-11-04 12:00:00	DIA	ETF	87.04	87.5	87.03	87.3	1011900.0
2002-11-04 13:00:00	DIA	ETF	87.3	87.33	86.96	87.08	829700.0
2002-11-04 14:00:00	DIA	ETF	87.05	87.23	86.4	86.46	1320900.0
2002-11-04 15:00:00	DIA	ETF	86.45	86.58	85.6	85.79	2737200.0
2002-11-04 16:00:00	DIA	ETF	85.79	86.0	85.63	85.65	258200.0
2002-11-04 17:00:00	DIA	ETF	85.7	85.8	85.65	85.8	2200.0
2002-11-04 18:00:00	DIA	ETF	85.77	85.77	85.69	85.69	400.0
2002-11-04 19:00:00	DIA	ETF	85.69	85.69	85.69	85.69	1500.0
2002-11-04 09:00:00	TLT	ETF	85.48	85.48	85.39	85.39	5600.0
2002-11-04 10:00:00	TLT	ETF	85.29	85.41	85.27	85.35	4200.0
2002-11-04 11:00:00	TLT	ETF	85.37	85.43	85.29	85.36	5800.0
2002-11-04 12:00:00	TLT	ETF	85.25	85.47	85.25	85.45	5500.0
2002-11-04 13:00:00	TLT	ETF	85.44	85.48	85.4	85.48	2500.0
2002-11-04 14:00:00	TLT	ETF	85.56	85.6	85.3	85.45	130300.0

> showing 50 of 398 rows — these rows as CSV

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