PREVIEW / etf_1hour / 2004-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-02.parquet
  size:    25 KB
  rows:    691

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-08-02 08:00:00	SPY	ETF	110.17	110.29	110.14	110.14	41200.0
2004-08-02 09:00:00	SPY	ETF	110.17	110.58	110.05	110.5	5622500.0
2004-08-02 10:00:00	SPY	ETF	110.48	110.7	110.23	110.48	6002800.0
2004-08-02 11:00:00	SPY	ETF	110.48	110.57	110.31	110.53	2911100.0
2004-08-02 12:00:00	SPY	ETF	110.52	110.6	110.41	110.51	1607800.0
2004-08-02 13:00:00	SPY	ETF	110.48	111.14	110.47	111.01	6230700.0
2004-08-02 14:00:00	SPY	ETF	111.01	111.18	110.76	110.78	5808400.0
2004-08-02 15:00:00	SPY	ETF	110.77	111.36	110.74	111.1	6819100.0
2004-08-02 16:00:00	SPY	ETF	111.1	111.25	111.04	111.16	1982100.0
2004-08-02 17:00:00	SPY	ETF	111.15	111.16	110.4783	111.1	496300.0
2004-08-02 18:00:00	SPY	ETF	111.08	111.08	110.96	110.98	53800.0
2004-08-02 19:00:00	SPY	ETF	110.93	111.0	110.89	110.89	5600.0
2004-08-02 08:00:00	QQQ	ETF	34.65	34.67	34.57	34.59	339700.0
2004-08-02 09:00:00	QQQ	ETF	34.59	34.71	34.46	34.67	13923400.0
2004-08-02 10:00:00	QQQ	ETF	34.67	34.7	34.48	34.63	15108700.0
2004-08-02 11:00:00	QQQ	ETF	34.633	34.69	34.57	34.66	6957700.0
2004-08-02 12:00:00	QQQ	ETF	34.66	34.68	34.57	34.637	5405600.0
2004-08-02 13:00:00	QQQ	ETF	34.64	34.91	34.63	34.859	10904200.0
2004-08-02 14:00:00	QQQ	ETF	34.86	34.92	34.72	34.734	11848200.0
2004-08-02 15:00:00	QQQ	ETF	34.735	35.02	34.71	34.93	13251300.0
2004-08-02 16:00:00	QQQ	ETF	34.925	35.01	34.92	34.93	2500100.0
2004-08-02 17:00:00	QQQ	ETF	34.94	34.95	34.93	34.93	36000.0
2004-08-02 18:00:00	QQQ	ETF	34.95	34.95	34.87	34.87	102800.0
2004-08-02 19:00:00	QQQ	ETF	34.88	34.9	34.87	34.89	5800.0
2004-08-02 08:00:00	IWM	ETF	54.575	54.575	54.575	54.575	200.0
2004-08-02 09:00:00	IWM	ETF	54.5	54.885	54.465	54.72	1532800.0
2004-08-02 10:00:00	IWM	ETF	54.715	54.715	54.165	54.355	2775400.0
2004-08-02 11:00:00	IWM	ETF	54.35	54.535	54.265	54.535	1062600.0
2004-08-02 12:00:00	IWM	ETF	54.52	54.57	54.45	54.48	490000.0
2004-08-02 13:00:00	IWM	ETF	54.49	55.095	54.49	54.995	1725400.0
2004-08-02 14:00:00	IWM	ETF	54.965	55.04	54.63	54.65	1810800.0
2004-08-02 15:00:00	IWM	ETF	54.64	55.005	54.625	54.975	1687000.0
2004-08-02 16:00:00	IWM	ETF	54.97	55.025	54.775	54.775	736600.0
2004-08-02 17:00:00	IWM	ETF	54.7544	54.8348	54.4598	54.8348	391200.0
2004-08-02 18:00:00	IWM	ETF	54.875	54.875	54.87	54.87	10400.0
2004-08-02 08:00:00	DIA	ETF	101.32	101.33	101.28	101.28	5200.0
2004-08-02 09:00:00	DIA	ETF	101.21	101.58	101.16	101.5	927200.0
2004-08-02 10:00:00	DIA	ETF	101.51	101.72	101.33	101.58	812500.0
2004-08-02 11:00:00	DIA	ETF	101.6	101.69	101.44	101.64	351600.0
2004-08-02 12:00:00	DIA	ETF	101.64	101.69	101.53	101.6	142200.0
2004-08-02 13:00:00	DIA	ETF	101.59	102.09	101.59	101.96	699400.0
2004-08-02 14:00:00	DIA	ETF	101.99	102.12	101.75	101.76	720100.0
2004-08-02 15:00:00	DIA	ETF	101.77	102.23	101.73	102.0	885500.0
2004-08-02 16:00:00	DIA	ETF	102.0	102.06	101.94	101.99	383300.0
2004-08-02 17:00:00	DIA	ETF	102.03	102.06	102.03	102.06	400.0
2004-08-02 18:00:00	DIA	ETF	101.95	101.97	101.9	101.9	500.0
2004-08-02 08:00:00	TLT	ETF	84.59	84.59	84.59	84.59	600.0
2004-08-02 09:00:00	TLT	ETF	84.59	84.6	84.49	84.57	40600.0
2004-08-02 10:00:00	TLT	ETF	84.55	84.61	84.36	84.45	431100.0
2004-08-02 11:00:00	TLT	ETF	84.45	84.5	84.37	84.46	29500.0

> showing 50 of 691 rows — these rows as CSV

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