PREVIEW / etf_1hour / 2005-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-03.parquet
  size:    28 KB
  rows:    827

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
2005-02-03 08:00:00	SPY	ETF	119.24	119.32	119.07	119.07	152800.0
2005-02-03 09:00:00	SPY	ETF	119.07	119.15	118.9	119.14	5992800.0
2005-02-03 10:00:00	SPY	ETF	119.14	119.15	118.78	118.85	10401800.0
2005-02-03 11:00:00	SPY	ETF	118.84	118.92	118.74	118.79	4525800.0
2005-02-03 12:00:00	SPY	ETF	118.79	118.9	118.57	118.68	5652200.0
2005-02-03 13:00:00	SPY	ETF	118.68	118.9	118.61	118.88	4427500.0
2005-02-03 14:00:00	SPY	ETF	118.86	119.04	118.76	118.85	5182700.0
2005-02-03 15:00:00	SPY	ETF	118.86	119.16	118.7	119.05	9964900.0
2005-02-03 16:00:00	SPY	ETF	119.05	119.12	118.84	119.08	2179200.0
2005-02-03 17:00:00	SPY	ETF	119.07	119.1	119.05	119.06	8700.0
2005-02-03 18:00:00	SPY	ETF	119.06	119.11	119.05	119.11	1000.0
2005-02-03 09:00:00	QQQ	ETF	37.39	37.42	37.29	37.4	12051800.0
2005-02-03 10:00:00	QQQ	ETF	37.41	37.41	37.11	37.12	20505900.0
2005-02-03 11:00:00	QQQ	ETF	37.11	37.13	37.02	37.05	16126600.0
2005-02-03 12:00:00	QQQ	ETF	37.06	37.1	37.0	37.05	7836800.0
2005-02-03 13:00:00	QQQ	ETF	37.06	37.17	37.03	37.16	7287500.0
2005-02-03 14:00:00	QQQ	ETF	37.15	37.21	37.07	37.11	8018300.0
2005-02-03 15:00:00	QQQ	ETF	37.12	37.23	37.05	37.17	13813900.0
2005-02-03 08:00:00	IWM	ETF	62.83	62.86	62.81	62.81	4400.0
2005-02-03 09:00:00	IWM	ETF	62.71	62.85	62.53	62.71	2912800.0
2005-02-03 10:00:00	IWM	ETF	62.71	62.715	62.38	62.395	3509000.0
2005-02-03 11:00:00	IWM	ETF	62.39	62.45	62.25	62.405	2117800.0
2005-02-03 12:00:00	IWM	ETF	62.41	62.475	62.125	62.271	1679200.0
2005-02-03 13:00:00	IWM	ETF	62.275	62.54	62.27	62.535	968000.0
2005-02-03 14:00:00	IWM	ETF	62.535	62.65	62.44	62.525	1475400.0
2005-02-03 15:00:00	IWM	ETF	62.52	62.69	62.4	62.68	1811800.0
2005-02-03 16:00:00	IWM	ETF	62.69	62.725	62.545	62.545	277600.0
2005-02-03 17:00:00	IWM	ETF	62.575	62.575	62.5518	62.5518	5000.0
2005-02-03 08:00:00	DIA	ETF	105.79	105.8	105.69	105.69	9700.0
2005-02-03 09:00:00	DIA	ETF	105.7	105.82	105.59	105.79	519700.0
2005-02-03 10:00:00	DIA	ETF	105.8	105.82	105.56	105.6	1109200.0
2005-02-03 11:00:00	DIA	ETF	105.61	105.66	105.52	105.59	361700.0
2005-02-03 12:00:00	DIA	ETF	105.6	105.66	105.44	105.52	639700.0
2005-02-03 13:00:00	DIA	ETF	105.53	105.72	105.46	105.72	400800.0
2005-02-03 14:00:00	DIA	ETF	105.7	105.83	105.63	105.71	937200.0
2005-02-03 15:00:00	DIA	ETF	105.7	105.95	105.58	105.88	744700.0
2005-02-03 16:00:00	DIA	ETF	105.89	105.94	105.81	105.82	99800.0
2005-02-03 17:00:00	DIA	ETF	105.9	105.9	105.85	105.85	10400.0
2005-02-03 18:00:00	DIA	ETF	105.9	105.9	105.9	105.9	100.0
2005-02-03 09:00:00	GLD	ETF	41.56	41.58	41.5	41.56	1257300.0
2005-02-03 10:00:00	GLD	ETF	41.57	41.7	41.54	41.63	552600.0
2005-02-03 11:00:00	GLD	ETF	41.62	41.74	41.6	41.69	125000.0
2005-02-03 12:00:00	GLD	ETF	41.67	41.7	41.6	41.61	169000.0
2005-02-03 13:00:00	GLD	ETF	41.63	41.73	41.6	41.73	54300.0
2005-02-03 14:00:00	GLD	ETF	41.73	41.73	41.67	41.7	155300.0
2005-02-03 15:00:00	GLD	ETF	41.68	41.73	41.66	41.72	125300.0
2005-02-03 08:00:00	TLT	ETF	91.31	91.31	90.98	91.02	32400.0
2005-02-03 09:00:00	TLT	ETF	91.07	91.15	91.06	91.12	38800.0
2005-02-03 10:00:00	TLT	ETF	91.14	91.31	91.14	91.22	66400.0
2005-02-03 11:00:00	TLT	ETF	91.24	91.28	91.14	91.25	73700.0

> showing 50 of 827 rows — these rows as CSV

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