PREVIEW / etf_1hour / 2003-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-01.parquet
  size:    16 KB
  rows:    404

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-01 08:00:00	SPY	ETF	99.55	99.62	98.98	99.1	422100.0
2003-08-01 09:00:00	SPY	ETF	99.1	99.29	98.72	98.77	7935800.0
2003-08-01 10:00:00	SPY	ETF	98.77	98.97	98.24	98.46	10913200.0
2003-08-01 11:00:00	SPY	ETF	98.49	98.73	98.3	98.5	3377000.0
2003-08-01 12:00:00	SPY	ETF	98.511	98.699	98.33	98.68	2014400.0
2003-08-01 13:00:00	SPY	ETF	98.64	98.94	98.5	98.67	3882700.0
2003-08-01 14:00:00	SPY	ETF	98.68	98.81	98.42	98.6	3985200.0
2003-08-01 15:00:00	SPY	ETF	98.6	98.67	98.25	98.38	10330400.0
2003-08-01 16:00:00	SPY	ETF	98.38	98.55	98.35	98.41	1443400.0
2003-08-01 17:00:00	SPY	ETF	98.39	98.42	98.38	98.42	4400.0
2003-08-01 18:00:00	SPY	ETF	98.4	98.4	98.38	98.4	2500.0
2003-08-01 19:00:00	SPY	ETF	98.4	98.4	98.4	98.4	2000.0
2003-08-01 08:00:00	QQQ	ETF	31.84	31.89	31.58	31.63	297400.0
2003-08-01 09:00:00	QQQ	ETF	31.64	31.79	31.55	31.62	6764900.0
2003-08-01 10:00:00	QQQ	ETF	31.62	31.69	31.3	31.47	18684900.0
2003-08-01 11:00:00	QQQ	ETF	31.5	31.6	31.39	31.51	7640400.0
2003-08-01 12:00:00	QQQ	ETF	31.51	31.57	31.42	31.55	3479900.0
2003-08-01 13:00:00	QQQ	ETF	31.555	31.716	31.52	31.56	8756000.0
2003-08-01 14:00:00	QQQ	ETF	31.561	31.648	31.44	31.57	8183400.0
2003-08-01 15:00:00	QQQ	ETF	31.57	31.59	31.37	31.484	10533100.0
2003-08-01 16:00:00	QQQ	ETF	31.483	31.55	31.44	31.47	3077900.0
2003-08-01 17:00:00	QQQ	ETF	31.47	31.48	31.41	31.469	388800.0
2003-08-01 18:00:00	QQQ	ETF	31.47	31.49	31.45	31.45	17400.0
2003-08-01 19:00:00	QQQ	ETF	31.45	31.45	31.4	31.41	11400.0
2003-08-01 09:00:00	IWM	ETF	47.235	47.477	47.161	47.2	358400.0
2003-08-01 10:00:00	IWM	ETF	47.175	47.195	46.525	46.58	775000.0
2003-08-01 11:00:00	IWM	ETF	46.57	46.79	46.545	46.74	490200.0
2003-08-01 12:00:00	IWM	ETF	46.75	46.76	46.66	46.73	459200.0
2003-08-01 13:00:00	IWM	ETF	46.775	46.88	46.775	46.82	386200.0
2003-08-01 14:00:00	IWM	ETF	46.82	46.83	46.675	46.81	450000.0
2003-08-01 15:00:00	IWM	ETF	46.815	46.815	46.625	46.655	1302400.0
2003-08-01 16:00:00	IWM	ETF	46.6	46.68	46.6	46.675	84000.0
2003-08-01 08:00:00	DIA	ETF	92.62	92.69	92.15	92.26	38100.0
2003-08-01 09:00:00	DIA	ETF	92.27	92.49	91.95	92.0	992900.0
2003-08-01 10:00:00	DIA	ETF	91.99	92.11	91.5	91.78	2121500.0
2003-08-01 11:00:00	DIA	ETF	91.75	92.05	91.63	91.79	801300.0
2003-08-01 12:00:00	DIA	ETF	91.8	91.93	91.67	91.92	373100.0
2003-08-01 13:00:00	DIA	ETF	91.929	92.17	91.79	91.95	417700.0
2003-08-01 14:00:00	DIA	ETF	91.95	92.0	91.72	91.82	488800.0
2003-08-01 15:00:00	DIA	ETF	91.82	91.84	91.52	91.7	1122900.0
2003-08-01 16:00:00	DIA	ETF	91.7	91.81	91.65	91.68	93000.0
2003-08-01 17:00:00	DIA	ETF	91.66	91.66	91.66	91.66	200.0
2003-08-01 19:00:00	DIA	ETF	91.66	91.67	91.66	91.67	500.0
2003-08-01 09:00:00	TLT	ETF	82.1	82.4	82.05	82.11	462600.0
2003-08-01 10:00:00	TLT	ETF	82.1	82.79	82.1	82.35	861600.0
2003-08-01 11:00:00	TLT	ETF	82.32	82.7	81.98	82.42	391000.0
2003-08-01 12:00:00	TLT	ETF	82.42	82.7	82.37	82.37	222300.0
2003-08-01 13:00:00	TLT	ETF	82.3	82.51	82.12	82.35	179000.0
2003-08-01 14:00:00	TLT	ETF	82.36	82.7	82.1	82.55	328600.0
2003-08-01 15:00:00	TLT	ETF	82.6	82.74	82.56	82.61	469600.0

> showing 50 of 404 rows — these rows as CSV

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