PREVIEW / etf_1hour / 2003-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-07.parquet
  size:    17 KB
  rows:    402

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-08-07 08:00:00	SPY	ETF	96.87	97.11	96.8	96.93	117500.0
2003-08-07 09:00:00	SPY	ETF	96.96	97.351	96.758	97.32	5042900.0
2003-08-07 10:00:00	SPY	ETF	97.31	97.494	96.828	97.29	5859800.0
2003-08-07 11:00:00	SPY	ETF	97.3	97.8	97.22	97.68	4046800.0
2003-08-07 12:00:00	SPY	ETF	97.68	97.74	97.37	97.57	2566100.0
2003-08-07 13:00:00	SPY	ETF	97.57	97.93	97.5	97.82	5153600.0
2003-08-07 14:00:00	SPY	ETF	97.8	97.91	97.4	97.54	3206800.0
2003-08-07 15:00:00	SPY	ETF	97.541	97.978	97.46	97.89	4967100.0
2003-08-07 16:00:00	SPY	ETF	97.88	98.1	97.81	97.97	2820400.0
2003-08-07 17:00:00	SPY	ETF	97.97	97.97	97.66	97.95	148200.0
2003-08-07 18:00:00	SPY	ETF	97.95	98.0	97.92	97.92	18500.0
2003-08-07 19:00:00	SPY	ETF	97.96	98.05	97.95	97.95	1500.0
2003-08-07 08:00:00	QQQ	ETF	30.14	30.19	30.1	30.16	141600.0
2003-08-07 09:00:00	QQQ	ETF	30.16	30.37	30.1	30.23	10010100.0
2003-08-07 10:00:00	QQQ	ETF	30.24	30.3	30.03	30.21	12834300.0
2003-08-07 11:00:00	QQQ	ETF	30.22	30.5	30.16	30.42	8007700.0
2003-08-07 12:00:00	QQQ	ETF	30.42	30.48	30.27	30.36	4546200.0
2003-08-07 13:00:00	QQQ	ETF	30.36	30.46	30.26	30.39	6767600.0
2003-08-07 14:00:00	QQQ	ETF	30.4	30.422	30.11	30.19	6425600.0
2003-08-07 15:00:00	QQQ	ETF	30.189	30.34	30.15	30.29	7466200.0
2003-08-07 16:00:00	QQQ	ETF	30.3	30.35	30.26	30.29	2317500.0
2003-08-07 17:00:00	QQQ	ETF	30.3	30.3	30.27	30.3	54100.0
2003-08-07 18:00:00	QQQ	ETF	30.29	30.32	30.28	30.29	13000.0
2003-08-07 19:00:00	QQQ	ETF	30.31	30.32	30.3	30.3	4600.0
2003-08-07 09:00:00	IWM	ETF	45.255	45.3	45.05	45.175	296400.0
2003-08-07 10:00:00	IWM	ETF	45.295	45.295	44.815	44.98	846200.0
2003-08-07 11:00:00	IWM	ETF	44.999	45.325	44.98	45.215	355400.0
2003-08-07 12:00:00	IWM	ETF	45.26	45.26	45.075	45.125	285400.0
2003-08-07 13:00:00	IWM	ETF	45.125	45.205	45.09	45.14	659600.0
2003-08-07 14:00:00	IWM	ETF	45.145	45.2	44.98	45.0	539000.0
2003-08-07 15:00:00	IWM	ETF	45.0	45.285	45.0	45.28	567200.0
2003-08-07 16:00:00	IWM	ETF	45.28	45.36	45.26	45.36	115400.0
2003-08-07 08:00:00	DIA	ETF	90.5	90.72	90.5	90.63	15100.0
2003-08-07 09:00:00	DIA	ETF	90.69	91.0	90.43	90.989	813800.0
2003-08-07 10:00:00	DIA	ETF	90.95	91.175	90.61	91.04	1413900.0
2003-08-07 11:00:00	DIA	ETF	91.0	91.33	90.87	91.19	577600.0
2003-08-07 12:00:00	DIA	ETF	91.28	91.28	90.89	91.06	367400.0
2003-08-07 13:00:00	DIA	ETF	91.03	91.324	90.93	91.25	863500.0
2003-08-07 14:00:00	DIA	ETF	91.24	91.32	91.0	91.11	423000.0
2003-08-07 15:00:00	DIA	ETF	91.1	91.51	91.04	91.43	817600.0
2003-08-07 16:00:00	DIA	ETF	91.38	91.6	91.36	91.54	103900.0
2003-08-07 17:00:00	DIA	ETF	91.53	91.56	91.53	91.53	1400.0
2003-08-07 18:00:00	DIA	ETF	91.54	91.54	91.54	91.54	400.0
2003-08-07 19:00:00	DIA	ETF	91.54	91.54	91.53	91.53	500.0
2003-08-07 09:00:00	TLT	ETF	83.8	83.99	83.8	83.99	336600.0
2003-08-07 10:00:00	TLT	ETF	84.0	84.0	83.61	83.73	465200.0
2003-08-07 11:00:00	TLT	ETF	83.74	83.77	83.34	83.44	146000.0
2003-08-07 12:00:00	TLT	ETF	83.44	83.46	83.24	83.39	122100.0
2003-08-07 13:00:00	TLT	ETF	83.4	83.74	83.14	83.4	264400.0
2003-08-07 14:00:00	TLT	ETF	83.4	83.9	83.38	83.85	149100.0

> showing 50 of 402 rows — these rows as CSV

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