PREVIEW / futures_1hour / 2019-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-02.parquet
  size:    44 KB
  rows:    1,334

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-09-02 00:00:00	ES	Futures	3153.44	3154.53	3151.55	3151.82	3287.0
2019-09-02 01:00:00	ES	Futures	3152.09	3156.15	3152.09	3154.26	5660.0
2019-09-02 02:00:00	ES	Futures	3154.26	3156.42	3151.01	3152.63	9167.0
2019-09-02 03:00:00	ES	Futures	3152.36	3161.56	3152.36	3158.86	23027.0
2019-09-02 04:00:00	ES	Futures	3158.86	3161.84	3155.88	3160.21	18274.0
2019-09-02 05:00:00	ES	Futures	3159.94	3160.75	3156.69	3159.67	12474.0
2019-09-02 06:00:00	ES	Futures	3159.67	3168.87	3159.13	3166.71	19727.0
2019-09-02 07:00:00	ES	Futures	3166.44	3166.98	3161.84	3162.11	11312.0
2019-09-02 08:00:00	ES	Futures	3162.11	3162.92	3158.59	3160.48	11041.0
2019-09-02 09:00:00	ES	Futures	3160.48	3160.75	3151.82	3152.9	19362.0
2019-09-02 10:00:00	ES	Futures	3152.63	3160.21	3152.63	3159.13	16084.0
2019-09-02 11:00:00	ES	Futures	3158.86	3159.94	3128.27	3145.05	45965.0
2019-09-02 12:00:00	ES	Futures	3145.32	3148.03	3138.28	3138.83	24512.0
2019-09-02 18:00:00	ES	Futures	3139.1	3150.19	3138.55	3147.76	9466.0
2019-09-02 19:00:00	ES	Futures	3147.76	3148.57	3142.62	3143.43	4454.0
2019-09-02 20:00:00	ES	Futures	3143.43	3149.65	3142.62	3145.86	12552.0
2019-09-02 21:00:00	ES	Futures	3145.86	3156.96	3143.7	3154.8	21301.0
2019-09-02 22:00:00	ES	Futures	3154.53	3156.69	3150.19	3151.28	9259.0
2019-09-02 23:00:00	ES	Futures	3151.28	3153.44	3148.3	3149.11	5373.0
2019-09-02 00:00:00	NQ	Futures	8866.75	8869.36	8860.95	8863.27	2059.0
2019-09-02 01:00:00	NQ	Futures	8863.56	8875.17	8862.69	8869.65	3198.0
2019-09-02 02:00:00	NQ	Futures	8869.94	8878.94	8858.34	8863.27	4197.0
2019-09-02 03:00:00	NQ	Futures	8864.14	8907.37	8862.69	8898.09	11212.0
2019-09-02 04:00:00	NQ	Futures	8898.67	8911.14	8888.51	8900.12	6770.0
2019-09-02 05:00:00	NQ	Futures	8900.12	8903.31	8888.51	8896.93	4680.0
2019-09-02 06:00:00	NQ	Futures	8896.35	8931.16	8894.61	8920.14	7783.0
2019-09-02 07:00:00	NQ	Futures	8920.43	8921.59	8905.05	8905.05	4893.0
2019-09-02 08:00:00	NQ	Futures	8905.63	8909.69	8893.16	8896.64	5171.0
2019-09-02 09:00:00	NQ	Futures	8896.93	8898.96	8867.91	8875.17	10497.0
2019-09-02 10:00:00	NQ	Futures	8874.88	8903.89	8874.3	8897.22	9724.0
2019-09-02 11:00:00	NQ	Futures	8897.8	8900.99	8797.99	8851.38	18303.0
2019-09-02 12:00:00	NQ	Futures	8852.25	8858.63	8829.9	8834.55	11347.0
2019-09-02 18:00:00	NQ	Futures	8836.58	8872.27	8826.13	8863.56	4272.0
2019-09-02 19:00:00	NQ	Futures	8863.27	8867.04	8846.44	8849.05	2937.0
2019-09-02 20:00:00	NQ	Futures	8849.63	8867.91	8847.02	8856.31	6157.0
2019-09-02 21:00:00	NQ	Futures	8856.6	8894.9	8849.63	8887.93	11296.0
2019-09-02 22:00:00	NQ	Futures	8887.93	8895.19	8874.3	8876.62	6509.0
2019-09-02 23:00:00	NQ	Futures	8876.62	8883.58	8862.69	8865.88	4974.0
2019-09-02 00:00:00	YM	Futures	28612.1	28625.2	28596.9	28600.2	816.0
2019-09-02 01:00:00	YM	Futures	28601.3	28635.0	28601.3	28607.8	1297.0
2019-09-02 02:00:00	YM	Futures	28608.9	28628.4	28566.5	28577.3	2189.0
2019-09-02 03:00:00	YM	Futures	28576.2	28632.8	28575.2	28594.7	3916.0
2019-09-02 04:00:00	YM	Futures	28595.8	28613.2	28556.7	28592.6	2821.0
2019-09-02 05:00:00	YM	Futures	28592.6	28599.1	28569.7	28588.2	1546.0
2019-09-02 06:00:00	YM	Futures	28589.3	28679.6	28582.8	28646.9	3348.0
2019-09-02 07:00:00	YM	Futures	28646.9	28652.4	28621.9	28623.0	1698.0
2019-09-02 08:00:00	YM	Futures	28624.1	28630.6	28588.2	28608.9	1849.0
2019-09-02 09:00:00	YM	Futures	28608.9	28618.7	28564.3	28575.2	4439.0
2019-09-02 10:00:00	YM	Futures	28574.1	28632.8	28573.0	28610.0	4476.0
2019-09-02 11:00:00	YM	Futures	28611.0	28617.6	28395.7	28512.1	7020.0

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

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