PREVIEW / etf_1hour / 2003-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-04.parquet
  size:    17 KB
  rows:    412

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-08-04 08:00:00	SPY	ETF	98.68	98.7	98.43	98.43	87800.0
2003-08-04 09:00:00	SPY	ETF	98.43	98.46	97.39	97.58	6816700.0
2003-08-04 10:00:00	SPY	ETF	97.59	97.7	97.024	97.38	8753200.0
2003-08-04 11:00:00	SPY	ETF	97.338	97.55	97.26	97.396	4222000.0
2003-08-04 12:00:00	SPY	ETF	97.39	98.18	97.35	97.85	4882300.0
2003-08-04 13:00:00	SPY	ETF	97.87	98.43	97.85	97.9	6411900.0
2003-08-04 14:00:00	SPY	ETF	97.91	98.98	97.84	98.76	10085600.0
2003-08-04 15:00:00	SPY	ETF	98.75	99.0	98.46	98.71	6349800.0
2003-08-04 16:00:00	SPY	ETF	98.72	98.73	98.51	98.57	2180600.0
2003-08-04 17:00:00	SPY	ETF	98.59	98.64	98.55	98.62	304300.0
2003-08-04 18:00:00	SPY	ETF	98.62	98.65	98.55	98.65	7800.0
2003-08-04 19:00:00	SPY	ETF	98.6	98.65	98.57	98.62	2200.0
2003-08-04 08:00:00	QQQ	ETF	31.58	31.58	31.46	31.47	51800.0
2003-08-04 09:00:00	QQQ	ETF	31.47	31.5	31.06	31.15	10431200.0
2003-08-04 10:00:00	QQQ	ETF	31.154	31.21	30.84	30.95	18222200.0
2003-08-04 11:00:00	QQQ	ETF	30.97	31.1	30.93	30.996	8990400.0
2003-08-04 12:00:00	QQQ	ETF	31.0	31.226	30.959	31.15	7345900.0
2003-08-04 13:00:00	QQQ	ETF	31.14	31.37	31.13	31.15	11159600.0
2003-08-04 14:00:00	QQQ	ETF	31.16	31.8	31.12	31.66	14966400.0
2003-08-04 15:00:00	QQQ	ETF	31.655	31.75	31.38	31.51	12035700.0
2003-08-04 16:00:00	QQQ	ETF	31.509	31.54	31.422	31.44	2146800.0
2003-08-04 17:00:00	QQQ	ETF	31.46	31.47	31.44	31.45	15000.0
2003-08-04 18:00:00	QQQ	ETF	31.46	31.49	31.46	31.47	11100.0
2003-08-04 19:00:00	QQQ	ETF	31.46	31.52	31.46	31.52	7600.0
2003-08-04 09:00:00	IWM	ETF	46.57	46.752	46.285	46.285	1957000.0
2003-08-04 10:00:00	IWM	ETF	46.275	46.305	45.845	45.97	754600.0
2003-08-04 11:00:00	IWM	ETF	45.97	46.065	45.945	45.995	212200.0
2003-08-04 12:00:00	IWM	ETF	45.965	46.11	45.945	46.06	912400.0
2003-08-04 13:00:00	IWM	ETF	46.025	46.2	46.025	46.125	711400.0
2003-08-04 14:00:00	IWM	ETF	46.125	46.57	46.085	46.55	982600.0
2003-08-04 15:00:00	IWM	ETF	46.545	46.615	46.35	46.37	1006800.0
2003-08-04 16:00:00	IWM	ETF	46.37	46.42	46.205	46.205	134600.0
2003-08-04 08:00:00	DIA	ETF	91.9	91.93	91.67	91.67	13300.0
2003-08-04 09:00:00	DIA	ETF	91.66	91.68	90.89	90.99	960400.0
2003-08-04 10:00:00	DIA	ETF	91.0	91.19	90.6	90.94	1221600.0
2003-08-04 11:00:00	DIA	ETF	90.94	91.14	90.89	90.98	812800.0
2003-08-04 12:00:00	DIA	ETF	91.0	91.6	90.94	91.3	615000.0
2003-08-04 13:00:00	DIA	ETF	91.31	91.89	91.3	91.4	709400.0
2003-08-04 14:00:00	DIA	ETF	91.37	92.22	91.31	92.0	1143600.0
2003-08-04 15:00:00	DIA	ETF	92.02	92.24	91.73	92.009	1390700.0
2003-08-04 16:00:00	DIA	ETF	92.0	92.0	91.8	91.9	67200.0
2003-08-04 17:00:00	DIA	ETF	91.94	91.95	91.84	91.95	600.0
2003-08-04 18:00:00	DIA	ETF	91.88	91.88	91.88	91.88	100.0
2003-08-04 19:00:00	DIA	ETF	91.9	91.95	91.9	91.95	200.0
2003-08-04 09:00:00	TLT	ETF	82.48	82.75	82.37	82.66	302500.0
2003-08-04 10:00:00	TLT	ETF	82.65	82.79	82.45	82.5	398000.0
2003-08-04 11:00:00	TLT	ETF	82.58	82.75	82.5	82.7	153500.0
2003-08-04 12:00:00	TLT	ETF	82.7	82.93	82.65	82.71	282200.0
2003-08-04 13:00:00	TLT	ETF	82.78	82.94	82.68	82.94	88200.0
2003-08-04 14:00:00	TLT	ETF	82.9	83.1	82.82	83.0	221500.0

> showing 50 of 412 rows — these rows as CSV

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