PREVIEW / etf_1hour / 2019-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-01.parquet
  size:    327 KB
  rows:    10,889

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-01 04:00:00	SPY	ETF	295.27	295.38	295.22	295.22	5220.0
2019-05-01 05:00:00	SPY	ETF	295.21	295.23	295.14	295.15	4065.0
2019-05-01 06:00:00	SPY	ETF	295.13	295.13	294.95	294.95	9596.0
2019-05-01 07:00:00	SPY	ETF	294.93	295.15	294.85	295.05	119844.0
2019-05-01 08:00:00	SPY	ETF	295.0601	295.25	294.85	294.95	590333.0
2019-05-01 09:00:00	SPY	ETF	294.95	294.95	294.33	294.47	5255099.0
2019-05-01 10:00:00	SPY	ETF	294.47	294.64	294.0	294.31	6052783.0
2019-05-01 11:00:00	SPY	ETF	294.305	294.92	294.22	294.66	5310451.0
2019-05-01 12:00:00	SPY	ETF	294.66	294.69	293.68	294.06	5919196.0
2019-05-01 13:00:00	SPY	ETF	294.07	294.44	293.87	294.35	4287730.0
2019-05-01 14:00:00	SPY	ETF	294.35	294.95	293.27	293.78	12630989.0
2019-05-01 15:00:00	SPY	ETF	293.78	293.98	291.8	291.84	19971305.0
2019-05-01 16:00:00	SPY	ETF	291.83	294.0839	291.02	291.06	9777707.0
2019-05-01 17:00:00	SPY	ETF	291.09	291.81	290.79	290.93	390923.0
2019-05-01 18:00:00	SPY	ETF	290.98	291.32	290.91	291.26	209165.0
2019-05-01 19:00:00	SPY	ETF	291.26	291.5	291.26	291.38	81017.0
2019-05-01 04:00:00	QQQ	ETF	191.05	191.17	191.05	191.12	7127.0
2019-05-01 05:00:00	QQQ	ETF	191.1	191.11	191.02	191.07	5794.0
2019-05-01 06:00:00	QQQ	ETF	191.04	191.06	190.91	190.91	14450.0
2019-05-01 07:00:00	QQQ	ETF	190.91	191.04	190.86	190.9	81529.0
2019-05-01 08:00:00	QQQ	ETF	190.8899	191.08	190.82	190.88	156841.0
2019-05-01 09:00:00	QQQ	ETF	190.85	190.89	190.45	190.63	3043755.0
2019-05-01 10:00:00	QQQ	ETF	190.63	191.02	190.26	190.72	2634300.0
2019-05-01 11:00:00	QQQ	ETF	190.72	191.29	190.64	191.06	2099336.0
2019-05-01 12:00:00	QQQ	ETF	191.0825	191.13	190.3234	190.52	2189060.0
2019-05-01 13:00:00	QQQ	ETF	190.53	190.83	190.45	190.8055	2185125.0
2019-05-01 14:00:00	QQQ	ETF	190.77	191.32	190.06	190.42	6589663.0
2019-05-01 15:00:00	QQQ	ETF	190.42	190.51	188.795	188.83	7620406.0
2019-05-01 16:00:00	QQQ	ETF	188.84	189.1556	188.16	188.17	1257069.0
2019-05-01 17:00:00	QQQ	ETF	188.25	188.35	188.15	188.15	50617.0
2019-05-01 18:00:00	QQQ	ETF	188.25	188.39	188.04	188.34	93303.0
2019-05-01 19:00:00	QQQ	ETF	188.34	188.55	188.34	188.49	39220.0
2019-05-01 06:00:00	IWM	ETF	158.79	158.79	158.69	158.69	4000.0
2019-05-01 07:00:00	IWM	ETF	158.66	158.78	158.66	158.73	5736.0
2019-05-01 08:00:00	IWM	ETF	158.7799	158.91	158.7	158.75	84840.0
2019-05-01 09:00:00	IWM	ETF	158.71	158.74	158.14	158.43	2251693.0
2019-05-01 10:00:00	IWM	ETF	158.41	158.44	157.68	157.79	1933997.0
2019-05-01 11:00:00	IWM	ETF	157.79	158.68	157.68	158.53	1498689.0
2019-05-01 12:00:00	IWM	ETF	158.55	158.58	157.41	157.79	2030775.0
2019-05-01 13:00:00	IWM	ETF	157.79	158.26	157.5	158.16	1416016.0
2019-05-01 14:00:00	IWM	ETF	158.19	158.56	157.57	158.0	2284254.0
2019-05-01 15:00:00	IWM	ETF	157.99	158.07	156.71	156.74	4377056.0
2019-05-01 16:00:00	IWM	ETF	156.74	156.79	156.27	156.28	823225.0
2019-05-01 17:00:00	IWM	ETF	156.26	156.48	156.26	156.31	3674.0
2019-05-01 18:00:00	IWM	ETF	156.31	156.79	156.22	156.41	24800.0
2019-05-01 19:00:00	IWM	ETF	156.42	156.55	156.42	156.51	8087.0
2019-05-01 04:00:00	DIA	ETF	266.96	266.96	266.96	266.96	100.0
2019-05-01 06:00:00	DIA	ETF	266.68	266.76	266.68	266.76	200.0
2019-05-01 07:00:00	DIA	ETF	266.54	266.8	266.51	266.77	1242.0
2019-05-01 08:00:00	DIA	ETF	266.9	266.91	266.72	266.72	14475.0

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

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