PREVIEW / etf_1hour / 2005-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-10.parquet
  size:    29 KB
  rows:    822

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-10 08:00:00	SPY	ETF	118.52	118.56	118.47	118.49	60500.0
2005-01-10 09:00:00	SPY	ETF	118.46	118.73	118.34	118.7	7011500.0
2005-01-10 10:00:00	SPY	ETF	118.71	119.22	118.56	119.09	12480600.0
2005-01-10 11:00:00	SPY	ETF	119.09	119.26	119.01	119.13	6044700.0
2005-01-10 12:00:00	SPY	ETF	119.13	119.31	119.06	119.22	4386500.0
2005-01-10 13:00:00	SPY	ETF	119.23	119.46	119.16	119.38	5853300.0
2005-01-10 14:00:00	SPY	ETF	119.39	119.39	119.05	119.11	5479300.0
2005-01-10 15:00:00	SPY	ETF	119.11	119.22	118.59	118.94	12262000.0
2005-01-10 16:00:00	SPY	ETF	118.96	119.05	118.88	119.01	1291100.0
2005-01-10 17:00:00	SPY	ETF	118.98	118.99	118.9	118.99	243500.0
2005-01-10 18:00:00	SPY	ETF	118.99	119.09	118.89	118.96	27300.0
2005-01-10 19:00:00	SPY	ETF	118.94	118.94	118.94	118.94	500.0
2005-01-10 09:00:00	QQQ	ETF	38.45	38.61	38.4	38.58	13549000.0
2005-01-10 10:00:00	QQQ	ETF	38.59	38.8	38.47	38.74	20631500.0
2005-01-10 11:00:00	QQQ	ETF	38.74	38.82	38.65	38.71	8343800.0
2005-01-10 12:00:00	QQQ	ETF	38.71	38.8	38.67	38.76	4316400.0
2005-01-10 13:00:00	QQQ	ETF	38.76	38.87	38.71	38.81	8388800.0
2005-01-10 14:00:00	QQQ	ETF	38.81	38.87	38.67	38.72	9315500.0
2005-01-10 15:00:00	QQQ	ETF	38.72	38.76	38.39	38.51	17661400.0
2005-01-10 08:00:00	IWM	ETF	61.0	61.0	60.965	60.965	4000.0
2005-01-10 09:00:00	IWM	ETF	60.955	61.425	60.9	61.36	3112000.0
2005-01-10 10:00:00	IWM	ETF	61.355	61.765	61.2	61.595	5090000.0
2005-01-10 11:00:00	IWM	ETF	61.585	61.925	61.58	61.82	2252000.0
2005-01-10 12:00:00	IWM	ETF	61.82	61.895	61.675	61.785	1651800.0
2005-01-10 13:00:00	IWM	ETF	61.795	62.1	61.78	62.0	2872800.0
2005-01-10 14:00:00	IWM	ETF	62.005	62.01	61.76	61.865	2228600.0
2005-01-10 15:00:00	IWM	ETF	61.855	61.9492	61.235	61.51	4834000.0
2005-01-10 16:00:00	IWM	ETF	61.5	61.62	61.45	61.615	1043400.0
2005-01-10 17:00:00	IWM	ETF	61.905	61.905	61.905	61.905	2000.0
2005-01-10 18:00:00	IWM	ETF	61.55	61.645	61.55	61.645	1400.0
2005-01-10 19:00:00	IWM	ETF	61.645	61.645	61.645	61.645	600.0
2005-01-10 08:00:00	DIA	ETF	105.98	105.98	105.93	105.93	4400.0
2005-01-10 09:00:00	DIA	ETF	105.92	106.03	105.77	105.97	707900.0
2005-01-10 10:00:00	DIA	ETF	106.02	106.42	105.82	106.29	1188600.0
2005-01-10 11:00:00	DIA	ETF	106.27	106.4	106.23	106.29	390400.0
2005-01-10 12:00:00	DIA	ETF	106.3	106.42	106.29	106.39	678700.0
2005-01-10 13:00:00	DIA	ETF	106.4	106.63	106.35	106.56	545100.0
2005-01-10 14:00:00	DIA	ETF	106.55	106.55	106.29	106.32	650500.0
2005-01-10 15:00:00	DIA	ETF	106.32	106.41	105.87	106.13	1643200.0
2005-01-10 16:00:00	DIA	ETF	106.08	106.2939	106.08	106.22	91900.0
2005-01-10 18:00:00	DIA	ETF	106.23	106.23	106.23	106.23	100.0
2005-01-10 09:00:00	GLD	ETF	41.99	42.07	41.97	42.02	213000.0
2005-01-10 10:00:00	GLD	ETF	42.03	42.05	41.95	42.04	213600.0
2005-01-10 11:00:00	GLD	ETF	42.04	42.06	42.0	42.06	150600.0
2005-01-10 12:00:00	GLD	ETF	42.06	42.06	41.89	41.9	143500.0
2005-01-10 13:00:00	GLD	ETF	41.91	41.97	41.89	41.91	99900.0
2005-01-10 14:00:00	GLD	ETF	41.91	41.97	41.9	41.96	109400.0
2005-01-10 15:00:00	GLD	ETF	41.95	41.98	41.95	41.95	94600.0
2005-01-10 16:00:00	GLD	ETF	42.0	42.0	42.0	42.0	500.0
2005-01-10 17:00:00	GLD	ETF	41.95	41.95	41.95	41.95	300.0

> showing 50 of 822 rows — these rows as CSV

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