PREVIEW / etf_1hour / 2003-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-20.parquet
  size:    17 KB
  rows:    404

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-05-20 08:00:00	SPY	ETF	92.93	92.93	92.81	92.86	30500.0
2003-05-20 09:00:00	SPY	ETF	92.88	93.01	92.63	92.66	6834000.0
2003-05-20 10:00:00	SPY	ETF	92.7	93.03	92.5	92.8	5274600.0
2003-05-20 11:00:00	SPY	ETF	92.81	92.95	92.38	92.69	5380100.0
2003-05-20 12:00:00	SPY	ETF	92.7	92.94	92.61	92.73	3353800.0
2003-05-20 13:00:00	SPY	ETF	92.72	92.8	92.25	92.53	2737700.0
2003-05-20 14:00:00	SPY	ETF	92.52	92.57	91.72	91.76	9937400.0
2003-05-20 15:00:00	SPY	ETF	91.75	92.6	91.59	92.44	12054000.0
2003-05-20 16:00:00	SPY	ETF	92.44	92.56	92.32	92.47	1497700.0
2003-05-20 17:00:00	SPY	ETF	92.53	92.56	92.45	92.49	80900.0
2003-05-20 18:00:00	SPY	ETF	92.5	92.55	92.43	92.47	11800.0
2003-05-20 19:00:00	SPY	ETF	92.44	92.56	92.44	92.5	2400.0
2003-05-20 08:00:00	QQQ	ETF	27.77	27.8	27.75	27.78	152000.0
2003-05-20 09:00:00	QQQ	ETF	27.77	27.92	27.72	27.79	10415900.0
2003-05-20 10:00:00	QQQ	ETF	27.79	27.96	27.73	27.85	10464200.0
2003-05-20 11:00:00	QQQ	ETF	27.85	27.9	27.7	27.84	5326300.0
2003-05-20 12:00:00	QQQ	ETF	27.82	27.9	27.74	27.8	6874700.0
2003-05-20 13:00:00	QQQ	ETF	27.8	27.82	27.59	27.7	5652100.0
2003-05-20 14:00:00	QQQ	ETF	27.7	27.74	27.43	27.49	8414400.0
2003-05-20 15:00:00	QQQ	ETF	27.43	27.78	27.41	27.7	9195500.0
2003-05-20 16:00:00	QQQ	ETF	27.7	27.85	27.66	27.82	3627200.0
2003-05-20 17:00:00	QQQ	ETF	27.82	27.87	27.77	27.79	880400.0
2003-05-20 18:00:00	QQQ	ETF	27.8	27.85	27.8	27.84	14700.0
2003-05-20 19:00:00	QQQ	ETF	27.85	27.86	27.81	27.85	25600.0
2003-05-20 09:00:00	IWM	ETF	40.87	41.045	40.87	40.96	371600.0
2003-05-20 10:00:00	IWM	ETF	40.975	41.055	40.87	40.885	759600.0
2003-05-20 11:00:00	IWM	ETF	40.855	40.885	40.68	40.76	463800.0
2003-05-20 12:00:00	IWM	ETF	40.76	40.92	40.755	40.875	442600.0
2003-05-20 13:00:00	IWM	ETF	40.86	40.86	40.725	40.785	225200.0
2003-05-20 14:00:00	IWM	ETF	40.8	40.8	40.52	40.575	636400.0
2003-05-20 15:00:00	IWM	ETF	40.535	40.88	40.43	40.78	639200.0
2003-05-20 16:00:00	IWM	ETF	40.755	40.84	40.755	40.825	10800.0
2003-05-20 08:00:00	DIA	ETF	85.38	85.47	85.3	85.4	9100.0
2003-05-20 09:00:00	DIA	ETF	85.45	85.65	85.24	85.31	1838600.0
2003-05-20 10:00:00	DIA	ETF	85.3	85.63	85.1	85.44	1095000.0
2003-05-20 11:00:00	DIA	ETF	85.5	85.53	85.0	85.29	523300.0
2003-05-20 12:00:00	DIA	ETF	85.3	85.48	85.17	85.3	461900.0
2003-05-20 13:00:00	DIA	ETF	85.28	85.32	84.91	85.03	740200.0
2003-05-20 14:00:00	DIA	ETF	85.03	85.06	84.3	84.4	1239800.0
2003-05-20 15:00:00	DIA	ETF	84.38	85.2	84.25	85.04	2360900.0
2003-05-20 16:00:00	DIA	ETF	85.04	85.19	85.02	85.14	219800.0
2003-05-20 17:00:00	DIA	ETF	85.14	85.14	85.12	85.12	5400.0
2003-05-20 18:00:00	DIA	ETF	85.12	85.2	85.12	85.2	1500.0
2003-05-20 19:00:00	DIA	ETF	85.13	85.13	85.1	85.1	2400.0
2003-05-20 09:00:00	TLT	ETF	93.15	93.3	93.12	93.18	76800.0
2003-05-20 10:00:00	TLT	ETF	93.14	93.36	93.12	93.35	38500.0
2003-05-20 11:00:00	TLT	ETF	93.3	93.58	93.25	93.52	42500.0
2003-05-20 12:00:00	TLT	ETF	93.53	93.83	93.52	93.8	32100.0
2003-05-20 13:00:00	TLT	ETF	93.85	94.1	93.85	94.04	66300.0
2003-05-20 14:00:00	TLT	ETF	94.08	94.78	94.06	94.56	157200.0

> showing 50 of 404 rows — these rows as CSV

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