PREVIEW / etf_1hour / 2009-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-02.parquet
  size:    137 KB
  rows:    4,239

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
2009-07-02 04:00:00	SPY	ETF	91.88	91.9	91.87	91.9	20418.0
2009-07-02 05:00:00	SPY	ETF	91.86	91.99	91.86	91.9	3200.0
2009-07-02 06:00:00	SPY	ETF	91.84	91.85	91.67	91.68	46600.0
2009-07-02 07:00:00	SPY	ETF	91.72	92.0	91.7	92.0	866145.0
2009-07-02 08:00:00	SPY	ETF	91.99	91.99	90.96	91.14	15069593.0
2009-07-02 09:00:00	SPY	ETF	91.14	91.16	90.34	90.48	31528253.0
2009-07-02 10:00:00	SPY	ETF	90.48	90.6591	90.18	90.445	32438640.0
2009-07-02 11:00:00	SPY	ETF	90.43	90.52	90.09	90.26	19064286.0
2009-07-02 12:00:00	SPY	ETF	90.26	90.36	90.15	90.21	11351879.0
2009-07-02 13:00:00	SPY	ETF	90.21	90.36	90.1	90.2001	12920452.0
2009-07-02 14:00:00	SPY	ETF	90.2	90.3	90.115	90.22	12797714.0
2009-07-02 15:00:00	SPY	ETF	90.23	90.28	89.76	89.82	41469132.0
2009-07-02 16:00:00	SPY	ETF	89.81	92.3631	89.35	89.47	23782750.0
2009-07-02 17:00:00	SPY	ETF	89.47	91.11	89.38	89.39	988023.0
2009-07-02 18:00:00	SPY	ETF	89.42	89.59	89.39	89.59	604581.0
2009-07-02 19:00:00	SPY	ETF	89.59	89.7	89.57	89.63	113045.0
2009-07-02 04:00:00	QQQ	ETF	36.25	36.25	36.25	36.25	100.0
2009-07-02 05:00:00	QQQ	ETF	36.22	36.22	36.22	36.22	1364.0
2009-07-02 06:00:00	QQQ	ETF	36.2	36.2	36.2	36.2	2450.0
2009-07-02 07:00:00	QQQ	ETF	36.17	36.28	36.17	36.28	110820.0
2009-07-02 08:00:00	QQQ	ETF	36.28	36.37	36.06	36.13	4934577.0
2009-07-02 09:00:00	QQQ	ETF	36.13	36.14	35.61	35.65	22074134.0
2009-07-02 10:00:00	QQQ	ETF	35.65	35.74	35.5	35.69	21126464.0
2009-07-02 11:00:00	QQQ	ETF	35.68	35.71	35.53	35.629	10169132.0
2009-07-02 12:00:00	QQQ	ETF	35.62	35.67	35.57	35.625	4593266.0
2009-07-02 13:00:00	QQQ	ETF	35.64	35.7	35.62	35.6499	6397220.0
2009-07-02 14:00:00	QQQ	ETF	35.64	35.74	35.64	35.71	6263578.0
2009-07-02 15:00:00	QQQ	ETF	35.71	35.73	35.57	35.59	19814611.0
2009-07-02 16:00:00	QQQ	ETF	35.6	36.4342	35.4	35.45	12405847.0
2009-07-02 17:00:00	QQQ	ETF	35.44	36.4342	35.41	35.46	1207688.0
2009-07-02 18:00:00	QQQ	ETF	35.46	35.57	35.44	35.5	50119.0
2009-07-02 19:00:00	QQQ	ETF	35.49	35.5	35.47	35.48	153712.0
2009-07-02 06:00:00	IWM	ETF	51.15	51.17	51.15	51.17	1100.0
2009-07-02 07:00:00	IWM	ETF	51.17	51.37	51.17	51.36	39818.0
2009-07-02 08:00:00	IWM	ETF	51.34	51.38	50.7	50.77	1639575.0
2009-07-02 09:00:00	IWM	ETF	50.77	50.89	50.04	50.2	10477968.0
2009-07-02 10:00:00	IWM	ETF	50.2	50.26	49.88	50.0	9055733.0
2009-07-02 11:00:00	IWM	ETF	50.0	50.15	49.9699	50.07	4678572.0
2009-07-02 12:00:00	IWM	ETF	50.06	50.12	49.935	49.96	2268874.0
2009-07-02 13:00:00	IWM	ETF	49.96	50.06	49.94	49.99	2837220.0
2009-07-02 14:00:00	IWM	ETF	49.98	50.04	49.87	49.99	3152979.0
2009-07-02 15:00:00	IWM	ETF	49.99	50.02	49.69	49.99	9439326.0
2009-07-02 16:00:00	IWM	ETF	49.99	51.7214	49.67	49.77	5704799.0
2009-07-02 17:00:00	IWM	ETF	49.81	49.93	49.75	49.93	10300.0
2009-07-02 18:00:00	IWM	ETF	49.91	49.92	49.81	49.92	5900.0
2009-07-02 19:00:00	IWM	ETF	49.9	49.9	49.89	49.89	1700.0
2009-07-02 06:00:00	DIA	ETF	84.53	84.53	84.53	84.53	500.0
2009-07-02 07:00:00	DIA	ETF	84.55	84.75	84.55	84.75	1000.0
2009-07-02 08:00:00	DIA	ETF	84.71	84.73	83.83	83.97	132549.0
2009-07-02 09:00:00	DIA	ETF	83.95	84.04	83.35	83.47	3103610.0

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

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