PREVIEW / etf_1hour / 2019-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-01.parquet
  size:    341 KB
  rows:    11,167

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
2019-11-01 04:00:00	SPY	ETF	303.82	304.05	303.76	303.86	7265.0
2019-11-01 05:00:00	SPY	ETF	303.9	303.95	303.81	303.85	7010.0
2019-11-01 06:00:00	SPY	ETF	303.92	304.03	303.87	303.97	44219.0
2019-11-01 07:00:00	SPY	ETF	303.97	304.01	303.54	303.61	63194.0
2019-11-01 08:00:00	SPY	ETF	303.8801	304.68	303.33	304.58	1038357.0
2019-11-01 09:00:00	SPY	ETF	304.62	305.39	304.5	305.23	6094696.0
2019-11-01 10:00:00	SPY	ETF	305.24	305.89	304.79	305.63	10021305.0
2019-11-01 11:00:00	SPY	ETF	305.63	305.68	305.35	305.53	9021066.0
2019-11-01 12:00:00	SPY	ETF	305.53	305.545	305.02	305.28	5847308.0
2019-11-01 13:00:00	SPY	ETF	305.28	306.01	305.24	305.85	7464177.0
2019-11-01 14:00:00	SPY	ETF	305.85	305.91	305.6	305.785	5694918.0
2019-11-01 15:00:00	SPY	ETF	305.785	306.19	305.53	306.18	15049411.0
2019-11-01 16:00:00	SPY	ETF	306.18	306.19	305.7505	306.01	8526219.0
2019-11-01 17:00:00	SPY	ETF	306.01	306.14	305.94	306.13	472304.0
2019-11-01 18:00:00	SPY	ETF	306.13	306.17	306.08	306.17	17192.0
2019-11-01 19:00:00	SPY	ETF	306.14	306.19	306.0	306.07	27473.0
2019-11-01 04:00:00	QQQ	ETF	197.45	197.7	197.42	197.51	18414.0
2019-11-01 05:00:00	QQQ	ETF	197.54	197.6	197.5	197.5	11650.0
2019-11-01 06:00:00	QQQ	ETF	197.55	197.6	197.51	197.6	3445.0
2019-11-01 07:00:00	QQQ	ETF	197.59	197.6	197.22	197.23	58082.0
2019-11-01 08:00:00	QQQ	ETF	197.55	197.99	197.17	197.88	364741.0
2019-11-01 09:00:00	QQQ	ETF	197.89	198.42	197.7	198.23	2544744.0
2019-11-01 10:00:00	QQQ	ETF	198.22	198.77	197.93	198.45	3638436.0
2019-11-01 11:00:00	QQQ	ETF	198.45	198.46	198.17	198.255	1190819.0
2019-11-01 12:00:00	QQQ	ETF	198.265	198.27	197.63	197.83	1787819.0
2019-11-01 13:00:00	QQQ	ETF	197.83	198.46	197.8	198.3703	1586935.0
2019-11-01 14:00:00	QQQ	ETF	198.38	198.44	198.26	198.4	1099874.0
2019-11-01 15:00:00	QQQ	ETF	198.41	198.88	198.24	198.87	4900750.0
2019-11-01 16:00:00	QQQ	ETF	198.86	198.93	196.9818	198.82	1388347.0
2019-11-01 17:00:00	QQQ	ETF	198.93	198.93	198.74	198.8	11970.0
2019-11-01 18:00:00	QQQ	ETF	198.85	198.88	198.85	198.88	4530.0
2019-11-01 19:00:00	QQQ	ETF	198.86	198.95	198.79	198.84	3974.0
2019-11-01 04:00:00	IWM	ETF	155.63	155.63	155.63	155.63	107.0
2019-11-01 05:00:00	IWM	ETF	155.7	155.7	155.62	155.62	3432.0
2019-11-01 06:00:00	IWM	ETF	155.71	155.77	155.68	155.77	6000.0
2019-11-01 07:00:00	IWM	ETF	155.74	155.74	155.58	155.58	11500.0
2019-11-01 08:00:00	IWM	ETF	155.63	156.4	155.53	156.22	104091.0
2019-11-01 09:00:00	IWM	ETF	156.16	157.2	156.05	157.2	1725616.0
2019-11-01 10:00:00	IWM	ETF	157.17	157.81	156.905	157.665	3311504.0
2019-11-01 11:00:00	IWM	ETF	157.665	157.98	157.635	157.91	1458859.0
2019-11-01 12:00:00	IWM	ETF	157.91	157.96	157.46	157.66	1453087.0
2019-11-01 13:00:00	IWM	ETF	157.66	158.185	157.65	158.065	1578747.0
2019-11-01 14:00:00	IWM	ETF	158.065	158.09	157.81	157.91	1370143.0
2019-11-01 15:00:00	IWM	ETF	157.92	158.13	157.71	158.07	3529386.0
2019-11-01 16:00:00	IWM	ETF	158.08	158.19	157.97	158.092	742795.0
2019-11-01 17:00:00	IWM	ETF	158.12	158.23	158.06	158.2	37131.0
2019-11-01 18:00:00	IWM	ETF	158.2	158.2	158.1	158.2	74941.0
2019-11-01 19:00:00	IWM	ETF	158.2	158.23	158.13	158.15	2604.0
2019-11-01 04:00:00	DIA	ETF	270.84	271.01	270.84	270.95	1300.0
2019-11-01 06:00:00	DIA	ETF	271.01	271.01	271.01	271.01	100.0

> showing 50 of 11,167 rows — these rows as CSV

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