PREVIEW / etf_1hour / 2003-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-27.parquet
  size:    16 KB
  rows:    399

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-27 08:00:00	SPY	ETF	100.17	100.17	100.06	100.06	21100.0
2003-08-27 09:00:00	SPY	ETF	100.04	100.16	99.95	99.97	2807900.0
2003-08-27 10:00:00	SPY	ETF	99.95	100.252	99.82	100.17	3664600.0
2003-08-27 11:00:00	SPY	ETF	100.153	100.208	100.02	100.08	1892000.0
2003-08-27 12:00:00	SPY	ETF	100.09	100.22	100.04	100.21	923000.0
2003-08-27 13:00:00	SPY	ETF	100.2	100.36	100.15	100.17	2406100.0
2003-08-27 14:00:00	SPY	ETF	100.17	100.295	100.02	100.22	2332400.0
2003-08-27 15:00:00	SPY	ETF	100.209	100.34	100.13	100.24	2789600.0
2003-08-27 16:00:00	SPY	ETF	100.25	100.28	100.1	100.12	865600.0
2003-08-27 17:00:00	SPY	ETF	100.12	100.14	100.1	100.1	265800.0
2003-08-27 18:00:00	SPY	ETF	100.14	100.14	100.14	100.14	200.0
2003-08-27 19:00:00	SPY	ETF	100.14	100.14	100.14	100.14	100.0
2003-08-27 08:00:00	QQQ	ETF	32.55	32.55	32.46	32.46	75000.0
2003-08-27 09:00:00	QQQ	ETF	32.45	32.596	32.42	32.43	5801000.0
2003-08-27 10:00:00	QQQ	ETF	32.43	32.66	32.37	32.6	8451000.0
2003-08-27 11:00:00	QQQ	ETF	32.6	32.68	32.53	32.605	5514400.0
2003-08-27 12:00:00	QQQ	ETF	32.6	32.67	32.56	32.65	2987500.0
2003-08-27 13:00:00	QQQ	ETF	32.65	32.823	32.62	32.74	7830300.0
2003-08-27 14:00:00	QQQ	ETF	32.738	32.77	32.57	32.702	4962600.0
2003-08-27 15:00:00	QQQ	ETF	32.702	32.83	32.67	32.81	6308600.0
2003-08-27 16:00:00	QQQ	ETF	32.8	32.85	32.75	32.8	1603900.0
2003-08-27 17:00:00	QQQ	ETF	32.8	32.81	32.78	32.79	33400.0
2003-08-27 18:00:00	QQQ	ETF	32.8	32.82	32.8	32.8	10400.0
2003-08-27 19:00:00	QQQ	ETF	32.8	32.83	32.79	32.83	12100.0
2003-08-27 09:00:00	IWM	ETF	48.595	48.735	48.525	48.525	246400.0
2003-08-27 10:00:00	IWM	ETF	48.525	48.9	48.495	48.782	561200.0
2003-08-27 11:00:00	IWM	ETF	48.815	48.85	48.745	48.745	121400.0
2003-08-27 12:00:00	IWM	ETF	48.75	48.84	48.74	48.84	281800.0
2003-08-27 13:00:00	IWM	ETF	48.84	48.9515	48.825	48.895	134600.0
2003-08-27 14:00:00	IWM	ETF	48.88	48.93	48.8	48.9	568400.0
2003-08-27 15:00:00	IWM	ETF	48.895	49.095	48.84	49.07	347400.0
2003-08-27 16:00:00	IWM	ETF	49.05	49.075	49.01	49.075	79600.0
2003-08-27 08:00:00	DIA	ETF	93.62	93.62	93.45	93.53	3100.0
2003-08-27 09:00:00	DIA	ETF	93.48	93.64	93.39	93.43	387500.0
2003-08-27 10:00:00	DIA	ETF	93.41	93.63	93.25	93.51	609500.0
2003-08-27 11:00:00	DIA	ETF	93.55	93.59	93.4	93.45	282300.0
2003-08-27 12:00:00	DIA	ETF	93.43	93.52	93.4	93.49	113700.0
2003-08-27 13:00:00	DIA	ETF	93.48	93.71	93.47	93.53	437200.0
2003-08-27 14:00:00	DIA	ETF	93.5	93.61	93.4	93.56	577300.0
2003-08-27 15:00:00	DIA	ETF	93.57	93.678	93.5	93.57	396800.0
2003-08-27 16:00:00	DIA	ETF	93.59	93.61	93.46	93.55	53100.0
2003-08-27 17:00:00	DIA	ETF	93.55	93.55	93.47	93.47	400.0
2003-08-27 19:00:00	DIA	ETF	93.47	93.47	93.47	93.47	100.0
2003-08-27 09:00:00	TLT	ETF	83.2	83.2	82.85	82.96	19200.0
2003-08-27 10:00:00	TLT	ETF	82.95	83.05	82.74	82.9	77300.0
2003-08-27 11:00:00	TLT	ETF	82.88	82.94	82.61	82.73	140600.0
2003-08-27 12:00:00	TLT	ETF	82.79	82.86	82.76	82.78	13100.0
2003-08-27 13:00:00	TLT	ETF	82.79	82.79	82.65	82.73	32500.0
2003-08-27 14:00:00	TLT	ETF	82.82	83.02	82.71	82.78	79700.0
2003-08-27 15:00:00	TLT	ETF	82.88	83.0	82.78	82.99	24200.0

> showing 50 of 399 rows — these rows as CSV

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