PREVIEW / etf_1hour / 2003-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-26.parquet
  size:    17 KB
  rows:    419

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-09-26 08:00:00	SPY	ETF	100.04	100.35	100.0	100.34	140700.0
2003-09-26 09:00:00	SPY	ETF	100.33	100.54	100.02	100.38	6641200.0
2003-09-26 10:00:00	SPY	ETF	100.38	100.66	99.97	100.37	7054100.0
2003-09-26 11:00:00	SPY	ETF	100.37	100.65	100.04	100.13	5200400.0
2003-09-26 12:00:00	SPY	ETF	100.12	100.39	99.88	100.31	3888200.0
2003-09-26 13:00:00	SPY	ETF	100.29	100.59	100.197	100.33	3173400.0
2003-09-26 14:00:00	SPY	ETF	100.31	100.42	99.9	99.99	2835000.0
2003-09-26 15:00:00	SPY	ETF	99.99	100.37	99.85	99.98	5774000.0
2003-09-26 16:00:00	SPY	ETF	100.02	100.5854	99.88	99.94	2714900.0
2003-09-26 17:00:00	SPY	ETF	99.95	100.03	99.93	100.0	51100.0
2003-09-26 18:00:00	SPY	ETF	100.0	100.05	100.0	100.05	300.0
2003-09-26 08:00:00	QQQ	ETF	32.7	32.91	32.66	32.86	224500.0
2003-09-26 09:00:00	QQQ	ETF	32.89	33.09	32.78	32.97	11664200.0
2003-09-26 10:00:00	QQQ	ETF	32.98	33.17	32.78	33.04	20510000.0
2003-09-26 11:00:00	QQQ	ETF	33.001	33.14	32.71	32.76	15253500.0
2003-09-26 12:00:00	QQQ	ETF	32.77	32.901	32.62	32.85	8426700.0
2003-09-26 13:00:00	QQQ	ETF	32.84	33.02	32.79	32.85	8574200.0
2003-09-26 14:00:00	QQQ	ETF	32.84	32.95	32.61	32.65	11001100.0
2003-09-26 15:00:00	QQQ	ETF	32.65	32.87	32.56	32.58	17049000.0
2003-09-26 16:00:00	QQQ	ETF	32.59	32.64	32.46	32.55	3415400.0
2003-09-26 17:00:00	QQQ	ETF	32.54	32.58	32.5	32.58	86100.0
2003-09-26 18:00:00	QQQ	ETF	32.58	32.64	32.55	32.6	41500.0
2003-09-26 19:00:00	QQQ	ETF	32.6	32.62	32.58	32.61	18200.0
2003-09-26 09:00:00	IWM	ETF	49.235	49.305	48.8	48.9	1221600.0
2003-09-26 10:00:00	IWM	ETF	48.915	49.075	48.5	48.925	2499800.0
2003-09-26 11:00:00	IWM	ETF	48.875	49.005	48.695	48.75	1253200.0
2003-09-26 12:00:00	IWM	ETF	48.735	48.74	48.5	48.67	868800.0
2003-09-26 13:00:00	IWM	ETF	48.66	48.815	48.66	48.685	381200.0
2003-09-26 14:00:00	IWM	ETF	48.685	48.845	48.55	48.58	631800.0
2003-09-26 15:00:00	IWM	ETF	48.57	48.67	48.25	48.26	2226000.0
2003-09-26 16:00:00	IWM	ETF	48.31	48.355	48.23	48.3	329800.0
2003-09-26 08:00:00	DIA	ETF	93.28	93.47	93.28	93.47	3500.0
2003-09-26 09:00:00	DIA	ETF	93.5	93.63	93.26	93.44	992400.0
2003-09-26 10:00:00	DIA	ETF	93.43	93.68	93.13	93.46	1261600.0
2003-09-26 11:00:00	DIA	ETF	93.42	93.67	93.27	93.33	700100.0
2003-09-26 12:00:00	DIA	ETF	93.32	93.61	93.18	93.52	541000.0
2003-09-26 13:00:00	DIA	ETF	93.53	93.74	93.47	93.59	881800.0
2003-09-26 14:00:00	DIA	ETF	93.59	93.67	93.25	93.27	444300.0
2003-09-26 15:00:00	DIA	ETF	93.28	93.57	93.21	93.33	738700.0
2003-09-26 16:00:00	DIA	ETF	93.34	93.38	93.22	93.37	226400.0
2003-09-26 17:00:00	DIA	ETF	93.3	93.3	93.28	93.28	500.0
2003-09-26 19:00:00	DIA	ETF	93.39	93.39	93.37	93.39	300.0
2003-09-26 09:00:00	TLT	ETF	86.94	87.08	86.823	87.0	101600.0
2003-09-26 10:00:00	TLT	ETF	86.85	87.18	86.85	87.0	270400.0
2003-09-26 11:00:00	TLT	ETF	87.0	87.14	86.85	87.11	134900.0
2003-09-26 12:00:00	TLT	ETF	87.07	87.22	86.994	87.06	106900.0
2003-09-26 13:00:00	TLT	ETF	87.06	87.335	87.06	87.29	235400.0
2003-09-26 14:00:00	TLT	ETF	87.28	87.48	87.1	87.2	582900.0
2003-09-26 15:00:00	TLT	ETF	87.22	87.44	87.17	87.39	116800.0
2003-09-26 16:00:00	TLT	ETF	87.48	87.49	87.44	87.48	10500.0

> showing 50 of 419 rows — these rows as CSV

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