PREVIEW / futures_1hour / 2020-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-07.parquet
  size:    60 KB
  rows:    1,884

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-07 00:00:00	ES	Futures	4133.91	4135.04	4129.99	4130.83	4584.0
2020-12-07 01:00:00	ES	Futures	4131.11	4134.19	4129.71	4132.51	4314.0
2020-12-07 02:00:00	ES	Futures	4132.51	4137.56	4130.55	4137.0	7160.0
2020-12-07 03:00:00	ES	Futures	4137.0	4137.28	4114.31	4117.67	31547.0
2020-12-07 04:00:00	ES	Futures	4117.95	4125.79	4115.71	4124.95	18212.0
2020-12-07 05:00:00	ES	Futures	4124.95	4129.99	4123.55	4124.67	10150.0
2020-12-07 06:00:00	ES	Futures	4124.67	4131.11	4123.55	4130.27	10813.0
2020-12-07 07:00:00	ES	Futures	4130.27	4131.11	4125.79	4130.27	9133.0
2020-12-07 08:00:00	ES	Futures	4130.27	4133.91	4127.19	4133.91	17807.0
2020-12-07 09:00:00	ES	Futures	4133.63	4138.68	4132.51	4138.68	118829.0
2020-12-07 10:00:00	ES	Futures	4138.68	4141.2	4135.04	4138.12	104832.0
2020-12-07 11:00:00	ES	Futures	4138.12	4141.48	4134.47	4138.96	93730.0
2020-12-07 12:00:00	ES	Futures	4139.24	4139.8	4132.79	4132.79	68686.0
2020-12-07 13:00:00	ES	Futures	4133.07	4133.63	4123.55	4127.47	100437.0
2020-12-07 14:00:00	ES	Futures	4127.47	4131.39	4121.59	4127.19	93154.0
2020-12-07 15:00:00	ES	Futures	4127.47	4136.72	4119.91	4135.6	211419.0
2020-12-07 16:00:00	ES	Futures	4135.88	4137.56	4122.43	4124.67	46401.0
2020-12-07 18:00:00	ES	Futures	4126.07	4128.31	4124.67	4125.79	5388.0
2020-12-07 19:00:00	ES	Futures	4125.79	4126.63	4119.91	4126.07	11919.0
2020-12-07 20:00:00	ES	Futures	4125.79	4128.03	4120.75	4122.99	10652.0
2020-12-07 21:00:00	ES	Futures	4122.99	4123.83	4121.03	4122.43	5282.0
2020-12-07 22:00:00	ES	Futures	4122.43	4122.99	4118.51	4121.87	6749.0
2020-12-07 23:00:00	ES	Futures	4121.87	4125.23	4121.59	4124.11	4381.0
2020-12-07 00:00:00	NQ	Futures	14494.86	14498.91	14485.3	14489.07	1516.0
2020-12-07 01:00:00	NQ	Futures	14489.65	14507.3	14486.75	14500.65	2044.0
2020-12-07 02:00:00	NQ	Futures	14501.51	14509.91	14492.25	14507.88	3219.0
2020-12-07 03:00:00	NQ	Futures	14507.59	14509.33	14444.2	14460.99	9906.0
2020-12-07 04:00:00	NQ	Futures	14462.44	14484.15	14451.15	14473.43	4927.0
2020-12-07 05:00:00	NQ	Futures	14473.43	14500.07	14472.28	14489.36	3896.0
2020-12-07 06:00:00	NQ	Futures	14489.07	14502.38	14483.86	14497.17	4378.0
2020-12-07 07:00:00	NQ	Futures	14496.88	14504.41	14485.59	14496.88	3045.0
2020-12-07 08:00:00	NQ	Futures	14497.46	14511.93	14493.99	14511.93	8650.0
2020-12-07 09:00:00	NQ	Futures	14511.64	14576.2	14503.25	14571.56	48663.0
2020-12-07 10:00:00	NQ	Futures	14571.28	14590.67	14561.72	14575.91	45250.0
2020-12-07 11:00:00	NQ	Futures	14575.62	14603.41	14568.38	14579.67	38127.0
2020-12-07 12:00:00	NQ	Futures	14579.96	14580.54	14555.93	14557.96	23211.0
2020-12-07 13:00:00	NQ	Futures	14557.67	14560.28	14527.86	14553.91	30204.0
2020-12-07 14:00:00	NQ	Futures	14553.62	14576.2	14536.83	14568.09	22805.0
2020-12-07 15:00:00	NQ	Futures	14568.09	14588.93	14533.64	14586.04	39951.0
2020-12-07 16:00:00	NQ	Futures	14586.33	14592.41	14547.25	14556.51	9030.0
2020-12-07 18:00:00	NQ	Futures	14559.12	14576.2	14554.49	14561.14	2690.0
2020-12-07 19:00:00	NQ	Futures	14560.85	14562.88	14542.33	14560.57	4451.0
2020-12-07 20:00:00	NQ	Futures	14559.7	14570.41	14542.91	14548.99	3449.0
2020-12-07 21:00:00	NQ	Futures	14549.28	14553.62	14543.49	14549.28	1702.0
2020-12-07 22:00:00	NQ	Futures	14548.99	14551.88	14536.25	14546.67	2108.0
2020-12-07 23:00:00	NQ	Futures	14546.96	14554.49	14546.09	14550.72	1412.0
2020-12-07 00:00:00	YM	Futures	33323.4	33334.4	33289.1	33297.9	1124.0
2020-12-07 01:00:00	YM	Futures	33299.0	33316.7	33283.6	33301.3	1125.0
2020-12-07 02:00:00	YM	Futures	33301.3	33349.9	33283.6	33348.8	2838.0
2020-12-07 03:00:00	YM	Futures	33348.8	33351.0	33159.7	33195.1	8922.0

> showing 50 of 1,884 rows — these rows as CSV

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