PREVIEW / etf_1hour / 2005-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-01.parquet
  size:    29 KB
  rows:    828

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-01 08:00:00	SPY	ETF	118.16	118.36	118.16	118.34	180400.0
2005-02-01 09:00:00	SPY	ETF	118.34	118.34	118.12	118.21	3876000.0
2005-02-01 10:00:00	SPY	ETF	118.19	118.42	118.1	118.36	5555900.0
2005-02-01 11:00:00	SPY	ETF	118.37	118.77	118.35	118.69	8140300.0
2005-02-01 12:00:00	SPY	ETF	118.7	118.88	118.65	118.78	7462300.0
2005-02-01 13:00:00	SPY	ETF	118.78	118.89	118.69	118.85	3087200.0
2005-02-01 14:00:00	SPY	ETF	118.88	119.08	118.85	118.86	8442900.0
2005-02-01 15:00:00	SPY	ETF	118.86	119.01	118.69	118.91	9460800.0
2005-02-01 16:00:00	SPY	ETF	118.88	119.14	118.79	119.14	2045600.0
2005-02-01 17:00:00	SPY	ETF	119.11	119.17	118.94	119.14	262500.0
2005-02-01 18:00:00	SPY	ETF	119.14	119.14	119.11	119.11	41900.0
2005-02-01 19:00:00	SPY	ETF	119.08	119.08	119.08	119.08	900.0
2005-02-01 09:00:00	QQQ	ETF	37.48	37.5	37.39	37.45	9953600.0
2005-02-01 10:00:00	QQQ	ETF	37.45	37.57	37.37	37.49	12325100.0
2005-02-01 11:00:00	QQQ	ETF	37.49	37.59	37.47	37.56	9498400.0
2005-02-01 12:00:00	QQQ	ETF	37.57	37.65	37.48	37.57	9381100.0
2005-02-01 13:00:00	QQQ	ETF	37.56	37.63	37.53	37.62	5061900.0
2005-02-01 14:00:00	QQQ	ETF	37.62	37.64	37.52	37.53	8124300.0
2005-02-01 15:00:00	QQQ	ETF	37.53	37.55	37.43	37.51	14787000.0
2005-02-01 08:00:00	IWM	ETF	62.255	62.255	62.255	62.255	1000.0
2005-02-01 09:00:00	IWM	ETF	62.14	62.215	62.03	62.14	3457400.0
2005-02-01 10:00:00	IWM	ETF	62.13	62.49	62.075	62.375	5524800.0
2005-02-01 11:00:00	IWM	ETF	62.375	62.62	62.365	62.525	2995000.0
2005-02-01 12:00:00	IWM	ETF	62.535	62.685	62.435	62.465	1377600.0
2005-02-01 13:00:00	IWM	ETF	62.465	62.495	62.325	62.49	981200.0
2005-02-01 14:00:00	IWM	ETF	62.5	62.605	62.4	62.445	1533400.0
2005-02-01 15:00:00	IWM	ETF	62.44	62.5	62.35	62.475	1864400.0
2005-02-01 16:00:00	IWM	ETF	62.475	62.62	62.365	62.62	682400.0
2005-02-01 08:00:00	DIA	ETF	104.95	105.02	104.9	105.02	13300.0
2005-02-01 09:00:00	DIA	ETF	104.99	105.05	104.87	104.96	363000.0
2005-02-01 10:00:00	DIA	ETF	104.95	105.13	104.84	105.05	783700.0
2005-02-01 11:00:00	DIA	ETF	105.06	105.36	105.06	105.32	587300.0
2005-02-01 12:00:00	DIA	ETF	105.34	105.45	105.3	105.35	379500.0
2005-02-01 13:00:00	DIA	ETF	105.35	105.44	105.27	105.44	180300.0
2005-02-01 14:00:00	DIA	ETF	105.43	105.64	105.39	105.43	583300.0
2005-02-01 15:00:00	DIA	ETF	105.43	105.5	105.23	105.39	1131400.0
2005-02-01 16:00:00	DIA	ETF	105.35	105.55	105.29	105.55	171500.0
2005-02-01 17:00:00	DIA	ETF	105.5	105.5	105.5	105.5	1200.0
2005-02-01 19:00:00	DIA	ETF	105.45	105.45	105.45	105.45	1000.0
2005-02-01 09:00:00	GLD	ETF	42.09	42.12	42.06	42.08	415300.0
2005-02-01 10:00:00	GLD	ETF	42.1	42.14	41.95	42.0	185600.0
2005-02-01 11:00:00	GLD	ETF	42.0	42.06	41.97	42.04	155700.0
2005-02-01 12:00:00	GLD	ETF	42.06	42.07	42.03	42.04	94500.0
2005-02-01 13:00:00	GLD	ETF	42.06	42.12	42.05	42.11	97200.0
2005-02-01 14:00:00	GLD	ETF	42.1	42.14	42.06	42.07	76300.0
2005-02-01 15:00:00	GLD	ETF	42.07	42.12	42.06	42.1	64200.0
2005-02-01 16:00:00	GLD	ETF	42.14	42.14	42.14	42.14	100.0
2005-02-01 08:00:00	TLT	ETF	91.32	91.34	91.32	91.34	8900.0
2005-02-01 09:00:00	TLT	ETF	91.34	91.44	91.33	91.35	313600.0
2005-02-01 10:00:00	TLT	ETF	91.35	91.5	91.05	91.1	225200.0

> showing 50 of 828 rows — these rows as CSV

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