PREVIEW / etf_1hour / 2020-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-23.parquet
  size:    401 KB
  rows:    13,678

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-12-23 04:00:00	SPY	ETF	367.82	368.19	367.82	368.14	47570.0
2020-12-23 05:00:00	SPY	ETF	368.12	368.42	368.12	368.39	12448.0
2020-12-23 06:00:00	SPY	ETF	368.22	368.26	367.97	368.0	33193.0
2020-12-23 07:00:00	SPY	ETF	368.0	368.0	367.61	367.8	195181.0
2020-12-23 08:00:00	SPY	ETF	367.7999	368.37	366.38	368.2	269834.0
2020-12-23 09:00:00	SPY	ETF	368.13	369.21	368.04	368.98	6072758.0
2020-12-23 10:00:00	SPY	ETF	368.97	369.14	368.29	368.78	5127757.0
2020-12-23 11:00:00	SPY	ETF	368.77	369.12	368.66	369.1	3760742.0
2020-12-23 12:00:00	SPY	ETF	369.1	369.4	368.97	369.3	2984789.0
2020-12-23 13:00:00	SPY	ETF	369.2909	369.62	369.26	369.38	2678150.0
2020-12-23 14:00:00	SPY	ETF	369.39	369.53	368.87	368.905	3449379.0
2020-12-23 15:00:00	SPY	ETF	368.904	369.13	367.39	367.53	13488675.0
2020-12-23 16:00:00	SPY	ETF	367.53	367.97	366.92	367.88	5629285.0
2020-12-23 17:00:00	SPY	ETF	367.81	367.85	367.57	367.85	1190786.0
2020-12-23 18:00:00	SPY	ETF	367.86	368.01	367.52	367.8	123849.0
2020-12-23 19:00:00	SPY	ETF	367.77	368.07	367.58	367.76	59173.0
2020-12-23 04:00:00	QQQ	ETF	310.04	310.3	310.04	310.29	27219.0
2020-12-23 05:00:00	QQQ	ETF	310.3	310.38	310.2	310.25	6331.0
2020-12-23 06:00:00	QQQ	ETF	310.23	310.23	309.82	309.9	10150.0
2020-12-23 07:00:00	QQQ	ETF	309.87	310.0	309.61	309.81	92901.0
2020-12-23 08:00:00	QQQ	ETF	309.7302	310.25	309.6102	309.99	200106.0
2020-12-23 09:00:00	QQQ	ETF	309.76	310.07	308.19	309.17	3236111.0
2020-12-23 10:00:00	QQQ	ETF	309.17	309.56	308.67	309.12	2623579.0
2020-12-23 11:00:00	QQQ	ETF	309.13	309.39	308.59	309.355	1640275.0
2020-12-23 12:00:00	QQQ	ETF	309.35	309.75	309.03	309.7	901921.0
2020-12-23 13:00:00	QQQ	ETF	309.69	310.18	309.6219	310.01	1594642.0
2020-12-23 14:00:00	QQQ	ETF	310.0	310.055	309.445	309.46	1224128.0
2020-12-23 15:00:00	QQQ	ETF	309.4525	309.68	308.035	308.16	2899200.0
2020-12-23 16:00:00	QQQ	ETF	308.165	308.43	307.57	308.31	898908.0
2020-12-23 17:00:00	QQQ	ETF	308.33	308.48	308.2	308.3	9116.0
2020-12-23 18:00:00	QQQ	ETF	308.32	308.56	308.1	308.32	48478.0
2020-12-23 19:00:00	QQQ	ETF	308.35	308.52	308.11	308.2	39026.0
2020-12-23 04:00:00	IWM	ETF	198.04	198.51	197.53	198.47	31919.0
2020-12-23 05:00:00	IWM	ETF	198.43	198.53	198.43	198.53	2045.0
2020-12-23 06:00:00	IWM	ETF	198.35	198.37	198.04	198.27	31574.0
2020-12-23 07:00:00	IWM	ETF	198.26	198.26	197.9	198.03	22908.0
2020-12-23 08:00:00	IWM	ETF	198.09	198.45	196.66	198.42	64383.0
2020-12-23 09:00:00	IWM	ETF	198.41	198.92	197.9045	198.73	2334886.0
2020-12-23 10:00:00	IWM	ETF	198.72	199.195	198.08	199.09	2044001.0
2020-12-23 11:00:00	IWM	ETF	199.08	199.5	199.04	199.44	1711480.0
2020-12-23 12:00:00	IWM	ETF	199.46	199.495	198.9289	199.23	1100629.0
2020-12-23 13:00:00	IWM	ETF	199.23	199.51	199.08	199.135	1515983.0
2020-12-23 14:00:00	IWM	ETF	199.135	199.7018	198.98	199.16	1062687.0
2020-12-23 15:00:00	IWM	ETF	199.16	199.645	198.875	199.13	3517868.0
2020-12-23 16:00:00	IWM	ETF	199.14	199.4	198.99	199.4	1060199.0
2020-12-23 17:00:00	IWM	ETF	199.42	199.49	199.14	199.25	19221.0
2020-12-23 18:00:00	IWM	ETF	199.36	199.49	199.17	199.34	35181.0
2020-12-23 19:00:00	IWM	ETF	199.47	199.53	199.26	199.41	42282.0
2020-12-23 04:00:00	DIA	ETF	300.75	300.86	300.72	300.72	6700.0
2020-12-23 05:00:00	DIA	ETF	301.01	301.01	300.82	301.01	1254.0

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

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