PREVIEW / etf_1hour / 2003-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-15.parquet
  size:    17 KB
  rows:    414

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-04-15 08:00:00	SPY	ETF	89.35	89.36	88.84	89.02	103900.0
2003-04-15 09:00:00	SPY	ETF	89.04	89.04	88.42	88.68	6608700.0
2003-04-15 10:00:00	SPY	ETF	88.71	89.15	88.5	89.07	7093800.0
2003-04-15 11:00:00	SPY	ETF	89.07	89.46	89.05	89.17	5217900.0
2003-04-15 12:00:00	SPY	ETF	89.16	89.36	89.06	89.3	2765900.0
2003-04-15 13:00:00	SPY	ETF	89.29	89.38	88.72	88.87	4754100.0
2003-04-15 14:00:00	SPY	ETF	88.87	89.24	88.69	89.16	3603800.0
2003-04-15 15:00:00	SPY	ETF	89.16	89.44	88.91	89.42	5265600.0
2003-04-15 16:00:00	SPY	ETF	89.43	90.26	89.37	90.23	8355400.0
2003-04-15 17:00:00	SPY	ETF	90.23	90.4	90.19	90.37	303900.0
2003-04-15 18:00:00	SPY	ETF	90.4	90.65	90.39	90.52	68300.0
2003-04-15 19:00:00	SPY	ETF	90.6	90.69	90.53	90.69	16700.0
2003-04-15 08:00:00	QQQ	ETF	26.2	26.21	25.98	25.98	124900.0
2003-04-15 09:00:00	QQQ	ETF	26.01	26.15	25.84	26.02	9946600.0
2003-04-15 10:00:00	QQQ	ETF	26.02	26.25	25.91	26.2	9833300.0
2003-04-15 11:00:00	QQQ	ETF	26.22	26.34	26.19	26.22	8249800.0
2003-04-15 12:00:00	QQQ	ETF	26.22	26.3	26.17	26.29	3163800.0
2003-04-15 13:00:00	QQQ	ETF	26.28	26.31	26.07	26.11	5860200.0
2003-04-15 14:00:00	QQQ	ETF	26.12	26.2	26.05	26.17	5021400.0
2003-04-15 15:00:00	QQQ	ETF	26.18	26.24	26.07	26.21	7477100.0
2003-04-15 16:00:00	QQQ	ETF	26.2	26.68	26.18	26.66	8494000.0
2003-04-15 17:00:00	QQQ	ETF	26.65	26.72	26.64	26.69	1409900.0
2003-04-15 18:00:00	QQQ	ETF	26.7	26.89	26.7	26.87	618400.0
2003-04-15 19:00:00	QQQ	ETF	26.87	26.94	26.85	26.89	32500.0
2003-04-15 09:00:00	IWM	ETF	37.575	37.575	37.325	37.435	153200.0
2003-04-15 10:00:00	IWM	ETF	37.42	37.635	37.365	37.605	264800.0
2003-04-15 11:00:00	IWM	ETF	37.635	37.775	37.625	37.635	267600.0
2003-04-15 12:00:00	IWM	ETF	37.625	37.7	37.625	37.655	48600.0
2003-04-15 13:00:00	IWM	ETF	37.67	37.67	37.515	37.555	99800.0
2003-04-15 14:00:00	IWM	ETF	37.56	37.695	37.515	37.695	79200.0
2003-04-15 15:00:00	IWM	ETF	37.675	37.8	37.615	37.8	200600.0
2003-04-15 16:00:00	IWM	ETF	37.84	37.995	37.84	37.995	58600.0
2003-04-15 18:00:00	IWM	ETF	38.285	38.29	38.285	38.29	10000.0
2003-04-15 08:00:00	DIA	ETF	84.3	84.3	83.59	83.73	26400.0
2003-04-15 09:00:00	DIA	ETF	83.8	83.8	83.24	83.45	1206800.0
2003-04-15 10:00:00	DIA	ETF	83.47	83.93	83.27	83.84	1354000.0
2003-04-15 11:00:00	DIA	ETF	83.84	84.17	83.81	83.9	1175200.0
2003-04-15 12:00:00	DIA	ETF	83.91	84.06	83.8	84.01	508700.0
2003-04-15 13:00:00	DIA	ETF	84.02	84.07	83.47	83.62	419300.0
2003-04-15 14:00:00	DIA	ETF	83.62	83.89	83.43	83.85	554700.0
2003-04-15 15:00:00	DIA	ETF	83.85	84.2	83.62	84.16	724500.0
2003-04-15 16:00:00	DIA	ETF	84.18	84.99	84.11	84.86	222800.0
2003-04-15 17:00:00	DIA	ETF	84.9	85.03	84.14	85.0	16300.0
2003-04-15 18:00:00	DIA	ETF	84.99	85.29	84.99	85.27	17300.0
2003-04-15 19:00:00	DIA	ETF	85.23	85.23	85.23	85.23	1700.0
2003-04-15 09:00:00	TLT	ETF	87.33	87.45	87.33	87.34	5400.0
2003-04-15 10:00:00	TLT	ETF	87.34	87.45	87.23	87.23	65500.0
2003-04-15 11:00:00	TLT	ETF	87.24	87.24	87.04	87.15	4200.0
2003-04-15 12:00:00	TLT	ETF	87.15	87.24	87.15	87.2	4200.0
2003-04-15 13:00:00	TLT	ETF	87.25	87.33	87.25	87.33	21400.0

> showing 50 of 414 rows — these rows as CSV

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