PREVIEW / etf_1hour / 2004-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-29.parquet
  size:    24 KB
  rows:    647

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-01-29 08:00:00	SPY	ETF	113.61	113.71	113.43	113.52	59700.0
2004-01-29 09:00:00	SPY	ETF	113.54	113.68	113.25	113.38	5454700.0
2004-01-29 10:00:00	SPY	ETF	113.38	113.57	113.07	113.25	8101700.0
2004-01-29 11:00:00	SPY	ETF	113.26	113.42	112.97	113.06	5701000.0
2004-01-29 12:00:00	SPY	ETF	113.03	113.31	112.96	113.24	3456000.0
2004-01-29 13:00:00	SPY	ETF	113.3	113.33	112.56	112.8	8329400.0
2004-01-29 14:00:00	SPY	ETF	112.8	113.56	112.67	113.5	11065600.0
2004-01-29 15:00:00	SPY	ETF	113.5	113.85	113.45	113.75	9185700.0
2004-01-29 16:00:00	SPY	ETF	113.71	113.76	113.47	113.63	2904700.0
2004-01-29 17:00:00	SPY	ETF	113.6	113.69	113.59	113.69	26400.0
2004-01-29 18:00:00	SPY	ETF	113.66	113.66	113.6	113.6	2900.0
2004-01-29 08:00:00	QQQ	ETF	37.25	37.31	37.12	37.22	328400.0
2004-01-29 09:00:00	QQQ	ETF	37.23	37.31	37.06	37.14	12700000.0
2004-01-29 10:00:00	QQQ	ETF	37.13	37.16	36.85	36.94	27971300.0
2004-01-29 11:00:00	QQQ	ETF	36.95	37.04	36.8	36.91	18795500.0
2004-01-29 12:00:00	QQQ	ETF	36.91	37.04	36.84	37.02	8711200.0
2004-01-29 13:00:00	QQQ	ETF	37.025	37.04	36.66	36.77	16708000.0
2004-01-29 14:00:00	QQQ	ETF	36.77	37.15	36.71	37.11	22355700.0
2004-01-29 15:00:00	QQQ	ETF	37.12	37.3	37.02	37.165	21681000.0
2004-01-29 16:00:00	QQQ	ETF	37.16	37.36	36.99	37.3	4936500.0
2004-01-29 17:00:00	QQQ	ETF	37.31	37.35	37.292	37.32	125000.0
2004-01-29 18:00:00	QQQ	ETF	37.32	37.35	37.3	37.34	44300.0
2004-01-29 19:00:00	QQQ	ETF	37.32	37.35	37.3	37.35	18100.0
2004-01-29 09:00:00	IWM	ETF	58.41	58.485	57.87	57.92	1842600.0
2004-01-29 10:00:00	IWM	ETF	57.89	57.935	57.525	57.63	3603600.0
2004-01-29 11:00:00	IWM	ETF	57.625	57.655	57.4	57.54	1415200.0
2004-01-29 12:00:00	IWM	ETF	57.545	57.595	57.33	57.465	1108400.0
2004-01-29 13:00:00	IWM	ETF	57.46	57.46	57.08	57.13	1275600.0
2004-01-29 14:00:00	IWM	ETF	57.1635	57.6075	57.12	57.585	3033400.0
2004-01-29 15:00:00	IWM	ETF	57.59	57.8855	57.575	57.735	3154600.0
2004-01-29 16:00:00	IWM	ETF	57.795	57.81	57.31	57.65	724400.0
2004-01-29 18:00:00	IWM	ETF	57.765	57.765	57.765	57.765	200.0
2004-01-29 08:00:00	DIA	ETF	105.32	105.4	105.16	105.31	6500.0
2004-01-29 09:00:00	DIA	ETF	105.33	105.45	105.1	105.15	1256300.0
2004-01-29 10:00:00	DIA	ETF	105.14	105.4	104.95	105.16	2040100.0
2004-01-29 11:00:00	DIA	ETF	105.19	105.19	104.88	104.96	1395400.0
2004-01-29 12:00:00	DIA	ETF	104.95	105.12	104.86	105.08	596100.0
2004-01-29 13:00:00	DIA	ETF	105.05	105.1	104.35	104.5	1804700.0
2004-01-29 14:00:00	DIA	ETF	104.5	105.15	104.418	105.12	3017000.0
2004-01-29 15:00:00	DIA	ETF	105.13	105.36	105.09	105.31	1589800.0
2004-01-29 16:00:00	DIA	ETF	105.3	105.33	105.0	105.042	83000.0
2004-01-29 17:00:00	DIA	ETF	105.2	105.2	105.12	105.12	400.0
2004-01-29 18:00:00	DIA	ETF	105.19	105.22	105.13	105.13	1100.0
2004-01-29 19:00:00	DIA	ETF	105.13	105.15	105.13	105.15	600.0
2004-01-29 09:00:00	TLT	ETF	86.22	86.406	86.1	86.15	115200.0
2004-01-29 10:00:00	TLT	ETF	86.21	86.32	86.02	86.17	83100.0
2004-01-29 11:00:00	TLT	ETF	86.07	86.42	86.02	86.42	72500.0
2004-01-29 12:00:00	TLT	ETF	86.43	86.43	86.13	86.17	114700.0
2004-01-29 13:00:00	TLT	ETF	86.2	86.3	86.13	86.3	28800.0
2004-01-29 14:00:00	TLT	ETF	86.35	86.58	86.27	86.48	259400.0

> showing 50 of 647 rows — these rows as CSV

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