PREVIEW / etf_1hour / 2004-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-02.parquet
  size:    24 KB
  rows:    671

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
2004-07-02 08:00:00	SPY	ETF	112.97	113.06	112.62	113.0	346300.0
2004-07-02 09:00:00	SPY	ETF	112.96	113.21	112.61	112.8	6040600.0
2004-07-02 10:00:00	SPY	ETF	112.82	113.29	112.6	113.11	8003400.0
2004-07-02 11:00:00	SPY	ETF	113.1	113.15	112.86	112.97	4225800.0
2004-07-02 12:00:00	SPY	ETF	112.98	113.17	112.72	112.9	2820200.0
2004-07-02 13:00:00	SPY	ETF	112.9	113.04	112.83	112.98	1731700.0
2004-07-02 14:00:00	SPY	ETF	112.98	112.98	112.68	112.8	3239400.0
2004-07-02 15:00:00	SPY	ETF	112.79	113.01	112.73	112.8	4204500.0
2004-07-02 16:00:00	SPY	ETF	112.79	113.15	112.71	112.72	1344300.0
2004-07-02 17:00:00	SPY	ETF	112.72	112.77	112.72	112.77	13200.0
2004-07-02 18:00:00	SPY	ETF	112.78	112.81	112.78	112.81	2800.0
2004-07-02 19:00:00	SPY	ETF	112.78	112.78	112.78	112.78	200.0
2004-07-02 08:00:00	QQQ	ETF	37.05	37.12	36.89	36.99	701100.0
2004-07-02 09:00:00	QQQ	ETF	36.97	37.05	36.63	36.73	20219200.0
2004-07-02 10:00:00	QQQ	ETF	36.712	36.92	36.64	36.83	16007900.0
2004-07-02 11:00:00	QQQ	ETF	36.821	36.9	36.776	36.863	6826800.0
2004-07-02 12:00:00	QQQ	ETF	36.863	36.944	36.73	36.81	7883400.0
2004-07-02 13:00:00	QQQ	ETF	36.812	36.91	36.79	36.863	3523000.0
2004-07-02 14:00:00	QQQ	ETF	36.862	36.87	36.76	36.82	4099500.0
2004-07-02 15:00:00	QQQ	ETF	36.83	36.88	36.77	36.78	10573700.0
2004-07-02 16:00:00	QQQ	ETF	36.775	36.9	36.77	36.82	1614000.0
2004-07-02 17:00:00	QQQ	ETF	36.81	36.83	36.81	36.81	33800.0
2004-07-02 18:00:00	QQQ	ETF	36.82	36.84	36.81	36.839	11200.0
2004-07-02 19:00:00	QQQ	ETF	36.83	36.85	36.82	36.83	16800.0
2004-07-02 08:00:00	IWM	ETF	57.93	58.035	57.89	57.9	111200.0
2004-07-02 09:00:00	IWM	ETF	57.935	58.225	57.65	57.705	1741800.0
2004-07-02 10:00:00	IWM	ETF	57.705	57.975	57.65	57.855	1753800.0
2004-07-02 11:00:00	IWM	ETF	57.865	57.95	57.82	57.92	458200.0
2004-07-02 12:00:00	IWM	ETF	57.905	57.99	57.77	57.855	886600.0
2004-07-02 13:00:00	IWM	ETF	57.865	58.03	57.845	57.985	352000.0
2004-07-02 14:00:00	IWM	ETF	57.97	58.02	57.93	57.97	354200.0
2004-07-02 15:00:00	IWM	ETF	57.975	58.02	57.875	57.995	1201800.0
2004-07-02 16:00:00	IWM	ETF	57.955	58.1	57.955	58.1	352200.0
2004-07-02 08:00:00	DIA	ETF	103.24	103.36	103.0	103.28	13200.0
2004-07-02 09:00:00	DIA	ETF	103.24	103.49	102.84	102.98	946400.0
2004-07-02 10:00:00	DIA	ETF	102.97	103.43	102.8	103.16	1149800.0
2004-07-02 11:00:00	DIA	ETF	103.24	103.27	103.01	103.1	233500.0
2004-07-02 12:00:00	DIA	ETF	103.13	103.23	102.85	102.99	255100.0
2004-07-02 13:00:00	DIA	ETF	103.0	103.11	102.9	103.03	365000.0
2004-07-02 14:00:00	DIA	ETF	103.02	103.06	102.84	102.97	169300.0
2004-07-02 15:00:00	DIA	ETF	102.97	103.21	102.9	103.0	1046600.0
2004-07-02 16:00:00	DIA	ETF	102.98	103.07	102.9	102.93	71000.0
2004-07-02 17:00:00	DIA	ETF	102.9	102.9	102.9	102.9	100.0
2004-07-02 08:00:00	TLT	ETF	83.47	84.95	83.47	84.72	112500.0
2004-07-02 09:00:00	TLT	ETF	84.65	84.69	84.48	84.6	659300.0
2004-07-02 10:00:00	TLT	ETF	84.6	84.6	84.4	84.5	345000.0
2004-07-02 11:00:00	TLT	ETF	84.49	84.55	84.45	84.45	34200.0
2004-07-02 12:00:00	TLT	ETF	84.4	84.48	84.3	84.38	41600.0
2004-07-02 13:00:00	TLT	ETF	84.37	84.43	84.31	84.31	12700.0
2004-07-02 14:00:00	TLT	ETF	84.31	84.4	84.3	84.39	26600.0

> showing 50 of 671 rows — these rows as CSV

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