PREVIEW / etf_1hour / 2004-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-10.parquet
  size:    26 KB
  rows:    750

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
2004-11-10 08:00:00	SPY	ETF	117.28	117.28	117.11	117.11	80700.0
2004-11-10 09:00:00	SPY	ETF	117.11	117.12	116.88	116.9016	3682800.0
2004-11-10 10:00:00	SPY	ETF	116.9	117.14	116.76	117.06	6439200.0
2004-11-10 11:00:00	SPY	ETF	117.06	117.23	116.96	117.16	4271400.0
2004-11-10 12:00:00	SPY	ETF	117.15	117.24	117.12	117.16	1916000.0
2004-11-10 13:00:00	SPY	ETF	117.16	117.19	116.92	117.02	2682600.0
2004-11-10 14:00:00	SPY	ETF	117.01	117.55	116.92	117.35	10995100.0
2004-11-10 15:00:00	SPY	ETF	117.35	117.41	116.8	116.92	9903100.0
2004-11-10 16:00:00	SPY	ETF	116.93	117.05	116.85	117.02	2096800.0
2004-11-10 17:00:00	SPY	ETF	116.97	116.99	116.94	116.94	4000.0
2004-11-10 18:00:00	SPY	ETF	116.93	117.0	116.93	117.0	1900.0
2004-11-10 19:00:00	SPY	ETF	117.0	117.0	117.0	117.0	100.0
2004-11-10 08:00:00	QQQ	ETF	38.03	38.06	37.95	37.95	443400.0
2004-11-10 09:00:00	QQQ	ETF	37.95	37.97	37.86	37.88	9316700.0
2004-11-10 10:00:00	QQQ	ETF	37.87	37.88	37.74	37.85	15702200.0
2004-11-10 11:00:00	QQQ	ETF	37.85	37.896	37.76	37.86	6106700.0
2004-11-10 12:00:00	QQQ	ETF	37.86	37.89	37.83	37.84	4530800.0
2004-11-10 13:00:00	QQQ	ETF	37.84	37.86	37.76	37.8	6705000.0
2004-11-10 14:00:00	QQQ	ETF	37.8	38.06	37.786	37.97	23590100.0
2004-11-10 15:00:00	QQQ	ETF	37.97	38.0	37.64	37.74	24834000.0
2004-11-10 16:00:00	QQQ	ETF	37.744	37.81	37.65	37.75	1845700.0
2004-11-10 17:00:00	QQQ	ETF	37.75	37.78	37.75	37.75	44700.0
2004-11-10 18:00:00	QQQ	ETF	37.75	37.78	37.74	37.76	29800.0
2004-11-10 19:00:00	QQQ	ETF	37.77	37.8	37.77	37.8	18500.0
2004-11-10 08:00:00	IWM	ETF	60.525	60.545	60.505	60.505	4000.0
2004-11-10 09:00:00	IWM	ETF	60.375	60.445	60.3	60.375	897800.0
2004-11-10 10:00:00	IWM	ETF	60.365	60.545	60.325	60.515	1293400.0
2004-11-10 11:00:00	IWM	ETF	60.5157	60.855	60.495	60.795	1523200.0
2004-11-10 12:00:00	IWM	ETF	60.8	60.875	60.79	60.82	950800.0
2004-11-10 13:00:00	IWM	ETF	60.81	60.87	60.67	60.85	1150200.0
2004-11-10 14:00:00	IWM	ETF	60.84	61.07	60.775	61.045	2558800.0
2004-11-10 15:00:00	IWM	ETF	61.005	61.035	60.7	60.73	2103800.0
2004-11-10 16:00:00	IWM	ETF	60.74	60.835	60.7	60.755	228600.0
2004-11-10 08:00:00	DIA	ETF	104.41	104.44	104.38	104.43	9600.0
2004-11-10 09:00:00	DIA	ETF	104.29	104.4	104.2	104.32	243400.0
2004-11-10 10:00:00	DIA	ETF	104.3	104.5	104.21	104.48	687700.0
2004-11-10 11:00:00	DIA	ETF	104.5	104.6	104.35	104.55	325700.0
2004-11-10 12:00:00	DIA	ETF	104.56	104.62	104.49	104.53	291700.0
2004-11-10 13:00:00	DIA	ETF	104.5	104.54	104.3	104.38	324900.0
2004-11-10 14:00:00	DIA	ETF	104.38	104.81	104.26	104.62	1605800.0
2004-11-10 15:00:00	DIA	ETF	104.61	104.68	104.15	104.3	1855700.0
2004-11-10 16:00:00	DIA	ETF	104.3	104.39	104.3	104.34	76200.0
2004-11-10 17:00:00	DIA	ETF	104.39	104.39	104.39	104.39	200.0
2004-11-10 18:00:00	DIA	ETF	104.31	104.31	104.31	104.31	100.0
2004-11-10 08:00:00	TLT	ETF	87.23	87.32	87.21	87.21	42000.0
2004-11-10 09:00:00	TLT	ETF	87.31	87.31	87.24	87.28	77500.0
2004-11-10 10:00:00	TLT	ETF	87.29	87.29	87.11	87.11	496200.0
2004-11-10 11:00:00	TLT	ETF	87.13	87.17	87.12	87.13	60700.0
2004-11-10 12:00:00	TLT	ETF	87.12	87.12	87.02	87.02	130600.0
2004-11-10 13:00:00	TLT	ETF	87.02	87.14	86.91	87.06	163000.0

> showing 50 of 750 rows — these rows as CSV

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