PREVIEW / etf_1hour / 2003-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-06.parquet
  size:    18 KB
  rows:    444

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-06-06 08:00:00	SPY	ETF	100.11	100.48	100.1	100.45	97100.0
2003-06-06 09:00:00	SPY	ETF	100.47	101.14	100.27	101.06	9477400.0
2003-06-06 10:00:00	SPY	ETF	101.07	101.4	100.75	100.9	11469100.0
2003-06-06 11:00:00	SPY	ETF	100.89	100.94	100.13	100.48	7920200.0
2003-06-06 12:00:00	SPY	ETF	100.47	100.54	99.65	99.71	4677000.0
2003-06-06 13:00:00	SPY	ETF	99.65	100.19	99.45	100.1	5273600.0
2003-06-06 14:00:00	SPY	ETF	100.11	100.38	99.63	99.73	4772700.0
2003-06-06 15:00:00	SPY	ETF	99.72	99.86	99.15	99.22	7242200.0
2003-06-06 16:00:00	SPY	ETF	99.22	101.06	99.2	99.34	3462000.0
2003-06-06 17:00:00	SPY	ETF	99.35	99.37	99.1	99.3	163800.0
2003-06-06 18:00:00	SPY	ETF	99.3	99.34	99.15	99.3	8700.0
2003-06-06 19:00:00	SPY	ETF	99.4	99.41	99.18	99.18	2700.0
2003-06-06 08:00:00	QQQ	ETF	30.98	31.26	30.91	31.25	377700.0
2003-06-06 09:00:00	QQQ	ETF	31.26	31.43	31.12	31.4	18747000.0
2003-06-06 10:00:00	QQQ	ETF	31.39	31.47	31.25	31.31	13630000.0
2003-06-06 11:00:00	QQQ	ETF	31.31	31.34	30.78	30.92	21055700.0
2003-06-06 12:00:00	QQQ	ETF	30.92	30.94	30.4	30.45	17145000.0
2003-06-06 13:00:00	QQQ	ETF	30.44	30.78	30.29	30.71	13385600.0
2003-06-06 14:00:00	QQQ	ETF	30.72	30.83	30.35	30.39	10754100.0
2003-06-06 15:00:00	QQQ	ETF	30.39	30.45	30.07	30.14	24855600.0
2003-06-06 16:00:00	QQQ	ETF	30.1	30.19	30.02	30.15	23294900.0
2003-06-06 17:00:00	QQQ	ETF	30.14	30.17	30.08	30.11	305000.0
2003-06-06 18:00:00	QQQ	ETF	30.1	30.14	30.08	30.11	22700.0
2003-06-06 19:00:00	QQQ	ETF	30.09	30.15	30.08	30.11	12500.0
2003-06-06 09:00:00	IWM	ETF	46.2	46.495	46.115	46.495	421600.0
2003-06-06 10:00:00	IWM	ETF	46.425	46.54	46.265	46.27	314000.0
2003-06-06 11:00:00	IWM	ETF	46.285	46.285	45.805	45.88	782600.0
2003-06-06 12:00:00	IWM	ETF	45.88	45.88	45.425	45.47	342000.0
2003-06-06 13:00:00	IWM	ETF	45.46	45.68	45.39	45.68	370600.0
2003-06-06 14:00:00	IWM	ETF	45.69	45.825	45.575	45.62	414000.0
2003-06-06 15:00:00	IWM	ETF	45.61	45.645	45.21	45.27	809400.0
2003-06-06 16:00:00	IWM	ETF	45.275	45.28	45.2	45.2	22000.0
2003-06-06 17:00:00	IWM	ETF	44.85	44.85	44.85	44.85	400.0
2003-06-06 08:00:00	DIA	ETF	91.15	91.51	91.12	91.5	27400.0
2003-06-06 09:00:00	DIA	ETF	91.49	92.1	91.35	92.09	1701000.0
2003-06-06 10:00:00	DIA	ETF	92.07	92.49	91.93	92.12	1741200.0
2003-06-06 11:00:00	DIA	ETF	92.11	92.13	91.5	91.94	1504000.0
2003-06-06 12:00:00	DIA	ETF	91.89	91.94	91.26	91.26	1052200.0
2003-06-06 13:00:00	DIA	ETF	91.26	91.68	91.08	91.57	909300.0
2003-06-06 14:00:00	DIA	ETF	91.6	91.85	91.21	91.23	885600.0
2003-06-06 15:00:00	DIA	ETF	91.22	91.35	90.74	90.88	1396200.0
2003-06-06 16:00:00	DIA	ETF	90.88	90.93	90.8	90.8	340400.0
2003-06-06 17:00:00	DIA	ETF	90.83	90.83	90.83	90.83	300.0
2003-06-06 18:00:00	DIA	ETF	90.86	90.86	90.82	90.84	1900.0
2003-06-06 19:00:00	DIA	ETF	90.78	90.78	90.78	90.78	100.0
2003-06-06 09:00:00	TLT	ETF	93.7	93.9	93.56	93.8	27000.0
2003-06-06 10:00:00	TLT	ETF	93.7	93.8	93.38	93.58	127400.0
2003-06-06 11:00:00	TLT	ETF	93.55	94.1	93.55	94.1	55900.0
2003-06-06 12:00:00	TLT	ETF	94.06	94.15	93.9	93.9	7500.0
2003-06-06 13:00:00	TLT	ETF	93.98	94.05	93.98	94.0	20900.0

> showing 50 of 444 rows — these rows as CSV

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