PREVIEW / etf_1hour / 2004-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-02.parquet
  size:    25 KB
  rows:    704

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-03-02 08:00:00	SPY	ETF	116.06	116.11	115.95	115.96	14200.0
2004-03-02 09:00:00	SPY	ETF	116.0	116.23	115.9	116.15	2154200.0
2004-03-02 10:00:00	SPY	ETF	116.13	116.22	115.854	116.11	4650300.0
2004-03-02 11:00:00	SPY	ETF	116.13	116.2	115.78	116.04	2271900.0
2004-03-02 12:00:00	SPY	ETF	116.04	116.14	115.49	115.6	5105500.0
2004-03-02 13:00:00	SPY	ETF	115.6	115.8	115.23	115.41	6120200.0
2004-03-02 14:00:00	SPY	ETF	115.4	115.68	115.33	115.6	3479800.0
2004-03-02 15:00:00	SPY	ETF	115.6	115.89	115.44	115.49	5161500.0
2004-03-02 16:00:00	SPY	ETF	115.49	115.54	115.36	115.36	958000.0
2004-03-02 17:00:00	SPY	ETF	115.41	115.45	115.41	115.45	600.0
2004-03-02 18:00:00	SPY	ETF	115.41	115.47	115.41	115.47	50500.0
2004-03-02 19:00:00	SPY	ETF	115.47	115.47	115.47	115.47	500.0
2004-03-02 08:00:00	QQQ	ETF	37.04	37.07	36.96	36.98	87800.0
2004-03-02 09:00:00	QQQ	ETF	37.0	37.14	36.95	37.12	6544600.0
2004-03-02 10:00:00	QQQ	ETF	37.12	37.18	36.95	37.15	13476500.0
2004-03-02 11:00:00	QQQ	ETF	37.14	37.142	36.96	37.022	8290500.0
2004-03-02 12:00:00	QQQ	ETF	37.03	37.06	36.73	36.78	10098900.0
2004-03-02 13:00:00	QQQ	ETF	36.79	36.86	36.66	36.7	15440200.0
2004-03-02 14:00:00	QQQ	ETF	36.706	36.801	36.63	36.72	7330300.0
2004-03-02 15:00:00	QQQ	ETF	36.71	36.84	36.62	36.677	12945400.0
2004-03-02 16:00:00	QQQ	ETF	36.672	36.7	36.57	36.59	2209800.0
2004-03-02 17:00:00	QQQ	ETF	36.58	36.6	36.56	36.6	110500.0
2004-03-02 18:00:00	QQQ	ETF	36.6	36.6	36.57	36.58	40000.0
2004-03-02 19:00:00	QQQ	ETF	36.58	36.59	36.57	36.57	14500.0
2004-03-02 09:00:00	IWM	ETF	59.135	59.42	59.1	59.42	1118000.0
2004-03-02 10:00:00	IWM	ETF	59.39	59.45	59.195	59.392	1796200.0
2004-03-02 11:00:00	IWM	ETF	59.325	59.34	59.135	59.275	1305400.0
2004-03-02 12:00:00	IWM	ETF	59.275	59.32	58.98	59.03	1930400.0
2004-03-02 13:00:00	IWM	ETF	59.03	59.175	58.845	58.93	2030400.0
2004-03-02 14:00:00	IWM	ETF	58.93	59.025	58.87	58.9605	1880000.0
2004-03-02 15:00:00	IWM	ETF	58.965	59.13	58.81	58.81	1161200.0
2004-03-02 16:00:00	IWM	ETF	58.815	58.925	58.735	58.735	496000.0
2004-03-02 17:00:00	IWM	ETF	58.78	58.78	58.775	58.775	5000.0
2004-03-02 18:00:00	IWM	ETF	58.755	58.755	58.75	58.75	4000.0
2004-03-02 08:00:00	DIA	ETF	106.87	106.87	106.73	106.76	9900.0
2004-03-02 09:00:00	DIA	ETF	106.77	106.83	106.55	106.7	900100.0
2004-03-02 10:00:00	DIA	ETF	106.69	106.77	106.4	106.6	777500.0
2004-03-02 11:00:00	DIA	ETF	106.59	106.7	106.41	106.56	384200.0
2004-03-02 12:00:00	DIA	ETF	106.56	106.65	106.09	106.16	763000.0
2004-03-02 13:00:00	DIA	ETF	106.16	106.31	105.85	106.0	762000.0
2004-03-02 14:00:00	DIA	ETF	105.993	106.2	105.97	106.14	663700.0
2004-03-02 15:00:00	DIA	ETF	106.12	106.35	106.04	106.09	1528600.0
2004-03-02 16:00:00	DIA	ETF	106.05	106.1	106.01	106.01	48100.0
2004-03-02 17:00:00	DIA	ETF	106.0	106.0	106.0	106.0	2000.0
2004-03-02 09:00:00	TLT	ETF	88.12	88.2	88.1	88.14	67700.0
2004-03-02 10:00:00	TLT	ETF	88.14	88.14	87.88	87.9	67100.0
2004-03-02 11:00:00	TLT	ETF	87.82	87.9	87.58	87.65	93900.0
2004-03-02 12:00:00	TLT	ETF	87.61	87.62	87.41	87.47	222700.0
2004-03-02 13:00:00	TLT	ETF	87.47	87.65	87.4	87.53	42100.0
2004-03-02 14:00:00	TLT	ETF	87.56	87.65	87.5	87.64	55400.0

> showing 50 of 704 rows — these rows as CSV

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