PREVIEW / etf_1hour / 2002-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-06.parquet
  size:    17 KB
  rows:    403

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-06 08:00:00	SPY	ETF	92.72	92.73	92.3	92.3	18900.0
2002-11-06 09:00:00	SPY	ETF	92.25	92.48	91.6	91.74	5607800.0
2002-11-06 10:00:00	SPY	ETF	91.7	92.37	91.64	92.18	6766300.0
2002-11-06 11:00:00	SPY	ETF	92.13	92.28	91.75	91.8	3383600.0
2002-11-06 12:00:00	SPY	ETF	91.8	91.87	91.4	91.67	3511500.0
2002-11-06 13:00:00	SPY	ETF	91.66	91.86	91.57	91.78	2569900.0
2002-11-06 14:00:00	SPY	ETF	91.76	92.9	90.79	92.07	22834600.0
2002-11-06 15:00:00	SPY	ETF	92.0	93.07	91.87	92.77	10828500.0
2002-11-06 16:00:00	SPY	ETF	92.79	93.15	92.2	92.98	3461200.0
2002-11-06 17:00:00	SPY	ETF	93.04	93.08	91.99	92.57	416400.0
2002-11-06 18:00:00	SPY	ETF	92.55	92.63	92.4	92.57	78600.0
2002-11-06 08:00:00	QQQ	ETF	26.52	26.52	26.22	26.22	28700.0
2002-11-06 09:00:00	QQQ	ETF	26.22	26.36	25.91	25.96	13089100.0
2002-11-06 10:00:00	QQQ	ETF	25.95	26.3	25.89	26.15	12425800.0
2002-11-06 11:00:00	QQQ	ETF	26.16	26.29	26.03	26.06	5647200.0
2002-11-06 12:00:00	QQQ	ETF	26.06	26.07	25.87	25.97	5159700.0
2002-11-06 13:00:00	QQQ	ETF	25.99	26.08	25.92	25.98	6395900.0
2002-11-06 14:00:00	QQQ	ETF	25.99	26.42	25.64	26.16	38970500.0
2002-11-06 15:00:00	QQQ	ETF	26.21	26.5	26.11	26.48	20048800.0
2002-11-06 16:00:00	QQQ	ETF	26.47	26.7	26.01	26.62	5766100.0
2002-11-06 17:00:00	QQQ	ETF	26.65	26.7	25.23	26.33	2037400.0
2002-11-06 18:00:00	QQQ	ETF	26.32	26.33	26.2	26.3	176100.0
2002-11-06 19:00:00	QQQ	ETF	26.23	26.23	26.23	26.23	100.0
2002-11-06 09:00:00	IWM	ETF	38.85	38.875	38.525	38.55	147200.0
2002-11-06 10:00:00	IWM	ETF	38.55	39.115	38.55	39.035	208400.0
2002-11-06 11:00:00	IWM	ETF	39.03	39.03	38.86	38.86	140800.0
2002-11-06 12:00:00	IWM	ETF	38.87	38.88	38.725	38.845	138200.0
2002-11-06 13:00:00	IWM	ETF	38.795	38.875	38.765	38.8	268200.0
2002-11-06 14:00:00	IWM	ETF	38.79	39.25	38.6	38.9	1357400.0
2002-11-06 15:00:00	IWM	ETF	38.95	39.23	38.865	39.15	506800.0
2002-11-06 16:00:00	IWM	ETF	39.13	39.175	39.045	39.175	30000.0
2002-11-06 17:00:00	IWM	ETF	39.175	39.175	39.175	39.175	510400.0
2002-11-06 08:00:00	DIA	ETF	87.7	87.72	87.4	87.46	3300.0
2002-11-06 09:00:00	DIA	ETF	87.31	87.54	86.67	86.79	2095700.0
2002-11-06 10:00:00	DIA	ETF	86.81	87.44	86.76	87.29	1657900.0
2002-11-06 11:00:00	DIA	ETF	87.32	87.4	86.95	86.99	779700.0
2002-11-06 12:00:00	DIA	ETF	87.0	87.05	86.56	86.82	636700.0
2002-11-06 13:00:00	DIA	ETF	86.85	86.97	86.69	86.9	480100.0
2002-11-06 14:00:00	DIA	ETF	86.9	88.0	85.91	87.17	6962700.0
2002-11-06 15:00:00	DIA	ETF	87.17	88.15	86.99	87.82	3123700.0
2002-11-06 16:00:00	DIA	ETF	87.82	88.18	87.3	88.1	361500.0
2002-11-06 17:00:00	DIA	ETF	88.15	88.15	87.45	87.57	33700.0
2002-11-06 18:00:00	DIA	ETF	87.6	87.6	87.5	87.54	2400.0
2002-11-06 09:00:00	TLT	ETF	85.05	85.17	84.93	85.1	12600.0
2002-11-06 10:00:00	TLT	ETF	85.0	85.25	84.91	85.25	25200.0
2002-11-06 11:00:00	TLT	ETF	85.25	85.25	85.21	85.21	800.0
2002-11-06 12:00:00	TLT	ETF	85.1	85.1	85.1	85.1	300.0
2002-11-06 13:00:00	TLT	ETF	85.22	85.75	85.22	85.75	20200.0
2002-11-06 14:00:00	TLT	ETF	85.72	86.13	85.25	85.5	44800.0
2002-11-06 15:00:00	TLT	ETF	85.69	85.9	85.38	85.85	10300.0

> showing 50 of 403 rows — these rows as CSV

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