PREVIEW / futures_1hour / 2020-08-10

all futures 1-hour files

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

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-08-10 00:00:00	ES	Futures	3741.58	3744.1	3741.03	3743.26	5002.0
2020-08-10 01:00:00	ES	Futures	3742.98	3748.01	3742.98	3747.17	7847.0
2020-08-10 02:00:00	ES	Futures	3747.17	3747.17	3740.75	3741.3	10511.0
2020-08-10 03:00:00	ES	Futures	3741.03	3746.89	3736.56	3742.98	25221.0
2020-08-10 04:00:00	ES	Futures	3742.7	3742.98	3734.32	3741.58	20612.0
2020-08-10 05:00:00	ES	Futures	3741.58	3744.93	3739.35	3742.7	10910.0
2020-08-10 06:00:00	ES	Futures	3742.98	3743.82	3740.19	3741.58	10329.0
2020-08-10 07:00:00	ES	Futures	3741.58	3741.86	3736.56	3739.35	14426.0
2020-08-10 08:00:00	ES	Futures	3739.63	3741.86	3737.67	3740.75	13297.0
2020-08-10 09:00:00	ES	Futures	3740.75	3747.73	3737.4	3742.42	126302.0
2020-08-10 10:00:00	ES	Futures	3742.42	3745.77	3720.64	3720.92	201359.0
2020-08-10 11:00:00	ES	Futures	3720.92	3741.58	3718.41	3740.47	159151.0
2020-08-10 12:00:00	ES	Futures	3740.47	3744.66	3734.04	3742.98	102803.0
2020-08-10 13:00:00	ES	Futures	3742.98	3746.33	3740.47	3742.42	81364.0
2020-08-10 14:00:00	ES	Futures	3742.42	3747.17	3738.79	3746.89	86029.0
2020-08-10 15:00:00	ES	Futures	3746.89	3749.96	3739.63	3747.45	208331.0
2020-08-10 16:00:00	ES	Futures	3747.73	3748.29	3742.14	3744.66	35877.0
2020-08-10 18:00:00	ES	Futures	3742.14	3744.1	3739.63	3740.47	6050.0
2020-08-10 19:00:00	ES	Futures	3740.47	3745.77	3739.07	3744.38	9479.0
2020-08-10 20:00:00	ES	Futures	3744.1	3747.45	3739.63	3746.89	14835.0
2020-08-10 21:00:00	ES	Futures	3746.89	3752.47	3745.49	3751.36	13813.0
2020-08-10 22:00:00	ES	Futures	3751.36	3755.27	3751.36	3753.87	10595.0
2020-08-10 23:00:00	ES	Futures	3753.87	3755.55	3753.03	3754.99	4578.0
2020-08-10 00:00:00	NQ	Futures	12854.56	12864.97	12851.09	12861.79	1442.0
2020-08-10 01:00:00	NQ	Futures	12862.08	12880.3	12860.64	12879.14	2787.0
2020-08-10 02:00:00	NQ	Futures	12878.57	12879.14	12851.67	12854.56	3370.0
2020-08-10 03:00:00	NQ	Futures	12853.7	12874.23	12838.95	12866.42	6275.0
2020-08-10 04:00:00	NQ	Futures	12867.0	12869.6	12833.74	12857.46	6502.0
2020-08-10 05:00:00	NQ	Futures	12857.75	12871.63	12850.23	12862.95	3098.0
2020-08-10 06:00:00	NQ	Futures	12864.69	12871.34	12855.72	12866.71	2428.0
2020-08-10 07:00:00	NQ	Futures	12866.42	12875.67	12853.7	12875.67	4078.0
2020-08-10 08:00:00	NQ	Futures	12875.1	12885.22	12870.18	12879.14	7449.0
2020-08-10 09:00:00	NQ	Futures	12878.86	12893.6	12799.04	12817.55	62078.0
2020-08-10 10:00:00	NQ	Futures	12817.84	12824.2	12657.63	12659.37	100036.0
2020-08-10 11:00:00	NQ	Futures	12659.08	12768.68	12640.86	12760.0	75129.0
2020-08-10 12:00:00	NQ	Futures	12760.0	12820.44	12732.24	12808.01	45794.0
2020-08-10 13:00:00	NQ	Futures	12808.3	12842.42	12785.16	12795.28	38262.0
2020-08-10 14:00:00	NQ	Futures	12795.28	12823.04	12770.99	12818.71	37552.0
2020-08-10 15:00:00	NQ	Futures	12818.42	12834.32	12771.57	12814.37	51778.0
2020-08-10 16:00:00	NQ	Futures	12814.95	12828.54	12799.62	12815.81	7679.0
2020-08-10 18:00:00	NQ	Futures	12807.43	12808.58	12793.55	12796.44	1779.0
2020-08-10 19:00:00	NQ	Futures	12795.86	12812.92	12791.52	12809.16	1636.0
2020-08-10 20:00:00	NQ	Futures	12808.58	12832.3	12798.17	12829.69	3898.0
2020-08-10 21:00:00	NQ	Futures	12829.41	12856.59	12823.91	12852.54	4563.0
2020-08-10 22:00:00	NQ	Futures	12852.25	12867.29	12852.25	12857.75	3820.0
2020-08-10 23:00:00	NQ	Futures	12858.32	12865.26	12852.83	12862.37	1561.0
2020-08-10 00:00:00	YM	Futures	30176.7	30203.2	30176.7	30192.2	822.0
2020-08-10 01:00:00	YM	Futures	30192.2	30246.1	30190.0	30239.5	1895.0
2020-08-10 02:00:00	YM	Futures	30239.5	30239.5	30199.9	30203.2	2523.0
2020-08-10 03:00:00	YM	Futures	30202.1	30249.4	30153.6	30203.2	4547.0

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

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