PREVIEW / futures_1hour / 2019-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-04.parquet
  size:    50 KB
  rows:    1,497

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-04 00:00:00	ES	Futures	3159.34	3162.33	3159.34	3162.06	3973.0
2019-10-04 01:00:00	ES	Futures	3162.33	3170.48	3162.06	3164.5	14947.0
2019-10-04 02:00:00	ES	Futures	3164.77	3164.77	3155.81	3158.25	20925.0
2019-10-04 03:00:00	ES	Futures	3157.98	3161.78	3154.45	3159.34	36257.0
2019-10-04 04:00:00	ES	Futures	3159.34	3161.51	3154.45	3156.08	21379.0
2019-10-04 05:00:00	ES	Futures	3156.35	3156.9	3150.38	3150.92	23289.0
2019-10-04 06:00:00	ES	Futures	3150.92	3155.27	3148.75	3151.73	21215.0
2019-10-04 07:00:00	ES	Futures	3151.73	3154.72	3150.1	3152.28	23135.0
2019-10-04 08:00:00	ES	Futures	3152.55	3174.01	3147.39	3172.11	111732.0
2019-10-04 09:00:00	ES	Futures	3171.83	3183.52	3168.85	3183.52	223859.0
2019-10-04 10:00:00	ES	Futures	3183.52	3187.86	3173.46	3178.35	220725.0
2019-10-04 11:00:00	ES	Futures	3178.63	3192.75	3176.18	3190.03	165109.0
2019-10-04 12:00:00	ES	Futures	3190.03	3192.48	3188.13	3190.03	75990.0
2019-10-04 13:00:00	ES	Futures	3190.31	3194.92	3188.4	3191.39	65702.0
2019-10-04 14:00:00	ES	Futures	3191.66	3199.0	3190.03	3197.37	79239.0
2019-10-04 15:00:00	ES	Futures	3197.37	3208.78	3196.55	3206.06	214060.0
2019-10-04 16:00:00	ES	Futures	3205.79	3207.96	3203.62	3206.06	70518.0
2019-10-04 00:00:00	NQ	Futures	8884.42	8896.04	8884.13	8895.75	2500.0
2019-10-04 01:00:00	NQ	Futures	8895.75	8930.31	8895.16	8910.85	7170.0
2019-10-04 02:00:00	NQ	Futures	8911.14	8911.14	8879.48	8887.32	9037.0
2019-10-04 03:00:00	NQ	Futures	8887.32	8903.3	8875.7	8893.42	11929.0
2019-10-04 04:00:00	NQ	Futures	8893.42	8900.97	8875.7	8883.55	8611.0
2019-10-04 05:00:00	NQ	Futures	8882.96	8883.55	8860.02	8862.05	8106.0
2019-10-04 06:00:00	NQ	Futures	8862.63	8874.83	8858.85	8867.86	6123.0
2019-10-04 07:00:00	NQ	Futures	8868.15	8881.8	8863.5	8876.28	7309.0
2019-10-04 08:00:00	NQ	Futures	8876.28	8942.22	8864.66	8935.25	35247.0
2019-10-04 09:00:00	NQ	Futures	8934.67	8968.95	8925.09	8967.79	72350.0
2019-10-04 10:00:00	NQ	Futures	8967.5	8979.12	8934.09	8955.88	63892.0
2019-10-04 11:00:00	NQ	Futures	8955.88	9000.32	8946.87	8990.74	52633.0
2019-10-04 12:00:00	NQ	Futures	8990.74	8997.71	8983.47	8987.54	22012.0
2019-10-04 13:00:00	NQ	Futures	8987.83	9004.39	8982.31	8988.41	17662.0
2019-10-04 14:00:00	NQ	Futures	8988.7	9015.43	8984.06	9010.2	22051.0
2019-10-04 15:00:00	NQ	Futures	9010.49	9032.86	9004.97	9022.98	44589.0
2019-10-04 16:00:00	NQ	Futures	9022.98	9029.37	9011.94	9028.21	12639.0
2019-10-04 00:00:00	YM	Futures	28465.9	28496.3	28464.8	28489.8	1546.0
2019-10-04 01:00:00	YM	Futures	28492.0	28566.0	28490.9	28511.6	4512.0
2019-10-04 02:00:00	YM	Futures	28511.6	28512.7	28432.1	28451.7	4858.0
2019-10-04 03:00:00	YM	Futures	28452.8	28481.1	28418.0	28455.0	7143.0
2019-10-04 04:00:00	YM	Futures	28455.0	28477.8	28425.6	28438.6	4448.0
2019-10-04 05:00:00	YM	Futures	28437.6	28443.0	28382.1	28385.3	4594.0
2019-10-04 06:00:00	YM	Futures	28386.4	28428.9	28362.5	28398.4	7255.0
2019-10-04 07:00:00	YM	Futures	28398.4	28432.1	28383.1	28419.1	8927.0
2019-10-04 08:00:00	YM	Futures	28419.1	28588.8	28397.3	28571.4	19068.0
2019-10-04 09:00:00	YM	Futures	28570.3	28671.6	28543.1	28670.5	27383.0
2019-10-04 10:00:00	YM	Futures	28669.4	28709.6	28574.7	28619.3	22850.0
2019-10-04 11:00:00	YM	Futures	28619.3	28739.0	28598.6	28711.8	18192.0
2019-10-04 12:00:00	YM	Futures	28711.8	28737.9	28700.9	28719.4	9693.0
2019-10-04 13:00:00	YM	Futures	28720.5	28747.7	28699.9	28729.2	6912.0
2019-10-04 14:00:00	YM	Futures	28729.2	28807.6	28721.6	28784.7	10476.0
2019-10-04 15:00:00	YM	Futures	28784.7	28894.7	28778.2	28871.8	16703.0

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

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