PREVIEW / futures_1hour / 2021-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-03.parquet
  size:    62 KB
  rows:    1,937

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
2021-02-03 00:00:00	ES	Futures	4301.21	4307.39	4300.37	4306.83	7499.0
2021-02-03 01:00:00	ES	Futures	4306.83	4307.67	4303.18	4306.26	8898.0
2021-02-03 02:00:00	ES	Futures	4305.98	4314.97	4303.74	4313.28	16997.0
2021-02-03 03:00:00	ES	Futures	4313.28	4314.97	4303.18	4304.02	24376.0
2021-02-03 04:00:00	ES	Futures	4304.02	4305.42	4297.56	4300.37	18808.0
2021-02-03 05:00:00	ES	Futures	4300.09	4306.26	4298.41	4304.3	17329.0
2021-02-03 06:00:00	ES	Futures	4304.02	4305.98	4301.49	4305.14	8000.0
2021-02-03 07:00:00	ES	Futures	4305.14	4305.7	4296.44	4298.13	18449.0
2021-02-03 08:00:00	ES	Futures	4298.41	4304.3	4296.44	4302.9	23119.0
2021-02-03 09:00:00	ES	Futures	4302.9	4304.3	4289.71	4302.05	180085.0
2021-02-03 10:00:00	ES	Futures	4302.34	4304.02	4274.83	4288.02	249946.0
2021-02-03 11:00:00	ES	Futures	4288.02	4300.65	4285.21	4299.53	114024.0
2021-02-03 12:00:00	ES	Futures	4299.81	4303.46	4294.2	4302.05	69021.0
2021-02-03 13:00:00	ES	Futures	4302.05	4307.67	4299.25	4306.83	63895.0
2021-02-03 14:00:00	ES	Futures	4306.83	4311.04	4303.46	4303.46	87947.0
2021-02-03 15:00:00	ES	Futures	4303.74	4305.7	4290.27	4290.83	209730.0
2021-02-03 16:00:00	ES	Futures	4290.55	4302.62	4289.71	4302.62	60490.0
2021-02-03 18:00:00	ES	Futures	4302.9	4305.98	4298.13	4302.9	8853.0
2021-02-03 19:00:00	ES	Futures	4302.9	4305.14	4294.76	4295.32	10600.0
2021-02-03 20:00:00	ES	Futures	4295.04	4298.69	4293.63	4297.0	8752.0
2021-02-03 21:00:00	ES	Futures	4297.28	4301.77	4297.28	4299.25	6271.0
2021-02-03 22:00:00	ES	Futures	4299.25	4300.37	4281.0	4282.97	17690.0
2021-02-03 23:00:00	ES	Futures	4282.97	4286.9	4280.72	4284.09	6697.0
2021-02-03 00:00:00	NQ	Futures	15649.1	15683.84	15645.05	15681.52	3846.0
2021-02-03 01:00:00	NQ	Futures	15681.23	15686.15	15672.55	15683.84	2865.0
2021-02-03 02:00:00	NQ	Futures	15682.1	15721.75	15673.42	15718.28	6377.0
2021-02-03 03:00:00	NQ	Futures	15717.99	15727.25	15681.52	15687.31	8870.0
2021-02-03 04:00:00	NQ	Futures	15686.73	15692.52	15645.05	15652.29	6953.0
2021-02-03 05:00:00	NQ	Futures	15651.71	15688.18	15649.68	15678.91	6369.0
2021-02-03 06:00:00	NQ	Futures	15678.63	15693.68	15666.76	15691.07	4003.0
2021-02-03 07:00:00	NQ	Futures	15691.07	15691.36	15652.87	15663.57	8081.0
2021-02-03 08:00:00	NQ	Futures	15663.29	15684.99	15658.65	15675.73	8393.0
2021-02-03 09:00:00	NQ	Futures	15675.44	15684.7	15584.85	15660.1	75434.0
2021-02-03 10:00:00	NQ	Futures	15660.97	15668.21	15503.23	15544.91	103789.0
2021-02-03 11:00:00	NQ	Futures	15544.62	15599.9	15532.46	15595.56	50089.0
2021-02-03 12:00:00	NQ	Futures	15595.56	15620.74	15576.74	15608.0	39321.0
2021-02-03 13:00:00	NQ	Futures	15608.0	15625.95	15582.24	15615.53	33456.0
2021-02-03 14:00:00	NQ	Futures	15615.53	15621.32	15571.82	15571.82	29703.0
2021-02-03 15:00:00	NQ	Futures	15571.54	15580.8	15498.31	15500.62	65228.0
2021-02-03 16:00:00	NQ	Futures	15500.33	15533.91	15498.6	15532.17	13860.0
2021-02-03 18:00:00	NQ	Futures	15547.8	15574.14	15547.8	15564.88	4757.0
2021-02-03 19:00:00	NQ	Futures	15563.72	15566.9	15531.01	15533.91	3861.0
2021-02-03 20:00:00	NQ	Futures	15533.91	15553.3	15528.7	15544.04	3685.0
2021-02-03 21:00:00	NQ	Futures	15544.04	15568.35	15544.04	15553.88	2995.0
2021-02-03 22:00:00	NQ	Futures	15554.17	15559.38	15463.0	15478.34	6943.0
2021-02-03 23:00:00	NQ	Futures	15477.47	15491.07	15468.79	15471.39	3929.0
2021-02-03 00:00:00	YM	Futures	33985.7	34025.7	33981.3	34015.7	1548.0
2021-02-03 01:00:00	YM	Futures	34015.7	34019.0	33981.3	33995.7	1462.0
2021-02-03 02:00:00	YM	Futures	33994.6	34058.9	33972.4	34044.5	2429.0
2021-02-03 03:00:00	YM	Futures	34045.6	34062.3	33964.7	33984.6	4667.0

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

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