PREVIEW / etf_1hour / 2005-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-19.parquet
  size:    29 KB
  rows:    832

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-01-19 08:00:00	SPY	ETF	119.28	119.55	119.21	119.5	256600.0
2005-01-19 09:00:00	SPY	ETF	119.52	119.52	119.3	119.39	5829500.0
2005-01-19 10:00:00	SPY	ETF	119.39	119.5	119.02	119.12	9143100.0
2005-01-19 11:00:00	SPY	ETF	119.12	119.27	119.02	119.04	5164900.0
2005-01-19 12:00:00	SPY	ETF	119.05	119.2	118.89	119.19	5607300.0
2005-01-19 13:00:00	SPY	ETF	119.19	119.24	119.0	119.04	3675800.0
2005-01-19 14:00:00	SPY	ETF	119.04	119.22	118.94	119.091	4849300.0
2005-01-19 15:00:00	SPY	ETF	119.1	119.13	118.39	118.39	14411000.0
2005-01-19 16:00:00	SPY	ETF	118.41	118.44	117.78	117.84	2041800.0
2005-01-19 17:00:00	SPY	ETF	117.84	117.9	117.56	117.64	1437500.0
2005-01-19 18:00:00	SPY	ETF	117.63	117.84	117.62	117.83	158700.0
2005-01-19 19:00:00	SPY	ETF	117.78	117.83	117.78	117.81	5900.0
2005-01-19 09:00:00	QQQ	ETF	38.75	38.75	38.56	38.61	12960000.0
2005-01-19 10:00:00	QQQ	ETF	38.61	38.66	38.4	38.44	18568600.0
2005-01-19 11:00:00	QQQ	ETF	38.44	38.55	38.39	38.42	10174900.0
2005-01-19 12:00:00	QQQ	ETF	38.42	38.46	38.33	38.45	7937800.0
2005-01-19 13:00:00	QQQ	ETF	38.44	38.53	38.4	38.42	5615800.0
2005-01-19 14:00:00	QQQ	ETF	38.42	38.5	38.37	38.42	8150700.0
2005-01-19 15:00:00	QQQ	ETF	38.42	38.46	38.06	38.08	24745100.0
2005-01-19 08:00:00	IWM	ETF	62.105	62.205	62.105	62.185	4600.0
2005-01-19 09:00:00	IWM	ETF	62.15	62.375	62.02	62.19	1969600.0
2005-01-19 10:00:00	IWM	ETF	62.19	62.305	62.0	62.015	5639200.0
2005-01-19 11:00:00	IWM	ETF	62.025	62.095	61.855	61.96	2430000.0
2005-01-19 12:00:00	IWM	ETF	61.97	62.125	61.875	62.125	1054200.0
2005-01-19 13:00:00	IWM	ETF	62.125	62.225	61.965	62.0	953200.0
2005-01-19 14:00:00	IWM	ETF	62.005	62.135	61.96	62.035	1787800.0
2005-01-19 15:00:00	IWM	ETF	62.04	62.07	61.325	61.46	5092800.0
2005-01-19 16:00:00	IWM	ETF	61.44	61.465	61.025	61.025	1027600.0
2005-01-19 17:00:00	IWM	ETF	61.025	61.035	60.875	60.88	7800.0
2005-01-19 18:00:00	IWM	ETF	61.025	61.025	61.025	61.025	600.0
2005-01-19 08:00:00	DIA	ETF	106.12	106.26	106.12	106.23	1800.0
2005-01-19 09:00:00	DIA	ETF	106.2	106.24	106.07	106.17	622700.0
2005-01-19 10:00:00	DIA	ETF	106.18	106.25	105.85	105.93	1049300.0
2005-01-19 11:00:00	DIA	ETF	105.94	106.07	105.88	105.9	366400.0
2005-01-19 12:00:00	DIA	ETF	105.9	106.07	105.79	106.04	605700.0
2005-01-19 13:00:00	DIA	ETF	106.05	106.11	105.84	105.86	814300.0
2005-01-19 14:00:00	DIA	ETF	105.86	106.06	105.8	105.95	549900.0
2005-01-19 15:00:00	DIA	ETF	105.95	105.98	105.38	105.41	2309000.0
2005-01-19 16:00:00	DIA	ETF	105.38	105.39	104.9	104.96	200700.0
2005-01-19 17:00:00	DIA	ETF	104.96	105.39	104.8	105.39	74900.0
2005-01-19 18:00:00	DIA	ETF	104.81	104.99	104.8	104.99	1400.0
2005-01-19 19:00:00	DIA	ETF	105.0	105.0	104.9	104.9	700.0
2005-01-19 09:00:00	GLD	ETF	42.65	42.65	42.56	42.56	254900.0
2005-01-19 10:00:00	GLD	ETF	42.58	42.6	42.45	42.47	210000.0
2005-01-19 11:00:00	GLD	ETF	42.45	42.45	42.35	42.36	159000.0
2005-01-19 12:00:00	GLD	ETF	42.35	42.35	42.24	42.33	417500.0
2005-01-19 13:00:00	GLD	ETF	42.33	42.35	42.23	42.26	172900.0
2005-01-19 14:00:00	GLD	ETF	42.26	42.29	42.2	42.21	205000.0
2005-01-19 15:00:00	GLD	ETF	42.23	42.28	42.2	42.25	158900.0
2005-01-19 08:00:00	TLT	ETF	90.75	91.02	90.71	90.71	71900.0

> showing 50 of 832 rows — these rows as CSV

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