PREVIEW / futures_1hour / 2020-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-04.parquet
  size:    52 KB
  rows:    1,511

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-04 00:00:00	ES	Futures	3845.46	3854.4	3843.51	3853.0	11135.0
2020-09-04 01:00:00	ES	Futures	3853.0	3859.15	3847.42	3855.79	9624.0
2020-09-04 02:00:00	ES	Futures	3855.79	3857.19	3841.83	3845.46	17561.0
2020-09-04 03:00:00	ES	Futures	3845.46	3876.74	3837.64	3874.5	46299.0
2020-09-04 04:00:00	ES	Futures	3874.22	3884.28	3870.59	3880.93	30506.0
2020-09-04 05:00:00	ES	Futures	3880.65	3890.14	3876.46	3889.02	19039.0
2020-09-04 06:00:00	ES	Futures	3889.3	3891.82	3876.74	3876.74	25984.0
2020-09-04 07:00:00	ES	Futures	3876.74	3877.85	3849.93	3853.0	54786.0
2020-09-04 08:00:00	ES	Futures	3853.28	3878.13	3850.21	3869.48	100462.0
2020-09-04 09:00:00	ES	Futures	3869.48	3884.0	3830.94	3836.53	303297.0
2020-09-04 10:00:00	ES	Futures	3836.53	3849.65	3739.35	3779.0	644406.0
2020-09-04 11:00:00	ES	Futures	3778.72	3791.29	3744.93	3787.38	358897.0
2020-09-04 12:00:00	ES	Futures	3787.38	3814.47	3774.26	3806.37	279421.0
2020-09-04 13:00:00	ES	Futures	3806.37	3806.65	3779.0	3800.5	200004.0
2020-09-04 14:00:00	ES	Futures	3800.23	3848.25	3792.69	3847.7	232007.0
2020-09-04 15:00:00	ES	Futures	3847.7	3857.19	3822.01	3826.19	368028.0
2020-09-04 16:00:00	ES	Futures	3825.92	3829.27	3813.35	3814.47	78846.0
2020-09-04 00:00:00	NQ	Futures	13467.91	13527.48	13463.86	13521.99	7998.0
2020-09-04 01:00:00	NQ	Futures	13522.57	13540.21	13480.64	13521.41	6550.0
2020-09-04 02:00:00	NQ	Futures	13519.96	13522.57	13449.98	13462.71	7832.0
2020-09-04 03:00:00	NQ	Futures	13462.13	13623.78	13439.57	13613.66	16703.0
2020-09-04 04:00:00	NQ	Futures	13613.08	13636.5	13569.7	13613.66	12169.0
2020-09-04 05:00:00	NQ	Futures	13613.08	13641.71	13574.62	13639.68	5842.0
2020-09-04 06:00:00	NQ	Futures	13640.26	13648.07	13580.98	13588.21	7457.0
2020-09-04 07:00:00	NQ	Futures	13587.92	13588.5	13433.5	13467.62	21410.0
2020-09-04 08:00:00	NQ	Futures	13466.47	13578.38	13438.42	13520.83	37861.0
2020-09-04 09:00:00	NQ	Futures	13521.12	13698.97	13303.37	13351.66	157971.0
2020-09-04 10:00:00	NQ	Futures	13350.22	13432.05	12888.11	13128.42	203699.0
2020-09-04 11:00:00	NQ	Futures	13127.84	13298.45	12997.13	13290.65	131298.0
2020-09-04 12:00:00	NQ	Futures	13290.93	13397.35	13194.93	13313.49	124915.0
2020-09-04 13:00:00	NQ	Futures	13312.62	13314.36	13149.82	13276.48	104549.0
2020-09-04 14:00:00	NQ	Futures	13276.19	13520.54	13242.35	13514.47	107957.0
2020-09-04 15:00:00	NQ	Futures	13515.34	13592.84	13436.68	13441.31	130598.0
2020-09-04 16:00:00	NQ	Futures	13439.86	13445.36	13345.59	13346.46	24316.0
2020-09-04 00:00:00	YM	Futures	31113.8	31170.0	31098.4	31160.1	1696.0
2020-09-04 01:00:00	YM	Futures	31159.0	31207.4	31121.5	31185.4	2005.0
2020-09-04 02:00:00	YM	Futures	31187.6	31200.8	31077.5	31109.4	3765.0
2020-09-04 03:00:00	YM	Futures	31108.3	31342.8	31030.1	31312.0	8820.0
2020-09-04 04:00:00	YM	Futures	31310.9	31422.1	31296.6	31389.1	8496.0
2020-09-04 05:00:00	YM	Futures	31385.8	31467.3	31337.3	31457.4	4255.0
2020-09-04 06:00:00	YM	Futures	31458.5	31483.8	31357.2	31361.6	4132.0
2020-09-04 07:00:00	YM	Futures	31358.3	31374.8	31193.1	31217.3	10754.0
2020-09-04 08:00:00	YM	Futures	31218.4	31444.2	31218.4	31370.4	14385.0
2020-09-04 09:00:00	YM	Futures	31371.5	31419.9	31152.4	31168.9	45008.0
2020-09-04 10:00:00	YM	Futures	31167.8	31285.6	30488.4	30689.9	84995.0
2020-09-04 11:00:00	YM	Futures	30687.7	30720.7	30438.8	30642.5	47311.0
2020-09-04 12:00:00	YM	Futures	30635.9	30873.8	30562.1	30809.9	36213.0
2020-09-04 13:00:00	YM	Futures	30809.9	30815.4	30655.7	30794.5	20933.0
2020-09-04 14:00:00	YM	Futures	30794.5	31145.7	30741.6	31135.8	24496.0
2020-09-04 15:00:00	YM	Futures	31135.8	31196.4	30922.2	30959.7	39840.0

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

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