PREVIEW / etf_1hour / 2003-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-26.parquet
  size:    17 KB
  rows:    413

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-26 08:00:00	SPY	ETF	97.85	97.86	97.71	97.72	83700.0
2003-06-26 09:00:00	SPY	ETF	97.7	98.06	97.6	98.03	5211500.0
2003-06-26 10:00:00	SPY	ETF	98.01	98.244	97.61	98.1	6886500.0
2003-06-26 11:00:00	SPY	ETF	98.078	98.6	97.954	98.59	3489800.0
2003-06-26 12:00:00	SPY	ETF	98.6	98.68	98.344	98.42	3171400.0
2003-06-26 13:00:00	SPY	ETF	98.44	98.67	98.41	98.49	1732200.0
2003-06-26 14:00:00	SPY	ETF	98.533	98.979	98.53	98.787	3688200.0
2003-06-26 15:00:00	SPY	ETF	98.784	98.9	98.52	98.87	2931900.0
2003-06-26 16:00:00	SPY	ETF	98.89	99.02	98.02	98.81	1512600.0
2003-06-26 17:00:00	SPY	ETF	98.877	98.877	98.78	98.83	68500.0
2003-06-26 18:00:00	SPY	ETF	98.87	98.89	98.83	98.89	8400.0
2003-06-26 19:00:00	SPY	ETF	98.91	98.94	98.88	98.94	8300.0
2003-06-26 08:00:00	QQQ	ETF	29.63	29.68	29.62	29.63	123200.0
2003-06-26 09:00:00	QQQ	ETF	29.62	29.95	29.6	29.87	12195800.0
2003-06-26 10:00:00	QQQ	ETF	29.9	29.97	29.7	29.85	14302500.0
2003-06-26 11:00:00	QQQ	ETF	29.87	30.118	29.81	30.118	10187300.0
2003-06-26 12:00:00	QQQ	ETF	30.1	30.17	30.02	30.07	8652000.0
2003-06-26 13:00:00	QQQ	ETF	30.07	30.14	30.04	30.09	4248400.0
2003-06-26 14:00:00	QQQ	ETF	30.087	30.28	30.08	30.18	8867800.0
2003-06-26 15:00:00	QQQ	ETF	30.18	30.28	30.01	30.21	10348200.0
2003-06-26 16:00:00	QQQ	ETF	30.21	30.26	30.17	30.23	2092500.0
2003-06-26 17:00:00	QQQ	ETF	30.232	30.25	30.203	30.23	126300.0
2003-06-26 18:00:00	QQQ	ETF	30.25	30.26	30.22	30.25	25800.0
2003-06-26 19:00:00	QQQ	ETF	30.26	30.28	30.25	30.26	26300.0
2003-06-26 09:00:00	IWM	ETF	44.22	44.43	44.2	44.425	915000.0
2003-06-26 10:00:00	IWM	ETF	44.425	44.5	44.25	44.34	929000.0
2003-06-26 11:00:00	IWM	ETF	44.415	44.67	44.355	44.65	554200.0
2003-06-26 12:00:00	IWM	ETF	44.665	44.71	44.58	44.66	1090400.0
2003-06-26 13:00:00	IWM	ETF	44.66	44.72	44.62	44.655	492800.0
2003-06-26 14:00:00	IWM	ETF	44.675	44.825	44.675	44.72	455800.0
2003-06-26 15:00:00	IWM	ETF	44.735	44.97	44.655	44.97	1217800.0
2003-06-26 16:00:00	IWM	ETF	44.96	44.96	44.86	44.865	92600.0
2003-06-26 08:00:00	DIA	ETF	90.28	90.4	90.27	90.27	19300.0
2003-06-26 09:00:00	DIA	ETF	90.18	90.48	90.05	90.35	1144300.0
2003-06-26 10:00:00	DIA	ETF	90.32	90.61	90.02	90.41	1559300.0
2003-06-26 11:00:00	DIA	ETF	90.37	90.84	90.29	90.8	694000.0
2003-06-26 12:00:00	DIA	ETF	90.82	90.88	90.6	90.65	645400.0
2003-06-26 13:00:00	DIA	ETF	90.69	90.84	90.63	90.67	318700.0
2003-06-26 14:00:00	DIA	ETF	90.72	91.11	90.72	90.89	901200.0
2003-06-26 15:00:00	DIA	ETF	90.9	90.99	90.65	90.92	1049000.0
2003-06-26 16:00:00	DIA	ETF	90.9	90.94	90.72	90.86	107300.0
2003-06-26 17:00:00	DIA	ETF	90.84	90.88	90.76	90.88	1700.0
2003-06-26 18:00:00	DIA	ETF	90.9	90.9	90.9	90.9	600.0
2003-06-26 09:00:00	TLT	ETF	93.25	93.25	92.9	92.96	210300.0
2003-06-26 10:00:00	TLT	ETF	92.95	93.07	92.63	92.8	332300.0
2003-06-26 11:00:00	TLT	ETF	92.81	92.97	92.62	92.7	139200.0
2003-06-26 12:00:00	TLT	ETF	92.69	92.86	92.43	92.56	128100.0
2003-06-26 13:00:00	TLT	ETF	92.607	92.607	92.34	92.38	21300.0
2003-06-26 14:00:00	TLT	ETF	92.44	92.44	92.12	92.25	281700.0
2003-06-26 15:00:00	TLT	ETF	92.23	92.42	92.2	92.42	154000.0

> showing 50 of 413 rows — these rows as CSV

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