PREVIEW / futures_1hour / 2019-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-02.parquet
  size:    62 KB
  rows:    1,892

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-02 00:00:00	ES	Futures	3199.81	3199.81	3197.1	3198.45	3223.0
2019-10-02 01:00:00	ES	Futures	3198.45	3200.63	3196.82	3198.18	6096.0
2019-10-02 02:00:00	ES	Futures	3198.18	3198.73	3192.75	3195.2	11095.0
2019-10-02 03:00:00	ES	Futures	3195.47	3197.1	3178.9	3181.89	44402.0
2019-10-02 04:00:00	ES	Futures	3181.61	3183.24	3174.82	3177.27	29587.0
2019-10-02 05:00:00	ES	Futures	3177.27	3179.71	3169.12	3173.19	37764.0
2019-10-02 06:00:00	ES	Futures	3173.46	3174.28	3170.21	3171.02	22600.0
2019-10-02 07:00:00	ES	Futures	3171.29	3178.9	3171.29	3178.35	27846.0
2019-10-02 08:00:00	ES	Futures	3178.35	3181.07	3172.65	3173.19	43540.0
2019-10-02 09:00:00	ES	Futures	3173.19	3177.27	3152.28	3157.71	276996.0
2019-10-02 10:00:00	ES	Futures	3157.44	3160.15	3137.61	3141.96	356895.0
2019-10-02 11:00:00	ES	Futures	3141.96	3147.12	3131.91	3140.05	241876.0
2019-10-02 12:00:00	ES	Futures	3139.78	3140.33	3122.67	3126.47	175285.0
2019-10-02 13:00:00	ES	Futures	3126.2	3135.16	3123.76	3130.0	163189.0
2019-10-02 14:00:00	ES	Futures	3129.73	3143.59	3127.02	3142.77	149672.0
2019-10-02 15:00:00	ES	Futures	3142.5	3147.93	3132.99	3137.88	299714.0
2019-10-02 16:00:00	ES	Futures	3137.88	3139.51	3128.37	3133.26	102250.0
2019-10-02 18:00:00	ES	Futures	3133.26	3137.34	3131.91	3136.25	9035.0
2019-10-02 19:00:00	ES	Futures	3136.25	3141.14	3135.16	3135.71	10655.0
2019-10-02 20:00:00	ES	Futures	3135.71	3138.15	3131.36	3133.53	16581.0
2019-10-02 21:00:00	ES	Futures	3133.53	3140.05	3133.53	3138.42	14220.0
2019-10-02 22:00:00	ES	Futures	3138.7	3142.5	3136.79	3138.7	13089.0
2019-10-02 23:00:00	ES	Futures	3138.7	3141.41	3137.07	3138.15	7764.0
2019-10-02 00:00:00	NQ	Futures	8967.21	8967.5	8955.59	8960.24	1473.0
2019-10-02 01:00:00	NQ	Futures	8960.53	8969.53	8956.17	8959.65	2471.0
2019-10-02 02:00:00	NQ	Futures	8959.65	8960.24	8940.48	8947.45	4378.0
2019-10-02 03:00:00	NQ	Futures	8947.45	8953.84	8894.0	8903.01	15525.0
2019-10-02 04:00:00	NQ	Futures	8903.88	8914.34	8882.67	8890.81	10263.0
2019-10-02 05:00:00	NQ	Futures	8890.81	8900.1	8866.12	8879.77	11180.0
2019-10-02 06:00:00	NQ	Futures	8880.35	8883.84	8870.18	8874.25	6328.0
2019-10-02 07:00:00	NQ	Futures	8874.25	8899.52	8874.25	8897.2	8041.0
2019-10-02 08:00:00	NQ	Futures	8896.91	8904.17	8875.12	8877.15	16219.0
2019-10-02 09:00:00	NQ	Futures	8877.44	8895.46	8820.8	8838.52	79432.0
2019-10-02 10:00:00	NQ	Futures	8838.23	8853.33	8782.45	8799.88	104170.0
2019-10-02 11:00:00	NQ	Futures	8799.88	8815.86	8766.77	8788.26	65522.0
2019-10-02 12:00:00	NQ	Futures	8788.26	8789.72	8744.4	8754.86	46129.0
2019-10-02 13:00:00	NQ	Futures	8754.86	8784.49	8746.43	8762.12	47065.0
2019-10-02 14:00:00	NQ	Futures	8762.12	8805.11	8755.73	8800.75	47372.0
2019-10-02 15:00:00	NQ	Futures	8801.05	8820.8	8779.26	8791.46	73044.0
2019-10-02 16:00:00	NQ	Futures	8791.17	8797.56	8762.12	8778.1	17604.0
2019-10-02 18:00:00	NQ	Futures	8774.61	8789.72	8772.58	8786.81	3143.0
2019-10-02 19:00:00	NQ	Futures	8787.1	8802.21	8782.16	8783.91	3303.0
2019-10-02 20:00:00	NQ	Futures	8784.2	8790.88	8767.93	8774.32	6159.0
2019-10-02 21:00:00	NQ	Futures	8774.03	8797.56	8773.16	8788.55	6159.0
2019-10-02 22:00:00	NQ	Futures	8788.84	8805.4	8785.65	8790.3	5491.0
2019-10-02 23:00:00	NQ	Futures	8790.59	8801.92	8787.97	8790.01	2958.0
2019-10-02 00:00:00	YM	Futures	28936.0	28936.0	28915.3	28924.1	718.0
2019-10-02 01:00:00	YM	Futures	28924.1	28941.5	28911.0	28919.7	1276.0
2019-10-02 02:00:00	YM	Futures	28920.8	28924.1	28877.3	28903.4	2360.0
2019-10-02 03:00:00	YM	Futures	28903.4	28913.2	28757.5	28779.3	8840.0

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

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