PREVIEW / futures_1hour / 2020-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-18.parquet
  size:    63 KB
  rows:    1,910

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-11-18 00:00:00	ES	Futures	4033.36	4037.28	4023.84	4026.92	10089.0
2020-11-18 01:00:00	ES	Futures	4026.64	4028.6	4017.4	4021.04	9409.0
2020-11-18 02:00:00	ES	Futures	4021.04	4035.04	4021.04	4029.16	8636.0
2020-11-18 03:00:00	ES	Futures	4029.16	4045.68	4027.48	4036.44	19658.0
2020-11-18 04:00:00	ES	Futures	4036.72	4046.81	4036.16	4044.84	11684.0
2020-11-18 05:00:00	ES	Futures	4044.84	4053.53	4044.28	4050.45	15031.0
2020-11-18 06:00:00	ES	Futures	4050.45	4055.77	4047.93	4052.13	22968.0
2020-11-18 07:00:00	ES	Futures	4052.13	4059.41	4051.01	4054.37	21282.0
2020-11-18 08:00:00	ES	Futures	4054.09	4054.93	4045.97	4049.89	25658.0
2020-11-18 09:00:00	ES	Futures	4049.61	4050.73	4037.84	4041.2	150133.0
2020-11-18 10:00:00	ES	Futures	4041.2	4049.61	4040.64	4047.09	121390.0
2020-11-18 11:00:00	ES	Futures	4047.37	4051.57	4043.44	4047.93	101765.0
2020-11-18 12:00:00	ES	Futures	4048.21	4051.57	4041.76	4043.44	69994.0
2020-11-18 13:00:00	ES	Futures	4043.44	4046.25	4026.64	4032.52	115382.0
2020-11-18 14:00:00	ES	Futures	4032.52	4036.44	4019.36	4028.32	138981.0
2020-11-18 15:00:00	ES	Futures	4028.6	4035.6	3991.91	3992.47	312727.0
2020-11-18 16:00:00	ES	Futures	3992.47	3998.07	3984.62	3988.55	67447.0
2020-11-18 18:00:00	ES	Futures	3990.79	3997.79	3989.67	3992.19	9097.0
2020-11-18 19:00:00	ES	Futures	3992.19	3994.99	3981.54	3987.43	18307.0
2020-11-18 20:00:00	ES	Futures	3987.43	3996.39	3986.02	3994.43	11752.0
2020-11-18 21:00:00	ES	Futures	3994.43	3994.99	3987.99	3989.67	6511.0
2020-11-18 22:00:00	ES	Futures	3989.95	3991.35	3982.1	3988.83	7447.0
2020-11-18 23:00:00	ES	Futures	3988.83	3992.19	3987.71	3991.63	3746.0
2020-11-18 00:00:00	NQ	Futures	13862.95	13875.68	13820.1	13836.6	6184.0
2020-11-18 01:00:00	NQ	Futures	13835.45	13840.66	13797.82	13813.74	6009.0
2020-11-18 02:00:00	NQ	Futures	13814.03	13867.0	13814.03	13845.29	4977.0
2020-11-18 03:00:00	NQ	Futures	13845.58	13905.5	13840.08	13875.39	7974.0
2020-11-18 04:00:00	NQ	Futures	13875.39	13897.39	13869.89	13887.84	4987.0
2020-11-18 05:00:00	NQ	Futures	13886.68	13921.13	13886.39	13907.23	5335.0
2020-11-18 06:00:00	NQ	Futures	13907.23	13919.1	13876.26	13884.95	7563.0
2020-11-18 07:00:00	NQ	Futures	13884.66	13902.6	13875.97	13889.87	5772.0
2020-11-18 08:00:00	NQ	Futures	13888.71	13890.45	13868.16	13874.81	26617.0
2020-11-18 09:00:00	NQ	Futures	13874.52	13881.18	13794.34	13811.13	61391.0
2020-11-18 10:00:00	NQ	Futures	13811.13	13870.76	13790.58	13865.55	57929.0
2020-11-18 11:00:00	NQ	Futures	13865.84	13892.18	13844.42	13892.18	40691.0
2020-11-18 12:00:00	NQ	Futures	13891.89	13926.34	13891.6	13903.76	34497.0
2020-11-18 13:00:00	NQ	Futures	13903.76	13916.79	13835.45	13851.95	31536.0
2020-11-18 14:00:00	NQ	Futures	13852.24	13881.18	13826.18	13874.81	63385.0
2020-11-18 15:00:00	NQ	Futures	13875.1	13909.55	13767.42	13769.45	68779.0
2020-11-18 16:00:00	NQ	Futures	13769.45	13790.29	13734.13	13748.32	13026.0
2020-11-18 18:00:00	NQ	Futures	13750.92	13774.95	13740.79	13755.84	3199.0
2020-11-18 19:00:00	NQ	Futures	13757.58	13765.68	13727.47	13740.5	5552.0
2020-11-18 20:00:00	NQ	Futures	13741.37	13764.24	13735.87	13750.92	4661.0
2020-11-18 21:00:00	NQ	Futures	13750.05	13753.24	13733.55	13743.68	3339.0
2020-11-18 22:00:00	NQ	Futures	13743.68	13746.0	13699.11	13722.55	4971.0
2020-11-18 23:00:00	NQ	Futures	13722.55	13734.42	13721.97	13728.63	1906.0
2020-11-18 00:00:00	YM	Futures	32804.8	32833.6	32724.1	32759.5	2815.0
2020-11-18 01:00:00	YM	Futures	32754.0	32776.1	32689.8	32723.0	6237.0
2020-11-18 02:00:00	YM	Futures	32724.1	32828.1	32720.8	32778.3	4161.0
2020-11-18 03:00:00	YM	Futures	32777.2	32901.0	32759.5	32834.7	5290.0

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

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