PREVIEW / etf_1hour / 2004-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-25.parquet
  size:    24 KB
  rows:    671

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
2004-03-25 08:00:00	SPY	ETF	110.11	110.14	110.03	110.07	76400.0
2004-03-25 09:00:00	SPY	ETF	110.04	110.2	109.95	110.0	4833400.0
2004-03-25 10:00:00	SPY	ETF	110.01	110.26	109.79	110.14	5822800.0
2004-03-25 11:00:00	SPY	ETF	110.16	110.43	110.01	110.35	4260800.0
2004-03-25 12:00:00	SPY	ETF	110.36	110.87	110.31	110.72	5211700.0
2004-03-25 13:00:00	SPY	ETF	110.73	110.98	110.68	110.98	5364200.0
2004-03-25 14:00:00	SPY	ETF	110.97	111.09	110.81	110.91	5683300.0
2004-03-25 15:00:00	SPY	ETF	110.92	111.3	110.87	111.11	5483600.0
2004-03-25 16:00:00	SPY	ETF	111.11	111.19	110.93	111.06	2597300.0
2004-03-25 17:00:00	SPY	ETF	111.01	111.1	111.01	111.1	23600.0
2004-03-25 18:00:00	SPY	ETF	111.06	111.08	111.05	111.08	106500.0
2004-03-25 19:00:00	SPY	ETF	111.06	111.09	111.01	111.03	11500.0
2004-03-25 08:00:00	QQQ	ETF	34.64	34.65	34.58	34.6	475900.0
2004-03-25 09:00:00	QQQ	ETF	34.61	34.85	34.6	34.76	18466600.0
2004-03-25 10:00:00	QQQ	ETF	34.75	34.96	34.663	34.94	18202100.0
2004-03-25 11:00:00	QQQ	ETF	34.95	35.02	34.88	34.99	10166900.0
2004-03-25 12:00:00	QQQ	ETF	34.9877	35.21	34.978	35.12	16068800.0
2004-03-25 13:00:00	QQQ	ETF	35.12	35.3	35.093	35.281	13051800.0
2004-03-25 14:00:00	QQQ	ETF	35.28	35.3	35.16	35.17	14301900.0
2004-03-25 15:00:00	QQQ	ETF	35.18	35.46	35.17	35.41	20178900.0
2004-03-25 16:00:00	QQQ	ETF	35.4	35.44	35.33	35.37	2940700.0
2004-03-25 17:00:00	QQQ	ETF	35.38	35.44	35.37	35.43	537300.0
2004-03-25 18:00:00	QQQ	ETF	35.4	35.42	35.37	35.42	16300.0
2004-03-25 19:00:00	QQQ	ETF	35.42	35.44	35.4	35.43	15900.0
2004-03-25 08:00:00	IWM	ETF	56.13	56.13	56.13	56.13	1000.0
2004-03-25 09:00:00	IWM	ETF	56.14	56.305	56.0	56.225	3179200.0
2004-03-25 10:00:00	IWM	ETF	56.24	56.505	56.13	56.465	1920000.0
2004-03-25 11:00:00	IWM	ETF	56.48	56.6	56.36	56.565	1312400.0
2004-03-25 12:00:00	IWM	ETF	56.57	56.875	56.55	56.735	1196200.0
2004-03-25 13:00:00	IWM	ETF	56.75	56.825	56.71	56.785	1263600.0
2004-03-25 14:00:00	IWM	ETF	56.81	56.87	56.735	56.78	743800.0
2004-03-25 15:00:00	IWM	ETF	56.79	57.095	56.79	57.08	3218000.0
2004-03-25 16:00:00	IWM	ETF	57.1	57.145	57.015	57.015	4451600.0
2004-03-25 08:00:00	DIA	ETF	101.21	101.25	101.13	101.19	15100.0
2004-03-25 09:00:00	DIA	ETF	101.18	101.33	101.13	101.18	898400.0
2004-03-25 10:00:00	DIA	ETF	101.17	101.38	100.99	101.27	895000.0
2004-03-25 11:00:00	DIA	ETF	101.29	101.6	101.22	101.56	886800.0
2004-03-25 12:00:00	DIA	ETF	101.55	101.94	101.52	101.8	798900.0
2004-03-25 13:00:00	DIA	ETF	101.8	102.07	101.77	102.07	833700.0
2004-03-25 14:00:00	DIA	ETF	102.05	102.17	101.94	102.06	641300.0
2004-03-25 15:00:00	DIA	ETF	102.04	102.37	102.01	102.24	1149600.0
2004-03-25 16:00:00	DIA	ETF	102.24	102.28	102.15	102.19	125400.0
2004-03-25 17:00:00	DIA	ETF	102.19	102.19	102.16	102.16	500.0
2004-03-25 18:00:00	DIA	ETF	102.16	102.16	102.16	102.16	100.0
2004-03-25 19:00:00	DIA	ETF	102.15	102.15	102.15	102.15	100.0
2004-03-25 09:00:00	TLT	ETF	90.72	90.8	90.66	90.7	80200.0
2004-03-25 10:00:00	TLT	ETF	90.67	90.8	90.65	90.7	40200.0
2004-03-25 11:00:00	TLT	ETF	90.72	90.79	90.72	90.74	37900.0
2004-03-25 12:00:00	TLT	ETF	90.74	90.87	90.73	90.75	17300.0
2004-03-25 13:00:00	TLT	ETF	90.82	90.94	90.82	90.89	30600.0

> showing 50 of 671 rows — these rows as CSV

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