PREVIEW / futures_1hour / 2020-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-15.parquet
  size:    58 KB
  rows:    1,829

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-09-15 00:00:00	ES	Futures	3784.92	3789.96	3784.08	3789.96	2973.0
2020-09-15 01:00:00	ES	Futures	3789.96	3791.36	3784.92	3791.08	5432.0
2020-09-15 02:00:00	ES	Futures	3791.08	3798.36	3786.88	3788.84	24813.0
2020-09-15 03:00:00	ES	Futures	3789.12	3792.48	3784.36	3788.84	17602.0
2020-09-15 04:00:00	ES	Futures	3788.56	3797.24	3788.0	3795.84	20438.0
2020-09-15 05:00:00	ES	Futures	3795.84	3806.76	3795.56	3805.64	22382.0
2020-09-15 06:00:00	ES	Futures	3805.36	3807.6	3800.04	3806.2	16077.0
2020-09-15 07:00:00	ES	Futures	3806.2	3808.16	3803.4	3804.52	14552.0
2020-09-15 08:00:00	ES	Futures	3804.8	3816.29	3802.84	3811.25	34970.0
2020-09-15 09:00:00	ES	Futures	3811.25	3819.37	3808.44	3814.89	134080.0
2020-09-15 10:00:00	ES	Futures	3814.61	3819.09	3803.12	3813.77	193459.0
2020-09-15 11:00:00	ES	Futures	3813.77	3817.97	3809.01	3811.25	194398.0
2020-09-15 12:00:00	ES	Futures	3811.25	3816.01	3810.69	3815.73	132140.0
2020-09-15 13:00:00	ES	Futures	3815.73	3818.53	3809.29	3809.57	74705.0
2020-09-15 14:00:00	ES	Futures	3809.85	3810.69	3801.44	3805.92	98731.0
2020-09-15 15:00:00	ES	Futures	3806.2	3806.48	3785.2	3798.08	221413.0
2020-09-15 16:00:00	ES	Futures	3798.36	3806.48	3797.52	3803.68	38281.0
2020-09-15 18:00:00	ES	Futures	3804.52	3807.6	3802.84	3805.64	4011.0
2020-09-15 19:00:00	ES	Futures	3805.36	3805.92	3795.56	3799.48	8453.0
2020-09-15 20:00:00	ES	Futures	3799.48	3801.44	3792.76	3800.88	9239.0
2020-09-15 21:00:00	ES	Futures	3800.88	3803.68	3796.96	3803.68	8240.0
2020-09-15 22:00:00	ES	Futures	3803.4	3810.41	3802.84	3807.6	8454.0
2020-09-15 23:00:00	ES	Futures	3807.6	3813.21	3806.76	3812.09	5284.0
2020-09-15 00:00:00	NQ	Futures	13069.22	13102.51	13064.59	13100.77	1864.0
2020-09-15 01:00:00	NQ	Futures	13101.06	13105.98	13079.35	13103.67	2768.0
2020-09-15 02:00:00	NQ	Futures	13104.83	13117.56	13085.14	13092.38	3777.0
2020-09-15 03:00:00	NQ	Futures	13092.38	13108.59	13074.72	13101.35	4317.0
2020-09-15 04:00:00	NQ	Futures	13100.2	13130.3	13099.04	13125.67	4271.0
2020-09-15 05:00:00	NQ	Futures	13123.64	13184.14	13122.48	13173.14	6002.0
2020-09-15 06:00:00	NQ	Futures	13172.85	13175.75	13145.06	13168.8	4280.0
2020-09-15 07:00:00	NQ	Futures	13168.51	13199.19	13159.25	13181.25	5160.0
2020-09-15 08:00:00	NQ	Futures	13182.12	13215.69	13178.93	13200.93	10904.0
2020-09-15 09:00:00	NQ	Futures	13200.06	13278.51	13197.75	13278.51	64122.0
2020-09-15 10:00:00	NQ	Futures	13278.22	13284.01	13162.43	13221.19	73522.0
2020-09-15 11:00:00	NQ	Futures	13221.77	13268.96	13213.09	13249.85	43494.0
2020-09-15 12:00:00	NQ	Futures	13249.56	13287.77	13247.82	13281.4	33216.0
2020-09-15 13:00:00	NQ	Futures	13281.4	13294.43	13256.22	13259.69	30506.0
2020-09-15 14:00:00	NQ	Futures	13259.98	13265.19	13203.25	13246.96	48207.0
2020-09-15 15:00:00	NQ	Futures	13247.54	13249.27	13141.88	13227.56	72317.0
2020-09-15 16:00:00	NQ	Futures	13227.85	13270.4	13225.54	13255.35	12066.0
2020-09-15 18:00:00	NQ	Futures	13257.96	13273.59	13253.03	13263.75	2078.0
2020-09-15 19:00:00	NQ	Futures	13264.03	13264.61	13201.8	13224.09	6051.0
2020-09-15 20:00:00	NQ	Futures	13224.38	13228.14	13186.46	13223.22	6221.0
2020-09-15 21:00:00	NQ	Futures	13223.51	13250.14	13206.14	13246.09	4954.0
2020-09-15 22:00:00	NQ	Futures	13246.38	13283.14	13245.51	13269.82	5263.0
2020-09-15 23:00:00	NQ	Futures	13269.82	13311.51	13266.64	13305.14	4114.0
2020-09-15 00:00:00	YM	Futures	30865.6	30906.5	30862.3	30906.5	634.0
2020-09-15 01:00:00	YM	Futures	30905.4	30914.2	30864.5	30908.7	1094.0
2020-09-15 02:00:00	YM	Futures	30909.8	30983.9	30888.8	30907.6	2958.0
2020-09-15 03:00:00	YM	Futures	30909.8	30952.9	30868.9	30898.7	2942.0

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

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