PREVIEW / etf_1hour / 2008-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-24.parquet
  size:    79 KB
  rows:    2,293

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
2008-12-24 04:00:00	SPY	ETF	86.15	86.15	86.12	86.12	500.0
2008-12-24 05:00:00	SPY	ETF	86.18	86.19	86.15	86.19	400.0
2008-12-24 06:00:00	SPY	ETF	86.24	86.3	86.2	86.2	5500.0
2008-12-24 07:00:00	SPY	ETF	86.19	86.21	85.88	85.88	53318.0
2008-12-24 08:00:00	SPY	ETF	85.88	86.4	85.84	86.4	650671.0
2008-12-24 09:00:00	SPY	ETF	86.38	86.58	86.12	86.13	16466192.0
2008-12-24 10:00:00	SPY	ETF	86.13	86.7	86.0	86.55	17902337.0
2008-12-24 11:00:00	SPY	ETF	86.54	86.77	86.43	86.65	11121497.0
2008-12-24 12:00:00	SPY	ETF	86.65	86.87	86.5	86.64	14530943.0
2008-12-24 13:00:00	SPY	ETF	86.63	86.76	86.4869	86.55	1089040.0
2008-12-24 14:00:00	SPY	ETF	86.53	86.67	86.52	86.52	20800.0
2008-12-24 15:00:00	SPY	ETF	86.51	86.56	86.45	86.56	8032.0
2008-12-24 16:00:00	SPY	ETF	86.59	86.63	86.59	86.63	1600.0
2008-12-24 04:00:00	QQQ	ETF	29.16	29.16	29.08	29.1	600.0
2008-12-24 06:00:00	QQQ	ETF	29.14	29.14	29.14	29.14	100.0
2008-12-24 07:00:00	QQQ	ETF	29.1	29.12	29.05	29.05	23433.0
2008-12-24 08:00:00	QQQ	ETF	29.06	29.2	29.05	29.18	743093.0
2008-12-24 09:00:00	QQQ	ETF	29.17	29.21	29.01	29.03	4363248.0
2008-12-24 10:00:00	QQQ	ETF	29.03	29.2	28.98	29.12	6653723.0
2008-12-24 11:00:00	QQQ	ETF	29.12	29.17	29.06	29.1	4193296.0
2008-12-24 12:00:00	QQQ	ETF	29.105	29.18	29.04	29.09	5380022.0
2008-12-24 13:00:00	QQQ	ETF	29.09	29.14	28.95	28.99	300766.0
2008-12-24 14:00:00	QQQ	ETF	29.03	29.03	28.97	28.97	7300.0
2008-12-24 15:00:00	QQQ	ETF	28.97	29.01	28.97	29.01	4030.0
2008-12-24 16:00:00	QQQ	ETF	29.03	29.05	29.01	29.05	6774.0
2008-12-24 04:00:00	IWM	ETF	46.53	46.53	46.53	46.53	100.0
2008-12-24 05:00:00	IWM	ETF	46.46	46.46	46.46	46.46	100.0
2008-12-24 06:00:00	IWM	ETF	46.53	46.53	46.53	46.53	100.0
2008-12-24 07:00:00	IWM	ETF	46.46	46.48	46.37	46.37	724.0
2008-12-24 08:00:00	IWM	ETF	46.31	46.94	46.25	46.6	79773.0
2008-12-24 09:00:00	IWM	ETF	46.6	46.83	46.25	46.32	3428624.0
2008-12-24 10:00:00	IWM	ETF	46.32	46.83	46.16	46.72	5928795.0
2008-12-24 11:00:00	IWM	ETF	46.7275	47.11	46.67	46.96	4212285.0
2008-12-24 12:00:00	IWM	ETF	46.96	47.07	46.75	46.78	4307451.0
2008-12-24 13:00:00	IWM	ETF	46.76	47.21	46.76	46.92	527356.0
2008-12-24 15:00:00	IWM	ETF	46.7044	46.7044	46.7044	46.7044	100000.0
2008-12-24 06:00:00	DIA	ETF	84.24	84.32	84.24	84.24	300.0
2008-12-24 07:00:00	DIA	ETF	84.2	84.2	83.98	83.98	300.0
2008-12-24 08:00:00	DIA	ETF	83.97	84.46	83.97	84.46	12202.0
2008-12-24 09:00:00	DIA	ETF	84.47	84.6	84.26	84.28	708136.0
2008-12-24 10:00:00	DIA	ETF	84.28	84.63	84.141	84.48	1031379.0
2008-12-24 11:00:00	DIA	ETF	84.49	84.81	84.42	84.63	834924.0
2008-12-24 12:00:00	DIA	ETF	84.629	84.93	84.52	84.56	1370743.0
2008-12-24 13:00:00	DIA	ETF	84.56	84.8	84.46	84.68	142618.0
2008-12-24 15:00:00	DIA	ETF	84.5	84.5	84.32	84.32	1050.0
2008-12-24 05:00:00	GLD	ETF	82.8	82.8	82.8	82.8	300.0
2008-12-24 07:00:00	GLD	ETF	82.4	82.4	82.4	82.4	600.0
2008-12-24 08:00:00	GLD	ETF	82.4	82.49	82.19	82.49	10563.0
2008-12-24 09:00:00	GLD	ETF	82.5	82.95	82.46	82.8	303694.0
2008-12-24 10:00:00	GLD	ETF	82.82	83.1	82.81	82.92	691940.0

> showing 50 of 2,293 rows — these rows as CSV

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