PREVIEW / etf_1hour / 2003-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-21.parquet
  size:    19 KB
  rows:    473

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-10-21 08:00:00	SPY	ETF	105.08	105.22	104.87	104.88	119900.0
2003-10-21 09:00:00	SPY	ETF	104.91	104.93	104.6	104.89	2852700.0
2003-10-21 10:00:00	SPY	ETF	104.9	105.14	104.655	104.72	3704300.0
2003-10-21 11:00:00	SPY	ETF	104.72	105.03	104.66	104.97	1759700.0
2003-10-21 12:00:00	SPY	ETF	104.99	105.28	104.97	105.19	3661900.0
2003-10-21 13:00:00	SPY	ETF	105.2	105.25	104.97	105.18	2269800.0
2003-10-21 14:00:00	SPY	ETF	105.19	105.27	104.93	105.23	3593400.0
2003-10-21 15:00:00	SPY	ETF	105.21	105.24	104.79	104.96	6095700.0
2003-10-21 16:00:00	SPY	ETF	104.96	105.0	104.68	104.91	1513800.0
2003-10-21 17:00:00	SPY	ETF	104.88	104.89	104.76	104.76	23000.0
2003-10-21 18:00:00	SPY	ETF	104.76	104.78	104.75	104.78	16400.0
2003-10-21 19:00:00	SPY	ETF	104.78	104.78	104.72	104.75	3300.0
2003-10-21 08:00:00	QQQ	ETF	35.24	35.28	35.14	35.15	126100.0
2003-10-21 09:00:00	QQQ	ETF	35.15	35.18	34.939	35.14	13121800.0
2003-10-21 10:00:00	QQQ	ETF	35.14	35.28	35.03	35.12	14125000.0
2003-10-21 11:00:00	QQQ	ETF	35.12	35.35	35.103	35.34	10201600.0
2003-10-21 12:00:00	QQQ	ETF	35.33	35.433	35.31	35.384	6162600.0
2003-10-21 13:00:00	QQQ	ETF	35.39	35.42	35.28	35.39	6592000.0
2003-10-21 14:00:00	QQQ	ETF	35.41	35.45	35.31	35.42	5083600.0
2003-10-21 15:00:00	QQQ	ETF	35.422	35.44	35.25	35.36	12039200.0
2003-10-21 16:00:00	QQQ	ETF	35.35	35.38	35.18	35.28	3818900.0
2003-10-21 17:00:00	QQQ	ETF	35.27	35.299	35.15	35.15	1248000.0
2003-10-21 18:00:00	QQQ	ETF	35.19	35.2	35.14	35.16	363400.0
2003-10-21 19:00:00	QQQ	ETF	35.17	35.17	35.15	35.15	33500.0
2003-10-21 09:00:00	IWM	ETF	51.99	52.22	51.99	52.185	403800.0
2003-10-21 10:00:00	IWM	ETF	52.19	52.46	52.01	52.27	1360200.0
2003-10-21 11:00:00	IWM	ETF	52.235	52.5	52.175	52.495	2545000.0
2003-10-21 12:00:00	IWM	ETF	52.47	52.575	52.38	52.425	1382600.0
2003-10-21 13:00:00	IWM	ETF	52.425	52.475	52.305	52.46	144000.0
2003-10-21 14:00:00	IWM	ETF	52.46	52.48	52.31	52.42	476400.0
2003-10-21 15:00:00	IWM	ETF	52.41	52.445	52.218	52.35	705000.0
2003-10-21 16:00:00	IWM	ETF	52.398	52.418	52.219	52.32	363800.0
2003-10-21 08:00:00	DIA	ETF	98.11	98.11	97.86	97.86	11700.0
2003-10-21 09:00:00	DIA	ETF	97.85	97.88	97.6	97.81	584400.0
2003-10-21 10:00:00	DIA	ETF	97.79	97.97	97.52	97.56	1229700.0
2003-10-21 11:00:00	DIA	ETF	97.59	97.8	97.451	97.74	613200.0
2003-10-21 12:00:00	DIA	ETF	97.76	97.95	97.75	97.83	455300.0
2003-10-21 13:00:00	DIA	ETF	97.84	97.93	97.64	97.88	215800.0
2003-10-21 14:00:00	DIA	ETF	97.88	97.94	97.66	97.87	336400.0
2003-10-21 15:00:00	DIA	ETF	97.86	97.89	97.49	97.65	754600.0
2003-10-21 16:00:00	DIA	ETF	97.65	97.7	97.4	97.6	103800.0
2003-10-21 18:00:00	DIA	ETF	97.3	97.35	97.25	97.3	6000.0
2003-10-21 09:00:00	TLT	ETF	84.03	84.33	83.95	84.12	41500.0
2003-10-21 10:00:00	TLT	ETF	84.11	84.3	84.11	84.21	92700.0
2003-10-21 11:00:00	TLT	ETF	84.19	84.34	84.12	84.2	59400.0
2003-10-21 12:00:00	TLT	ETF	84.23	84.26	84.14	84.26	23200.0
2003-10-21 13:00:00	TLT	ETF	84.29	84.38	84.0	84.0	28600.0
2003-10-21 14:00:00	TLT	ETF	84.05	84.14	83.85	84.0	73200.0
2003-10-21 15:00:00	TLT	ETF	84.0	84.12	83.95	84.1	78500.0
2003-10-21 16:00:00	TLT	ETF	84.12	84.14	84.12	84.13	29000.0

> showing 50 of 473 rows — these rows as CSV

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