PREVIEW / etf_1hour / 2019-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-29.parquet
  size:    323 KB
  rows:    10,672

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-29 04:00:00	SPY	ETF	293.56	293.89	293.56	293.69	4880.0
2019-04-29 05:00:00	SPY	ETF	293.4	293.46	293.36	293.42	1511.0
2019-04-29 06:00:00	SPY	ETF	293.38	293.46	293.17	293.21	15573.0
2019-04-29 07:00:00	SPY	ETF	293.21	293.31	293.06	293.29	27911.0
2019-04-29 08:00:00	SPY	ETF	293.19	293.57	293.14	293.45	135135.0
2019-04-29 09:00:00	SPY	ETF	293.47	294.07	293.37	293.77	4935061.0
2019-04-29 10:00:00	SPY	ETF	293.78	294.13	293.41	293.91	15027076.0
2019-04-29 11:00:00	SPY	ETF	293.92	294.04	293.71	293.81	4658130.0
2019-04-29 12:00:00	SPY	ETF	293.815	294.3	293.71	294.24	5556523.0
2019-04-29 13:00:00	SPY	ETF	294.24	294.25	294.06	294.2	5741836.0
2019-04-29 14:00:00	SPY	ETF	294.205	294.45	294.13	294.18	6147551.0
2019-04-29 15:00:00	SPY	ETF	294.19	294.29	293.76	293.81	7111218.0
2019-04-29 16:00:00	SPY	ETF	293.81	293.87	293.44	293.58	5837052.0
2019-04-29 17:00:00	SPY	ETF	293.6	294.0154	293.45	293.54	973388.0
2019-04-29 18:00:00	SPY	ETF	293.58	293.59	293.44	293.5	56235.0
2019-04-29 19:00:00	SPY	ETF	293.5	293.53	293.4	293.41	72832.0
2019-04-29 04:00:00	QQQ	ETF	190.89	191.08	190.89	190.92	22514.0
2019-04-29 05:00:00	QQQ	ETF	190.89	190.93	190.56	190.64	15527.0
2019-04-29 06:00:00	QQQ	ETF	190.59	190.69	190.44	190.45	16384.0
2019-04-29 07:00:00	QQQ	ETF	190.44	190.58	190.37	190.5	33382.0
2019-04-29 08:00:00	QQQ	ETF	190.47	190.98	190.39	190.6	477612.0
2019-04-29 09:00:00	QQQ	ETF	190.6	190.93	190.41	190.6515	2776476.0
2019-04-29 10:00:00	QQQ	ETF	190.665	191.109	190.34	190.98	2588113.0
2019-04-29 11:00:00	QQQ	ETF	190.975	191.09	190.73	190.76	1590792.0
2019-04-29 12:00:00	QQQ	ETF	190.75	191.18	190.69	191.08	1585481.0
2019-04-29 13:00:00	QQQ	ETF	191.08	191.11	190.885	191.02	1066946.0
2019-04-29 14:00:00	QQQ	ETF	191.03	191.32	191.01	191.24	1959831.0
2019-04-29 15:00:00	QQQ	ETF	191.25	191.265	190.85	191.0	3265021.0
2019-04-29 16:00:00	QQQ	ETF	191.0	191.11	189.81	189.84	2299247.0
2019-04-29 17:00:00	QQQ	ETF	189.93	190.03	189.77	189.8	41030.0
2019-04-29 18:00:00	QQQ	ETF	189.77	191.02	189.73	189.83	43932.0
2019-04-29 19:00:00	QQQ	ETF	189.83	189.85	189.71	189.72	37840.0
2019-04-29 04:00:00	IWM	ETF	158.63	158.63	158.63	158.63	1221.0
2019-04-29 05:00:00	IWM	ETF	158.29	158.29	158.29	158.29	200.0
2019-04-29 06:00:00	IWM	ETF	158.3	158.3	158.13	158.13	2200.0
2019-04-29 07:00:00	IWM	ETF	158.13	158.3	158.13	158.3	7804.0
2019-04-29 08:00:00	IWM	ETF	158.3199	158.46	158.27	158.44	13962.0
2019-04-29 09:00:00	IWM	ETF	158.43	159.17	158.42	158.95	1783114.0
2019-04-29 10:00:00	IWM	ETF	158.95	159.29	158.49	159.27	2683590.0
2019-04-29 11:00:00	IWM	ETF	159.28	159.39	159.04	159.12	1408653.0
2019-04-29 12:00:00	IWM	ETF	159.12	159.61	158.99	159.47	1427264.0
2019-04-29 13:00:00	IWM	ETF	159.48	159.48	159.18	159.3	719628.0
2019-04-29 14:00:00	IWM	ETF	159.3075	159.49	159.22	159.31	1172841.0
2019-04-29 15:00:00	IWM	ETF	159.31	159.35	158.97	159.03	2345263.0
2019-04-29 16:00:00	IWM	ETF	159.06	159.15	158.97	159.11	346576.0
2019-04-29 17:00:00	IWM	ETF	159.05	159.07	159.05	159.05	1674.0
2019-04-29 18:00:00	IWM	ETF	159.14	159.14	159.02	159.03	3800.0
2019-04-29 19:00:00	IWM	ETF	159.03	159.07	159.01	159.01	7725.0
2019-04-29 04:00:00	DIA	ETF	265.62	265.62	265.62	265.62	100.0
2019-04-29 07:00:00	DIA	ETF	265.07	265.1	264.99	264.99	527.0

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

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