PREVIEW / etf_1hour / 2003-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-05.parquet
  size:    19 KB
  rows:    492

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-12-05 08:00:00	SPY	ETF	107.37	107.37	106.95	107.0	76300.0
2003-12-05 09:00:00	SPY	ETF	107.0	107.29	107.0	107.19	2487100.0
2003-12-05 10:00:00	SPY	ETF	107.2	107.42	107.11	107.15	3738900.0
2003-12-05 11:00:00	SPY	ETF	107.15	107.52	107.04	107.33	3049400.0
2003-12-05 12:00:00	SPY	ETF	107.33	107.34	107.09	107.28	1740200.0
2003-12-05 13:00:00	SPY	ETF	107.3	107.32	106.65	106.73	4479000.0
2003-12-05 14:00:00	SPY	ETF	106.72	106.89	106.62	106.8	2880600.0
2003-12-05 15:00:00	SPY	ETF	106.8	106.96	106.62	106.81	3646300.0
2003-12-05 16:00:00	SPY	ETF	106.79	106.94	106.76	106.9	759100.0
2003-12-05 17:00:00	SPY	ETF	106.9	106.9	106.82	106.82	12700.0
2003-12-05 18:00:00	SPY	ETF	106.82	106.83	106.8	106.83	6700.0
2003-12-05 19:00:00	SPY	ETF	106.81	106.85	106.78	106.85	3500.0
2003-12-05 08:00:00	QQQ	ETF	35.39	35.41	35.18	35.2	538500.0
2003-12-05 09:00:00	QQQ	ETF	35.22	35.37	35.16	35.322	9279900.0
2003-12-05 10:00:00	QQQ	ETF	35.32	35.5	35.23	35.306	10719900.0
2003-12-05 11:00:00	QQQ	ETF	35.31	35.479	35.23	35.35	8217900.0
2003-12-05 12:00:00	QQQ	ETF	35.35	35.35	35.232	35.31	4464900.0
2003-12-05 13:00:00	QQQ	ETF	35.31	35.32	34.98	35.0	12131400.0
2003-12-05 14:00:00	QQQ	ETF	35.0	35.15	34.96	35.06	9173900.0
2003-12-05 15:00:00	QQQ	ETF	35.07	35.19	34.96	35.05	12524500.0
2003-12-05 16:00:00	QQQ	ETF	35.04	35.09	35.01	35.08	3504700.0
2003-12-05 17:00:00	QQQ	ETF	35.07	35.1	35.0	35.0	173800.0
2003-12-05 18:00:00	QQQ	ETF	35.0	35.02	34.99	35.02	27700.0
2003-12-05 19:00:00	QQQ	ETF	35.03	35.08	35.03	35.08	11500.0
2003-12-05 08:00:00	IWM	ETF	54.075	54.11	54.025	54.025	3200.0
2003-12-05 09:00:00	IWM	ETF	54.025	54.16	53.89	54.12	890200.0
2003-12-05 10:00:00	IWM	ETF	54.12	54.25	53.95	54.105	318400.0
2003-12-05 11:00:00	IWM	ETF	54.135	54.185	53.9795	54.025	513800.0
2003-12-05 12:00:00	IWM	ETF	53.9995	54.025	53.805	53.875	1120200.0
2003-12-05 13:00:00	IWM	ETF	53.88	53.925	53.625	53.66	930000.0
2003-12-05 14:00:00	IWM	ETF	53.66	53.91	53.614	53.825	737000.0
2003-12-05 15:00:00	IWM	ETF	53.795	53.98	53.7	53.755	798800.0
2003-12-05 16:00:00	IWM	ETF	53.777	54.19	53.7	54.19	445200.0
2003-12-05 08:00:00	DIA	ETF	99.25	99.25	98.94	98.98	17700.0
2003-12-05 09:00:00	DIA	ETF	98.98	99.15	98.98	99.07	457600.0
2003-12-05 10:00:00	DIA	ETF	99.13	99.19	98.96	99.05	306200.0
2003-12-05 11:00:00	DIA	ETF	99.03	99.33	98.96	99.15	630600.0
2003-12-05 12:00:00	DIA	ETF	99.13	99.15	98.97	99.11	653200.0
2003-12-05 13:00:00	DIA	ETF	99.13	99.14	98.65	98.72	419100.0
2003-12-05 14:00:00	DIA	ETF	98.72	98.84	98.6	98.78	517600.0
2003-12-05 15:00:00	DIA	ETF	98.74	98.89	98.59	98.76	746200.0
2003-12-05 16:00:00	DIA	ETF	98.78	98.84	98.7	98.825	293900.0
2003-12-05 17:00:00	DIA	ETF	98.83	98.83	98.76	98.76	800.0
2003-12-05 18:00:00	DIA	ETF	98.76	98.76	98.76	98.76	400.0
2003-12-05 09:00:00	TLT	ETF	85.3	85.44	85.16	85.2	109000.0
2003-12-05 10:00:00	TLT	ETF	85.13	85.48	85.12	85.48	85100.0
2003-12-05 11:00:00	TLT	ETF	85.5	85.66	85.4	85.59	76600.0
2003-12-05 12:00:00	TLT	ETF	85.59	85.74	85.55	85.64	26900.0
2003-12-05 13:00:00	TLT	ETF	85.63	86.11	85.63	85.99	169700.0
2003-12-05 14:00:00	TLT	ETF	85.97	86.23	85.87	85.88	194300.0

> showing 50 of 492 rows — these rows as CSV

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