PREVIEW / etf_1hour / 2003-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-28.parquet
  size:    17 KB
  rows:    420

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-08-28 08:00:00	SPY	ETF	100.25	100.4	100.18	100.37	43100.0
2003-08-28 09:00:00	SPY	ETF	100.36	100.57	100.35	100.39	2250000.0
2003-08-28 10:00:00	SPY	ETF	100.38	100.43	99.66	99.84	8117700.0
2003-08-28 11:00:00	SPY	ETF	99.85	100.25	99.76	100.23	3149500.0
2003-08-28 12:00:00	SPY	ETF	100.22	100.47	100.15	100.37	2416200.0
2003-08-28 13:00:00	SPY	ETF	100.364	100.39	100.08	100.25	1878500.0
2003-08-28 14:00:00	SPY	ETF	100.27	100.39	100.17	100.36	1405100.0
2003-08-28 15:00:00	SPY	ETF	100.37	101.0	100.32	100.84	5184000.0
2003-08-28 16:00:00	SPY	ETF	100.85	100.85	100.649	100.67	1326100.0
2003-08-28 17:00:00	SPY	ETF	100.4714	100.757	100.4714	100.75	164900.0
2003-08-28 18:00:00	SPY	ETF	100.75	100.76	100.7	100.7	5700.0
2003-08-28 19:00:00	SPY	ETF	100.75	100.77	100.75	100.77	900.0
2003-08-28 08:00:00	QQQ	ETF	32.84	33.0	32.84	32.92	152800.0
2003-08-28 09:00:00	QQQ	ETF	32.92	32.984	32.81	32.87	6534000.0
2003-08-28 10:00:00	QQQ	ETF	32.88	32.89	32.522	32.59	10881900.0
2003-08-28 11:00:00	QQQ	ETF	32.59	32.88	32.55	32.85	5775500.0
2003-08-28 12:00:00	QQQ	ETF	32.86	32.95	32.8	32.864	5754100.0
2003-08-28 13:00:00	QQQ	ETF	32.87	32.94	32.78	32.87	3367700.0
2003-08-28 14:00:00	QQQ	ETF	32.86	32.94	32.79	32.93	3637000.0
2003-08-28 15:00:00	QQQ	ETF	32.94	33.11	32.89	33.09	13894500.0
2003-08-28 16:00:00	QQQ	ETF	33.09	33.12	33.01	33.03	1687600.0
2003-08-28 17:00:00	QQQ	ETF	33.039	33.075	33.01	33.05	82400.0
2003-08-28 18:00:00	QQQ	ETF	33.06	33.07	33.05	33.07	12200.0
2003-08-28 19:00:00	QQQ	ETF	33.06	33.07	33.03	33.03	12300.0
2003-08-28 20:00:00	QQQ	ETF	33.05	33.05	33.05	33.05	400.0
2003-08-28 09:00:00	IWM	ETF	49.15	49.295	49.046	49.05	427200.0
2003-08-28 10:00:00	IWM	ETF	49.045	49.075	48.645	48.895	1250400.0
2003-08-28 11:00:00	IWM	ETF	48.895	49.245	48.84	49.24	298800.0
2003-08-28 12:00:00	IWM	ETF	49.25	49.405	49.25	49.35	394600.0
2003-08-28 13:00:00	IWM	ETF	49.34	49.39	49.26	49.3	621600.0
2003-08-28 14:00:00	IWM	ETF	49.3	49.325	49.19	49.325	441400.0
2003-08-28 15:00:00	IWM	ETF	49.325	49.495	49.305	49.435	177400.0
2003-08-28 16:00:00	IWM	ETF	49.395	49.425	49.335	49.345	73000.0
2003-08-28 08:00:00	DIA	ETF	93.68	93.76	93.64	93.74	7300.0
2003-08-28 09:00:00	DIA	ETF	93.75	93.78	93.56	93.63	487100.0
2003-08-28 10:00:00	DIA	ETF	93.61	93.64	92.81	93.03	1290900.0
2003-08-28 11:00:00	DIA	ETF	93.03	93.37	92.92	93.36	613000.0
2003-08-28 12:00:00	DIA	ETF	93.37	93.7	93.26	93.55	408500.0
2003-08-28 13:00:00	DIA	ETF	93.55	93.61	93.33	93.52	204400.0
2003-08-28 14:00:00	DIA	ETF	93.52	93.59	93.38	93.57	211200.0
2003-08-28 15:00:00	DIA	ETF	93.57	94.17	93.51	94.06	1328200.0
2003-08-28 16:00:00	DIA	ETF	94.07	94.09	93.9	93.92	146600.0
2003-08-28 17:00:00	DIA	ETF	93.93	93.96	93.93	93.96	700.0
2003-08-28 18:00:00	DIA	ETF	93.95	93.95	93.95	93.95	100.0
2003-08-28 09:00:00	TLT	ETF	83.23	83.62	83.23	83.55	103800.0
2003-08-28 10:00:00	TLT	ETF	83.55	83.64	83.44	83.57	116400.0
2003-08-28 11:00:00	TLT	ETF	83.6	83.65	83.45	83.6	94200.0
2003-08-28 12:00:00	TLT	ETF	83.59	83.7	83.5	83.58	54500.0
2003-08-28 13:00:00	TLT	ETF	83.61	83.72	83.55	83.57	22600.0
2003-08-28 14:00:00	TLT	ETF	83.68	83.88	83.59	83.8	22100.0

> showing 50 of 420 rows — these rows as CSV

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