PREVIEW / futures_1hour / 2019-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-10.parquet
  size:    61 KB
  rows:    1,849

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
2019-10-10 00:00:00	ES	Futures	3165.32	3167.22	3162.33	3165.04	4515.0
2019-10-10 01:00:00	ES	Futures	3165.32	3169.93	3165.04	3168.03	6296.0
2019-10-10 02:00:00	ES	Futures	3168.03	3171.83	3165.86	3168.58	11084.0
2019-10-10 03:00:00	ES	Futures	3168.58	3172.38	3158.25	3162.33	35748.0
2019-10-10 04:00:00	ES	Futures	3162.6	3173.19	3160.43	3168.03	34613.0
2019-10-10 05:00:00	ES	Futures	3167.76	3171.02	3165.04	3168.03	13813.0
2019-10-10 06:00:00	ES	Futures	3168.03	3176.18	3166.13	3167.49	17907.0
2019-10-10 07:00:00	ES	Futures	3167.49	3168.3	3160.7	3164.23	26982.0
2019-10-10 08:00:00	ES	Futures	3164.23	3169.93	3163.96	3168.3	23837.0
2019-10-10 09:00:00	ES	Futures	3168.3	3193.02	3166.13	3191.94	202220.0
2019-10-10 10:00:00	ES	Futures	3191.94	3198.73	3185.14	3198.45	190550.0
2019-10-10 11:00:00	ES	Futures	3198.73	3203.34	3196.82	3200.63	128877.0
2019-10-10 12:00:00	ES	Futures	3200.9	3201.44	3187.32	3193.02	107922.0
2019-10-10 13:00:00	ES	Futures	3193.29	3197.37	3185.69	3194.38	92394.0
2019-10-10 14:00:00	ES	Futures	3194.11	3196.01	3179.44	3188.13	132351.0
2019-10-10 15:00:00	ES	Futures	3187.86	3195.47	3187.05	3193.02	153667.0
2019-10-10 16:00:00	ES	Futures	3192.75	3209.59	3191.94	3204.7	75815.0
2019-10-10 18:00:00	ES	Futures	3204.16	3213.39	3198.73	3203.07	16469.0
2019-10-10 19:00:00	ES	Futures	3203.07	3204.16	3197.64	3201.99	7708.0
2019-10-10 20:00:00	ES	Futures	3201.71	3202.53	3196.28	3199.81	13535.0
2019-10-10 21:00:00	ES	Futures	3199.81	3203.62	3197.64	3201.71	13248.0
2019-10-10 22:00:00	ES	Futures	3201.71	3202.8	3200.36	3202.26	4618.0
2019-10-10 23:00:00	ES	Futures	3202.26	3206.88	3202.26	3206.06	6894.0
2019-10-10 00:00:00	NQ	Futures	8931.48	8938.74	8921.31	8931.77	3139.0
2019-10-10 01:00:00	NQ	Futures	8932.35	8946.87	8932.35	8940.48	3460.0
2019-10-10 02:00:00	NQ	Futures	8939.9	8955.3	8931.19	8943.68	6000.0
2019-10-10 03:00:00	NQ	Futures	8943.1	8956.46	8906.2	8919.86	13919.0
2019-10-10 04:00:00	NQ	Futures	8920.15	8955.59	8913.47	8939.61	11029.0
2019-10-10 05:00:00	NQ	Futures	8939.32	8947.74	8925.67	8935.83	6785.0
2019-10-10 06:00:00	NQ	Futures	8935.83	8964.59	8934.67	8939.03	7563.0
2019-10-10 07:00:00	NQ	Futures	8939.03	8941.35	8913.47	8929.73	12946.0
2019-10-10 08:00:00	NQ	Futures	8929.15	8947.45	8927.41	8938.45	11137.0
2019-10-10 09:00:00	NQ	Futures	8938.45	9019.21	8931.48	9012.81	70309.0
2019-10-10 10:00:00	NQ	Futures	9013.1	9034.31	8996.26	9033.73	60816.0
2019-10-10 11:00:00	NQ	Futures	9034.02	9047.38	9026.47	9035.76	40310.0
2019-10-10 12:00:00	NQ	Futures	9035.47	9037.22	8984.64	9003.81	39534.0
2019-10-10 13:00:00	NQ	Futures	9004.1	9012.81	8977.96	9004.97	29066.0
2019-10-10 14:00:00	NQ	Futures	9004.97	9010.2	8956.46	8992.48	47373.0
2019-10-10 15:00:00	NQ	Futures	8992.19	9017.75	8990.16	9010.2	44517.0
2019-10-10 16:00:00	NQ	Futures	9010.49	9061.91	9007.29	9047.96	17906.0
2019-10-10 18:00:00	NQ	Futures	9043.9	9078.76	9028.79	9045.06	5578.0
2019-10-10 19:00:00	NQ	Futures	9046.22	9049.71	9029.08	9043.61	2548.0
2019-10-10 20:00:00	NQ	Futures	9043.03	9045.06	9025.01	9038.38	4624.0
2019-10-10 21:00:00	NQ	Futures	9038.09	9049.42	9030.53	9043.03	4493.0
2019-10-10 22:00:00	NQ	Futures	9043.03	9044.19	9036.93	9042.15	1714.0
2019-10-10 23:00:00	NQ	Futures	9042.44	9061.04	9042.44	9059.87	3349.0
2019-10-10 00:00:00	YM	Futures	28574.7	28587.8	28551.8	28576.9	1079.0
2019-10-10 01:00:00	YM	Futures	28576.9	28613.9	28574.7	28607.3	1899.0
2019-10-10 02:00:00	YM	Futures	28606.3	28621.5	28573.6	28592.1	3291.0
2019-10-10 03:00:00	YM	Futures	28591.0	28623.7	28494.2	28530.1	7125.0

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

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