PREVIEW / futures_1hour / 2019-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-07.parquet
  size:    61 KB
  rows:    1,873

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-05-07 00:00:00	ES	Futures	3158.34	3164.03	3158.34	3163.49	13685.0
2019-05-07 01:00:00	ES	Futures	3163.76	3163.76	3158.88	3162.14	8918.0
2019-05-07 02:00:00	ES	Futures	3161.87	3177.86	3161.32	3173.79	32360.0
2019-05-07 03:00:00	ES	Futures	3174.07	3175.42	3170.27	3171.35	20437.0
2019-05-07 04:00:00	ES	Futures	3171.35	3172.44	3165.93	3167.02	18131.0
2019-05-07 05:00:00	ES	Futures	3166.75	3167.02	3161.87	3165.12	20012.0
2019-05-07 06:00:00	ES	Futures	3165.12	3165.93	3159.15	3159.7	18492.0
2019-05-07 07:00:00	ES	Futures	3159.97	3163.22	3154.0	3155.63	30393.0
2019-05-07 08:00:00	ES	Futures	3155.36	3160.78	3153.73	3158.34	46156.0
2019-05-07 09:00:00	ES	Futures	3158.34	3158.88	3139.91	3147.5	417271.0
2019-05-07 10:00:00	ES	Futures	3147.5	3147.77	3130.96	3132.86	381382.0
2019-05-07 11:00:00	ES	Futures	3132.86	3139.36	3125.81	3129.6	320628.0
2019-05-07 12:00:00	ES	Futures	3129.33	3139.91	3124.72	3132.32	164852.0
2019-05-07 13:00:00	ES	Futures	3132.32	3133.4	3113.34	3119.84	290689.0
2019-05-07 14:00:00	ES	Futures	3119.57	3124.18	3109.0	3117.13	259803.0
2019-05-07 15:00:00	ES	Futures	3117.13	3130.42	3104.12	3128.52	433661.0
2019-05-07 16:00:00	ES	Futures	3128.52	3135.84	3127.98	3134.76	132563.0
2019-05-07 18:00:00	ES	Futures	3133.67	3134.76	3128.79	3130.96	9363.0
2019-05-07 19:00:00	ES	Futures	3131.23	3132.59	3127.16	3128.25	7813.0
2019-05-07 20:00:00	ES	Futures	3128.25	3132.59	3126.08	3130.15	21904.0
2019-05-07 21:00:00	ES	Futures	3130.15	3137.2	3130.15	3136.38	21321.0
2019-05-07 22:00:00	ES	Futures	3136.38	3139.91	3134.48	3137.74	20443.0
2019-05-07 23:00:00	ES	Futures	3138.01	3138.55	3133.94	3135.84	12978.0
2019-05-07 00:00:00	NQ	Futures	9018.56	9033.99	9017.39	9032.83	4674.0
2019-05-07 01:00:00	NQ	Futures	9032.83	9033.41	9015.65	9024.96	3803.0
2019-05-07 02:00:00	NQ	Futures	9024.67	9088.73	9023.51	9070.38	12926.0
2019-05-07 03:00:00	NQ	Futures	9070.97	9075.63	9058.16	9064.85	6909.0
2019-05-07 04:00:00	NQ	Futures	9064.56	9066.89	9043.6	9045.05	7020.0
2019-05-07 05:00:00	NQ	Futures	9044.76	9047.09	9030.79	9040.69	6417.0
2019-05-07 06:00:00	NQ	Futures	9040.4	9044.76	9019.43	9021.76	6071.0
2019-05-07 07:00:00	NQ	Futures	9021.76	9033.99	8998.47	9000.8	10167.0
2019-05-07 08:00:00	NQ	Futures	9000.51	9023.22	8990.03	9012.74	20065.0
2019-05-07 09:00:00	NQ	Futures	9013.03	9028.75	8961.78	8978.67	120443.0
2019-05-07 10:00:00	NQ	Futures	8978.38	8980.42	8913.74	8925.68	132321.0
2019-05-07 11:00:00	NQ	Futures	8925.39	8952.47	8899.48	8921.6	104629.0
2019-05-07 12:00:00	NQ	Futures	8921.6	8955.38	8905.59	8923.06	63793.0
2019-05-07 13:00:00	NQ	Futures	8923.06	8927.14	8859.3	8877.93	79050.0
2019-05-07 14:00:00	NQ	Futures	8877.93	8895.69	8836.59	8867.16	83718.0
2019-05-07 15:00:00	NQ	Futures	8866.87	8914.62	8829.31	8914.32	101735.0
2019-05-07 16:00:00	NQ	Futures	8914.03	8939.36	8912.29	8933.25	24597.0
2019-05-07 18:00:00	NQ	Futures	8925.39	8934.71	8910.83	8920.15	3665.0
2019-05-07 19:00:00	NQ	Futures	8920.73	8925.1	8907.92	8912.29	3455.0
2019-05-07 20:00:00	NQ	Futures	8912.58	8926.55	8903.84	8917.53	6397.0
2019-05-07 21:00:00	NQ	Futures	8917.53	8942.86	8917.24	8939.07	6101.0
2019-05-07 22:00:00	NQ	Futures	8938.78	8953.63	8933.25	8945.77	6030.0
2019-05-07 23:00:00	NQ	Futures	8946.06	8947.81	8933.25	8939.66	3559.0
2019-05-07 00:00:00	YM	Futures	28541.5	28579.5	28536.0	28577.4	3353.0
2019-05-07 01:00:00	YM	Futures	28576.3	28578.5	28532.8	28562.1	2568.0
2019-05-07 02:00:00	YM	Futures	28560.0	28707.9	28555.6	28668.7	7252.0
2019-05-07 03:00:00	YM	Futures	28668.7	28691.6	28645.9	28655.7	3988.0

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

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