PREVIEW / etf_1hour / 2002-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-18.parquet
  size:    16 KB
  rows:    368

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-18 08:00:00	SPY	ETF	87.51	87.77	87.41	87.62	16700.0
2002-10-18 09:00:00	SPY	ETF	87.62	87.85	87.02	87.13	6279700.0
2002-10-18 10:00:00	SPY	ETF	87.12	88.5	86.93	88.32	10126700.0
2002-10-18 11:00:00	SPY	ETF	88.31	89.11	88.3	88.59	8700700.0
2002-10-18 12:00:00	SPY	ETF	88.6	88.67	88.0	88.13	3719700.0
2002-10-18 13:00:00	SPY	ETF	88.16	88.76	87.96	88.54	3455800.0
2002-10-18 14:00:00	SPY	ETF	88.55	88.85	88.19	88.43	4119100.0
2002-10-18 15:00:00	SPY	ETF	88.42	88.74	88.06	88.7	5477300.0
2002-10-18 16:00:00	SPY	ETF	88.68	88.78	87.12	88.59	3104400.0
2002-10-18 17:00:00	SPY	ETF	88.45	88.65	87.7	88.63	46900.0
2002-10-18 18:00:00	SPY	ETF	88.56	88.68	88.55	88.64	3900.0
2002-10-18 19:00:00	SPY	ETF	88.45	88.45	88.45	88.45	900.0
2002-10-18 08:00:00	QQQ	ETF	23.56	23.56	23.08	23.22	151800.0
2002-10-18 09:00:00	QQQ	ETF	23.24	23.39	22.97	23.0	15170500.0
2002-10-18 10:00:00	QQQ	ETF	23.0	23.45	22.93	23.38	17522600.0
2002-10-18 11:00:00	QQQ	ETF	23.41	23.75	23.38	23.57	15389200.0
2002-10-18 12:00:00	QQQ	ETF	23.57	23.58	23.26	23.44	6519300.0
2002-10-18 13:00:00	QQQ	ETF	23.43	23.64	23.37	23.56	6132700.0
2002-10-18 14:00:00	QQQ	ETF	23.55	23.71	23.47	23.66	8125100.0
2002-10-18 15:00:00	QQQ	ETF	23.66	23.8	23.47	23.78	10419900.0
2002-10-18 16:00:00	QQQ	ETF	23.78	23.89	23.71	23.78	3864400.0
2002-10-18 17:00:00	QQQ	ETF	23.8	23.82	23.76	23.82	44300.0
2002-10-18 18:00:00	QQQ	ETF	23.81	23.88	23.81	23.88	37900.0
2002-10-18 19:00:00	QQQ	ETF	23.86	23.87	23.83	23.83	1500.0
2002-10-18 09:00:00	IWM	ETF	35.835	36.08	35.825	35.825	261600.0
2002-10-18 10:00:00	IWM	ETF	35.825	36.205	35.78	36.19	1069200.0
2002-10-18 11:00:00	IWM	ETF	36.19	36.36	36.19	36.22	327600.0
2002-10-18 12:00:00	IWM	ETF	36.215	36.25	36.09	36.15	346200.0
2002-10-18 13:00:00	IWM	ETF	36.135	36.3	36.11	36.275	64200.0
2002-10-18 14:00:00	IWM	ETF	36.235	36.29	36.195	36.285	148000.0
2002-10-18 15:00:00	IWM	ETF	36.235	36.32	36.15	36.25	470000.0
2002-10-18 16:00:00	IWM	ETF	36.2	36.225	35.75	36.2	69400.0
2002-10-18 18:00:00	IWM	ETF	36.225	36.225	36.225	36.225	138000.0
2002-10-18 08:00:00	DIA	ETF	82.43	82.43	82.01	82.01	1900.0
2002-10-18 09:00:00	DIA	ETF	82.2	82.46	81.65	81.7	1417000.0
2002-10-18 10:00:00	DIA	ETF	81.7	82.98	81.49	82.8	2282600.0
2002-10-18 11:00:00	DIA	ETF	82.77	83.48	82.77	83.03	2180400.0
2002-10-18 12:00:00	DIA	ETF	83.04	83.13	82.5	82.65	820400.0
2002-10-18 13:00:00	DIA	ETF	82.65	83.24	82.42	83.02	924400.0
2002-10-18 14:00:00	DIA	ETF	83.03	83.25	82.7	82.95	990000.0
2002-10-18 15:00:00	DIA	ETF	82.94	83.21	82.6	83.17	1677300.0
2002-10-18 16:00:00	DIA	ETF	83.2	83.22	83.04	83.2	313400.0
2002-10-18 17:00:00	DIA	ETF	83.15	83.15	83.1	83.11	1400.0
2002-10-18 18:00:00	DIA	ETF	83.12	83.18	83.1	83.1	2300.0
2002-10-18 09:00:00	TLT	ETF	85.02	85.25	84.99	85.17	19200.0
2002-10-18 10:00:00	TLT	ETF	85.01	85.03	84.46	84.57	163700.0
2002-10-18 11:00:00	TLT	ETF	84.5	84.92	84.28	84.92	165500.0
2002-10-18 12:00:00	TLT	ETF	84.97	85.25	84.97	85.25	58200.0
2002-10-18 13:00:00	TLT	ETF	85.21	85.38	85.01	85.01	22400.0
2002-10-18 14:00:00	TLT	ETF	85.12	85.19	85.05	85.19	5100.0

> showing 50 of 368 rows — these rows as CSV

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