PREVIEW / etf_1hour / 2019-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-06.parquet
  size:    342 KB
  rows:    11,155

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-06 04:00:00	SPY	ETF	289.4	289.5	288.68	288.83	96401.0
2019-05-06 05:00:00	SPY	ETF	288.86	289.15	288.68	289.15	22942.0
2019-05-06 06:00:00	SPY	ETF	289.18	289.6	288.99	289.39	207572.0
2019-05-06 07:00:00	SPY	ETF	289.39	289.81	289.25	289.62	1027183.0
2019-05-06 08:00:00	SPY	ETF	289.62	289.99	288.17	289.74	1389858.0
2019-05-06 09:00:00	SPY	ETF	289.74	290.96	288.9	290.949	15943967.0
2019-05-06 10:00:00	SPY	ETF	290.945	291.63	290.45	291.52	14203718.0
2019-05-06 11:00:00	SPY	ETF	291.51	291.95	291.22	291.34	11579684.0
2019-05-06 12:00:00	SPY	ETF	291.3399	291.56	291.11	291.16	7605436.0
2019-05-06 13:00:00	SPY	ETF	291.14	291.74	290.97	291.74	6026410.0
2019-05-06 14:00:00	SPY	ETF	291.74	293.05	291.58	293.03	8377384.0
2019-05-06 15:00:00	SPY	ETF	293.02	293.31	292.69	292.87	14661308.0
2019-05-06 16:00:00	SPY	ETF	292.87	294.126	290.38	290.51	12749277.0
2019-05-06 17:00:00	SPY	ETF	290.51	291.69	290.41	290.95	1873666.0
2019-05-06 18:00:00	SPY	ETF	290.95	291.23	290.64	291.09	383461.0
2019-05-06 19:00:00	SPY	ETF	291.09	291.37	291.0	291.28	124051.0
2019-05-06 04:00:00	QQQ	ETF	187.54	187.54	186.69	186.85	54696.0
2019-05-06 05:00:00	QQQ	ETF	186.83	187.1	186.68	187.1	51657.0
2019-05-06 06:00:00	QQQ	ETF	187.12	187.38	186.94	187.33	54990.0
2019-05-06 07:00:00	QQQ	ETF	187.28	187.65	187.24	187.56	256226.0
2019-05-06 08:00:00	QQQ	ETF	187.36	187.92	186.85	187.75	549662.0
2019-05-06 09:00:00	QQQ	ETF	187.74	188.62	186.76	188.5589	6832114.0
2019-05-06 10:00:00	QQQ	ETF	188.57	189.25	188.15	189.16	6834290.0
2019-05-06 11:00:00	QQQ	ETF	189.1694	189.45	188.88	188.96	3503693.0
2019-05-06 12:00:00	QQQ	ETF	188.98	189.06	188.46	188.5	3127784.0
2019-05-06 13:00:00	QQQ	ETF	188.5	189.12	188.36	189.08	2934545.0
2019-05-06 14:00:00	QQQ	ETF	189.08	190.18	188.93	190.13	3022561.0
2019-05-06 15:00:00	QQQ	ETF	190.13	190.2	189.79	189.99	4024459.0
2019-05-06 16:00:00	QQQ	ETF	189.98	190.05	188.33	188.33	1792013.0
2019-05-06 17:00:00	QQQ	ETF	188.33	189.17	188.33	188.8	215605.0
2019-05-06 18:00:00	QQQ	ETF	188.7	188.82	188.49	188.73	94759.0
2019-05-06 19:00:00	QQQ	ETF	188.75	188.93	188.6501	188.9	31357.0
2019-05-06 04:00:00	IWM	ETF	157.92	157.92	157.4	157.4	9470.0
2019-05-06 05:00:00	IWM	ETF	157.5	157.8	157.5	157.8	2438.0
2019-05-06 06:00:00	IWM	ETF	157.8	158.29	157.8	158.21	23784.0
2019-05-06 07:00:00	IWM	ETF	158.2	158.39	158.09	158.27	45254.0
2019-05-06 08:00:00	IWM	ETF	158.23	158.53	157.35	158.47	81663.0
2019-05-06 09:00:00	IWM	ETF	158.44	159.15	158.0	159.0785	3273448.0
2019-05-06 10:00:00	IWM	ETF	159.06	160.01	158.77	159.95	3819050.0
2019-05-06 11:00:00	IWM	ETF	159.96	160.41	159.5	160.03	2566275.0
2019-05-06 12:00:00	IWM	ETF	160.05	160.2	159.72	159.76	2332369.0
2019-05-06 13:00:00	IWM	ETF	159.76	160.08	159.4	160.075	1459532.0
2019-05-06 14:00:00	IWM	ETF	160.07	160.79	159.9275	160.75	1564417.0
2019-05-06 15:00:00	IWM	ETF	160.755	161.11	160.545	160.72	3224487.0
2019-05-06 16:00:00	IWM	ETF	160.73	160.8	159.36	159.43	871796.0
2019-05-06 17:00:00	IWM	ETF	159.47	160.09	159.25	159.93	61975.0
2019-05-06 18:00:00	IWM	ETF	159.6	159.79	159.49	159.73	12414.0
2019-05-06 19:00:00	IWM	ETF	159.72	159.95	159.72	159.92	5590.0
2019-05-06 04:00:00	DIA	ETF	260.64	260.64	259.9	259.92	2336.0
2019-05-06 05:00:00	DIA	ETF	259.89	260.26	259.89	260.26	550.0

> showing 50 of 11,155 rows — these rows as CSV

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