PREVIEW / etf_1hour / 2019-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-20.parquet
  size:    328 KB
  rows:    10,853

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-08-20 04:00:00	SPY	ETF	292.55	292.73	292.48	292.58	5678.0
2019-08-20 05:00:00	SPY	ETF	292.53	292.53	292.25	292.48	15109.0
2019-08-20 06:00:00	SPY	ETF	292.6	292.6	292.25	292.25	8978.0
2019-08-20 07:00:00	SPY	ETF	292.25	292.57	291.97	292.54	247436.0
2019-08-20 08:00:00	SPY	ETF	292.3601	293.0	291.99	292.09	266605.0
2019-08-20 09:00:00	SPY	ETF	292.07	292.21	290.35	290.7	6947721.0
2019-08-20 10:00:00	SPY	ETF	290.71	291.865	290.5	291.8167	7127974.0
2019-08-20 11:00:00	SPY	ETF	291.825	292.36	291.36	291.5145	4432081.0
2019-08-20 12:00:00	SPY	ETF	291.54	291.975	291.38	291.78	2878957.0
2019-08-20 13:00:00	SPY	ETF	291.77	291.85	290.81	291.25	3515604.0
2019-08-20 14:00:00	SPY	ETF	291.24	291.2849	290.35	290.855	6510595.0
2019-08-20 15:00:00	SPY	ETF	290.84	290.96	289.95	290.05	12308117.0
2019-08-20 16:00:00	SPY	ETF	290.06	290.1917	289.34	289.49	5588050.0
2019-08-20 17:00:00	SPY	ETF	289.51	289.54	289.37	289.37	42916.0
2019-08-20 18:00:00	SPY	ETF	289.36	289.87	289.26	289.84	88754.0
2019-08-20 19:00:00	SPY	ETF	289.8	290.0	289.58	289.85	31406.0
2019-08-20 04:00:00	QQQ	ETF	188.67	188.75	188.5	188.57	10429.0
2019-08-20 05:00:00	QQQ	ETF	188.58	188.6	188.28	188.51	17902.0
2019-08-20 06:00:00	QQQ	ETF	188.59	188.72	188.34	188.43	18708.0
2019-08-20 07:00:00	QQQ	ETF	188.39	188.51	188.08	188.51	248453.0
2019-08-20 08:00:00	QQQ	ETF	188.21	188.8	188.11	188.23	135225.0
2019-08-20 09:00:00	QQQ	ETF	188.19	188.34	187.15	187.51	2996541.0
2019-08-20 10:00:00	QQQ	ETF	187.47	188.27	187.3	188.2346	2343618.0
2019-08-20 11:00:00	QQQ	ETF	188.26	188.635	187.98	188.06	1998920.0
2019-08-20 12:00:00	QQQ	ETF	188.06	188.4	187.94	188.2	1057778.0
2019-08-20 13:00:00	QQQ	ETF	188.18	188.21	187.545	187.8	1172955.0
2019-08-20 14:00:00	QQQ	ETF	187.78	187.84	187.09	187.49	1613457.0
2019-08-20 15:00:00	QQQ	ETF	187.49	187.64	186.95	186.99	3463860.0
2019-08-20 16:00:00	QQQ	ETF	186.99	187.02	186.55	186.61	779911.0
2019-08-20 17:00:00	QQQ	ETF	186.68	186.78	186.55	186.62	9578.0
2019-08-20 18:00:00	QQQ	ETF	186.6	186.93	186.5	186.93	27045.0
2019-08-20 19:00:00	QQQ	ETF	186.89	187.03	186.78	186.95	27465.0
2019-08-20 04:00:00	IWM	ETF	150.38	150.38	150.38	150.38	249.0
2019-08-20 05:00:00	IWM	ETF	150.15	150.15	150.15	150.15	100.0
2019-08-20 06:00:00	IWM	ETF	150.3	150.3	150.14	150.14	3000.0
2019-08-20 07:00:00	IWM	ETF	150.13	150.2	149.98	150.2	133511.0
2019-08-20 08:00:00	IWM	ETF	150.0001	150.35	150.0001	150.06	43508.0
2019-08-20 09:00:00	IWM	ETF	150.05	150.13	149.27	149.7	1793044.0
2019-08-20 10:00:00	IWM	ETF	149.67	149.9	149.27	149.8565	1610955.0
2019-08-20 11:00:00	IWM	ETF	149.87	150.01	149.24	149.36	1268942.0
2019-08-20 12:00:00	IWM	ETF	149.35	149.54	149.14	149.325	1122559.0
2019-08-20 13:00:00	IWM	ETF	149.33	149.34	148.99	149.26	1371032.0
2019-08-20 14:00:00	IWM	ETF	149.25	149.42	149.03	149.38	1359644.0
2019-08-20 15:00:00	IWM	ETF	149.37	149.49	149.05	149.13	2486467.0
2019-08-20 16:00:00	IWM	ETF	149.12	149.16	148.8	148.82	759166.0
2019-08-20 17:00:00	IWM	ETF	148.74	148.93	148.74	148.89	2401.0
2019-08-20 18:00:00	IWM	ETF	148.81	149.07	148.68	149.0	9400.0
2019-08-20 19:00:00	IWM	ETF	149.0	149.05	149.0	149.02	1000.0
2019-08-20 07:00:00	DIA	ETF	260.94	261.4	260.94	261.4	200.0
2019-08-20 08:00:00	DIA	ETF	261.0399	261.63	261.0399	261.19	2600.0

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

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