PREVIEW / etf_1hour / 2003-09-18

all etf 1-hour files

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

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-18 08:00:00	SPY	ETF	103.28	103.57	103.28	103.49	56100.0
2003-09-18 09:00:00	SPY	ETF	103.47	103.602	103.2	103.58	2878100.0
2003-09-18 10:00:00	SPY	ETF	103.58	104.05	103.5	103.99	7235900.0
2003-09-18 11:00:00	SPY	ETF	103.99	104.36	103.92	104.19	4475800.0
2003-09-18 12:00:00	SPY	ETF	104.17	104.33	104.02	104.21	3079100.0
2003-09-18 13:00:00	SPY	ETF	104.23	104.59	104.12	104.5	2464800.0
2003-09-18 14:00:00	SPY	ETF	104.5	104.6	104.35	104.49	2815700.0
2003-09-18 15:00:00	SPY	ETF	104.49	104.7	104.44	104.59	3011100.0
2003-09-18 16:00:00	SPY	ETF	104.56	104.63	104.55	104.57	982100.0
2003-09-18 17:00:00	SPY	ETF	104.6	104.6	104.56	104.58	51500.0
2003-09-18 18:00:00	SPY	ETF	104.58	104.61	104.58	104.58	900.0
2003-09-18 19:00:00	SPY	ETF	104.57	104.57	104.57	104.57	100.0
2003-09-18 08:00:00	QQQ	ETF	34.11	34.21	34.11	34.13	152800.0
2003-09-18 09:00:00	QQQ	ETF	34.12	34.25	34.0	34.23	11581500.0
2003-09-18 10:00:00	QQQ	ETF	34.23	34.47	34.21	34.42	17930600.0
2003-09-18 11:00:00	QQQ	ETF	34.43	34.69	34.36	34.59	14625900.0
2003-09-18 12:00:00	QQQ	ETF	34.61	34.69	34.49	34.601	7138700.0
2003-09-18 13:00:00	QQQ	ETF	34.61	34.781	34.555	34.72	9516800.0
2003-09-18 14:00:00	QQQ	ETF	34.715	34.77	34.6	34.7	6561400.0
2003-09-18 15:00:00	QQQ	ETF	34.7	34.86	34.7	34.779	11804700.0
2003-09-18 16:00:00	QQQ	ETF	34.78	34.81	34.76	34.79	2616700.0
2003-09-18 17:00:00	QQQ	ETF	34.79	34.81	34.75	34.78	67400.0
2003-09-18 18:00:00	QQQ	ETF	34.78	34.81	34.77	34.77	33200.0
2003-09-18 19:00:00	QQQ	ETF	34.8	34.81	34.77	34.81	17200.0
2003-09-18 09:00:00	IWM	ETF	51.33	51.375	51.06	51.24	692400.0
2003-09-18 10:00:00	IWM	ETF	51.245	51.63	51.24	51.53	536000.0
2003-09-18 11:00:00	IWM	ETF	51.53	51.74	51.455	51.645	396400.0
2003-09-18 12:00:00	IWM	ETF	51.575	51.625	51.425	51.56	240400.0
2003-09-18 13:00:00	IWM	ETF	51.55	51.7	51.475	51.66	179000.0
2003-09-18 14:00:00	IWM	ETF	51.67	51.765	51.585	51.72	127200.0
2003-09-18 15:00:00	IWM	ETF	51.72	51.82	51.655	51.82	194200.0
2003-09-18 16:00:00	IWM	ETF	51.85	51.855	51.76	51.76	59200.0
2003-09-18 08:00:00	DIA	ETF	95.86	95.86	95.86	95.86	300.0
2003-09-18 09:00:00	DIA	ETF	96.0	96.04	95.7	96.03	470000.0
2003-09-18 10:00:00	DIA	ETF	96.04	96.39	96.0	96.31	858200.0
2003-09-18 11:00:00	DIA	ETF	96.33	96.69	96.28	96.51	969200.0
2003-09-18 12:00:00	DIA	ETF	96.53	96.6	96.35	96.48	466400.0
2003-09-18 13:00:00	DIA	ETF	96.46	96.85	96.4	96.76	644400.0
2003-09-18 14:00:00	DIA	ETF	96.73	96.85	96.62	96.77	791700.0
2003-09-18 15:00:00	DIA	ETF	96.75	96.94	96.72	96.8	736100.0
2003-09-18 16:00:00	DIA	ETF	96.84	97.0	96.83	96.95	311600.0
2003-09-18 17:00:00	DIA	ETF	96.95	97.0	96.87	96.87	1700.0
2003-09-18 18:00:00	DIA	ETF	96.87	96.87	96.87	96.87	700.0
2003-09-18 19:00:00	DIA	ETF	96.98	97.01	96.98	97.01	800.0
2003-09-18 09:00:00	TLT	ETF	85.65	85.65	85.44	85.5	100500.0
2003-09-18 10:00:00	TLT	ETF	85.5	85.53	85.14	85.14	153800.0
2003-09-18 11:00:00	TLT	ETF	85.14	85.21	84.83	85.12	49500.0
2003-09-18 12:00:00	TLT	ETF	85.12	85.15	84.87	85.15	27900.0
2003-09-18 13:00:00	TLT	ETF	85.2	85.46	85.15	85.21	45900.0
2003-09-18 14:00:00	TLT	ETF	85.27	85.42	85.25	85.32	32500.0

> showing 50 of 438 rows — these rows as CSV

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