PREVIEW / etf_1hour / 2019-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-03.parquet
  size:    318 KB
  rows:    10,477

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-05-03 04:00:00	SPY	ETF	291.97	292.29	291.97	292.16	6402.0
2019-05-03 05:00:00	SPY	ETF	292.19	292.26	291.95	291.96	13290.0
2019-05-03 06:00:00	SPY	ETF	291.96	292.09	291.91	291.94	49773.0
2019-05-03 07:00:00	SPY	ETF	291.94	292.19	291.89	292.14	61363.0
2019-05-03 08:00:00	SPY	ETF	292.02	292.83	291.65	292.73	1544460.0
2019-05-03 09:00:00	SPY	ETF	292.75	293.14	292.51	293.05	6939605.0
2019-05-03 10:00:00	SPY	ETF	293.04	293.39	292.58	293.37	7543424.0
2019-05-03 11:00:00	SPY	ETF	293.37	293.7	293.19	293.575	5251377.0
2019-05-03 12:00:00	SPY	ETF	293.5701	294.03	293.53	293.9	4288825.0
2019-05-03 13:00:00	SPY	ETF	293.9	294.34	293.8	294.19	3782650.0
2019-05-03 14:00:00	SPY	ETF	294.18	294.19	293.91	293.98	3241134.0
2019-05-03 15:00:00	SPY	ETF	293.97	294.2	293.75	294.02	14609624.0
2019-05-03 16:00:00	SPY	ETF	294.02	294.4536	293.65	294.35	7083574.0
2019-05-03 17:00:00	SPY	ETF	294.35	294.38	294.03	294.22	734211.0
2019-05-03 18:00:00	SPY	ETF	294.23	294.25	294.03	294.22	7265.0
2019-05-03 19:00:00	SPY	ETF	294.23	294.34	294.22	294.34	21695.0
2019-05-03 04:00:00	QQQ	ETF	189.05	189.2	189.05	189.14	14336.0
2019-05-03 05:00:00	QQQ	ETF	189.13	189.2	189.02	189.02	11175.0
2019-05-03 06:00:00	QQQ	ETF	189.05	189.24	189.0	189.11	20783.0
2019-05-03 07:00:00	QQQ	ETF	189.11	189.34	189.08	189.31	110661.0
2019-05-03 08:00:00	QQQ	ETF	189.11	189.69	188.81	189.65	1627688.0
2019-05-03 09:00:00	QQQ	ETF	189.67	189.97	189.33	189.91	3250007.0
2019-05-03 10:00:00	QQQ	ETF	189.915	190.58	189.7299	190.55	3749375.0
2019-05-03 11:00:00	QQQ	ETF	190.56	190.83	190.32	190.485	3727315.0
2019-05-03 12:00:00	QQQ	ETF	190.48	190.88	190.37	190.72	2151106.0
2019-05-03 13:00:00	QQQ	ETF	190.73	191.25	190.68	191.12	2629302.0
2019-05-03 14:00:00	QQQ	ETF	191.11	191.13	190.86	190.9	2146243.0
2019-05-03 15:00:00	QQQ	ETF	190.9	191.22	190.71	191.12	5306054.0
2019-05-03 16:00:00	QQQ	ETF	191.11	191.46	191.09	191.46	1159642.0
2019-05-03 17:00:00	QQQ	ETF	191.4	191.45	191.11	191.36	22853.0
2019-05-03 18:00:00	QQQ	ETF	191.36	191.41	191.35	191.36	8157.0
2019-05-03 19:00:00	QQQ	ETF	191.37	191.41	191.36	191.36	8117.0
2019-05-03 04:00:00	IWM	ETF	158.0	158.0	158.0	158.0	300.0
2019-05-03 05:00:00	IWM	ETF	158.02	158.05	157.94	157.94	2200.0
2019-05-03 06:00:00	IWM	ETF	157.91	157.97	157.89	157.89	4084.0
2019-05-03 07:00:00	IWM	ETF	157.9	158.05	157.9	158.0	35511.0
2019-05-03 08:00:00	IWM	ETF	158.05	158.3	157.75	158.24	207777.0
2019-05-03 09:00:00	IWM	ETF	158.24	159.27	158.1	159.06	2795889.0
2019-05-03 10:00:00	IWM	ETF	159.03	159.33	158.68	159.11	2298805.0
2019-05-03 11:00:00	IWM	ETF	159.11	159.57	159.08	159.35	2567372.0
2019-05-03 12:00:00	IWM	ETF	159.34	159.83	159.29	159.69	1648598.0
2019-05-03 13:00:00	IWM	ETF	159.695	160.28	159.6	160.17	1522333.0
2019-05-03 14:00:00	IWM	ETF	160.17	160.39	160.05	160.19	2383834.0
2019-05-03 15:00:00	IWM	ETF	160.2	160.64	160.07	160.53	3731704.0
2019-05-03 16:00:00	IWM	ETF	160.53	160.75	160.43	160.71	1436456.0
2019-05-03 17:00:00	IWM	ETF	160.66	160.73	160.64	160.64	16804.0
2019-05-03 18:00:00	IWM	ETF	160.7	160.7	160.7	160.7	100.0
2019-05-03 19:00:00	IWM	ETF	160.69	160.72	160.67	160.7	7185.0
2019-05-03 04:00:00	DIA	ETF	263.44	263.56	263.44	263.56	300.0
2019-05-03 07:00:00	DIA	ETF	263.59	263.64	263.59	263.64	310.0

> showing 50 of 10,477 rows — these rows as CSV

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