PREVIEW / etf_1hour / 2003-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-30.parquet
  size:    18 KB
  rows:    454

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-30 08:00:00	SPY	ETF	100.6	100.63	100.52	100.54	31900.0
2003-09-30 09:00:00	SPY	ETF	100.59	100.59	99.82	99.86	5981700.0
2003-09-30 10:00:00	SPY	ETF	99.87	100.04	99.25	99.67	17287200.0
2003-09-30 11:00:00	SPY	ETF	99.61	99.97	99.5	99.86	5885000.0
2003-09-30 12:00:00	SPY	ETF	99.86	100.14	99.71	100.03	5432000.0
2003-09-30 13:00:00	SPY	ETF	100.03	100.45	99.93	100.33	5474800.0
2003-09-30 14:00:00	SPY	ETF	100.33	100.6	100.16	100.45	6120000.0
2003-09-30 15:00:00	SPY	ETF	100.44	100.47	99.71	99.86	7904400.0
2003-09-30 16:00:00	SPY	ETF	99.86	100.94	99.85	99.95	4738600.0
2003-09-30 17:00:00	SPY	ETF	99.96	100.0	99.83	99.83	44300.0
2003-09-30 18:00:00	SPY	ETF	99.95	100.0	99.95	100.0	4100.0
2003-09-30 19:00:00	SPY	ETF	100.0	100.0	99.9	99.9	1400.0
2003-09-30 08:00:00	QQQ	ETF	33.02	33.05	32.96	32.97	81600.0
2003-09-30 09:00:00	QQQ	ETF	32.98	33.0	32.64	32.64	10347200.0
2003-09-30 10:00:00	QQQ	ETF	32.7	32.7	32.36	32.53	28083500.0
2003-09-30 11:00:00	QQQ	ETF	32.52	32.67	32.486	32.592	9122500.0
2003-09-30 12:00:00	QQQ	ETF	32.596	32.685	32.53	32.63	7371500.0
2003-09-30 13:00:00	QQQ	ETF	32.629	32.83	32.599	32.73	11876100.0
2003-09-30 14:00:00	QQQ	ETF	32.74	32.887	32.666	32.755	10679500.0
2003-09-30 15:00:00	QQQ	ETF	32.76	32.78	32.357	32.439	20435600.0
2003-09-30 16:00:00	QQQ	ETF	32.441	32.49	32.37	32.41	3437500.0
2003-09-30 17:00:00	QQQ	ETF	32.41	32.47	32.41	32.45	49000.0
2003-09-30 18:00:00	QQQ	ETF	32.46	32.47	32.43	32.45	47500.0
2003-09-30 19:00:00	QQQ	ETF	32.46	32.46	32.43	32.44	5300.0
2003-09-30 08:00:00	IWM	ETF	48.96	48.96	48.96	48.96	1000.0
2003-09-30 09:00:00	IWM	ETF	48.94	49.0	48.485	48.485	864800.0
2003-09-30 10:00:00	IWM	ETF	48.485	48.515	48.095	48.408	2086000.0
2003-09-30 11:00:00	IWM	ETF	48.41	48.645	48.395	48.6	1512000.0
2003-09-30 12:00:00	IWM	ETF	48.58	48.99	48.58	48.95	1719000.0
2003-09-30 13:00:00	IWM	ETF	48.95	49.15	48.9	48.94	1017000.0
2003-09-30 14:00:00	IWM	ETF	48.966	49.07	48.755	48.88	1414400.0
2003-09-30 15:00:00	IWM	ETF	48.87	48.925	48.5	48.52	3149600.0
2003-09-30 16:00:00	IWM	ETF	48.5	48.53	48.47	48.525	355800.0
2003-09-30 08:00:00	DIA	ETF	93.63	93.63	93.63	93.63	900.0
2003-09-30 09:00:00	DIA	ETF	93.65	93.74	93.05	93.1	838400.0
2003-09-30 10:00:00	DIA	ETF	93.09	93.1	92.42	92.72	1991400.0
2003-09-30 11:00:00	DIA	ETF	92.75	92.99	92.62	92.9	492000.0
2003-09-30 12:00:00	DIA	ETF	92.9	93.14	92.75	93.09	493700.0
2003-09-30 13:00:00	DIA	ETF	93.07	93.41	92.98	93.27	771800.0
2003-09-30 14:00:00	DIA	ETF	93.29	93.58	93.15	93.38	862500.0
2003-09-30 15:00:00	DIA	ETF	93.43	93.43	92.8	92.95	1020400.0
2003-09-30 16:00:00	DIA	ETF	92.93	93.15	92.9	93.108	197400.0
2003-09-30 17:00:00	DIA	ETF	93.2	93.25	93.06	93.06	2300.0
2003-09-30 19:00:00	DIA	ETF	93.19	93.19	93.19	93.19	100.0
2003-09-30 09:00:00	TLT	ETF	87.0	87.28	86.96	87.28	74400.0
2003-09-30 10:00:00	TLT	ETF	87.28	87.98	87.28	87.77	590900.0
2003-09-30 11:00:00	TLT	ETF	87.84	87.93	87.7	87.75	158300.0
2003-09-30 12:00:00	TLT	ETF	87.75	87.75	87.33	87.42	96900.0
2003-09-30 13:00:00	TLT	ETF	87.33	87.54	87.32	87.53	22800.0
2003-09-30 14:00:00	TLT	ETF	87.5	88.08	87.5	88.08	217600.0

> showing 50 of 454 rows — these rows as CSV

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