PREVIEW / futures_1hour / 2019-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-09.parquet
  size:    51 KB
  rows:    1,508

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-08-09 00:00:00	ES	Futures	3169.96	3171.04	3166.98	3168.6	4248.0
2019-08-09 01:00:00	ES	Futures	3168.6	3170.77	3167.79	3168.06	5935.0
2019-08-09 02:00:00	ES	Futures	3168.06	3173.2	3167.52	3172.93	14121.0
2019-08-09 03:00:00	ES	Futures	3172.66	3173.2	3166.17	3168.87	26082.0
2019-08-09 04:00:00	ES	Futures	3168.87	3169.96	3164.81	3168.87	25327.0
2019-08-09 05:00:00	ES	Futures	3169.14	3172.39	3164.54	3165.08	22149.0
2019-08-09 06:00:00	ES	Futures	3164.81	3167.52	3162.38	3165.35	20620.0
2019-08-09 07:00:00	ES	Futures	3165.35	3165.63	3159.4	3162.65	25841.0
2019-08-09 08:00:00	ES	Futures	3162.65	3169.69	3161.56	3166.98	43925.0
2019-08-09 09:00:00	ES	Futures	3166.98	3178.62	3162.38	3164.81	203760.0
2019-08-09 10:00:00	ES	Futures	3164.81	3169.14	3148.3	3157.77	338034.0
2019-08-09 11:00:00	ES	Futures	3157.77	3159.4	3139.1	3142.34	236751.0
2019-08-09 12:00:00	ES	Futures	3142.07	3165.35	3139.64	3154.8	227709.0
2019-08-09 13:00:00	ES	Futures	3154.53	3170.23	3153.98	3164.54	163140.0
2019-08-09 14:00:00	ES	Futures	3164.54	3168.87	3161.56	3164.27	117288.0
2019-08-09 15:00:00	ES	Futures	3164.27	3175.64	3158.59	3160.21	281035.0
2019-08-09 16:00:00	ES	Futures	3160.21	3166.44	3158.86	3165.9	80052.0
2019-08-09 00:00:00	NQ	Futures	8924.78	8927.1	8917.82	8924.78	2866.0
2019-08-09 01:00:00	NQ	Futures	8924.49	8934.94	8921.01	8922.17	3812.0
2019-08-09 02:00:00	NQ	Futures	8922.46	8939.58	8921.3	8937.26	5086.0
2019-08-09 03:00:00	NQ	Futures	8936.97	8939.58	8915.21	8925.65	8240.0
2019-08-09 04:00:00	NQ	Futures	8925.07	8926.52	8906.79	8919.27	7524.0
2019-08-09 05:00:00	NQ	Futures	8919.27	8929.42	8904.47	8907.08	6673.0
2019-08-09 06:00:00	NQ	Futures	8906.79	8915.79	8899.54	8906.5	7623.0
2019-08-09 07:00:00	NQ	Futures	8906.79	8909.4	8888.22	8898.09	10520.0
2019-08-09 08:00:00	NQ	Futures	8898.09	8923.33	8895.19	8915.5	13746.0
2019-08-09 09:00:00	NQ	Futures	8914.63	8959.6	8893.45	8908.82	67935.0
2019-08-09 10:00:00	NQ	Futures	8908.82	8923.91	8848.47	8887.35	103110.0
2019-08-09 11:00:00	NQ	Futures	8887.35	8892.29	8816.56	8825.84	75394.0
2019-08-09 12:00:00	NQ	Futures	8825.55	8897.8	8820.04	8873.14	65930.0
2019-08-09 13:00:00	NQ	Futures	8872.85	8927.97	8870.23	8901.57	58771.0
2019-08-09 14:00:00	NQ	Futures	8901.57	8915.21	8888.8	8896.93	35148.0
2019-08-09 15:00:00	NQ	Futures	8896.93	8932.03	8878.94	8885.9	62329.0
2019-08-09 16:00:00	NQ	Futures	8885.32	8905.92	8880.68	8900.7	12946.0
2019-08-09 00:00:00	YM	Futures	28579.5	28584.9	28543.6	28563.2	1267.0
2019-08-09 01:00:00	YM	Futures	28564.3	28583.9	28553.4	28557.8	1875.0
2019-08-09 02:00:00	YM	Futures	28558.8	28600.2	28553.4	28595.8	3023.0
2019-08-09 03:00:00	YM	Futures	28594.7	28599.1	28537.1	28562.1	4041.0
2019-08-09 04:00:00	YM	Futures	28561.0	28573.0	28528.4	28564.3	3480.0
2019-08-09 05:00:00	YM	Futures	28565.4	28594.7	28523.0	28530.6	3475.0
2019-08-09 06:00:00	YM	Futures	28531.7	28550.1	28501.2	28529.5	3315.0
2019-08-09 07:00:00	YM	Futures	28529.5	28529.5	28480.5	28512.1	4376.0
2019-08-09 08:00:00	YM	Futures	28511.0	28574.1	28501.2	28550.1	6150.0
2019-08-09 09:00:00	YM	Futures	28549.1	28660.0	28527.3	28548.0	24411.0
2019-08-09 10:00:00	YM	Futures	28548.0	28593.6	28396.8	28480.5	39574.0
2019-08-09 11:00:00	YM	Futures	28479.5	28492.5	28355.5	28383.8	28206.0
2019-08-09 12:00:00	YM	Futures	28383.8	28600.2	28369.6	28503.4	30738.0
2019-08-09 13:00:00	YM	Futures	28503.4	28645.8	28499.0	28600.2	26426.0
2019-08-09 14:00:00	YM	Futures	28599.1	28640.4	28567.5	28605.6	17085.0
2019-08-09 15:00:00	YM	Futures	28606.7	28703.5	28552.3	28564.3	30706.0

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

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