PREVIEW / etf_1hour / 2002-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-21.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-10-21 08:00:00	SPY	ETF	88.18	88.26	88.03	88.03	2200.0
2002-10-21 09:00:00	SPY	ETF	88.09	88.32	87.88	88.15	4211800.0
2002-10-21 10:00:00	SPY	ETF	88.15	88.24	87.57	88.05	4718700.0
2002-10-21 11:00:00	SPY	ETF	88.06	89.43	88.02	89.29	7566200.0
2002-10-21 12:00:00	SPY	ETF	89.3	90.2	89.18	89.82	6638200.0
2002-10-21 13:00:00	SPY	ETF	89.8	90.05	89.6	89.96	4678100.0
2002-10-21 14:00:00	SPY	ETF	89.93	90.28	89.78	89.94	5765800.0
2002-10-21 15:00:00	SPY	ETF	89.94	90.5	89.58	90.28	7286000.0
2002-10-21 16:00:00	SPY	ETF	90.29	90.37	89.0	89.8	2497800.0
2002-10-21 17:00:00	SPY	ETF	89.84	90.26	89.06	89.77	275200.0
2002-10-21 18:00:00	SPY	ETF	89.8	89.8	89.73	89.75	11100.0
2002-10-21 08:00:00	QQQ	ETF	23.56	23.56	23.53	23.53	13300.0
2002-10-21 09:00:00	QQQ	ETF	23.54	23.66	23.45	23.55	7971800.0
2002-10-21 10:00:00	QQQ	ETF	23.57	23.59	23.3	23.42	12416600.0
2002-10-21 11:00:00	QQQ	ETF	23.41	23.82	23.4	23.73	13061000.0
2002-10-21 12:00:00	QQQ	ETF	23.75	24.21	23.72	24.12	15769800.0
2002-10-21 13:00:00	QQQ	ETF	24.14	24.25	24.05	24.15	7305800.0
2002-10-21 14:00:00	QQQ	ETF	24.17	24.35	24.12	24.3	7577000.0
2002-10-21 15:00:00	QQQ	ETF	24.3	24.45	24.14	24.3	13382800.0
2002-10-21 16:00:00	QQQ	ETF	24.3	24.36	23.9	24.0	6126300.0
2002-10-21 17:00:00	QQQ	ETF	24.0	24.05	23.8	23.83	1473100.0
2002-10-21 18:00:00	QQQ	ETF	23.9	23.93	23.8	23.92	71100.0
2002-10-21 19:00:00	QQQ	ETF	23.9	23.94	23.89	23.92	3500.0
2002-10-21 09:00:00	IWM	ETF	35.9	36.175	35.9	36.025	208400.0
2002-10-21 10:00:00	IWM	ETF	36.055	36.055	35.87	35.935	317200.0
2002-10-21 11:00:00	IWM	ETF	35.935	36.35	35.935	36.33	509600.0
2002-10-21 12:00:00	IWM	ETF	36.295	36.62	36.295	36.58	689200.0
2002-10-21 13:00:00	IWM	ETF	36.595	36.6	36.505	36.6	340800.0
2002-10-21 14:00:00	IWM	ETF	36.59	36.685	36.56	36.62	322800.0
2002-10-21 15:00:00	IWM	ETF	36.595	36.81	36.545	36.725	672400.0
2002-10-21 16:00:00	IWM	ETF	36.705	37.2	36.625	36.675	63800.0
2002-10-21 17:00:00	IWM	ETF	36.745	36.745	36.745	36.745	136000.0
2002-10-21 08:00:00	DIA	ETF	82.63	82.63	82.57	82.57	200.0
2002-10-21 09:00:00	DIA	ETF	82.56	82.93	82.42	82.8	1446400.0
2002-10-21 10:00:00	DIA	ETF	82.79	83.1	82.34	83.0	1757300.0
2002-10-21 11:00:00	DIA	ETF	82.98	84.45	82.91	84.3	2820600.0
2002-10-21 12:00:00	DIA	ETF	84.28	85.09	84.17	84.72	2019900.0
2002-10-21 13:00:00	DIA	ETF	84.66	84.99	84.52	84.91	1683200.0
2002-10-21 14:00:00	DIA	ETF	84.91	85.22	84.78	84.92	1218300.0
2002-10-21 15:00:00	DIA	ETF	84.96	85.64	84.61	85.43	2337300.0
2002-10-21 16:00:00	DIA	ETF	85.42	85.52	84.9	85.0	445200.0
2002-10-21 17:00:00	DIA	ETF	85.0	85.04	84.85	85.04	10500.0
2002-10-21 18:00:00	DIA	ETF	85.04	85.04	84.85	84.85	2700.0
2002-10-21 09:00:00	TLT	ETF	85.5	85.6	85.36	85.46	7700.0
2002-10-21 10:00:00	TLT	ETF	85.5	85.59	85.06	85.11	17800.0
2002-10-21 11:00:00	TLT	ETF	85.12	85.12	84.75	84.94	21300.0
2002-10-21 12:00:00	TLT	ETF	84.88	85.02	84.5	84.5	7100.0
2002-10-21 13:00:00	TLT	ETF	84.7	84.94	84.7	84.94	6700.0
2002-10-21 14:00:00	TLT	ETF	84.85	84.86	84.56	84.61	16900.0
2002-10-21 15:00:00	TLT	ETF	84.75	84.78	84.53	84.54	57400.0

> showing 50 of 378 rows — these rows as CSV

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