PREVIEW / etf_1hour / 2002-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-18.parquet
  size:    16 KB
  rows:    389

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-18 08:00:00	SPY	ETF	92.1	92.13	92.0	92.13	6000.0
2002-11-18 09:00:00	SPY	ETF	92.13	92.15	91.35	91.38	3982400.0
2002-11-18 10:00:00	SPY	ETF	91.44	91.85	91.19	91.38	4650000.0
2002-11-18 11:00:00	SPY	ETF	91.4	91.45	90.9	91.02	4200800.0
2002-11-18 12:00:00	SPY	ETF	91.03	91.3	90.85	91.21	1989000.0
2002-11-18 13:00:00	SPY	ETF	91.19	91.59	91.15	91.5	2688700.0
2002-11-18 14:00:00	SPY	ETF	91.55	91.56	90.72	90.81	2089700.0
2002-11-18 15:00:00	SPY	ETF	90.84	90.84	90.4	90.5	4795000.0
2002-11-18 16:00:00	SPY	ETF	90.5	91.23	90.33	90.33	1874200.0
2002-11-18 17:00:00	SPY	ETF	90.4	90.44	90.37	90.43	54000.0
2002-11-18 18:00:00	SPY	ETF	90.48	90.48	90.39	90.41	75000.0
2002-11-18 08:00:00	QQQ	ETF	26.68	26.8	26.65	26.78	72400.0
2002-11-18 09:00:00	QQQ	ETF	26.78	26.78	26.32	26.35	13416900.0
2002-11-18 10:00:00	QQQ	ETF	26.36	26.67	26.31	26.56	13439900.0
2002-11-18 11:00:00	QQQ	ETF	26.57	26.59	26.24	26.36	10146600.0
2002-11-18 12:00:00	QQQ	ETF	26.35	26.56	26.32	26.52	5649800.0
2002-11-18 13:00:00	QQQ	ETF	26.54	26.66	26.5	26.62	6227500.0
2002-11-18 14:00:00	QQQ	ETF	26.62	26.63	26.26	26.3	7383400.0
2002-11-18 15:00:00	QQQ	ETF	26.3	26.34	26.0	26.02	12469400.0
2002-11-18 16:00:00	QQQ	ETF	26.02	26.09	25.99	26.03	4137400.0
2002-11-18 17:00:00	QQQ	ETF	26.02	26.07	26.01	26.03	344800.0
2002-11-18 18:00:00	QQQ	ETF	26.04	26.05	25.96	26.05	414900.0
2002-11-18 19:00:00	QQQ	ETF	26.03	26.05	26.03	26.05	2800.0
2002-11-18 09:00:00	IWM	ETF	38.875	38.875	38.505	38.505	311000.0
2002-11-18 10:00:00	IWM	ETF	38.495	38.645	38.385	38.48	347000.0
2002-11-18 11:00:00	IWM	ETF	38.485	38.49	38.045	38.08	253200.0
2002-11-18 12:00:00	IWM	ETF	38.05	38.33	38.035	38.33	276400.0
2002-11-18 13:00:00	IWM	ETF	38.34	38.77	38.335	38.66	271000.0
2002-11-18 14:00:00	IWM	ETF	38.655	38.7	38.36	38.4	273800.0
2002-11-18 15:00:00	IWM	ETF	38.365	38.405	38.11	38.13	613800.0
2002-11-18 16:00:00	IWM	ETF	38.155	38.24	38.105	38.18	98600.0
2002-11-18 18:00:00	IWM	ETF	38.18	38.18	38.18	38.18	261600.0
2002-11-18 08:00:00	DIA	ETF	86.42	86.49	86.42	86.49	2400.0
2002-11-18 09:00:00	DIA	ETF	86.52	86.55	85.65	85.72	912900.0
2002-11-18 10:00:00	DIA	ETF	85.72	86.04	85.41	85.55	1570000.0
2002-11-18 11:00:00	DIA	ETF	85.54	85.67	85.25	85.42	537300.0
2002-11-18 12:00:00	DIA	ETF	85.38	85.65	85.27	85.6	358100.0
2002-11-18 13:00:00	DIA	ETF	85.6	85.96	85.55	85.88	471100.0
2002-11-18 14:00:00	DIA	ETF	85.92	85.92	85.15	85.31	458800.0
2002-11-18 15:00:00	DIA	ETF	85.28	85.3	84.9	84.97	943400.0
2002-11-18 16:00:00	DIA	ETF	84.97	85.19	84.8	84.8	64700.0
2002-11-18 18:00:00	DIA	ETF	84.85	84.85	84.85	84.85	100.0
2002-11-18 09:00:00	TLT	ETF	87.02	87.11	87.01	87.11	3800.0
2002-11-18 10:00:00	TLT	ETF	87.15	87.16	86.98	87.06	4100.0
2002-11-18 11:00:00	TLT	ETF	87.0	87.13	87.0	87.01	7000.0
2002-11-18 12:00:00	TLT	ETF	87.09	87.17	86.96	87.17	500.0
2002-11-18 13:00:00	TLT	ETF	87.13	87.13	87.07	87.07	1700.0
2002-11-18 14:00:00	TLT	ETF	87.14	87.4	87.14	87.4	9900.0
2002-11-18 15:00:00	TLT	ETF	87.4	87.63	87.33	87.56	3900.0
2002-11-18 16:00:00	TLT	ETF	87.5	87.5	87.5	87.5	1000.0

> showing 50 of 389 rows — these rows as CSV

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