PREVIEW / etf_1hour / 2003-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-03.parquet
  size:    15 KB
  rows:    373

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-01-03 08:00:00	SPY	ETF	91.13	91.2	90.97	90.97	35800.0
2003-01-03 09:00:00	SPY	ETF	90.98	91.08	90.66	90.98	4452500.0
2003-01-03 10:00:00	SPY	ETF	90.99	91.38	90.66	90.81	6791700.0
2003-01-03 11:00:00	SPY	ETF	90.79	90.95	90.61	90.83	3427800.0
2003-01-03 12:00:00	SPY	ETF	90.86	90.88	90.6	90.8	2380300.0
2003-01-03 13:00:00	SPY	ETF	90.8	91.2	90.72	91.01	2235400.0
2003-01-03 14:00:00	SPY	ETF	91.03	91.03	90.53	90.67	3233800.0
2003-01-03 15:00:00	SPY	ETF	90.65	91.11	90.5	91.11	3972700.0
2003-01-03 16:00:00	SPY	ETF	91.1	91.42	91.05	91.42	2501100.0
2003-01-03 17:00:00	SPY	ETF	91.38	91.4	91.09	91.4	82000.0
2003-01-03 18:00:00	SPY	ETF	91.38	91.39	91.29	91.29	2200.0
2003-01-03 19:00:00	SPY	ETF	91.29	91.41	91.29	91.41	1500.0
2003-01-03 08:00:00	QQQ	ETF	25.4	25.57	25.4	25.45	41400.0
2003-01-03 09:00:00	QQQ	ETF	25.46	25.54	25.28	25.53	7801200.0
2003-01-03 10:00:00	QQQ	ETF	25.52	25.7	25.36	25.44	9291400.0
2003-01-03 11:00:00	QQQ	ETF	25.43	25.5	25.33	25.49	2789500.0
2003-01-03 12:00:00	QQQ	ETF	25.47	25.48	25.34	25.45	2079800.0
2003-01-03 13:00:00	QQQ	ETF	25.46	25.64	25.43	25.58	3283800.0
2003-01-03 14:00:00	QQQ	ETF	25.59	25.6	25.35	25.44	3803300.0
2003-01-03 15:00:00	QQQ	ETF	25.44	25.65	25.37	25.61	5186600.0
2003-01-03 16:00:00	QQQ	ETF	25.63	25.8	25.59	25.78	1382300.0
2003-01-03 17:00:00	QQQ	ETF	25.77	25.78	25.73	25.75	36500.0
2003-01-03 18:00:00	QQQ	ETF	25.76	25.79	25.72	25.78	23200.0
2003-01-03 19:00:00	QQQ	ETF	25.78	25.86	25.78	25.86	16100.0
2003-01-03 09:00:00	IWM	ETF	39.0	39.0	38.72	38.88	449600.0
2003-01-03 10:00:00	IWM	ETF	38.92	39.05	38.665	38.775	680000.0
2003-01-03 11:00:00	IWM	ETF	38.8	38.875	38.735	38.835	92400.0
2003-01-03 12:00:00	IWM	ETF	38.8	38.84	38.725	38.815	227400.0
2003-01-03 13:00:00	IWM	ETF	38.815	38.99	38.78	38.95	127000.0
2003-01-03 14:00:00	IWM	ETF	38.975	38.975	38.76	38.79	476200.0
2003-01-03 15:00:00	IWM	ETF	38.78	38.945	38.75	38.85	561600.0
2003-01-03 16:00:00	IWM	ETF	38.875	39.03	38.855	38.885	171400.0
2003-01-03 17:00:00	IWM	ETF	38.835	38.835	38.835	38.835	205000.0
2003-01-03 08:00:00	DIA	ETF	86.13	86.13	85.98	86.06	5700.0
2003-01-03 09:00:00	DIA	ETF	86.05	86.28	85.8	86.1	837100.0
2003-01-03 10:00:00	DIA	ETF	86.14	86.54	85.82	86.0	1285600.0
2003-01-03 11:00:00	DIA	ETF	85.98	86.14	85.8	86.08	475500.0
2003-01-03 12:00:00	DIA	ETF	86.05	86.1	85.8	85.98	302000.0
2003-01-03 13:00:00	DIA	ETF	85.96	86.29	85.88	86.13	308400.0
2003-01-03 14:00:00	DIA	ETF	86.12	86.15	85.62	85.79	458400.0
2003-01-03 15:00:00	DIA	ETF	85.79	86.22	85.63	86.19	493700.0
2003-01-03 16:00:00	DIA	ETF	86.18	86.38	86.1	86.38	98900.0
2003-01-03 18:00:00	DIA	ETF	86.28	86.28	86.08	86.08	3500.0
2003-01-03 19:00:00	DIA	ETF	86.12	86.28	86.12	86.28	2500.0
2003-01-03 09:00:00	TLT	ETF	86.15	86.15	86.0	86.0	10800.0
2003-01-03 10:00:00	TLT	ETF	85.83	86.27	85.83	86.25	247700.0
2003-01-03 11:00:00	TLT	ETF	86.28	86.32	86.15	86.21	12800.0
2003-01-03 12:00:00	TLT	ETF	86.18	86.45	86.18	86.45	1600.0
2003-01-03 13:00:00	TLT	ETF	86.35	86.41	86.27	86.27	900.0
2003-01-03 14:00:00	TLT	ETF	86.41	86.44	86.41	86.44	800.0

> showing 50 of 373 rows — these rows as CSV

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