PREVIEW / futures_1hour / 2021-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-25.parquet
  size:    63 KB
  rows:    1,949

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-01-25 00:00:00	ES	Futures	4321.42	4323.67	4319.46	4321.98	5140.0
2021-01-25 01:00:00	ES	Futures	4322.26	4323.95	4320.86	4321.7	4736.0
2021-01-25 02:00:00	ES	Futures	4321.98	4325.91	4320.86	4324.79	7129.0
2021-01-25 03:00:00	ES	Futures	4324.79	4325.07	4316.37	4317.77	17484.0
2021-01-25 04:00:00	ES	Futures	4318.05	4321.14	4313.28	4314.68	11776.0
2021-01-25 05:00:00	ES	Futures	4314.68	4319.18	4312.44	4319.18	11545.0
2021-01-25 06:00:00	ES	Futures	4319.18	4320.58	4309.35	4314.12	21985.0
2021-01-25 07:00:00	ES	Futures	4314.4	4317.77	4301.49	4305.14	37447.0
2021-01-25 08:00:00	ES	Futures	4305.14	4313.0	4299.81	4307.11	66002.0
2021-01-25 09:00:00	ES	Futures	4307.11	4319.74	4306.83	4312.72	170521.0
2021-01-25 10:00:00	ES	Futures	4312.72	4324.51	4282.97	4284.65	246729.0
2021-01-25 11:00:00	ES	Futures	4284.93	4297.28	4253.22	4297.0	429327.0
2021-01-25 12:00:00	ES	Futures	4297.0	4306.55	4281.29	4304.86	187356.0
2021-01-25 13:00:00	ES	Futures	4304.58	4314.4	4298.41	4309.35	130426.0
2021-01-25 14:00:00	ES	Futures	4309.63	4312.72	4302.62	4308.51	94219.0
2021-01-25 15:00:00	ES	Futures	4308.51	4321.42	4298.13	4320.58	190492.0
2021-01-25 16:00:00	ES	Futures	4320.3	4323.95	4318.05	4318.89	44293.0
2021-01-25 18:00:00	ES	Futures	4316.65	4320.02	4314.4	4317.21	6044.0
2021-01-25 19:00:00	ES	Futures	4316.93	4318.05	4311.6	4313.0	7987.0
2021-01-25 20:00:00	ES	Futures	4313.0	4315.53	4307.39	4310.76	10198.0
2021-01-25 21:00:00	ES	Futures	4310.76	4311.88	4303.46	4304.02	10949.0
2021-01-25 22:00:00	ES	Futures	4304.02	4304.86	4300.93	4303.46	6376.0
2021-01-25 23:00:00	ES	Futures	4303.46	4304.3	4290.27	4293.63	15625.0
2021-01-25 00:00:00	NQ	Futures	15581.38	15593.53	15576.46	15583.4	2871.0
2021-01-25 01:00:00	NQ	Futures	15583.98	15586.01	15573.85	15582.24	2109.0
2021-01-25 02:00:00	NQ	Futures	15582.82	15610.9	15574.43	15602.5	3768.0
2021-01-25 03:00:00	NQ	Futures	15601.93	15602.79	15586.88	15600.77	5601.0
2021-01-25 04:00:00	NQ	Futures	15600.77	15626.53	15599.32	15610.61	8008.0
2021-01-25 05:00:00	NQ	Futures	15610.61	15619.0	15593.24	15618.42	4905.0
2021-01-25 06:00:00	NQ	Futures	15618.13	15619.0	15595.27	15604.24	6460.0
2021-01-25 07:00:00	NQ	Futures	15604.24	15638.68	15596.14	15601.64	14642.0
2021-01-25 08:00:00	NQ	Futures	15601.06	15635.21	15599.32	15608.58	16901.0
2021-01-25 09:00:00	NQ	Futures	15608.87	15692.52	15608.29	15675.15	73073.0
2021-01-25 10:00:00	NQ	Futures	15674.28	15688.18	15446.21	15454.6	120823.0
2021-01-25 11:00:00	NQ	Futures	15454.89	15512.49	15269.37	15512.49	140356.0
2021-01-25 12:00:00	NQ	Futures	15512.49	15542.01	15412.93	15535.65	67609.0
2021-01-25 13:00:00	NQ	Futures	15535.36	15569.8	15503.23	15553.59	51746.0
2021-01-25 14:00:00	NQ	Futures	15553.01	15574.43	15518.86	15555.91	41757.0
2021-01-25 15:00:00	NQ	Futures	15555.91	15605.98	15485.28	15599.9	64395.0
2021-01-25 16:00:00	NQ	Futures	15599.9	15610.61	15580.8	15588.03	9571.0
2021-01-25 18:00:00	NQ	Futures	15582.82	15601.93	15572.69	15586.59	2789.0
2021-01-25 19:00:00	NQ	Futures	15586.3	15591.8	15563.14	15566.04	2657.0
2021-01-25 20:00:00	NQ	Futures	15567.48	15572.69	15548.96	15566.61	2766.0
2021-01-25 21:00:00	NQ	Futures	15567.19	15571.25	15544.62	15550.99	2789.0
2021-01-25 22:00:00	NQ	Futures	15550.99	15555.04	15539.7	15548.67	2082.0
2021-01-25 23:00:00	NQ	Futures	15548.67	15551.56	15490.78	15499.47	4728.0
2021-01-25 00:00:00	YM	Futures	34372.8	34388.4	34350.7	34375.1	1146.0
2021-01-25 01:00:00	YM	Futures	34375.1	34396.1	34366.2	34374.0	1338.0
2021-01-25 02:00:00	YM	Futures	34376.2	34399.5	34368.4	34389.5	1605.0
2021-01-25 03:00:00	YM	Futures	34390.6	34390.6	34299.6	34313.0	4190.0

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

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