PREVIEW / etf_1hour / 2019-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-26.parquet
  size:    327 KB
  rows:    10,907

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-06-26 04:00:00	SPY	ETF	291.11	291.32	290.97	291.29	7694.0
2019-06-26 05:00:00	SPY	ETF	291.33	292.47	291.33	292.24	94487.0
2019-06-26 06:00:00	SPY	ETF	292.24	292.5	292.04	292.08	97589.0
2019-06-26 07:00:00	SPY	ETF	292.08	292.2	291.97	292.07	281748.0
2019-06-26 08:00:00	SPY	ETF	292.11	292.18	290.96	291.62	723863.0
2019-06-26 09:00:00	SPY	ETF	291.61	292.31	291.37	291.58	6540075.0
2019-06-26 10:00:00	SPY	ETF	291.56	291.78	291.04	291.62	5486877.0
2019-06-26 11:00:00	SPY	ETF	291.61	291.81	291.11	291.46	3235626.0
2019-06-26 12:00:00	SPY	ETF	291.46	291.68	291.14	291.49	3295261.0
2019-06-26 13:00:00	SPY	ETF	291.49	291.52	290.7	290.9733	3653686.0
2019-06-26 14:00:00	SPY	ETF	290.97	291.15	290.345	290.7193	6832949.0
2019-06-26 15:00:00	SPY	ETF	290.715	291.06	290.4	290.47	12916073.0
2019-06-26 16:00:00	SPY	ETF	290.48	290.6	290.1	290.17	5287169.0
2019-06-26 17:00:00	SPY	ETF	290.17	290.47	290.07	290.09	125950.0
2019-06-26 18:00:00	SPY	ETF	290.14	290.36	290.11	290.2	101072.0
2019-06-26 19:00:00	SPY	ETF	290.2	290.49	290.18	290.46	48082.0
2019-06-26 04:00:00	QQQ	ETF	185.35	185.57	185.3	185.57	21600.0
2019-06-26 05:00:00	QQQ	ETF	185.6	186.69	185.6	186.55	107674.0
2019-06-26 06:00:00	QQQ	ETF	186.55	186.82	186.37	186.45	40257.0
2019-06-26 07:00:00	QQQ	ETF	186.43	186.52	186.25	186.36	114038.0
2019-06-26 08:00:00	QQQ	ETF	186.47	186.51	185.01	185.86	497289.0
2019-06-26 09:00:00	QQQ	ETF	185.8	187.33	185.78	187.0001	4934221.0
2019-06-26 10:00:00	QQQ	ETF	187.01	187.04	186.36	186.58	2889608.0
2019-06-26 11:00:00	QQQ	ETF	186.57	186.64	186.14	186.55	1499658.0
2019-06-26 12:00:00	QQQ	ETF	186.55	186.68	186.23	186.39	1174000.0
2019-06-26 13:00:00	QQQ	ETF	186.383	186.42	185.6	185.835	1564075.0
2019-06-26 14:00:00	QQQ	ETF	185.84	186.02	185.49	185.73	1361847.0
2019-06-26 15:00:00	QQQ	ETF	185.71	186.08	185.71	185.78	2697213.0
2019-06-26 16:00:00	QQQ	ETF	185.77	185.82	185.43	185.48	1688732.0
2019-06-26 17:00:00	QQQ	ETF	185.55	185.55	185.41	185.41	17709.0
2019-06-26 18:00:00	QQQ	ETF	185.44	185.61	185.44	185.51	22659.0
2019-06-26 19:00:00	QQQ	ETF	185.51	185.73	185.51	185.73	27799.0
2019-06-26 04:00:00	IWM	ETF	151.19	151.19	151.19	151.19	1000.0
2019-06-26 05:00:00	IWM	ETF	151.37	152.0	151.37	151.98	16604.0
2019-06-26 06:00:00	IWM	ETF	151.98	152.11	151.9	151.93	4800.0
2019-06-26 07:00:00	IWM	ETF	151.9	151.97	151.85	151.95	23891.0
2019-06-26 08:00:00	IWM	ETF	151.89	152.0	151.49	151.67	110701.0
2019-06-26 09:00:00	IWM	ETF	151.66	152.22	151.35	151.43	2109257.0
2019-06-26 10:00:00	IWM	ETF	151.42	151.7799	151.0	151.54	2159190.0
2019-06-26 11:00:00	IWM	ETF	151.54	151.83	151.23	151.45	1672886.0
2019-06-26 12:00:00	IWM	ETF	151.46	151.53	151.09	151.15	1159678.0
2019-06-26 13:00:00	IWM	ETF	151.15	151.22	150.89	151.15	1741487.0
2019-06-26 14:00:00	IWM	ETF	151.15	151.36	150.91	151.13	1027850.0
2019-06-26 15:00:00	IWM	ETF	151.12	151.34	150.76	150.84	3442782.0
2019-06-26 16:00:00	IWM	ETF	150.84	150.89	150.65	150.66	553258.0
2019-06-26 17:00:00	IWM	ETF	150.8	150.8	150.7	150.7	112242.0
2019-06-26 18:00:00	IWM	ETF	150.71	150.8	150.7	150.7	9947.0
2019-06-26 19:00:00	IWM	ETF	150.7	150.81	150.7	150.8	20380.0
2019-06-26 04:00:00	DIA	ETF	265.38	265.74	265.38	265.74	1010.0
2019-06-26 05:00:00	DIA	ETF	266.26	266.56	266.26	266.56	5600.0

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

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