PREVIEW / etf_1hour / 2003-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-31.parquet
  size:    16 KB
  rows:    400

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-03-31 08:00:00	SPY	ETF	85.26	85.42	85.11	85.34	121200.0
2003-03-31 09:00:00	SPY	ETF	85.32	85.48	84.7	84.83	6016600.0
2003-03-31 10:00:00	SPY	ETF	84.7	85.21	84.4	85.19	12149500.0
2003-03-31 11:00:00	SPY	ETF	85.16	85.5	84.93	85.4	4327900.0
2003-03-31 12:00:00	SPY	ETF	85.4	85.6	85.26	85.37	4340100.0
2003-03-31 13:00:00	SPY	ETF	85.38	85.52	85.21	85.3	2875700.0
2003-03-31 14:00:00	SPY	ETF	85.3	86.05	85.1	85.88	7330000.0
2003-03-31 15:00:00	SPY	ETF	85.89	85.95	84.95	84.98	9739700.0
2003-03-31 16:00:00	SPY	ETF	84.98	85.05	84.68	84.74	3508300.0
2003-03-31 17:00:00	SPY	ETF	84.73	85.06	84.66	84.8	127300.0
2003-03-31 18:00:00	SPY	ETF	84.78	84.8	84.73	84.75	23200.0
2003-03-31 19:00:00	SPY	ETF	84.79	84.85	84.75	84.8	13200.0
2003-03-31 08:00:00	QQQ	ETF	25.57	25.61	25.54	25.61	102600.0
2003-03-31 09:00:00	QQQ	ETF	25.6	25.62	25.34	25.35	15154300.0
2003-03-31 10:00:00	QQQ	ETF	25.37	25.46	25.21	25.44	16310900.0
2003-03-31 11:00:00	QQQ	ETF	25.44	25.55	25.33	25.49	7074500.0
2003-03-31 12:00:00	QQQ	ETF	25.5	25.57	25.38	25.43	7013800.0
2003-03-31 13:00:00	QQQ	ETF	25.42	25.51	25.36	25.42	2694000.0
2003-03-31 14:00:00	QQQ	ETF	25.43	25.69	25.35	25.61	9930600.0
2003-03-31 15:00:00	QQQ	ETF	25.62	25.66	25.28	25.32	13991400.0
2003-03-31 16:00:00	QQQ	ETF	25.31	25.35	25.11	25.27	5281900.0
2003-03-31 17:00:00	QQQ	ETF	25.27	25.28	25.22	25.24	59800.0
2003-03-31 18:00:00	QQQ	ETF	25.23	25.32	25.23	25.28	23400.0
2003-03-31 19:00:00	QQQ	ETF	25.28	25.32	25.25	25.3	26800.0
2003-03-31 08:00:00	IWM	ETF	36.325	36.365	36.305	36.355	7200.0
2003-03-31 09:00:00	IWM	ETF	36.295	36.34	36.075	36.115	334400.0
2003-03-31 10:00:00	IWM	ETF	36.055	36.255	35.975	36.2	302000.0
2003-03-31 11:00:00	IWM	ETF	36.21	36.355	36.15	36.34	104200.0
2003-03-31 12:00:00	IWM	ETF	36.34	36.36	36.29	36.34	250200.0
2003-03-31 13:00:00	IWM	ETF	36.335	36.395	36.305	36.37	25800.0
2003-03-31 14:00:00	IWM	ETF	36.36	36.655	36.34	36.655	159400.0
2003-03-31 15:00:00	IWM	ETF	36.625	36.625	36.27	36.31	400400.0
2003-03-31 16:00:00	IWM	ETF	36.205	36.31	36.0	36.25	134200.0
2003-03-31 17:00:00	IWM	ETF	36.105	36.105	36.105	36.105	200.0
2003-03-31 08:00:00	DIA	ETF	80.48	80.5	80.3	80.45	16600.0
2003-03-31 09:00:00	DIA	ETF	80.42	80.47	79.62	79.67	2125700.0
2003-03-31 10:00:00	DIA	ETF	79.6	80.06	79.38	80.05	2810700.0
2003-03-31 11:00:00	DIA	ETF	80.05	80.3	79.83	80.23	1682400.0
2003-03-31 12:00:00	DIA	ETF	80.24	80.36	79.99	80.16	962700.0
2003-03-31 13:00:00	DIA	ETF	80.15	80.28	80.02	80.1	436000.0
2003-03-31 14:00:00	DIA	ETF	80.1	80.9	79.9	80.78	2024200.0
2003-03-31 15:00:00	DIA	ETF	80.78	80.83	79.97	80.0	1457600.0
2003-03-31 16:00:00	DIA	ETF	80.0	80.03	79.67	79.75	214200.0
2003-03-31 17:00:00	DIA	ETF	79.79	79.79	79.66	79.77	5100.0
2003-03-31 18:00:00	DIA	ETF	79.87	79.87	79.74	79.78	2100.0
2003-03-31 19:00:00	DIA	ETF	79.79	79.89	79.79	79.89	800.0
2003-03-31 09:00:00	TLT	ETF	88.3	88.6	88.3	88.55	49300.0
2003-03-31 10:00:00	TLT	ETF	88.65	88.79	88.59	88.65	105300.0
2003-03-31 11:00:00	TLT	ETF	88.63	88.75	88.6	88.65	103800.0
2003-03-31 12:00:00	TLT	ETF	88.65	88.73	88.63	88.67	82000.0

> showing 50 of 400 rows — these rows as CSV

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