PREVIEW / etf_1hour / 2003-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-21.parquet
  size:    17 KB
  rows:    409

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-21 08:00:00	SPY	ETF	99.46	99.46	99.34	99.4	27900.0
2003-07-21 09:00:00	SPY	ETF	99.4	99.49	98.9	98.98	3799900.0
2003-07-21 10:00:00	SPY	ETF	99.03	99.07	98.37	98.55	5492100.0
2003-07-21 11:00:00	SPY	ETF	98.56	98.59	98.07	98.1	4074400.0
2003-07-21 12:00:00	SPY	ETF	98.1	98.3	98.02	98.25	3982700.0
2003-07-21 13:00:00	SPY	ETF	98.28	98.36	98.11	98.198	1763100.0
2003-07-21 14:00:00	SPY	ETF	98.2	98.47	97.95	98.0	4154400.0
2003-07-21 15:00:00	SPY	ETF	98.0	98.28	97.85	98.24	5059100.0
2003-07-21 16:00:00	SPY	ETF	98.24	98.41	98.161	98.2	1209300.0
2003-07-21 17:00:00	SPY	ETF	98.3	98.4	98.28	98.4	378400.0
2003-07-21 18:00:00	SPY	ETF	98.37	98.38	98.32	98.32	29100.0
2003-07-21 19:00:00	SPY	ETF	98.32	98.32	98.29	98.29	22900.0
2003-07-21 08:00:00	QQQ	ETF	31.3	31.31	31.23	31.24	69100.0
2003-07-21 09:00:00	QQQ	ETF	31.24	31.3	31.02	31.1	11278700.0
2003-07-21 10:00:00	QQQ	ETF	31.11	31.12	30.7	30.76	19613200.0
2003-07-21 11:00:00	QQQ	ETF	30.76	30.83	30.61	30.67	14748400.0
2003-07-21 12:00:00	QQQ	ETF	30.65	30.81	30.61	30.77	6172600.0
2003-07-21 13:00:00	QQQ	ETF	30.77	30.82	30.719	30.76	4317600.0
2003-07-21 14:00:00	QQQ	ETF	30.76	30.89	30.66	30.72	13432300.0
2003-07-21 15:00:00	QQQ	ETF	30.7	30.87	30.63	30.83	12655200.0
2003-07-21 16:00:00	QQQ	ETF	30.83	30.94	30.69	30.84	3416200.0
2003-07-21 17:00:00	QQQ	ETF	30.85	30.97	30.83	30.931	1656900.0
2003-07-21 18:00:00	QQQ	ETF	30.948	30.95	30.87	30.87	215400.0
2003-07-21 19:00:00	QQQ	ETF	30.87	30.96	30.86	30.91	71500.0
2003-07-21 09:00:00	IWM	ETF	46.055	46.175	46.025	46.04	233800.0
2003-07-21 10:00:00	IWM	ETF	46.04	46.04	45.45	45.52	928600.0
2003-07-21 11:00:00	IWM	ETF	45.49	45.55	45.41	45.52	393600.0
2003-07-21 12:00:00	IWM	ETF	45.52	45.655	45.475	45.605	344000.0
2003-07-21 13:00:00	IWM	ETF	45.65	45.725	45.625	45.675	636400.0
2003-07-21 14:00:00	IWM	ETF	45.66	45.82	45.625	45.675	239400.0
2003-07-21 15:00:00	IWM	ETF	45.65	45.84	45.585	45.585	790200.0
2003-07-21 16:00:00	IWM	ETF	45.6	45.75	45.6	45.6	230200.0
2003-07-21 08:00:00	DIA	ETF	91.77	91.77	91.77	91.77	100.0
2003-07-21 09:00:00	DIA	ETF	91.77	91.88	91.37	91.53	657300.0
2003-07-21 10:00:00	DIA	ETF	91.54	91.559	91.22	91.37	1109300.0
2003-07-21 11:00:00	DIA	ETF	91.36	91.45	90.91	90.93	1849000.0
2003-07-21 12:00:00	DIA	ETF	90.93	91.09	90.8	91.04	899700.0
2003-07-21 13:00:00	DIA	ETF	91.06	91.15	90.93	91.03	462800.0
2003-07-21 14:00:00	DIA	ETF	91.02	91.25	90.86	90.9	1477900.0
2003-07-21 15:00:00	DIA	ETF	90.9	91.17	90.81	91.05	1329000.0
2003-07-21 16:00:00	DIA	ETF	91.08	91.19	91.0	91.0	254600.0
2003-07-21 17:00:00	DIA	ETF	91.12	91.12	91.12	91.12	100.0
2003-07-21 09:00:00	TLT	ETF	87.5	87.52	87.23	87.42	135700.0
2003-07-21 10:00:00	TLT	ETF	87.35	87.6	87.28	87.28	129700.0
2003-07-21 11:00:00	TLT	ETF	87.25	87.26	86.56	86.79	163400.0
2003-07-21 12:00:00	TLT	ETF	86.79	86.92	86.65	86.9	30100.0
2003-07-21 13:00:00	TLT	ETF	86.81	86.93	86.65	86.72	84700.0
2003-07-21 14:00:00	TLT	ETF	86.62	86.65	86.01	86.02	246800.0
2003-07-21 15:00:00	TLT	ETF	86.0	86.15	85.65	85.8	346100.0
2003-07-21 16:00:00	TLT	ETF	85.86	85.86	85.8	85.81	7100.0

> showing 50 of 409 rows — these rows as CSV

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