PREVIEW / futures_1hour / 2020-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-08.parquet
  size:    58 KB
  rows:    1,826

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-07-08 00:00:00	ES	Futures	3509.81	3510.65	3497.53	3500.32	10706.0
2020-07-08 01:00:00	ES	Futures	3500.32	3506.18	3497.8	3499.48	12033.0
2020-07-08 02:00:00	ES	Futures	3499.48	3506.18	3491.1	3502.55	21779.0
2020-07-08 03:00:00	ES	Futures	3502.55	3517.07	3500.32	3513.44	34344.0
2020-07-08 04:00:00	ES	Futures	3513.44	3520.7	3505.9	3510.09	26063.0
2020-07-08 05:00:00	ES	Futures	3510.37	3511.49	3495.01	3500.6	32197.0
2020-07-08 06:00:00	ES	Futures	3500.32	3507.02	3496.13	3506.74	23181.0
2020-07-08 07:00:00	ES	Futures	3507.02	3513.44	3503.39	3511.21	21875.0
2020-07-08 08:00:00	ES	Futures	3511.21	3512.32	3503.11	3508.42	25753.0
2020-07-08 09:00:00	ES	Futures	3508.42	3530.76	3504.79	3529.64	164068.0
2020-07-08 10:00:00	ES	Futures	3529.64	3532.15	3517.63	3521.82	170647.0
2020-07-08 11:00:00	ES	Futures	3521.82	3522.94	3491.66	3507.86	251609.0
2020-07-08 12:00:00	ES	Futures	3507.86	3516.79	3506.18	3516.23	111424.0
2020-07-08 13:00:00	ES	Futures	3516.51	3516.79	3501.16	3504.51	97166.0
2020-07-08 14:00:00	ES	Futures	3504.51	3514.56	3501.43	3512.6	146131.0
2020-07-08 15:00:00	ES	Futures	3512.32	3530.76	3511.77	3529.92	223306.0
2020-07-08 16:00:00	ES	Futures	3529.64	3536.62	3527.96	3535.22	50524.0
2020-07-08 18:00:00	ES	Futures	3536.62	3539.69	3534.94	3536.9	8622.0
2020-07-08 19:00:00	ES	Futures	3536.9	3540.25	3534.94	3537.74	6719.0
2020-07-08 20:00:00	ES	Futures	3537.74	3540.81	3533.27	3535.5	10642.0
2020-07-08 21:00:00	ES	Futures	3535.5	3536.62	3527.96	3530.48	15515.0
2020-07-08 22:00:00	ES	Futures	3530.2	3532.15	3526.85	3530.2	10605.0
2020-07-08 23:00:00	ES	Futures	3530.48	3535.22	3526.57	3534.39	9672.0
2020-07-08 00:00:00	NQ	Futures	12199.57	12201.6	12159.96	12166.9	4804.0
2020-07-08 01:00:00	NQ	Futures	12166.61	12187.14	12163.72	12170.37	5167.0
2020-07-08 02:00:00	NQ	Futures	12170.08	12205.36	12151.57	12196.68	9353.0
2020-07-08 03:00:00	NQ	Futures	12196.39	12231.96	12189.74	12219.24	12007.0
2020-07-08 04:00:00	NQ	Futures	12219.24	12244.4	12200.73	12218.08	9778.0
2020-07-08 05:00:00	NQ	Futures	12218.66	12222.13	12173.55	12187.72	10042.0
2020-07-08 06:00:00	NQ	Futures	12187.72	12216.93	12180.2	12214.9	6631.0
2020-07-08 07:00:00	NQ	Futures	12215.19	12242.08	12211.43	12237.75	7549.0
2020-07-08 08:00:00	NQ	Futures	12238.32	12243.53	12200.15	12222.71	11182.0
2020-07-08 09:00:00	NQ	Futures	12222.42	12296.74	12212.88	12292.69	57112.0
2020-07-08 10:00:00	NQ	Futures	12292.98	12308.02	12260.3	12294.14	55339.0
2020-07-08 11:00:00	NQ	Futures	12293.85	12298.18	12159.96	12249.6	76825.0
2020-07-08 12:00:00	NQ	Futures	12249.89	12292.69	12240.64	12291.53	41980.0
2020-07-08 13:00:00	NQ	Futures	12291.24	12293.56	12226.47	12238.32	32773.0
2020-07-08 14:00:00	NQ	Futures	12238.32	12268.11	12216.06	12262.91	43569.0
2020-07-08 15:00:00	NQ	Futures	12262.62	12327.97	12261.17	12323.92	50325.0
2020-07-08 16:00:00	NQ	Futures	12323.92	12345.61	12315.25	12344.16	11365.0
2020-07-08 18:00:00	NQ	Futures	12347.06	12366.72	12338.96	12345.61	3098.0
2020-07-08 19:00:00	NQ	Futures	12346.48	12360.36	12338.09	12356.31	2538.0
2020-07-08 20:00:00	NQ	Futures	12356.31	12370.48	12330.57	12346.19	5525.0
2020-07-08 21:00:00	NQ	Futures	12346.48	12350.24	12321.32	12329.13	6914.0
2020-07-08 22:00:00	NQ	Futures	12328.26	12332.02	12314.09	12325.66	4945.0
2020-07-08 23:00:00	NQ	Futures	12325.66	12346.19	12319.58	12344.16	4022.0
2020-07-08 00:00:00	YM	Futures	28438.0	28449.1	28325.7	28351.1	2928.0
2020-07-08 01:00:00	YM	Futures	28347.7	28401.7	28324.6	28340.0	2887.0
2020-07-08 02:00:00	YM	Futures	28340.0	28388.5	28256.4	28357.7	5064.0
2020-07-08 03:00:00	YM	Futures	28358.8	28492.0	28337.8	28453.5	8686.0

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

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