PREVIEW / etf_1hour / 2008-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-31.parquet
  size:    131 KB
  rows:    4,010

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-31 04:00:00	SPY	ETF	88.98	89.04	88.94	89.04	2100.0
2008-12-31 05:00:00	SPY	ETF	89.11	89.45	89.11	89.44	600.0
2008-12-31 06:00:00	SPY	ETF	89.48	89.6	89.43	89.43	1552.0
2008-12-31 07:00:00	SPY	ETF	89.48	89.48	89.13	89.18	364246.0
2008-12-31 08:00:00	SPY	ETF	89.19	89.47	89.04	89.33	1840214.0
2008-12-31 09:00:00	SPY	ETF	89.33	89.5	88.87	89.41	16555650.0
2008-12-31 10:00:00	SPY	ETF	89.41	89.86	89.4	89.78	24931328.0
2008-12-31 11:00:00	SPY	ETF	89.78	90.14	89.68	89.97	22668360.0
2008-12-31 12:00:00	SPY	ETF	89.97	90.18	89.84	90.12	12951414.0
2008-12-31 13:00:00	SPY	ETF	90.12	90.27	89.72	90.19	15474342.0
2008-12-31 14:00:00	SPY	ETF	90.18	90.6	90.04	90.46	24107721.0
2008-12-31 15:00:00	SPY	ETF	90.47	90.97	90.04	90.24	57818847.0
2008-12-31 16:00:00	SPY	ETF	90.24	90.585	89.36	89.51	16455003.0
2008-12-31 17:00:00	SPY	ETF	89.51	90.24	89.48	89.55	141665.0
2008-12-31 18:00:00	SPY	ETF	89.6	89.64	89.6	89.62	29081.0
2008-12-31 19:00:00	SPY	ETF	89.62	89.68	89.6	89.68	54019.0
2008-12-31 04:00:00	QQQ	ETF	29.5	29.52	29.5	29.52	200.0
2008-12-31 05:00:00	QQQ	ETF	29.53	29.64	29.53	29.64	600.0
2008-12-31 06:00:00	QQQ	ETF	29.71	29.71	29.71	29.71	5000.0
2008-12-31 07:00:00	QQQ	ETF	29.68	29.68	29.55	29.55	233253.0
2008-12-31 08:00:00	QQQ	ETF	29.58	29.64	29.49	29.58	1163049.0
2008-12-31 09:00:00	QQQ	ETF	29.59	29.78	29.45	29.72	11582208.0
2008-12-31 10:00:00	QQQ	ETF	29.73	29.88	29.7275	29.8599	9317023.0
2008-12-31 11:00:00	QQQ	ETF	29.86	29.98	29.81	29.918	8336329.0
2008-12-31 12:00:00	QQQ	ETF	29.92	29.97	29.85	29.95	6294843.0
2008-12-31 13:00:00	QQQ	ETF	29.96	29.99	29.86	29.97	8005848.0
2008-12-31 14:00:00	QQQ	ETF	29.97	30.08	29.87	29.99	10306903.0
2008-12-31 15:00:00	QQQ	ETF	30.0	30.06	29.71	29.74	25650494.0
2008-12-31 16:00:00	QQQ	ETF	29.74	29.8574	29.42	29.65	5574239.0
2008-12-31 17:00:00	QQQ	ETF	29.63	29.63	29.48	29.59	133912.0
2008-12-31 18:00:00	QQQ	ETF	29.58	29.6	29.54	29.6	10410.0
2008-12-31 19:00:00	QQQ	ETF	29.61	29.65	29.6	29.63	19869.0
2008-12-31 06:00:00	IWM	ETF	48.55	48.55	48.55	48.55	100.0
2008-12-31 07:00:00	IWM	ETF	48.53	48.56	48.41	48.42	7845.0
2008-12-31 08:00:00	IWM	ETF	48.43	48.57	48.35	48.47	96010.0
2008-12-31 09:00:00	IWM	ETF	48.47	48.9	48.14	48.89	7967534.0
2008-12-31 10:00:00	IWM	ETF	48.89	49.05	48.64	48.91	6515173.0
2008-12-31 11:00:00	IWM	ETF	48.92	49.23	48.84	48.96	4239081.0
2008-12-31 12:00:00	IWM	ETF	48.95	49.17	48.7601	49.06	3628441.0
2008-12-31 13:00:00	IWM	ETF	49.05	49.22	48.75	49.13	4409101.0
2008-12-31 14:00:00	IWM	ETF	49.14	49.57	49.11	49.57	9955048.0
2008-12-31 15:00:00	IWM	ETF	49.57	50.32	49.34	49.43	31490576.0
2008-12-31 16:00:00	IWM	ETF	49.43	49.82	48.81	49.27	6731453.0
2008-12-31 17:00:00	IWM	ETF	49.39	49.39	49.24	49.24	560.0
2008-12-31 18:00:00	IWM	ETF	49.21	49.21	49.2	49.2	1000.0
2008-12-31 06:00:00	DIA	ETF	86.98	87.1	86.98	87.01	400.0
2008-12-31 07:00:00	DIA	ETF	86.95	87.05	86.92	86.97	4593.0
2008-12-31 08:00:00	DIA	ETF	86.94	87.04	86.78	87.01	33851.0
2008-12-31 09:00:00	DIA	ETF	87.02	87.14	86.63	87.05	2019891.0
2008-12-31 10:00:00	DIA	ETF	87.07	87.44	87.07	87.35	2324131.0

> showing 50 of 4,010 rows — these rows as CSV

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