PREVIEW / futures_1hour / 2020-10-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-08.parquet
  size:    59 KB
  rows:    1,841

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-10-08 00:00:00	ES	Futures	3828.33	3830.01	3825.81	3829.73	3554.0
2020-10-08 01:00:00	ES	Futures	3830.01	3831.41	3827.77	3830.85	4572.0
2020-10-08 02:00:00	ES	Futures	3830.85	3846.26	3830.57	3844.3	22884.0
2020-10-08 03:00:00	ES	Futures	3844.3	3846.26	3836.17	3837.29	23773.0
2020-10-08 04:00:00	ES	Futures	3837.01	3838.13	3825.25	3833.37	23560.0
2020-10-08 05:00:00	ES	Futures	3833.09	3834.21	3828.33	3830.29	15093.0
2020-10-08 06:00:00	ES	Futures	3830.29	3843.74	3829.17	3831.69	22764.0
2020-10-08 07:00:00	ES	Futures	3831.97	3834.77	3828.89	3833.65	17356.0
2020-10-08 08:00:00	ES	Futures	3833.93	3844.02	3832.25	3840.38	47798.0
2020-10-08 09:00:00	ES	Futures	3840.38	3845.14	3835.05	3844.58	131818.0
2020-10-08 10:00:00	ES	Futures	3844.58	3849.62	3834.77	3842.9	167898.0
2020-10-08 11:00:00	ES	Futures	3842.9	3848.78	3830.29	3836.73	145852.0
2020-10-08 12:00:00	ES	Futures	3836.73	3848.5	3836.45	3846.54	75232.0
2020-10-08 13:00:00	ES	Futures	3846.82	3847.66	3841.22	3842.34	53035.0
2020-10-08 14:00:00	ES	Futures	3842.34	3850.74	3840.66	3848.78	70482.0
2020-10-08 15:00:00	ES	Futures	3848.5	3852.7	3842.9	3851.3	141421.0
2020-10-08 16:00:00	ES	Futures	3851.3	3862.22	3848.5	3861.1	49168.0
2020-10-08 18:00:00	ES	Futures	3862.22	3872.03	3860.54	3868.11	17571.0
2020-10-08 19:00:00	ES	Futures	3868.39	3870.35	3866.14	3869.51	10015.0
2020-10-08 20:00:00	ES	Futures	3869.51	3871.75	3864.74	3867.26	14328.0
2020-10-08 21:00:00	ES	Futures	3867.26	3870.35	3865.58	3869.51	8673.0
2020-10-08 22:00:00	ES	Futures	3869.51	3873.71	3868.95	3873.43	5984.0
2020-10-08 23:00:00	ES	Futures	3873.43	3876.51	3872.59	3872.59	6922.0
2020-10-08 00:00:00	NQ	Futures	13321.64	13325.98	13308.32	13325.69	2173.0
2020-10-08 01:00:00	NQ	Futures	13325.11	13330.61	13315.56	13325.11	2633.0
2020-10-08 02:00:00	NQ	Futures	13324.24	13398.35	13324.24	13388.22	7618.0
2020-10-08 03:00:00	NQ	Futures	13388.22	13399.51	13369.69	13376.64	6020.0
2020-10-08 04:00:00	NQ	Futures	13376.06	13382.43	13344.51	13367.38	7234.0
2020-10-08 05:00:00	NQ	Futures	13366.8	13386.48	13352.9	13361.59	5393.0
2020-10-08 06:00:00	NQ	Futures	13361.3	13385.03	13344.51	13349.43	6183.0
2020-10-08 07:00:00	NQ	Futures	13348.56	13383.3	13344.8	13376.35	7099.0
2020-10-08 08:00:00	NQ	Futures	13377.51	13406.74	13365.64	13389.09	19444.0
2020-10-08 09:00:00	NQ	Futures	13389.09	13404.43	13329.45	13364.77	55910.0
2020-10-08 10:00:00	NQ	Futures	13364.77	13374.03	13301.38	13331.48	66511.0
2020-10-08 11:00:00	NQ	Futures	13331.19	13376.93	13310.93	13343.64	54380.0
2020-10-08 12:00:00	NQ	Futures	13344.22	13388.8	13344.22	13372.88	34467.0
2020-10-08 13:00:00	NQ	Futures	13372.88	13376.64	13322.51	13323.09	26182.0
2020-10-08 14:00:00	NQ	Futures	13323.09	13366.8	13317.01	13355.51	28336.0
2020-10-08 15:00:00	NQ	Futures	13354.93	13362.16	13330.03	13357.82	33923.0
2020-10-08 16:00:00	NQ	Futures	13357.24	13395.74	13348.27	13384.74	9424.0
2020-10-08 18:00:00	NQ	Futures	13387.35	13413.69	13382.43	13400.95	6398.0
2020-10-08 19:00:00	NQ	Futures	13402.11	13410.22	13393.43	13407.32	4978.0
2020-10-08 20:00:00	NQ	Futures	13407.03	13418.9	13388.8	13398.93	7463.0
2020-10-08 21:00:00	NQ	Futures	13399.22	13412.24	13392.85	13412.24	3549.0
2020-10-08 22:00:00	NQ	Futures	13411.66	13425.56	13406.16	13422.37	3556.0
2020-10-08 23:00:00	NQ	Futures	13422.37	13434.24	13421.51	13426.14	3342.0
2020-10-08 00:00:00	YM	Futures	31255.9	31268.0	31236.0	31266.9	1314.0
2020-10-08 01:00:00	YM	Futures	31266.9	31279.1	31248.1	31272.4	1529.0
2020-10-08 02:00:00	YM	Futures	31271.3	31390.7	31270.2	31377.5	6106.0
2020-10-08 03:00:00	YM	Futures	31378.6	31395.2	31305.6	31312.2	5157.0

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

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