PREVIEW / etf_1hour / 2003-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-08.parquet
  size:    16 KB
  rows:    391

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-08 08:00:00	SPY	ETF	92.8	92.91	92.62	92.7	80600.0
2003-05-08 09:00:00	SPY	ETF	92.67	92.78	92.4	92.51	5243400.0
2003-05-08 10:00:00	SPY	ETF	92.52	93.33	92.48	93.14	8524700.0
2003-05-08 11:00:00	SPY	ETF	93.18	93.29	92.88	92.88	3608300.0
2003-05-08 12:00:00	SPY	ETF	92.91	92.96	92.28	92.52	5265300.0
2003-05-08 13:00:00	SPY	ETF	92.53	92.8	92.37	92.4	3591500.0
2003-05-08 14:00:00	SPY	ETF	92.4	92.63	92.31	92.47	2790300.0
2003-05-08 15:00:00	SPY	ETF	92.48	92.69	92.29	92.34	4516700.0
2003-05-08 16:00:00	SPY	ETF	92.34	92.52	92.31	92.4	1325300.0
2003-05-08 17:00:00	SPY	ETF	92.41	92.54	92.37	92.54	64500.0
2003-05-08 18:00:00	SPY	ETF	92.54	92.61	92.46	92.61	167400.0
2003-05-08 19:00:00	SPY	ETF	92.61	92.61	92.54	92.58	5300.0
2003-05-08 08:00:00	QQQ	ETF	28.03	28.04	27.92	27.95	177100.0
2003-05-08 09:00:00	QQQ	ETF	27.95	27.97	27.76	27.85	16434400.0
2003-05-08 10:00:00	QQQ	ETF	27.85	28.16	27.81	28.05	17952000.0
2003-05-08 11:00:00	QQQ	ETF	28.05	28.19	27.97	28.05	6904000.0
2003-05-08 12:00:00	QQQ	ETF	28.06	28.07	27.83	27.92	8077200.0
2003-05-08 13:00:00	QQQ	ETF	27.93	27.99	27.82	27.82	4504100.0
2003-05-08 14:00:00	QQQ	ETF	27.83	27.94	27.8	27.86	3867300.0
2003-05-08 15:00:00	QQQ	ETF	27.86	27.96	27.76	27.82	8370400.0
2003-05-08 16:00:00	QQQ	ETF	27.81	27.85	27.7	27.7	1113300.0
2003-05-08 17:00:00	QQQ	ETF	27.69	27.85	27.68	27.8	918800.0
2003-05-08 18:00:00	QQQ	ETF	27.81	27.85	27.81	27.85	27800.0
2003-05-08 19:00:00	QQQ	ETF	27.85	27.87	27.83	27.85	29100.0
2003-05-08 09:00:00	IWM	ETF	40.69	40.725	40.54	40.635	758400.0
2003-05-08 10:00:00	IWM	ETF	40.56	40.88	40.56	40.825	642400.0
2003-05-08 11:00:00	IWM	ETF	40.825	40.84	40.735	40.76	228800.0
2003-05-08 12:00:00	IWM	ETF	40.75	40.75	40.61	40.7	229800.0
2003-05-08 13:00:00	IWM	ETF	40.665	40.77	40.665	40.68	150800.0
2003-05-08 14:00:00	IWM	ETF	40.67	40.725	40.63	40.65	355400.0
2003-05-08 15:00:00	IWM	ETF	40.645	40.715	40.57	40.625	888000.0
2003-05-08 16:00:00	IWM	ETF	40.625	40.65	40.59	40.65	132600.0
2003-05-08 08:00:00	DIA	ETF	85.19	85.25	85.06	85.16	10500.0
2003-05-08 09:00:00	DIA	ETF	85.16	85.33	84.94	85.13	2037500.0
2003-05-08 10:00:00	DIA	ETF	85.08	85.95	85.03	85.67	1781100.0
2003-05-08 11:00:00	DIA	ETF	85.65	85.79	85.43	85.43	719300.0
2003-05-08 12:00:00	DIA	ETF	85.45	85.48	84.87	85.1	1149700.0
2003-05-08 13:00:00	DIA	ETF	85.1	85.31	84.95	84.97	492700.0
2003-05-08 14:00:00	DIA	ETF	85.0	85.16	84.9	85.03	375100.0
2003-05-08 15:00:00	DIA	ETF	85.03	85.25	84.93	85.02	814400.0
2003-05-08 16:00:00	DIA	ETF	84.99	85.15	84.97	85.09	145500.0
2003-05-08 17:00:00	DIA	ETF	85.18	85.18	85.1	85.12	1300.0
2003-05-08 18:00:00	DIA	ETF	85.14	85.18	85.12	85.18	1900.0
2003-05-08 19:00:00	DIA	ETF	85.18	85.18	85.11	85.11	2400.0
2003-05-08 09:00:00	TLT	ETF	90.6	90.62	90.36	90.5	38700.0
2003-05-08 10:00:00	TLT	ETF	90.47	90.5	90.28	90.41	62600.0
2003-05-08 11:00:00	TLT	ETF	90.42	90.68	90.41	90.68	75100.0
2003-05-08 12:00:00	TLT	ETF	90.7	90.9	90.7	90.81	61200.0
2003-05-08 13:00:00	TLT	ETF	90.82	90.82	90.32	90.77	130100.0
2003-05-08 14:00:00	TLT	ETF	90.85	90.85	90.59	90.6	21000.0

> showing 50 of 391 rows — these rows as CSV

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