PREVIEW / etf_1hour / 2019-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-30.parquet
  size:    324 KB
  rows:    10,738

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-04-30 04:00:00	SPY	ETF	293.37	293.51	293.37	293.42	3528.0
2019-04-30 05:00:00	SPY	ETF	293.46	293.61	293.46	293.56	10210.0
2019-04-30 06:00:00	SPY	ETF	293.51	293.71	293.43	293.64	58338.0
2019-04-30 07:00:00	SPY	ETF	293.62	293.69	293.55	293.62	98332.0
2019-04-30 08:00:00	SPY	ETF	293.5701	293.86	293.23	293.4	169447.0
2019-04-30 09:00:00	SPY	ETF	293.36	293.53	292.9	293.03	7545542.0
2019-04-30 10:00:00	SPY	ETF	293.02	293.29	292.82	292.84	7643204.0
2019-04-30 11:00:00	SPY	ETF	292.83	293.285	291.92	293.08	12843298.0
2019-04-30 12:00:00	SPY	ETF	293.08	293.41	293.03	293.29	5023894.0
2019-04-30 13:00:00	SPY	ETF	293.2885	293.96	293.23	293.94	9228857.0
2019-04-30 14:00:00	SPY	ETF	293.94	294.0	293.67	293.79	5808107.0
2019-04-30 15:00:00	SPY	ETF	293.79	294.34	293.63	293.97	15347184.0
2019-04-30 16:00:00	SPY	ETF	293.95	294.94	293.8041	294.85	11484582.0
2019-04-30 17:00:00	SPY	ETF	294.86	294.9	294.27	294.78	208764.0
2019-04-30 18:00:00	SPY	ETF	294.79	294.82	294.02	294.74	2406740.0
2019-04-30 19:00:00	SPY	ETF	294.74	294.82	294.57	294.82	53820.0
2019-04-30 04:00:00	QQQ	ETF	189.6	189.71	189.58	189.65	10896.0
2019-04-30 05:00:00	QQQ	ETF	189.71	189.82	189.66	189.8	9339.0
2019-04-30 06:00:00	QQQ	ETF	189.8	189.88	189.75	189.85	13700.0
2019-04-30 07:00:00	QQQ	ETF	189.85	189.9	189.72	189.83	47810.0
2019-04-30 08:00:00	QQQ	ETF	189.78	189.94	189.36	189.38	215838.0
2019-04-30 09:00:00	QQQ	ETF	189.38	189.85	189.12	189.52	3436853.0
2019-04-30 10:00:00	QQQ	ETF	189.53	189.83	188.95	188.9566	3010252.0
2019-04-30 11:00:00	QQQ	ETF	188.955	189.1277	188.21	188.99	5325117.0
2019-04-30 12:00:00	QQQ	ETF	189.0	189.46	188.965	189.3098	1965334.0
2019-04-30 13:00:00	QQQ	ETF	189.299	189.78	189.0661	189.76	2297130.0
2019-04-30 14:00:00	QQQ	ETF	189.77	189.8	189.3999	189.42	1840555.0
2019-04-30 15:00:00	QQQ	ETF	189.43	189.75	189.26	189.55	5152323.0
2019-04-30 16:00:00	QQQ	ETF	189.56	191.05	189.5	190.91	1872039.0
2019-04-30 17:00:00	QQQ	ETF	190.91	190.93	189.54	190.84	101628.0
2019-04-30 18:00:00	QQQ	ETF	190.77	190.84	189.54	190.75	735029.0
2019-04-30 19:00:00	QQQ	ETF	190.76	190.77	190.63	190.77	23545.0
2019-04-30 06:00:00	IWM	ETF	159.25	159.25	159.25	159.25	1000.0
2019-04-30 07:00:00	IWM	ETF	159.19	159.25	159.19	159.25	14600.0
2019-04-30 08:00:00	IWM	ETF	159.35	159.35	159.01	159.07	35484.0
2019-04-30 09:00:00	IWM	ETF	159.03	159.19	158.6316	158.6932	1508379.0
2019-04-30 10:00:00	IWM	ETF	158.71	158.99	158.22	158.25	1885969.0
2019-04-30 11:00:00	IWM	ETF	158.24	158.31	156.96	158.17	3424530.0
2019-04-30 12:00:00	IWM	ETF	158.21	158.42	157.7501	158.05	1184590.0
2019-04-30 13:00:00	IWM	ETF	158.05	158.42	157.8	158.39	1304390.0
2019-04-30 14:00:00	IWM	ETF	158.4	158.415	158.1	158.25	908744.0
2019-04-30 15:00:00	IWM	ETF	158.255	158.45	158.04	158.23	3529233.0
2019-04-30 16:00:00	IWM	ETF	158.23	158.7	158.08	158.53	5885008.0
2019-04-30 17:00:00	IWM	ETF	158.56	158.59	158.51	158.59	7501.0
2019-04-30 18:00:00	IWM	ETF	158.57	158.58	158.29	158.57	46400.0
2019-04-30 19:00:00	IWM	ETF	158.47	158.5	158.46	158.49	2400.0
2019-04-30 04:00:00	DIA	ETF	265.52	265.52	265.52	265.52	200.0
2019-04-30 07:00:00	DIA	ETF	265.73	265.75	265.73	265.75	220.0
2019-04-30 08:00:00	DIA	ETF	265.7101	266.46	265.7101	266.09	14991.0
2019-04-30 09:00:00	DIA	ETF	266.04	266.05	265.12	265.24	282085.0

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

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