PREVIEW / etf_1hour / 2003-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-18.parquet
  size:    17 KB
  rows:    409

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
2003-07-18 08:00:00	SPY	ETF	98.84	98.9	98.64	98.8	30500.0
2003-07-18 09:00:00	SPY	ETF	98.85	99.25	98.79	98.97	6140900.0
2003-07-18 10:00:00	SPY	ETF	98.98	99.17	98.46	98.88	6760400.0
2003-07-18 11:00:00	SPY	ETF	98.87	98.88	98.6	98.754	4382600.0
2003-07-18 12:00:00	SPY	ETF	98.77	99.16	98.72	99.1	2536000.0
2003-07-18 13:00:00	SPY	ETF	99.09	99.1	98.89	98.95	1933800.0
2003-07-18 14:00:00	SPY	ETF	98.98	99.57	98.96	99.49	3164200.0
2003-07-18 15:00:00	SPY	ETF	99.47	99.8	99.43	99.58	4746000.0
2003-07-18 16:00:00	SPY	ETF	99.56	99.69	99.51	99.55	2034000.0
2003-07-18 17:00:00	SPY	ETF	99.55	99.55	99.48	99.52	32500.0
2003-07-18 18:00:00	SPY	ETF	99.47	99.6	99.47	99.6	7000.0
2003-07-18 19:00:00	SPY	ETF	99.54	99.54	99.54	99.54	100.0
2003-07-18 08:00:00	QQQ	ETF	31.25	31.33	31.24	31.33	151600.0
2003-07-18 09:00:00	QQQ	ETF	31.33	31.47	31.22	31.271	12719300.0
2003-07-18 10:00:00	QQQ	ETF	31.273	31.35	30.92	31.2	21801400.0
2003-07-18 11:00:00	QQQ	ETF	31.204	31.22	31.06	31.14	6965200.0
2003-07-18 12:00:00	QQQ	ETF	31.15	31.33	31.11	31.258	5123200.0
2003-07-18 13:00:00	QQQ	ETF	31.25	31.27	31.15	31.18	2670300.0
2003-07-18 14:00:00	QQQ	ETF	31.19	31.44	31.19	31.38	7640400.0
2003-07-18 15:00:00	QQQ	ETF	31.39	31.55	31.26	31.3	12813800.0
2003-07-18 16:00:00	QQQ	ETF	31.28	31.34	31.24	31.3	2133300.0
2003-07-18 17:00:00	QQQ	ETF	31.3	31.31	31.26	31.26	60100.0
2003-07-18 18:00:00	QQQ	ETF	31.26	31.3	31.23	31.23	46600.0
2003-07-18 19:00:00	QQQ	ETF	31.26	31.36	31.26	31.28	4900.0
2003-07-18 09:00:00	IWM	ETF	46.1	46.225	46.005	46.015	356000.0
2003-07-18 10:00:00	IWM	ETF	46.075	46.09	45.77	45.825	952400.0
2003-07-18 11:00:00	IWM	ETF	45.845	45.935	45.8	45.935	201800.0
2003-07-18 12:00:00	IWM	ETF	45.935	46.075	45.89	46.045	183000.0
2003-07-18 13:00:00	IWM	ETF	46.055	46.055	45.965	46.0	196600.0
2003-07-18 14:00:00	IWM	ETF	45.98	46.325	45.98	46.315	362800.0
2003-07-18 15:00:00	IWM	ETF	46.315	46.4	46.23	46.28	1037400.0
2003-07-18 16:00:00	IWM	ETF	46.25	46.36	46.1	46.225	369800.0
2003-07-18 08:00:00	DIA	ETF	90.75	90.82	90.75	90.8	4100.0
2003-07-18 09:00:00	DIA	ETF	90.83	91.23	90.82	91.08	1123200.0
2003-07-18 10:00:00	DIA	ETF	91.08	91.23	90.8	91.05	1344800.0
2003-07-18 11:00:00	DIA	ETF	91.03	91.03	90.87	90.98	418400.0
2003-07-18 12:00:00	DIA	ETF	90.96	91.39	90.96	91.34	589800.0
2003-07-18 13:00:00	DIA	ETF	91.34	91.37	91.21	91.26	266600.0
2003-07-18 14:00:00	DIA	ETF	91.26	91.76	91.26	91.71	711400.0
2003-07-18 15:00:00	DIA	ETF	91.72	91.96	91.7	91.91	1208000.0
2003-07-18 16:00:00	DIA	ETF	91.86	91.92	91.81	91.83	184900.0
2003-07-18 17:00:00	DIA	ETF	91.84	91.94	91.83	91.94	2000.0
2003-07-18 18:00:00	DIA	ETF	91.93	92.0	91.89	91.91	5300.0
2003-07-18 19:00:00	DIA	ETF	91.95	91.95	91.92	91.92	900.0
2003-07-18 09:00:00	TLT	ETF	87.65	87.7	87.44	87.63	218400.0
2003-07-18 10:00:00	TLT	ETF	87.55	87.92	87.44	87.78	89500.0
2003-07-18 11:00:00	TLT	ETF	87.83	87.83	87.68	87.75	23000.0
2003-07-18 12:00:00	TLT	ETF	87.73	87.77	87.73	87.74	3500.0
2003-07-18 13:00:00	TLT	ETF	87.75	87.88	87.75	87.87	33100.0
2003-07-18 14:00:00	TLT	ETF	87.87	87.96	87.82	87.86	83600.0

> showing 50 of 409 rows — these rows as CSV

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