PREVIEW / etf_1hour / 2003-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-29.parquet
  size:    17 KB
  rows:    398

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-29 08:00:00	SPY	ETF	85.05	85.34	85.05	85.2	71100.0
2003-01-29 09:00:00	SPY	ETF	85.2	85.75	84.78	85.1	6290600.0
2003-01-29 10:00:00	SPY	ETF	85.09	85.8	84.92	85.11	7464400.0
2003-01-29 11:00:00	SPY	ETF	85.11	85.78	85.06	85.67	4688700.0
2003-01-29 12:00:00	SPY	ETF	85.66	86.36	85.43	86.19	5899800.0
2003-01-29 13:00:00	SPY	ETF	86.19	86.6	86.06	86.23	5764400.0
2003-01-29 14:00:00	SPY	ETF	86.25	86.77	85.92	86.72	7528100.0
2003-01-29 15:00:00	SPY	ETF	86.7	87.18	86.54	86.75	5926800.0
2003-01-29 16:00:00	SPY	ETF	86.78	86.8	86.42	86.55	1708600.0
2003-01-29 17:00:00	SPY	ETF	86.55	86.55	85.63	86.46	274800.0
2003-01-29 18:00:00	SPY	ETF	86.46	86.5	86.43	86.5	18300.0
2003-01-29 19:00:00	SPY	ETF	86.48	86.55	86.48	86.51	600.0
2003-01-29 08:00:00	QQQ	ETF	24.62	24.75	24.62	24.7	146000.0
2003-01-29 09:00:00	QQQ	ETF	24.7	24.79	24.34	24.56	12731500.0
2003-01-29 10:00:00	QQQ	ETF	24.52	24.76	24.42	24.46	19439400.0
2003-01-29 11:00:00	QQQ	ETF	24.47	24.71	24.43	24.66	6809000.0
2003-01-29 12:00:00	QQQ	ETF	24.67	25.15	24.6	25.03	15348500.0
2003-01-29 13:00:00	QQQ	ETF	25.04	25.2	24.99	25.04	8221900.0
2003-01-29 14:00:00	QQQ	ETF	25.03	25.29	24.91	25.25	9828800.0
2003-01-29 15:00:00	QQQ	ETF	25.26	25.45	25.19	25.29	10888700.0
2003-01-29 16:00:00	QQQ	ETF	25.3	25.34	25.14	25.18	2754600.0
2003-01-29 17:00:00	QQQ	ETF	25.18	25.19	25.08	25.11	388000.0
2003-01-29 18:00:00	QQQ	ETF	25.11	25.16	25.1	25.15	41300.0
2003-01-29 19:00:00	QQQ	ETF	25.15	25.15	25.11	25.14	12100.0
2003-01-29 09:00:00	IWM	ETF	36.77	36.79	36.63	36.74	534200.0
2003-01-29 10:00:00	IWM	ETF	36.705	36.86	36.42	36.45	443200.0
2003-01-29 11:00:00	IWM	ETF	36.49	36.7	36.49	36.695	312200.0
2003-01-29 12:00:00	IWM	ETF	36.685	36.92	36.61	36.87	358200.0
2003-01-29 13:00:00	IWM	ETF	36.88	37.05	36.88	36.955	225800.0
2003-01-29 14:00:00	IWM	ETF	36.95	37.2	36.905	37.2	371600.0
2003-01-29 15:00:00	IWM	ETF	37.2	37.4	37.18	37.28	326000.0
2003-01-29 16:00:00	IWM	ETF	37.23	37.315	37.2	37.205	187200.0
2003-01-29 17:00:00	IWM	ETF	37.32	37.32	37.32	37.32	107200.0
2003-01-29 08:00:00	DIA	ETF	79.92	80.12	79.92	80.08	6000.0
2003-01-29 09:00:00	DIA	ETF	80.08	80.3	79.59	79.84	1376500.0
2003-01-29 10:00:00	DIA	ETF	79.81	80.4	79.52	79.7	1897600.0
2003-01-29 11:00:00	DIA	ETF	79.67	80.33	79.62	80.2	853600.0
2003-01-29 12:00:00	DIA	ETF	80.17	80.9	80.04	80.75	1025700.0
2003-01-29 13:00:00	DIA	ETF	80.71	81.09	80.59	80.77	1230300.0
2003-01-29 14:00:00	DIA	ETF	80.78	81.24	80.51	81.2	2557200.0
2003-01-29 15:00:00	DIA	ETF	81.19	81.72	81.07	81.25	1467900.0
2003-01-29 16:00:00	DIA	ETF	81.32	81.32	81.02	81.11	128300.0
2003-01-29 17:00:00	DIA	ETF	81.11	81.11	80.52	80.9	12000.0
2003-01-29 18:00:00	DIA	ETF	80.95	81.03	80.91	81.03	2100.0
2003-01-29 19:00:00	DIA	ETF	81.0	81.0	81.0	81.0	800.0
2003-01-29 09:00:00	TLT	ETF	87.83	87.88	87.8	87.81	35900.0
2003-01-29 10:00:00	TLT	ETF	87.8	87.87	87.7	87.7	8000.0
2003-01-29 11:00:00	TLT	ETF	87.75	87.75	87.57	87.66	31000.0
2003-01-29 12:00:00	TLT	ETF	87.6	87.6	87.49	87.56	4800.0
2003-01-29 13:00:00	TLT	ETF	87.35	87.51	87.31	87.51	9900.0

> showing 50 of 398 rows — these rows as CSV

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