PREVIEW / etf_1hour / 2020-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-11.parquet
  size:    387 KB
  rows:    13,077

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
2020-11-11 04:00:00	SPY	ETF	356.48	356.73	355.85	356.24	85614.0
2020-11-11 05:00:00	SPY	ETF	356.34	356.72	356.24	356.6	87156.0
2020-11-11 06:00:00	SPY	ETF	356.51	357.16	356.47	357.0	78403.0
2020-11-11 07:00:00	SPY	ETF	357.0	357.17	356.34	356.9	149956.0
2020-11-11 08:00:00	SPY	ETF	357.0001	357.25	354.5	356.47	783332.0
2020-11-11 09:00:00	SPY	ETF	356.47	356.6	355.12	355.2978	6175670.0
2020-11-11 10:00:00	SPY	ETF	355.31	356.31	355.12	356.0	6205742.0
2020-11-11 11:00:00	SPY	ETF	355.98	356.94	355.78	356.9	6017719.0
2020-11-11 12:00:00	SPY	ETF	356.91	357.36	356.72	357.1	3586969.0
2020-11-11 13:00:00	SPY	ETF	357.11	357.56	356.64	356.7	3969381.0
2020-11-11 14:00:00	SPY	ETF	356.71	357.28	355.06	355.71	7836217.0
2020-11-11 15:00:00	SPY	ETF	355.73	356.89	355.32	356.62	12400475.0
2020-11-11 16:00:00	SPY	ETF	356.64	357.52	356.64	357.24	8293241.0
2020-11-11 17:00:00	SPY	ETF	357.28	357.42	357.17	357.39	288868.0
2020-11-11 18:00:00	SPY	ETF	357.36	357.36	356.7	356.82	266690.0
2020-11-11 19:00:00	SPY	ETF	356.73	357.06	356.38	356.58	169454.0
2020-11-11 04:00:00	QQQ	ETF	286.46	286.66	285.6	286.19	80864.0
2020-11-11 05:00:00	QQQ	ETF	286.23	286.65	285.78	286.49	39924.0
2020-11-11 06:00:00	QQQ	ETF	286.37	287.21	286.01	286.6	69130.0
2020-11-11 07:00:00	QQQ	ETF	286.52	287.06	285.79	286.86	279284.0
2020-11-11 08:00:00	QQQ	ETF	286.86	287.45	282.73	286.23	530868.0
2020-11-11 09:00:00	QQQ	ETF	286.2	288.55	285.53	287.5	5438519.0
2020-11-11 10:00:00	QQQ	ETF	287.53	288.89	287.25	288.015	4511723.0
2020-11-11 11:00:00	QQQ	ETF	288.0	289.4018	287.4	289.4	2859701.0
2020-11-11 12:00:00	QQQ	ETF	289.39	289.96	289.05	289.23	1835305.0
2020-11-11 13:00:00	QQQ	ETF	289.24	290.12	289.11	289.51	2410623.0
2020-11-11 14:00:00	QQQ	ETF	289.52	290.25	288.52	288.92	2924515.0
2020-11-11 15:00:00	QQQ	ETF	288.92	290.23	288.82	289.84	4071755.0
2020-11-11 16:00:00	QQQ	ETF	289.81	290.66	289.75	290.19	2839301.0
2020-11-11 17:00:00	QQQ	ETF	290.21	290.25	290.03	290.13	61622.0
2020-11-11 18:00:00	QQQ	ETF	290.15	290.56	289.85	290.15	85805.0
2020-11-11 19:00:00	QQQ	ETF	290.1	290.3	289.44	289.54	135388.0
2020-11-11 04:00:00	IWM	ETF	173.28	173.69	173.22	173.68	17735.0
2020-11-11 05:00:00	IWM	ETF	173.7	173.78	173.36	173.36	9100.0
2020-11-11 06:00:00	IWM	ETF	173.31	173.67	173.13	173.65	10400.0
2020-11-11 07:00:00	IWM	ETF	173.71	173.88	173.3	173.54	96546.0
2020-11-11 08:00:00	IWM	ETF	173.5	173.78	172.93	173.37	162263.0
2020-11-11 09:00:00	IWM	ETF	173.41	173.6	171.2	171.24	3507645.0
2020-11-11 10:00:00	IWM	ETF	171.23	171.59	170.86	171.395	3567161.0
2020-11-11 11:00:00	IWM	ETF	171.395	172.56	171.32	172.26	2169549.0
2020-11-11 12:00:00	IWM	ETF	172.26	172.36	171.895	172.23	1230426.0
2020-11-11 13:00:00	IWM	ETF	172.2385	172.39	171.94	171.97	1017992.0
2020-11-11 14:00:00	IWM	ETF	171.97	172.22	171.27	171.69	1940022.0
2020-11-11 15:00:00	IWM	ETF	171.7	172.69	171.22	172.66	4116830.0
2020-11-11 16:00:00	IWM	ETF	172.65	173.11	171.65	172.86	2551263.0
2020-11-11 17:00:00	IWM	ETF	172.85	172.85	172.64	172.76	14912.0
2020-11-11 18:00:00	IWM	ETF	172.82	172.89	172.31	172.35	53789.0
2020-11-11 19:00:00	IWM	ETF	172.41	172.57	172.26	172.33	38900.0
2020-11-11 04:00:00	DIA	ETF	296.41	296.45	295.98	296.16	5104.0
2020-11-11 05:00:00	DIA	ETF	296.45	296.5	296.23	296.31	1800.0

> showing 50 of 13,077 rows — these rows as CSV

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