PREVIEW / etf_1hour / 2004-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-02.parquet
  size:    24 KB
  rows:    642

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-02 08:00:00	SPY	ETF	111.85	111.9	111.78	111.9	37300.0
2004-01-02 09:00:00	SPY	ETF	111.9	111.98	111.61	111.76	6465200.0
2004-01-02 10:00:00	SPY	ETF	111.76	112.19	111.7	112.11	7362200.0
2004-01-02 11:00:00	SPY	ETF	112.12	112.18	111.87	111.9	2570000.0
2004-01-02 12:00:00	SPY	ETF	111.9	111.99	111.6	111.77	3682400.0
2004-01-02 13:00:00	SPY	ETF	111.75	111.79	111.59	111.7	2078300.0
2004-01-02 14:00:00	SPY	ETF	111.7	111.72	110.88	110.93	4726400.0
2004-01-02 15:00:00	SPY	ETF	110.93	111.14	110.73	111.0	5784800.0
2004-01-02 16:00:00	SPY	ETF	111.0	111.39	110.98	111.36	3883200.0
2004-01-02 17:00:00	SPY	ETF	111.3	111.34	111.23	111.34	13800.0
2004-01-02 18:00:00	SPY	ETF	111.25	111.35	111.25	111.35	9200.0
2004-01-02 08:00:00	QQQ	ETF	36.6	36.71	36.6	36.7	102400.0
2004-01-02 09:00:00	QQQ	ETF	36.71	36.77	36.62	36.66	8903500.0
2004-01-02 10:00:00	QQQ	ETF	36.66	36.79	36.62	36.733	11011700.0
2004-01-02 11:00:00	QQQ	ETF	36.73	36.79	36.66	36.7	4821200.0
2004-01-02 12:00:00	QQQ	ETF	36.702	36.737	36.6	36.69	5005700.0
2004-01-02 13:00:00	QQQ	ETF	36.68	36.73	36.62	36.68	3427400.0
2004-01-02 14:00:00	QQQ	ETF	36.68	36.69	36.31	36.35	8327100.0
2004-01-02 15:00:00	QQQ	ETF	36.35	36.42	36.22	36.33	9403600.0
2004-01-02 16:00:00	QQQ	ETF	36.338	36.41	36.33	36.38	1861600.0
2004-01-02 17:00:00	QQQ	ETF	36.34	36.41	36.34	36.4	49200.0
2004-01-02 18:00:00	QQQ	ETF	36.4	36.41	36.34	36.34	31500.0
2004-01-02 19:00:00	QQQ	ETF	36.41	36.41	36.34	36.34	3200.0
2004-01-02 08:00:00	IWM	ETF	55.8	55.8	55.79	55.79	3600.0
2004-01-02 09:00:00	IWM	ETF	55.825	56.055	55.5835	55.995	1363600.0
2004-01-02 10:00:00	IWM	ETF	55.999	56.3145	55.975	56.145	1552600.0
2004-01-02 11:00:00	IWM	ETF	56.15	56.205	56.005	56.2	860600.0
2004-01-02 12:00:00	IWM	ETF	56.135	56.175	56.01	56.1	535200.0
2004-01-02 13:00:00	IWM	ETF	56.115	56.165	56.01	56.105	554000.0
2004-01-02 14:00:00	IWM	ETF	56.085	56.15	55.62	55.635	2613800.0
2004-01-02 15:00:00	IWM	ETF	55.62	55.92	55.58	55.92	2885000.0
2004-01-02 16:00:00	IWM	ETF	55.915	56.0	55.84	55.995	370200.0
2004-01-02 08:00:00	DIA	ETF	105.09	105.23	105.03	105.21	14100.0
2004-01-02 09:00:00	DIA	ETF	105.18	105.28	105.0	105.1	1028700.0
2004-01-02 10:00:00	DIA	ETF	105.06	105.46	104.97	105.4	1970800.0
2004-01-02 11:00:00	DIA	ETF	105.4	105.47	105.2	105.22	612000.0
2004-01-02 12:00:00	DIA	ETF	105.23	105.27	104.86	104.9	1569300.0
2004-01-02 13:00:00	DIA	ETF	104.89	104.97	104.75	104.91	410000.0
2004-01-02 14:00:00	DIA	ETF	104.94	104.96	104.019	104.13	1450000.0
2004-01-02 15:00:00	DIA	ETF	104.17	104.4	103.99	104.22	927100.0
2004-01-02 16:00:00	DIA	ETF	104.21	104.42	104.2	104.41	158800.0
2004-01-02 18:00:00	DIA	ETF	104.32	104.32	104.32	104.32	200.0
2004-01-02 08:00:00	TLT	ETF	85.27	85.27	85.27	85.27	200.0
2004-01-02 09:00:00	TLT	ETF	85.09	85.09	84.96	85.02	34300.0
2004-01-02 10:00:00	TLT	ETF	85.01	85.03	84.32	84.33	305500.0
2004-01-02 11:00:00	TLT	ETF	84.33	84.39	84.08	84.1	331300.0
2004-01-02 12:00:00	TLT	ETF	84.13	84.36	84.1	84.36	50700.0
2004-01-02 13:00:00	TLT	ETF	84.37	84.49	84.35	84.4	26500.0
2004-01-02 14:00:00	TLT	ETF	84.45	84.53	84.35	84.52	38600.0
2004-01-02 15:00:00	TLT	ETF	84.47	84.58	84.45	84.45	72000.0

> showing 50 of 642 rows — these rows as CSV

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