PREVIEW / futures_1hour / 2020-07-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	3519.03	3519.59	3514.0	3517.63	11313.0
2020-07-14 01:00:00	ES	Futures	3517.63	3523.22	3517.63	3518.19	9122.0
2020-07-14 02:00:00	ES	Futures	3518.19	3536.34	3518.19	3532.15	25325.0
2020-07-14 03:00:00	ES	Futures	3532.15	3534.11	3510.93	3515.96	38503.0
2020-07-14 04:00:00	ES	Futures	3515.96	3532.43	3515.4	3528.52	23756.0
2020-07-14 05:00:00	ES	Futures	3528.52	3532.15	3522.66	3527.96	20649.0
2020-07-14 06:00:00	ES	Futures	3527.96	3530.48	3523.22	3530.48	24744.0
2020-07-14 07:00:00	ES	Futures	3530.48	3534.11	3523.49	3530.76	34776.0
2020-07-14 08:00:00	ES	Futures	3531.03	3533.55	3502.83	3503.39	80427.0
2020-07-14 09:00:00	ES	Futures	3503.39	3520.98	3483.84	3504.79	346213.0
2020-07-14 10:00:00	ES	Futures	3504.51	3527.68	3487.75	3515.68	383434.0
2020-07-14 11:00:00	ES	Futures	3515.68	3536.62	3509.53	3528.8	246679.0
2020-07-14 12:00:00	ES	Futures	3528.8	3536.06	3519.03	3520.98	119688.0
2020-07-14 13:00:00	ES	Futures	3520.98	3540.25	3511.77	3532.43	194620.0
2020-07-14 14:00:00	ES	Futures	3532.43	3547.51	3527.4	3544.44	190418.0
2020-07-14 15:00:00	ES	Futures	3544.72	3565.66	3526.29	3560.91	311152.0
2020-07-14 16:00:00	ES	Futures	3560.63	3561.75	3553.37	3556.45	63281.0
2020-07-14 18:00:00	ES	Futures	3578.78	3590.79	3578.51	3587.72	36625.0
2020-07-14 19:00:00	ES	Futures	3587.72	3589.4	3579.62	3585.21	17264.0
2020-07-14 20:00:00	ES	Futures	3585.49	3592.47	3582.97	3586.32	29447.0
2020-07-14 21:00:00	ES	Futures	3586.05	3589.12	3582.97	3585.77	16968.0
2020-07-14 22:00:00	ES	Futures	3585.77	3587.16	3580.46	3583.81	7844.0
2020-07-14 23:00:00	ES	Futures	3583.53	3583.81	3577.95	3582.69	8764.0
2020-07-14 00:00:00	NQ	Futures	12292.4	12294.71	12277.07	12288.64	3689.0
2020-07-14 01:00:00	NQ	Futures	12288.35	12304.26	12277.94	12277.94	4232.0
2020-07-14 02:00:00	NQ	Futures	12279.1	12368.74	12279.1	12345.9	13508.0
2020-07-14 03:00:00	NQ	Futures	12346.48	12352.55	12243.82	12256.54	20977.0
2020-07-14 04:00:00	NQ	Futures	12256.54	12322.76	12256.54	12304.55	13217.0
2020-07-14 05:00:00	NQ	Futures	12303.68	12319.01	12278.23	12298.18	9494.0
2020-07-14 06:00:00	NQ	Futures	12298.18	12305.99	12266.09	12277.07	9776.0
2020-07-14 07:00:00	NQ	Futures	12277.07	12346.19	12250.76	12327.97	19699.0
2020-07-14 08:00:00	NQ	Futures	12328.55	12339.25	12148.97	12157.93	39767.0
2020-07-14 09:00:00	NQ	Futures	12156.78	12295.0	12014.5	12115.71	157067.0
2020-07-14 10:00:00	NQ	Futures	12114.27	12227.34	11982.11	12148.68	171446.0
2020-07-14 11:00:00	NQ	Futures	12148.68	12263.48	12102.99	12214.32	117447.0
2020-07-14 12:00:00	NQ	Futures	12214.32	12271.58	12165.74	12177.31	62555.0
2020-07-14 13:00:00	NQ	Futures	12177.6	12287.77	12131.91	12249.6	67403.0
2020-07-14 14:00:00	NQ	Futures	12250.18	12303.1	12230.81	12273.6	60130.0
2020-07-14 15:00:00	NQ	Futures	12273.6	12364.41	12174.99	12345.61	83440.0
2020-07-14 16:00:00	NQ	Futures	12345.32	12347.35	12302.81	12311.2	13449.0
2020-07-14 18:00:00	NQ	Futures	12383.78	12422.53	12375.11	12395.06	8782.0
2020-07-14 19:00:00	NQ	Futures	12395.64	12399.98	12383.2	12396.51	3858.0
2020-07-14 20:00:00	NQ	Futures	12396.79	12418.48	12391.01	12399.11	6405.0
2020-07-14 21:00:00	NQ	Futures	12398.24	12405.47	12371.64	12382.05	5811.0
2020-07-14 22:00:00	NQ	Futures	12382.62	12392.46	12349.08	12364.41	4935.0
2020-07-14 23:00:00	NQ	Futures	12364.41	12364.99	12332.31	12349.95	5400.0
2020-07-14 00:00:00	YM	Futures	28625.2	28628.5	28577.9	28609.8	1694.0
2020-07-14 01:00:00	YM	Futures	28608.7	28652.8	28606.5	28618.6	2254.0
2020-07-14 02:00:00	YM	Futures	28617.5	28762.9	28617.5	28722.1	5618.0
2020-07-14 03:00:00	YM	Futures	28725.4	28744.2	28540.4	28590.0	8270.0

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

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