PREVIEW / etf_1hour / 2003-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-08.parquet
  size:    19 KB
  rows:    502

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-12-08 08:00:00	SPY	ETF	106.65	106.65	106.55	106.63	7300.0
2003-12-08 09:00:00	SPY	ETF	106.64	107.1	106.64	107.03	3596500.0
2003-12-08 10:00:00	SPY	ETF	107.02	107.11	106.79	106.9	4434600.0
2003-12-08 11:00:00	SPY	ETF	106.9	106.99	106.73	106.96	2687400.0
2003-12-08 12:00:00	SPY	ETF	106.96	106.96	106.72	106.85	1683800.0
2003-12-08 13:00:00	SPY	ETF	106.87	107.14	106.78	107.07	3220100.0
2003-12-08 14:00:00	SPY	ETF	107.07	107.16	106.8	107.13	3075500.0
2003-12-08 15:00:00	SPY	ETF	107.13	107.64	107.09	107.52	6198600.0
2003-12-08 16:00:00	SPY	ETF	107.52	107.65	107.49	107.64	4173800.0
2003-12-08 17:00:00	SPY	ETF	107.64	107.7	107.62	107.7	8300.0
2003-12-08 18:00:00	SPY	ETF	107.67	107.7	107.66	107.7	4100.0
2003-12-08 19:00:00	SPY	ETF	107.71	107.71	107.7	107.71	6000.0
2003-12-08 08:00:00	QQQ	ETF	34.96	34.97	34.91	34.94	71700.0
2003-12-08 09:00:00	QQQ	ETF	34.94	35.188	34.94	35.12	10910900.0
2003-12-08 10:00:00	QQQ	ETF	35.118	35.2	34.91	34.95	13910600.0
2003-12-08 11:00:00	QQQ	ETF	34.96	35.01	34.86	34.99	11517700.0
2003-12-08 12:00:00	QQQ	ETF	34.98	34.99	34.835	34.914	6831300.0
2003-12-08 13:00:00	QQQ	ETF	34.92	35.06	34.85	35.003	7669100.0
2003-12-08 14:00:00	QQQ	ETF	35.0	35.01	34.78	34.95	9417500.0
2003-12-08 15:00:00	QQQ	ETF	34.96	35.33	34.951	35.25	18303300.0
2003-12-08 16:00:00	QQQ	ETF	35.25	35.345	35.22	35.281	2944500.0
2003-12-08 17:00:00	QQQ	ETF	35.29	35.304	35.25	35.27	75500.0
2003-12-08 18:00:00	QQQ	ETF	35.27	35.31	35.27	35.31	121300.0
2003-12-08 19:00:00	QQQ	ETF	35.3	35.32	35.3	35.32	24500.0
2003-12-08 09:00:00	IWM	ETF	53.73	54.275	53.7	54.175	718800.0
2003-12-08 10:00:00	IWM	ETF	54.18	54.2	53.655	53.67	1005400.0
2003-12-08 11:00:00	IWM	ETF	53.655	53.73	53.475	53.725	1095600.0
2003-12-08 12:00:00	IWM	ETF	53.72	53.758	53.6	53.705	369400.0
2003-12-08 13:00:00	IWM	ETF	53.7	53.91	53.63	53.85	483000.0
2003-12-08 14:00:00	IWM	ETF	53.845	53.895	53.575	53.7645	408800.0
2003-12-08 15:00:00	IWM	ETF	53.765	54.255	53.76	54.12	1124200.0
2003-12-08 16:00:00	IWM	ETF	54.13	54.2	54.125	54.2	646400.0
2003-12-08 18:00:00	IWM	ETF	54.18	54.18	54.18	54.18	400.0
2003-12-08 08:00:00	DIA	ETF	98.55	98.55	98.55	98.55	200.0
2003-12-08 09:00:00	DIA	ETF	98.59	99.11	98.52	99.05	349800.0
2003-12-08 10:00:00	DIA	ETF	99.06	99.15	98.96	99.09	588100.0
2003-12-08 11:00:00	DIA	ETF	99.09	99.21	98.99	99.11	410200.0
2003-12-08 12:00:00	DIA	ETF	99.13	99.14	99.0	99.12	234000.0
2003-12-08 13:00:00	DIA	ETF	99.11	99.44	99.08	99.38	464200.0
2003-12-08 14:00:00	DIA	ETF	99.37	99.435	99.13	99.38	491500.0
2003-12-08 15:00:00	DIA	ETF	99.43	99.84	99.38	99.78	1897000.0
2003-12-08 16:00:00	DIA	ETF	99.8	99.894	99.75	99.86	545200.0
2003-12-08 17:00:00	DIA	ETF	99.86	99.9	99.82	99.9	2000.0
2003-12-08 19:00:00	DIA	ETF	99.9	99.9	99.9	99.9	100.0
2003-12-08 09:00:00	TLT	ETF	85.78	85.78	85.53	85.56	18900.0
2003-12-08 10:00:00	TLT	ETF	85.55	85.64	85.34	85.34	81300.0
2003-12-08 11:00:00	TLT	ETF	85.3	85.37	85.18	85.25	35000.0
2003-12-08 12:00:00	TLT	ETF	85.32	85.36	85.22	85.22	132000.0
2003-12-08 13:00:00	TLT	ETF	85.26	85.26	85.1	85.1	96400.0
2003-12-08 14:00:00	TLT	ETF	85.09	85.18	85.09	85.16	39500.0

> showing 50 of 502 rows — these rows as CSV

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