PREVIEW / etf_1hour / 2003-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-22.parquet
  size:    17 KB
  rows:    416

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-04-22 08:00:00	SPY	ETF	89.34	89.38	89.18	89.29	12700.0
2003-04-22 09:00:00	SPY	ETF	89.22	89.27	88.89	89.14	5026400.0
2003-04-22 10:00:00	SPY	ETF	89.16	90.45	89.04	90.26	10800900.0
2003-04-22 11:00:00	SPY	ETF	90.27	90.43	89.8	90.36	6101800.0
2003-04-22 12:00:00	SPY	ETF	90.4	90.83	90.27	90.72	5765700.0
2003-04-22 13:00:00	SPY	ETF	90.72	91.11	90.69	90.97	4960400.0
2003-04-22 14:00:00	SPY	ETF	91.01	91.48	90.97	91.43	7608700.0
2003-04-22 15:00:00	SPY	ETF	91.43	91.56	91.24	91.51	9173500.0
2003-04-22 16:00:00	SPY	ETF	91.48	91.56	90.7	91.56	3417200.0
2003-04-22 17:00:00	SPY	ETF	91.53	91.58	91.45	91.47	68900.0
2003-04-22 18:00:00	SPY	ETF	91.49	91.55	91.47	91.55	31400.0
2003-04-22 19:00:00	SPY	ETF	91.55	91.6	91.47	91.47	4900.0
2003-04-22 08:00:00	QQQ	ETF	26.8	26.81	26.75	26.8	42600.0
2003-04-22 09:00:00	QQQ	ETF	26.8	26.8	26.65	26.7	7411200.0
2003-04-22 10:00:00	QQQ	ETF	26.72	27.14	26.66	27.06	13901300.0
2003-04-22 11:00:00	QQQ	ETF	27.05	27.13	26.87	27.05	7038100.0
2003-04-22 12:00:00	QQQ	ETF	27.04	27.27	27.01	27.18	7824800.0
2003-04-22 13:00:00	QQQ	ETF	27.18	27.29	27.15	27.22	5781100.0
2003-04-22 14:00:00	QQQ	ETF	27.22	27.44	27.22	27.4	8725200.0
2003-04-22 15:00:00	QQQ	ETF	27.39	27.46	27.32	27.4	8013900.0
2003-04-22 16:00:00	QQQ	ETF	27.39	27.51	27.35	27.46	2264300.0
2003-04-22 17:00:00	QQQ	ETF	27.46	27.51	27.45	27.5	234000.0
2003-04-22 18:00:00	QQQ	ETF	27.51	27.51	27.47	27.5	34800.0
2003-04-22 19:00:00	QQQ	ETF	27.51	27.51	27.47	27.5	25400.0
2003-04-22 09:00:00	IWM	ETF	38.1	38.395	38.1	38.375	192400.0
2003-04-22 10:00:00	IWM	ETF	38.325	38.64	38.27	38.6	488200.0
2003-04-22 11:00:00	IWM	ETF	38.575	38.63	38.465	38.61	268200.0
2003-04-22 12:00:00	IWM	ETF	38.67	38.75	38.615	38.72	175800.0
2003-04-22 13:00:00	IWM	ETF	38.73	38.875	38.73	38.875	146000.0
2003-04-22 14:00:00	IWM	ETF	38.875	39.055	38.875	39.035	316600.0
2003-04-22 15:00:00	IWM	ETF	39.05	39.075	38.925	39.02	95200.0
2003-04-22 16:00:00	IWM	ETF	39.0	39.0	38.965	38.965	24000.0
2003-04-22 08:00:00	DIA	ETF	83.17	83.17	83.12	83.12	9200.0
2003-04-22 09:00:00	DIA	ETF	83.05	83.06	82.71	82.85	917400.0
2003-04-22 10:00:00	DIA	ETF	82.87	83.99	82.76	83.83	1555900.0
2003-04-22 11:00:00	DIA	ETF	83.84	83.9	83.3	83.77	938500.0
2003-04-22 12:00:00	DIA	ETF	83.78	84.23	83.67	84.12	1034900.0
2003-04-22 13:00:00	DIA	ETF	84.11	84.55	84.08	84.49	908600.0
2003-04-22 14:00:00	DIA	ETF	84.5	84.99	84.45	84.9	1299600.0
2003-04-22 15:00:00	DIA	ETF	84.88	85.03	84.72	85.0	1365300.0
2003-04-22 16:00:00	DIA	ETF	84.97	85.02	84.86	85.0	121700.0
2003-04-22 17:00:00	DIA	ETF	85.0	85.05	85.0	85.0	9500.0
2003-04-22 18:00:00	DIA	ETF	85.0	85.09	84.99	85.0	2900.0
2003-04-22 19:00:00	DIA	ETF	84.95	85.12	84.95	85.12	2000.0
2003-04-22 09:00:00	TLT	ETF	88.15	88.26	88.13	88.15	12000.0
2003-04-22 10:00:00	TLT	ETF	88.2	88.2	87.93	87.93	174100.0
2003-04-22 11:00:00	TLT	ETF	87.95	88.1	87.95	87.98	23200.0
2003-04-22 12:00:00	TLT	ETF	87.89	87.96	87.86	87.9	1000.0
2003-04-22 13:00:00	TLT	ETF	87.78	87.8	87.7	87.8	77000.0
2003-04-22 14:00:00	TLT	ETF	87.68	87.77	87.62	87.7	8900.0

> showing 50 of 416 rows — these rows as CSV

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