PREVIEW / etf_1hour / 2003-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-05.parquet
  size:    18 KB
  rows:    465

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-11-05 08:00:00	SPY	ETF	105.51	105.56	105.5	105.51	11400.0
2003-11-05 09:00:00	SPY	ETF	105.53	105.93	105.45	105.88	2655900.0
2003-11-05 10:00:00	SPY	ETF	105.87	105.96	104.9	105.0	7937700.0
2003-11-05 11:00:00	SPY	ETF	105.0	105.2	104.98	105.19	2618300.0
2003-11-05 12:00:00	SPY	ETF	105.19	105.31	105.06	105.22	2644000.0
2003-11-05 13:00:00	SPY	ETF	105.23	105.29	105.03	105.08	1913600.0
2003-11-05 14:00:00	SPY	ETF	105.08	105.41	105.04	105.35	2174500.0
2003-11-05 15:00:00	SPY	ETF	105.35	105.83	105.24	105.63	4947200.0
2003-11-05 16:00:00	SPY	ETF	105.64	106.1	105.52	105.83	2564900.0
2003-11-05 17:00:00	SPY	ETF	105.88	105.95	105.74	105.94	78800.0
2003-11-05 18:00:00	SPY	ETF	105.88	105.98	105.88	105.98	7800.0
2003-11-05 19:00:00	SPY	ETF	105.94	105.94	105.89	105.89	23100.0
2003-11-05 08:00:00	QQQ	ETF	35.45	35.5	35.43	35.47	77600.0
2003-11-05 09:00:00	QQQ	ETF	35.48	35.727	35.47	35.67	6212400.0
2003-11-05 10:00:00	QQQ	ETF	35.7	35.729	35.15	35.23	15743300.0
2003-11-05 11:00:00	QQQ	ETF	35.235	35.38	35.22	35.34	6732100.0
2003-11-05 12:00:00	QQQ	ETF	35.345	35.4	35.28	35.36	2692000.0
2003-11-05 13:00:00	QQQ	ETF	35.34	35.39	35.27	35.31	3653100.0
2003-11-05 14:00:00	QQQ	ETF	35.31	35.52	35.29	35.47	6122000.0
2003-11-05 15:00:00	QQQ	ETF	35.46	35.77	35.42	35.64	11033400.0
2003-11-05 16:00:00	QQQ	ETF	35.65	35.92	35.598	35.76	7602500.0
2003-11-05 17:00:00	QQQ	ETF	35.77	35.89	35.67	35.89	1054000.0
2003-11-05 18:00:00	QQQ	ETF	35.87	35.96	35.821	35.92	627100.0
2003-11-05 19:00:00	QQQ	ETF	35.94	35.94	35.81	35.85	63500.0
2003-11-05 08:00:00	IWM	ETF	53.605	53.605	53.605	53.605	200.0
2003-11-05 09:00:00	IWM	ETF	53.675	53.775	53.545	53.775	501200.0
2003-11-05 10:00:00	IWM	ETF	53.755	53.81	53.032	53.175	2271200.0
2003-11-05 11:00:00	IWM	ETF	53.1735	53.8	53.16	53.57	1203600.0
2003-11-05 12:00:00	IWM	ETF	53.56	53.57	53.385	53.445	360400.0
2003-11-05 13:00:00	IWM	ETF	53.445	53.535	53.4	53.425	370000.0
2003-11-05 14:00:00	IWM	ETF	53.445	53.66	53.445	53.605	857400.0
2003-11-05 15:00:00	IWM	ETF	53.605	53.875	53.55	53.74	1249800.0
2003-11-05 16:00:00	IWM	ETF	53.764	54.385	53.713	54.0	679800.0
2003-11-05 08:00:00	DIA	ETF	98.41	98.41	98.25	98.27	4300.0
2003-11-05 09:00:00	DIA	ETF	98.4	98.81	98.26	98.729	304600.0
2003-11-05 10:00:00	DIA	ETF	98.726	98.8	98.02	98.1	1189800.0
2003-11-05 11:00:00	DIA	ETF	98.12	98.25	98.05	98.2	438000.0
2003-11-05 12:00:00	DIA	ETF	98.22	98.24	98.09	98.18	193900.0
2003-11-05 13:00:00	DIA	ETF	98.2	98.24	97.98	98.0	428400.0
2003-11-05 14:00:00	DIA	ETF	98.05	98.18	97.99	98.15	413600.0
2003-11-05 15:00:00	DIA	ETF	98.14	98.57	98.0	98.41	690200.0
2003-11-05 16:00:00	DIA	ETF	98.41	98.64	98.29	98.56	161200.0
2003-11-05 17:00:00	DIA	ETF	98.5	98.56	98.45	98.56	3500.0
2003-11-05 18:00:00	DIA	ETF	98.6	98.6	98.6	98.6	1900.0
2003-11-05 19:00:00	DIA	ETF	98.52	98.52	98.52	98.52	200.0
2003-11-05 09:00:00	TLT	ETF	84.82	84.82	84.45	84.49	33800.0
2003-11-05 10:00:00	TLT	ETF	84.29	84.72	84.29	84.66	5100.0
2003-11-05 11:00:00	TLT	ETF	84.69	84.69	84.54	84.55	31600.0
2003-11-05 12:00:00	TLT	ETF	84.51	84.66	84.49	84.66	8600.0
2003-11-05 13:00:00	TLT	ETF	84.56	84.59	84.55	84.55	1700.0

> showing 50 of 465 rows — these rows as CSV

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