PREVIEW / futures_1hour / 2020-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-07.parquet
  size:    43 KB
  rows:    1,305

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-07 00:00:00	ES	Futures	3813.63	3814.19	3803.86	3804.97	4772.0
2020-09-07 01:00:00	ES	Futures	3804.97	3807.49	3797.15	3801.62	8379.0
2020-09-07 02:00:00	ES	Futures	3801.62	3809.72	3789.06	3794.92	14771.0
2020-09-07 03:00:00	ES	Futures	3795.2	3809.72	3791.85	3803.86	19967.0
2020-09-07 04:00:00	ES	Futures	3804.13	3816.7	3801.34	3806.65	16702.0
2020-09-07 05:00:00	ES	Futures	3806.93	3815.02	3803.02	3807.76	10501.0
2020-09-07 06:00:00	ES	Futures	3808.04	3817.54	3805.25	3813.07	10739.0
2020-09-07 07:00:00	ES	Futures	3813.35	3826.47	3810.28	3822.56	13031.0
2020-09-07 08:00:00	ES	Futures	3822.29	3825.36	3817.82	3820.33	9792.0
2020-09-07 09:00:00	ES	Futures	3820.33	3827.59	3815.58	3822.56	23070.0
2020-09-07 10:00:00	ES	Futures	3822.29	3834.85	3821.73	3833.45	20841.0
2020-09-07 11:00:00	ES	Futures	3833.45	3840.16	3833.18	3838.2	20908.0
2020-09-07 12:00:00	ES	Futures	3838.48	3840.72	3833.45	3834.57	9647.0
2020-09-07 18:00:00	ES	Futures	3834.01	3844.9	3833.45	3844.07	11607.0
2020-09-07 19:00:00	ES	Futures	3844.07	3846.3	3839.32	3841.83	6732.0
2020-09-07 20:00:00	ES	Futures	3841.83	3846.3	3834.57	3836.25	9646.0
2020-09-07 21:00:00	ES	Futures	3836.53	3839.32	3830.66	3837.09	10649.0
2020-09-07 22:00:00	ES	Futures	3836.81	3841.27	3829.55	3830.38	9117.0
2020-09-07 23:00:00	ES	Futures	3830.1	3831.5	3823.68	3830.38	10529.0
2020-09-07 00:00:00	NQ	Futures	13257.39	13259.7	13201.0	13215.46	5442.0
2020-09-07 01:00:00	NQ	Futures	13215.17	13223.85	13176.13	13202.16	5728.0
2020-09-07 02:00:00	NQ	Futures	13201.58	13234.26	13153.29	13166.3	10521.0
2020-09-07 03:00:00	NQ	Futures	13164.56	13242.06	13153.29	13205.34	9300.0
2020-09-07 04:00:00	NQ	Futures	13207.36	13255.94	13196.08	13223.85	4641.0
2020-09-07 05:00:00	NQ	Futures	13224.71	13249.0	13203.89	13218.64	4612.0
2020-09-07 06:00:00	NQ	Futures	13218.93	13276.19	13206.78	13250.16	3537.0
2020-09-07 07:00:00	NQ	Futures	13251.03	13314.65	13239.46	13288.91	5404.0
2020-09-07 08:00:00	NQ	Futures	13287.75	13299.9	13245.82	13253.92	8472.0
2020-09-07 09:00:00	NQ	Futures	13252.47	13300.48	13223.85	13258.26	15206.0
2020-09-07 10:00:00	NQ	Futures	13256.81	13312.91	13246.98	13307.42	12812.0
2020-09-07 11:00:00	NQ	Futures	13307.71	13334.6	13281.68	13316.96	12184.0
2020-09-07 12:00:00	NQ	Futures	13316.96	13331.42	13284.86	13303.66	7406.0
2020-09-07 18:00:00	NQ	Futures	13308.57	13400.53	13303.37	13391.86	7318.0
2020-09-07 19:00:00	NQ	Futures	13391.86	13399.09	13360.34	13371.62	4317.0
2020-09-07 20:00:00	NQ	Futures	13370.75	13391.28	13336.91	13350.79	5404.0
2020-09-07 21:00:00	NQ	Futures	13349.93	13359.18	13318.99	13350.51	5911.0
2020-09-07 22:00:00	NQ	Futures	13348.77	13379.71	13308.29	13312.62	5782.0
2020-09-07 23:00:00	NQ	Futures	13312.33	13320.14	13267.8	13297.01	5787.0
2020-09-07 00:00:00	YM	Futures	30976.2	30976.2	30901.3	30915.6	1383.0
2020-09-07 01:00:00	YM	Futures	30915.6	30953.0	30869.4	30898.0	2077.0
2020-09-07 02:00:00	YM	Futures	30898.0	30958.6	30795.6	30850.6	5187.0
2020-09-07 03:00:00	YM	Futures	30848.4	30938.7	30818.7	30903.5	6341.0
2020-09-07 04:00:00	YM	Futures	30904.6	30996.0	30883.7	30911.2	4320.0
2020-09-07 05:00:00	YM	Futures	30913.4	30983.9	30877.1	30927.7	2618.0
2020-09-07 06:00:00	YM	Futures	30927.7	30983.9	30905.7	30942.0	1844.0
2020-09-07 07:00:00	YM	Futures	30946.4	31059.9	30924.4	31029.0	2863.0
2020-09-07 08:00:00	YM	Futures	31027.9	31061.0	31002.6	31034.5	2294.0
2020-09-07 09:00:00	YM	Futures	31034.5	31112.7	30999.3	31077.5	5947.0
2020-09-07 10:00:00	YM	Futures	31075.3	31168.9	31067.6	31123.7	4126.0
2020-09-07 11:00:00	YM	Futures	31124.8	31164.5	31112.7	31155.7	3269.0

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

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