PREVIEW / etf_1hour / 2003-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-16.parquet
  size:    17 KB
  rows:    415

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-07-16 08:00:00	SPY	ETF	101.08	101.1	100.86	100.86	86400.0
2003-07-16 09:00:00	SPY	ETF	100.87	100.9	100.17	100.36	5616700.0
2003-07-16 10:00:00	SPY	ETF	100.35	100.36	99.36	99.64	10490500.0
2003-07-16 11:00:00	SPY	ETF	99.64	99.65	99.23	99.42	3422300.0
2003-07-16 12:00:00	SPY	ETF	99.4	99.8	99.36	99.66	3770800.0
2003-07-16 13:00:00	SPY	ETF	99.66	99.83	99.41	99.52	2479600.0
2003-07-16 14:00:00	SPY	ETF	99.51	99.74	99.33	99.68	2707900.0
2003-07-16 15:00:00	SPY	ETF	99.68	99.785	99.3	99.76	4663000.0
2003-07-16 16:00:00	SPY	ETF	99.76	100.02	99.7	99.76	2824100.0
2003-07-16 17:00:00	SPY	ETF	99.76	99.76	99.44	99.44	821200.0
2003-07-16 18:00:00	SPY	ETF	99.44	99.59	99.43	99.59	41200.0
2003-07-16 19:00:00	SPY	ETF	99.64	99.7	99.63	99.65	5300.0
2003-07-16 08:00:00	QQQ	ETF	32.58	32.6	32.45	32.48	132600.0
2003-07-16 09:00:00	QQQ	ETF	32.48	32.5	32.132	32.25	13430100.0
2003-07-16 10:00:00	QQQ	ETF	32.25	32.28	31.78	31.97	18070600.0
2003-07-16 11:00:00	QQQ	ETF	31.96	31.98	31.73	31.908	9240900.0
2003-07-16 12:00:00	QQQ	ETF	31.918	32.13	31.9	32.08	6341400.0
2003-07-16 13:00:00	QQQ	ETF	32.07	32.19	32.0	32.03	6036300.0
2003-07-16 14:00:00	QQQ	ETF	32.02	32.12	31.92	32.072	7004000.0
2003-07-16 15:00:00	QQQ	ETF	32.07	32.15	31.9	32.14	9517400.0
2003-07-16 16:00:00	QQQ	ETF	32.15	32.2147	31.87	32.042	4052900.0
2003-07-16 17:00:00	QQQ	ETF	32.05	32.0662	31.84	31.84	1370900.0
2003-07-16 18:00:00	QQQ	ETF	31.85	31.9	31.83	31.9	508500.0
2003-07-16 19:00:00	QQQ	ETF	31.9	31.93	31.88	31.88	15800.0
2003-07-16 09:00:00	IWM	ETF	47.83	47.87	47.5	47.58	516200.0
2003-07-16 10:00:00	IWM	ETF	47.595	47.595	47.135	47.185	654000.0
2003-07-16 11:00:00	IWM	ETF	47.2	47.245	47.05	47.125	197000.0
2003-07-16 12:00:00	IWM	ETF	47.14	47.375	47.105	47.315	479600.0
2003-07-16 13:00:00	IWM	ETF	47.315	47.35	47.21	47.24	567400.0
2003-07-16 14:00:00	IWM	ETF	47.24	47.29	47.185	47.285	302400.0
2003-07-16 15:00:00	IWM	ETF	47.285	47.29	47.165	47.275	495400.0
2003-07-16 16:00:00	IWM	ETF	47.325	47.325	47.255	47.255	77400.0
2003-07-16 08:00:00	DIA	ETF	92.04	92.06	91.9	91.95	2700.0
2003-07-16 09:00:00	DIA	ETF	91.85	91.89	91.31	91.49	849900.0
2003-07-16 10:00:00	DIA	ETF	91.51	91.51	90.61	90.89	1250000.0
2003-07-16 11:00:00	DIA	ETF	90.87	90.9	90.57	90.77	599900.0
2003-07-16 12:00:00	DIA	ETF	90.8	91.04	90.78	90.94	750000.0
2003-07-16 13:00:00	DIA	ETF	90.94	91.09	90.75	90.85	542700.0
2003-07-16 14:00:00	DIA	ETF	90.84	91.08	90.7	91.01	352400.0
2003-07-16 15:00:00	DIA	ETF	91.01	91.16	90.68	91.13	1329000.0
2003-07-16 16:00:00	DIA	ETF	91.14	91.35	91.07	91.1	234400.0
2003-07-16 17:00:00	DIA	ETF	91.09	91.09	90.9	90.9	7900.0
2003-07-16 18:00:00	DIA	ETF	90.9	90.9	90.9	90.9	200.0
2003-07-16 19:00:00	DIA	ETF	90.95	90.95	90.95	90.95	900.0
2003-07-16 09:00:00	TLT	ETF	87.41	88.72	87.15	87.8	449000.0
2003-07-16 10:00:00	TLT	ETF	87.9	88.0	87.66	87.85	252800.0
2003-07-16 11:00:00	TLT	ETF	87.9	88.0	87.51	87.77	80000.0
2003-07-16 12:00:00	TLT	ETF	87.7	87.74	87.43	87.55	62900.0
2003-07-16 13:00:00	TLT	ETF	87.58	87.6	87.4	87.41	115400.0
2003-07-16 14:00:00	TLT	ETF	87.44	87.95	87.44	87.91	33200.0

> showing 50 of 415 rows — these rows as CSV

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