PREVIEW / futures_1hour / 2020-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-03.parquet
  size:    60 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-03 00:00:00	ES	Futures	3643.57	3645.8	3641.34	3645.52	4948.0
2020-08-03 01:00:00	ES	Futures	3645.8	3649.71	3643.29	3646.08	6686.0
2020-08-03 02:00:00	ES	Futures	3645.8	3646.64	3640.22	3643.01	13400.0
2020-08-03 03:00:00	ES	Futures	3643.29	3646.08	3635.47	3645.8	29745.0
2020-08-03 04:00:00	ES	Futures	3645.8	3650.27	3636.87	3640.78	20674.0
2020-08-03 05:00:00	ES	Futures	3640.78	3649.43	3638.82	3649.15	14208.0
2020-08-03 06:00:00	ES	Futures	3649.15	3664.51	3647.48	3663.4	24688.0
2020-08-03 07:00:00	ES	Futures	3663.67	3668.14	3661.16	3668.14	28964.0
2020-08-03 08:00:00	ES	Futures	3668.14	3670.38	3665.91	3668.14	29107.0
2020-08-03 09:00:00	ES	Futures	3668.14	3669.54	3659.77	3666.47	130812.0
2020-08-03 10:00:00	ES	Futures	3667.03	3677.08	3661.72	3665.63	215979.0
2020-08-03 11:00:00	ES	Futures	3665.63	3678.75	3664.79	3675.12	125430.0
2020-08-03 12:00:00	ES	Futures	3675.12	3676.52	3671.21	3673.45	79018.0
2020-08-03 13:00:00	ES	Futures	3673.45	3677.36	3672.33	3675.12	67239.0
2020-08-03 14:00:00	ES	Futures	3675.4	3680.99	3673.17	3679.59	77695.0
2020-08-03 15:00:00	ES	Futures	3679.59	3680.43	3667.31	3671.49	216588.0
2020-08-03 16:00:00	ES	Futures	3671.21	3675.4	3666.75	3674.01	51917.0
2020-08-03 18:00:00	ES	Futures	3675.68	3675.96	3669.82	3671.49	3379.0
2020-08-03 19:00:00	ES	Futures	3671.49	3675.12	3670.66	3672.33	5530.0
2020-08-03 20:00:00	ES	Futures	3672.33	3675.12	3668.98	3672.89	10550.0
2020-08-03 21:00:00	ES	Futures	3672.61	3679.87	3671.21	3674.29	12535.0
2020-08-03 22:00:00	ES	Futures	3674.57	3677.64	3673.45	3674.01	4634.0
2020-08-03 23:00:00	ES	Futures	3674.01	3674.84	3670.38	3671.21	5091.0
2020-08-03 00:00:00	NQ	Futures	12634.5	12647.51	12620.04	12643.75	2750.0
2020-08-03 01:00:00	NQ	Futures	12644.04	12662.55	12637.68	12646.93	2358.0
2020-08-03 02:00:00	NQ	Futures	12647.51	12653.87	12632.19	12640.28	3613.0
2020-08-03 03:00:00	NQ	Futures	12640.28	12651.27	12607.61	12648.67	6940.0
2020-08-03 04:00:00	NQ	Futures	12648.09	12671.51	12632.76	12651.27	6267.0
2020-08-03 05:00:00	NQ	Futures	12651.56	12665.15	12639.99	12660.53	4001.0
2020-08-03 06:00:00	NQ	Futures	12660.24	12714.6	12655.32	12713.73	7496.0
2020-08-03 07:00:00	NQ	Futures	12713.73	12729.35	12704.48	12717.2	8252.0
2020-08-03 08:00:00	NQ	Futures	12717.49	12722.41	12699.56	12712.0	9468.0
2020-08-03 09:00:00	NQ	Futures	12712.58	12781.69	12690.89	12761.45	60205.0
2020-08-03 10:00:00	NQ	Futures	12761.16	12802.22	12713.73	12734.56	71640.0
2020-08-03 11:00:00	NQ	Futures	12735.13	12785.45	12727.33	12785.16	39314.0
2020-08-03 12:00:00	NQ	Futures	12784.87	12788.92	12757.98	12773.02	25224.0
2020-08-03 13:00:00	NQ	Futures	12773.02	12790.37	12749.59	12766.65	23027.0
2020-08-03 14:00:00	NQ	Futures	12767.52	12808.3	12752.48	12794.42	30033.0
2020-08-03 15:00:00	NQ	Futures	12794.7	12801.64	12742.94	12768.1	49181.0
2020-08-03 16:00:00	NQ	Futures	12767.81	12787.19	12752.77	12785.74	10283.0
2020-08-03 18:00:00	NQ	Futures	12786.32	12786.61	12762.32	12769.83	1209.0
2020-08-03 19:00:00	NQ	Futures	12768.68	12775.04	12755.38	12766.08	1510.0
2020-08-03 20:00:00	NQ	Futures	12764.92	12785.74	12754.8	12774.46	2782.0
2020-08-03 21:00:00	NQ	Futures	12775.33	12807.14	12768.97	12784.87	4987.0
2020-08-03 22:00:00	NQ	Futures	12783.14	12796.44	12776.49	12783.43	1848.0
2020-08-03 23:00:00	NQ	Futures	12784.29	12787.19	12765.5	12780.82	2252.0
2020-08-03 00:00:00	YM	Futures	28906.0	28921.4	28880.7	28921.4	1019.0
2020-08-03 01:00:00	YM	Futures	28920.3	28964.4	28901.6	28933.6	1187.0
2020-08-03 02:00:00	YM	Futures	28935.8	28940.2	28884.0	28907.1	2034.0
2020-08-03 03:00:00	YM	Futures	28910.4	28936.9	28846.6	28921.4	3284.0

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

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