PREVIEW / futures_1hour / 2020-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-16.parquet
  size:    60 KB
  rows:    1,844

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-16 00:00:00	ES	Futures	3812.09	3812.37	3807.88	3808.73	3411.0
2020-09-16 01:00:00	ES	Futures	3808.73	3808.73	3803.68	3804.8	5209.0
2020-09-16 02:00:00	ES	Futures	3804.52	3810.69	3801.44	3809.57	6568.0
2020-09-16 03:00:00	ES	Futures	3809.57	3815.45	3807.04	3812.09	14048.0
2020-09-16 04:00:00	ES	Futures	3812.09	3822.17	3810.41	3819.09	17628.0
2020-09-16 05:00:00	ES	Futures	3819.09	3824.97	3818.53	3823.57	22153.0
2020-09-16 06:00:00	ES	Futures	3823.57	3829.73	3818.81	3826.93	34155.0
2020-09-16 07:00:00	ES	Futures	3826.93	3828.05	3817.97	3823.29	32629.0
2020-09-16 08:00:00	ES	Futures	3823.29	3824.97	3816.29	3820.49	27110.0
2020-09-16 09:00:00	ES	Futures	3820.49	3820.49	3804.8	3812.37	136569.0
2020-09-16 10:00:00	ES	Futures	3812.37	3816.85	3800.32	3808.44	167557.0
2020-09-16 11:00:00	ES	Futures	3808.73	3823.29	3807.88	3815.73	141505.0
2020-09-16 12:00:00	ES	Futures	3815.45	3818.81	3807.88	3809.85	64884.0
2020-09-16 13:00:00	ES	Futures	3810.13	3812.65	3801.44	3809.85	76885.0
2020-09-16 14:00:00	ES	Futures	3809.57	3831.13	3806.2	3814.33	216370.0
2020-09-16 15:00:00	ES	Futures	3814.05	3818.53	3779.88	3783.24	399104.0
2020-09-16 16:00:00	ES	Futures	3783.24	3790.8	3780.16	3787.44	57055.0
2020-09-16 18:00:00	ES	Futures	3788.56	3794.16	3783.8	3790.8	8755.0
2020-09-16 19:00:00	ES	Futures	3790.8	3793.04	3786.04	3787.72	5419.0
2020-09-16 20:00:00	ES	Futures	3787.72	3789.12	3766.43	3772.87	22617.0
2020-09-16 21:00:00	ES	Futures	3772.87	3779.6	3753.83	3756.07	21915.0
2020-09-16 22:00:00	ES	Futures	3756.07	3757.19	3746.26	3748.78	23946.0
2020-09-16 23:00:00	ES	Futures	3748.5	3750.47	3735.9	3747.1	21089.0
2020-09-16 00:00:00	NQ	Futures	13304.85	13305.43	13283.72	13284.88	1597.0
2020-09-16 01:00:00	NQ	Futures	13285.74	13289.22	13262.59	13269.53	3237.0
2020-09-16 02:00:00	NQ	Futures	13269.25	13294.14	13251.88	13287.48	3606.0
2020-09-16 03:00:00	NQ	Futures	13286.61	13307.74	13276.48	13300.51	5152.0
2020-09-16 04:00:00	NQ	Futures	13301.38	13348.56	13291.53	13337.85	7248.0
2020-09-16 05:00:00	NQ	Futures	13338.72	13352.32	13317.01	13322.51	5579.0
2020-09-16 06:00:00	NQ	Futures	13322.51	13360.72	13306.01	13341.61	6062.0
2020-09-16 07:00:00	NQ	Futures	13342.19	13342.19	13264.9	13301.38	12516.0
2020-09-16 08:00:00	NQ	Futures	13301.09	13305.14	13274.46	13285.74	10585.0
2020-09-16 09:00:00	NQ	Futures	13286.32	13289.8	13194.56	13253.03	69849.0
2020-09-16 10:00:00	NQ	Futures	13252.75	13264.32	13125.96	13167.35	78678.0
2020-09-16 11:00:00	NQ	Futures	13167.35	13238.56	13164.46	13181.25	50451.0
2020-09-16 12:00:00	NQ	Futures	13181.25	13206.14	13132.62	13152.59	41512.0
2020-09-16 13:00:00	NQ	Futures	13152.59	13169.96	13092.67	13148.54	42820.0
2020-09-16 14:00:00	NQ	Futures	13148.54	13234.8	13119.59	13140.14	79783.0
2020-09-16 15:00:00	NQ	Futures	13139.27	13164.75	12999.46	13008.72	100773.0
2020-09-16 16:00:00	NQ	Futures	13009.3	13046.06	12995.7	13026.09	13972.0
2020-09-16 18:00:00	NQ	Futures	13034.2	13070.67	13017.7	13057.35	3378.0
2020-09-16 19:00:00	NQ	Futures	13056.78	13066.62	13038.54	13046.93	2691.0
2020-09-16 20:00:00	NQ	Futures	13047.8	13053.01	12930.57	12954.01	10861.0
2020-09-16 21:00:00	NQ	Futures	12954.88	12995.12	12905.38	12911.75	10341.0
2020-09-16 22:00:00	NQ	Futures	12912.04	12916.38	12854.44	12873.25	10278.0
2020-09-16 23:00:00	NQ	Futures	12871.8	12884.25	12812.46	12873.25	9054.0
2020-09-16 00:00:00	YM	Futures	30919.8	30919.8	30886.6	30893.2	464.0
2020-09-16 01:00:00	YM	Futures	30893.2	30893.2	30855.6	30861.2	835.0
2020-09-16 02:00:00	YM	Futures	30862.3	30910.9	30836.8	30905.4	1359.0
2020-09-16 03:00:00	YM	Futures	30905.4	30956.2	30882.2	30915.3	2631.0

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

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