PREVIEW / futures_1hour / 2020-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-20.parquet
  size:    61 KB
  rows:    1,897

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-02-20 00:00:00	ES	Futures	3666.5	3669.2	3665.4	3667.9	11576.0
2020-02-20 01:00:00	ES	Futures	3667.9	3671.6	3667.3	3670.3	16589.0
2020-02-20 02:00:00	ES	Futures	3670.0	3676.0	3669.2	3674.4	27513.0
2020-02-20 03:00:00	ES	Futures	3674.6	3674.9	3663.8	3666.8	44256.0
2020-02-20 04:00:00	ES	Futures	3667.0	3670.3	3665.1	3669.2	21216.0
2020-02-20 05:00:00	ES	Futures	3669.2	3670.8	3664.3	3667.0	15769.0
2020-02-20 06:00:00	ES	Futures	3666.8	3667.9	3662.2	3662.4	19901.0
2020-02-20 07:00:00	ES	Futures	3662.4	3666.2	3662.2	3665.1	19579.0
2020-02-20 08:00:00	ES	Futures	3665.1	3667.0	3658.6	3662.4	51738.0
2020-02-20 09:00:00	ES	Futures	3662.4	3671.1	3661.3	3669.2	185350.0
2020-02-20 10:00:00	ES	Futures	3669.2	3673.5	3668.1	3670.8	141127.0
2020-02-20 11:00:00	ES	Futures	3670.8	3671.1	3619.6	3638.9	551760.0
2020-02-20 12:00:00	ES	Futures	3638.9	3642.1	3629.4	3641.3	233682.0
2020-02-20 13:00:00	ES	Futures	3641.6	3651.6	3639.1	3643.5	151028.0
2020-02-20 14:00:00	ES	Futures	3643.5	3657.0	3643.5	3652.4	147369.0
2020-02-20 15:00:00	ES	Futures	3652.4	3658.4	3645.9	3655.1	219952.0
2020-02-20 16:00:00	ES	Futures	3655.1	3657.3	3650.0	3650.2	66149.0
2020-02-20 18:00:00	ES	Futures	3649.7	3652.1	3634.8	3637.8	34900.0
2020-02-20 19:00:00	ES	Futures	3637.8	3648.3	3637.5	3645.1	28285.0
2020-02-20 20:00:00	ES	Futures	3645.1	3647.3	3640.5	3642.7	21863.0
2020-02-20 21:00:00	ES	Futures	3642.9	3642.9	3636.4	3640.5	24351.0
2020-02-20 22:00:00	ES	Futures	3640.2	3642.9	3639.1	3642.1	9642.0
2020-02-20 23:00:00	ES	Futures	3642.1	3642.4	3637.2	3639.1	7611.0
2020-02-20 00:00:00	NQ	Futures	11232.94	11244.79	11228.89	11239.88	10456.0
2020-02-20 01:00:00	NQ	Futures	11240.17	11256.07	11236.41	11250.29	9830.0
2020-02-20 02:00:00	NQ	Futures	11250.58	11270.82	11245.66	11265.9	12292.0
2020-02-20 03:00:00	NQ	Futures	11265.9	11266.77	11229.18	11239.88	17375.0
2020-02-20 04:00:00	NQ	Futures	11240.17	11253.47	11237.56	11249.71	11821.0
2020-02-20 05:00:00	NQ	Futures	11249.42	11254.33	11234.96	11244.21	7883.0
2020-02-20 06:00:00	NQ	Futures	11243.64	11245.08	11223.68	11226.28	7660.0
2020-02-20 07:00:00	NQ	Futures	11226.57	11239.59	11225.42	11234.96	9078.0
2020-02-20 08:00:00	NQ	Futures	11234.67	11242.19	11209.51	11222.24	17641.0
2020-02-20 09:00:00	NQ	Futures	11222.53	11242.19	11203.73	11236.41	76980.0
2020-02-20 10:00:00	NQ	Futures	11236.41	11250.0	11216.74	11221.66	72319.0
2020-02-20 11:00:00	NQ	Futures	11221.66	11222.81	11008.25	11085.17	189239.0
2020-02-20 12:00:00	NQ	Futures	11084.88	11086.9	11043.82	11084.88	86676.0
2020-02-20 13:00:00	NQ	Futures	11084.59	11125.07	11073.31	11089.22	60158.0
2020-02-20 14:00:00	NQ	Futures	11090.08	11150.52	11090.08	11130.57	55664.0
2020-02-20 15:00:00	NQ	Futures	11130.57	11154.57	11104.25	11143.58	69774.0
2020-02-20 16:00:00	NQ	Futures	11143.58	11151.39	11125.07	11125.36	10817.0
2020-02-20 18:00:00	NQ	Futures	11124.21	11131.73	11062.03	11072.73	16244.0
2020-02-20 19:00:00	NQ	Futures	11073.02	11118.42	11072.16	11104.25	15649.0
2020-02-20 20:00:00	NQ	Futures	11104.25	11115.82	11089.51	11096.16	11998.0
2020-02-20 21:00:00	NQ	Futures	11096.16	11096.74	11068.97	11085.75	13637.0
2020-02-20 22:00:00	NQ	Futures	11086.04	11095.87	11082.28	11093.55	4697.0
2020-02-20 23:00:00	NQ	Futures	11093.84	11094.13	11071.58	11079.38	5170.0
2020-02-20 00:00:00	YM	Futures	31891.4	31914.3	31879.5	31896.9	3312.0
2020-02-20 01:00:00	YM	Futures	31898.0	31940.4	31890.4	31919.8	3740.0
2020-02-20 02:00:00	YM	Futures	31917.6	31984.0	31911.0	31967.7	5458.0
2020-02-20 03:00:00	YM	Futures	31967.7	31969.8	31869.7	31898.0	7619.0

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

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