PREVIEW / etf_1hour / 2002-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-20.parquet
  size:    16 KB
  rows:    380

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-20 08:00:00	SPY	ETF	90.11	90.11	89.95	89.96	27100.0
2002-11-20 09:00:00	SPY	ETF	89.99	90.33	89.95	90.14	3877500.0
2002-11-20 10:00:00	SPY	ETF	90.18	90.94	90.18	90.79	6161900.0
2002-11-20 11:00:00	SPY	ETF	90.8	91.34	90.63	91.26	3881400.0
2002-11-20 12:00:00	SPY	ETF	91.35	91.62	91.2	91.35	3927700.0
2002-11-20 13:00:00	SPY	ETF	91.35	91.95	91.31	91.7	3355100.0
2002-11-20 14:00:00	SPY	ETF	91.7	92.07	91.65	91.95	4229600.0
2002-11-20 15:00:00	SPY	ETF	91.95	91.99	91.23	91.94	6721200.0
2002-11-20 16:00:00	SPY	ETF	91.95	92.65	91.59	92.37	2212600.0
2002-11-20 17:00:00	SPY	ETF	92.39	92.42	92.33	92.41	375100.0
2002-11-20 18:00:00	SPY	ETF	92.42	92.6	92.38	92.6	5200.0
2002-11-20 19:00:00	SPY	ETF	92.51	92.55	92.48	92.55	7400.0
2002-11-20 08:00:00	QQQ	ETF	25.63	25.66	25.56	25.59	62900.0
2002-11-20 09:00:00	QQQ	ETF	25.59	25.8	25.54	25.74	7665400.0
2002-11-20 10:00:00	QQQ	ETF	25.74	26.18	25.72	26.11	12519000.0
2002-11-20 11:00:00	QQQ	ETF	26.12	26.3	26.05	26.28	6785400.0
2002-11-20 12:00:00	QQQ	ETF	26.26	26.49	26.21	26.37	9455300.0
2002-11-20 13:00:00	QQQ	ETF	26.37	26.55	26.36	26.47	8592300.0
2002-11-20 14:00:00	QQQ	ETF	26.47	26.66	26.45	26.59	8481700.0
2002-11-20 15:00:00	QQQ	ETF	26.59	26.67	26.35	26.65	11361900.0
2002-11-20 16:00:00	QQQ	ETF	26.62	26.96	26.62	26.86	5548900.0
2002-11-20 17:00:00	QQQ	ETF	26.87	26.91	26.82	26.9	861200.0
2002-11-20 18:00:00	QQQ	ETF	26.9	26.97	26.88	26.96	72800.0
2002-11-20 19:00:00	QQQ	ETF	26.95	26.96	26.92	26.92	18000.0
2002-11-20 09:00:00	IWM	ETF	37.85	38.07	37.76	38.0	252200.0
2002-11-20 10:00:00	IWM	ETF	38.07	38.44	38.03	38.4	222600.0
2002-11-20 11:00:00	IWM	ETF	38.39	38.5	38.255	38.45	353000.0
2002-11-20 12:00:00	IWM	ETF	38.485	38.55	38.435	38.52	166200.0
2002-11-20 13:00:00	IWM	ETF	38.5	38.58	38.455	38.52	133800.0
2002-11-20 14:00:00	IWM	ETF	38.54	38.65	38.485	38.585	345800.0
2002-11-20 15:00:00	IWM	ETF	38.605	38.85	38.405	38.85	691600.0
2002-11-20 16:00:00	IWM	ETF	38.85	38.975	38.8	38.95	205200.0
2002-11-20 17:00:00	IWM	ETF	38.885	38.885	38.515	38.515	35200.0
2002-11-20 08:00:00	DIA	ETF	84.91	84.91	84.6	84.67	10500.0
2002-11-20 09:00:00	DIA	ETF	84.76	85.04	84.56	84.6	1755600.0
2002-11-20 10:00:00	DIA	ETF	84.65	85.46	84.6	85.34	1081900.0
2002-11-20 11:00:00	DIA	ETF	85.35	85.95	85.26	85.88	1192900.0
2002-11-20 12:00:00	DIA	ETF	85.88	86.19	85.75	85.9	1144800.0
2002-11-20 13:00:00	DIA	ETF	85.83	86.46	85.83	86.26	602900.0
2002-11-20 14:00:00	DIA	ETF	86.29	86.69	86.25	86.56	928200.0
2002-11-20 15:00:00	DIA	ETF	86.53	86.57	85.87	86.46	1042300.0
2002-11-20 16:00:00	DIA	ETF	86.49	87.1	86.45	87.0	352100.0
2002-11-20 17:00:00	DIA	ETF	86.95	87.03	86.8	86.82	2100.0
2002-11-20 18:00:00	DIA	ETF	86.85	87.0	86.85	87.0	2900.0
2002-11-20 19:00:00	DIA	ETF	86.95	87.1	86.95	87.07	3100.0
2002-11-20 09:00:00	TLT	ETF	88.2	88.22	87.96	87.96	8000.0
2002-11-20 10:00:00	TLT	ETF	88.1	88.1	88.03	88.03	81100.0
2002-11-20 11:00:00	TLT	ETF	88.09	88.19	88.0	88.0	9500.0
2002-11-20 12:00:00	TLT	ETF	87.97	87.97	87.51	87.56	12200.0
2002-11-20 13:00:00	TLT	ETF	87.55	87.55	87.1	87.1	16500.0

> showing 50 of 380 rows — these rows as CSV

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