PREVIEW / futures_1hour / 2021-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-20.parquet
  size:    62 KB
  rows:    1,932

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-20 00:00:00	ES	Futures	4259.39	4262.48	4257.15	4260.24	5720.0
2021-01-20 01:00:00	ES	Futures	4260.24	4266.97	4258.27	4264.45	5050.0
2021-01-20 02:00:00	ES	Futures	4264.45	4267.81	4263.6	4264.45	5302.0
2021-01-20 03:00:00	ES	Futures	4264.16	4274.27	4260.24	4266.13	24356.0
2021-01-20 04:00:00	ES	Futures	4266.41	4270.06	4263.32	4269.22	12746.0
2021-01-20 05:00:00	ES	Futures	4269.5	4275.39	4268.37	4274.27	11606.0
2021-01-20 06:00:00	ES	Futures	4274.55	4275.39	4269.22	4269.5	11459.0
2021-01-20 07:00:00	ES	Futures	4269.78	4272.02	4268.66	4272.02	13918.0
2021-01-20 08:00:00	ES	Futures	4271.74	4278.48	4271.74	4278.2	28916.0
2021-01-20 09:00:00	ES	Futures	4278.48	4289.14	4278.2	4286.06	167388.0
2021-01-20 10:00:00	ES	Futures	4286.34	4305.98	4286.06	4302.34	211698.0
2021-01-20 11:00:00	ES	Futures	4302.34	4305.98	4295.6	4304.3	110958.0
2021-01-20 12:00:00	ES	Futures	4304.3	4313.56	4304.3	4312.44	83017.0
2021-01-20 13:00:00	ES	Futures	4312.44	4319.18	4311.6	4314.4	86711.0
2021-01-20 14:00:00	ES	Futures	4314.68	4321.14	4309.35	4317.77	93487.0
2021-01-20 15:00:00	ES	Futures	4318.05	4325.07	4313.84	4314.12	219680.0
2021-01-20 16:00:00	ES	Futures	4314.12	4317.49	4311.04	4311.32	55334.0
2021-01-20 18:00:00	ES	Futures	4312.72	4321.98	4311.88	4320.02	10605.0
2021-01-20 19:00:00	ES	Futures	4320.3	4323.67	4315.81	4322.82	10194.0
2021-01-20 20:00:00	ES	Futures	4322.82	4327.88	4320.86	4322.54	12315.0
2021-01-20 21:00:00	ES	Futures	4322.82	4329.0	4322.26	4327.31	6458.0
2021-01-20 22:00:00	ES	Futures	4327.59	4332.09	4327.31	4330.12	7372.0
2021-01-20 23:00:00	ES	Futures	4330.12	4333.21	4329.56	4329.84	6823.0
2021-01-20 00:00:00	NQ	Futures	15086.73	15118.86	15079.5	15106.99	3217.0
2021-01-20 01:00:00	NQ	Futures	15107.28	15135.65	15099.18	15124.07	3592.0
2021-01-20 02:00:00	NQ	Futures	15123.78	15133.91	15113.94	15117.99	2649.0
2021-01-20 03:00:00	NQ	Futures	15116.83	15154.75	15103.81	15128.7	7860.0
2021-01-20 04:00:00	NQ	Futures	15129.57	15146.65	15114.52	15143.17	5008.0
2021-01-20 05:00:00	NQ	Futures	15143.17	15165.75	15138.25	15160.83	5832.0
2021-01-20 06:00:00	NQ	Futures	15161.12	15163.43	15145.2	15155.04	4544.0
2021-01-20 07:00:00	NQ	Futures	15155.33	15175.59	15143.46	15174.43	6841.0
2021-01-20 08:00:00	NQ	Futures	15175.01	15192.38	15170.38	15190.64	10722.0
2021-01-20 09:00:00	NQ	Futures	15190.35	15276.31	15189.77	15240.71	76897.0
2021-01-20 10:00:00	NQ	Futures	15240.71	15338.54	15239.84	15325.23	73771.0
2021-01-20 11:00:00	NQ	Futures	15325.23	15345.78	15288.18	15338.83	46028.0
2021-01-20 12:00:00	NQ	Futures	15339.12	15368.64	15330.73	15359.96	31666.0
2021-01-20 13:00:00	NQ	Futures	15359.96	15391.51	15356.49	15375.3	31188.0
2021-01-20 14:00:00	NQ	Futures	15375.3	15417.27	15359.09	15409.16	34750.0
2021-01-20 15:00:00	NQ	Futures	15409.16	15429.13	15379.35	15381.09	51367.0
2021-01-20 16:00:00	NQ	Futures	15380.8	15410.03	15371.25	15386.88	16252.0
2021-01-20 18:00:00	NQ	Futures	15384.56	15424.21	15383.98	15414.95	3483.0
2021-01-20 19:00:00	NQ	Futures	15415.24	15457.5	15405.11	15455.47	5534.0
2021-01-20 20:00:00	NQ	Futures	15454.31	15493.97	15448.53	15460.68	7769.0
2021-01-20 21:00:00	NQ	Futures	15460.68	15484.7	15452.58	15473.13	3437.0
2021-01-20 22:00:00	NQ	Futures	15473.13	15488.18	15469.94	15484.7	4107.0
2021-01-20 23:00:00	NQ	Futures	15484.42	15504.39	15480.07	15489.91	4208.0
2021-01-20 00:00:00	YM	Futures	34172.1	34189.8	34156.6	34175.4	1171.0
2021-01-20 01:00:00	YM	Futures	34174.3	34215.3	34158.8	34199.8	1145.0
2021-01-20 02:00:00	YM	Futures	34200.9	34224.2	34196.5	34203.1	1598.0
2021-01-20 03:00:00	YM	Futures	34204.3	34284.1	34167.6	34223.1	4411.0

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

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