PREVIEW / futures_1hour / 2020-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-21.parquet
  size:    61 KB
  rows:    1,878

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-21 00:00:00	ES	Futures	3870.63	3873.71	3869.23	3871.47	5570.0
2020-10-21 01:00:00	ES	Futures	3871.47	3873.43	3860.82	3864.18	9768.0
2020-10-21 02:00:00	ES	Futures	3864.46	3873.71	3862.78	3868.67	11760.0
2020-10-21 03:00:00	ES	Futures	3868.95	3868.95	3849.06	3855.22	29989.0
2020-10-21 04:00:00	ES	Futures	3854.94	3856.62	3834.21	3834.77	30508.0
2020-10-21 05:00:00	ES	Futures	3834.77	3852.42	3832.25	3850.46	21290.0
2020-10-21 06:00:00	ES	Futures	3850.46	3852.14	3843.74	3846.26	11556.0
2020-10-21 07:00:00	ES	Futures	3846.54	3847.1	3835.33	3842.06	25228.0
2020-10-21 08:00:00	ES	Futures	3842.34	3853.26	3840.1	3848.5	32722.0
2020-10-21 09:00:00	ES	Futures	3848.22	3871.75	3844.86	3870.35	167463.0
2020-10-21 10:00:00	ES	Futures	3870.35	3873.43	3852.7	3854.94	179387.0
2020-10-21 11:00:00	ES	Futures	3855.22	3856.34	3836.73	3845.14	230964.0
2020-10-21 12:00:00	ES	Futures	3845.14	3866.98	3837.29	3840.94	236995.0
2020-10-21 13:00:00	ES	Futures	3840.66	3856.9	3839.26	3849.34	113456.0
2020-10-21 14:00:00	ES	Futures	3849.34	3865.3	3847.1	3865.02	157528.0
2020-10-21 15:00:00	ES	Futures	3864.74	3866.14	3838.42	3839.82	250139.0
2020-10-21 16:00:00	ES	Futures	3839.82	3852.42	3838.98	3844.58	55576.0
2020-10-21 18:00:00	ES	Futures	3843.18	3847.38	3839.54	3840.66	9761.0
2020-10-21 19:00:00	ES	Futures	3840.94	3845.42	3812.09	3824.41	45279.0
2020-10-21 20:00:00	ES	Futures	3824.69	3827.77	3812.93	3825.53	25105.0
2020-10-21 21:00:00	ES	Futures	3825.53	3826.65	3818.53	3823.01	9274.0
2020-10-21 22:00:00	ES	Futures	3823.01	3823.29	3814.89	3819.93	12050.0
2020-10-21 23:00:00	ES	Futures	3819.93	3822.45	3815.17	3815.45	4865.0
2020-10-21 00:00:00	NQ	Futures	13581.87	13592.87	13577.82	13586.21	2335.0
2020-10-21 01:00:00	NQ	Futures	13586.5	13592.29	13530.06	13552.64	5204.0
2020-10-21 02:00:00	NQ	Futures	13552.92	13595.77	13544.53	13573.77	5125.0
2020-10-21 03:00:00	NQ	Futures	13573.19	13573.48	13483.74	13510.95	12229.0
2020-10-21 04:00:00	NQ	Futures	13510.95	13527.45	13437.43	13438.87	11689.0
2020-10-21 05:00:00	NQ	Futures	13439.45	13531.79	13413.98	13520.21	11664.0
2020-10-21 06:00:00	NQ	Futures	13520.5	13538.45	13492.43	13517.61	5917.0
2020-10-21 07:00:00	NQ	Futures	13518.48	13519.35	13451.03	13467.24	9941.0
2020-10-21 08:00:00	NQ	Futures	13467.82	13525.71	13462.03	13517.61	10196.0
2020-10-21 09:00:00	NQ	Futures	13517.61	13638.9	13495.32	13632.53	61047.0
2020-10-21 10:00:00	NQ	Futures	13632.24	13638.32	13537.87	13549.16	69105.0
2020-10-21 11:00:00	NQ	Futures	13549.45	13560.16	13466.08	13503.43	82780.0
2020-10-21 12:00:00	NQ	Futures	13504.0	13591.13	13468.69	13480.85	86127.0
2020-10-21 13:00:00	NQ	Futures	13480.85	13564.21	13470.72	13531.79	41807.0
2020-10-21 14:00:00	NQ	Futures	13531.79	13606.19	13517.32	13605.03	58911.0
2020-10-21 15:00:00	NQ	Futures	13604.74	13607.06	13488.66	13492.43	75833.0
2020-10-21 16:00:00	NQ	Futures	13493.0	13553.79	13487.79	13533.24	13577.0
2020-10-21 18:00:00	NQ	Futures	13528.03	13548.87	13503.43	13526.58	4968.0
2020-10-21 19:00:00	NQ	Futures	13526.0	13538.16	13420.93	13461.16	11979.0
2020-10-21 20:00:00	NQ	Futures	13460.58	13475.93	13426.43	13470.14	6974.0
2020-10-21 21:00:00	NQ	Futures	13471.58	13473.03	13442.06	13462.03	3458.0
2020-10-21 22:00:00	NQ	Futures	13461.74	13464.06	13431.35	13456.82	4101.0
2020-10-21 23:00:00	NQ	Futures	13457.4	13468.69	13438.58	13442.64	2398.0
2020-10-21 00:00:00	YM	Futures	31342.1	31364.2	31328.8	31346.5	1334.0
2020-10-21 01:00:00	YM	Futures	31347.6	31363.1	31276.9	31300.1	1918.0
2020-10-21 02:00:00	YM	Futures	31303.4	31362.0	31287.9	31320.0	2684.0
2020-10-21 03:00:00	YM	Futures	31318.9	31318.9	31186.2	31233.7	5750.0

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

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