PREVIEW / etf_1hour / 2003-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-19.parquet
  size:    17 KB
  rows:    414

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-19 08:00:00	SPY	ETF	94.23	94.33	94.2	94.28	62000.0
2003-05-19 09:00:00	SPY	ETF	94.27	94.42	93.9	93.97	6067200.0
2003-05-19 10:00:00	SPY	ETF	93.95	94.08	93.06	93.2	10571000.0
2003-05-19 11:00:00	SPY	ETF	93.2	93.3	92.78	92.83	3534000.0
2003-05-19 12:00:00	SPY	ETF	92.83	93.03	92.68	92.76	3374500.0
2003-05-19 13:00:00	SPY	ETF	92.81	93.04	92.64	92.67	2346700.0
2003-05-19 14:00:00	SPY	ETF	92.66	92.91	92.5	92.71	3092800.0
2003-05-19 15:00:00	SPY	ETF	92.71	92.85	92.41	92.51	4515500.0
2003-05-19 16:00:00	SPY	ETF	92.5	92.74	92.45	92.69	1646000.0
2003-05-19 17:00:00	SPY	ETF	92.7	92.75	92.63	92.64	43600.0
2003-05-19 18:00:00	SPY	ETF	92.65	92.72	92.61	92.67	6600.0
2003-05-19 19:00:00	SPY	ETF	92.68	92.68	92.5	92.57	4500.0
2003-05-19 08:00:00	QQQ	ETF	28.51	28.53	28.46	28.5	80300.0
2003-05-19 09:00:00	QQQ	ETF	28.49	28.68	28.43	28.47	10923700.0
2003-05-19 10:00:00	QQQ	ETF	28.47	28.55	28.02	28.09	21244400.0
2003-05-19 11:00:00	QQQ	ETF	28.08	28.14	28.0	28.02	8212100.0
2003-05-19 12:00:00	QQQ	ETF	28.01	28.04	27.88	27.95	8609600.0
2003-05-19 13:00:00	QQQ	ETF	27.95	28.03	27.87	27.9	5609300.0
2003-05-19 14:00:00	QQQ	ETF	27.9	28.0	27.8	27.87	7313300.0
2003-05-19 15:00:00	QQQ	ETF	27.85	27.93	27.61	27.7	10743000.0
2003-05-19 16:00:00	QQQ	ETF	27.68	27.79	27.65	27.69	2680800.0
2003-05-19 17:00:00	QQQ	ETF	27.68	27.72	27.65	27.72	279800.0
2003-05-19 18:00:00	QQQ	ETF	27.71	27.71	27.67	27.67	38300.0
2003-05-19 19:00:00	QQQ	ETF	27.68	27.69	27.65	27.65	42400.0
2003-05-19 09:00:00	IWM	ETF	41.3	41.58	41.3	41.385	398600.0
2003-05-19 10:00:00	IWM	ETF	41.355	41.4	41.05	41.075	1155800.0
2003-05-19 11:00:00	IWM	ETF	41.065	41.14	41.0	41.0	495400.0
2003-05-19 12:00:00	IWM	ETF	40.995	41.05	40.85	40.945	256800.0
2003-05-19 13:00:00	IWM	ETF	40.945	41.025	40.875	40.945	264800.0
2003-05-19 14:00:00	IWM	ETF	40.955	40.985	40.825	40.94	363000.0
2003-05-19 15:00:00	IWM	ETF	40.92	40.975	40.765	40.795	495800.0
2003-05-19 16:00:00	IWM	ETF	40.795	40.82	40.79	40.8	62200.0
2003-05-19 08:00:00	DIA	ETF	86.4	86.5	86.37	86.39	10000.0
2003-05-19 09:00:00	DIA	ETF	86.38	86.43	85.97	86.08	1283200.0
2003-05-19 10:00:00	DIA	ETF	86.07	86.14	85.42	85.6	2664800.0
2003-05-19 11:00:00	DIA	ETF	85.56	85.67	85.19	85.19	788000.0
2003-05-19 12:00:00	DIA	ETF	85.21	85.4	85.14	85.2	559900.0
2003-05-19 13:00:00	DIA	ETF	85.21	85.44	85.09	85.12	603700.0
2003-05-19 14:00:00	DIA	ETF	85.13	85.3	84.95	85.15	706200.0
2003-05-19 15:00:00	DIA	ETF	85.15	85.26	84.9	85.02	1490500.0
2003-05-19 16:00:00	DIA	ETF	85.06	85.25	85.04	85.21	122000.0
2003-05-19 17:00:00	DIA	ETF	85.2	85.2	85.17	85.2	2600.0
2003-05-19 18:00:00	DIA	ETF	85.17	85.17	85.15	85.15	2300.0
2003-05-19 19:00:00	DIA	ETF	85.2	85.2	85.05	85.05	900.0
2003-05-19 09:00:00	TLT	ETF	94.11	94.19	93.85	93.9	81200.0
2003-05-19 10:00:00	TLT	ETF	93.94	93.95	93.5	93.59	135600.0
2003-05-19 11:00:00	TLT	ETF	93.6	93.74	93.47	93.66	35400.0
2003-05-19 12:00:00	TLT	ETF	93.69	93.76	93.63	93.68	80500.0
2003-05-19 13:00:00	TLT	ETF	93.62	93.97	93.62	93.95	133700.0
2003-05-19 14:00:00	TLT	ETF	93.9	93.9	93.13	93.29	75100.0

> showing 50 of 414 rows — these rows as CSV

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