PREVIEW / futures_1hour / 2019-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-30.parquet
  size:    49 KB
  rows:    1,456

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-30 00:00:00	ES	Futures	3176.18	3176.45	3174.29	3174.83	4220.0
2019-08-30 01:00:00	ES	Futures	3174.83	3174.83	3169.96	3173.48	11218.0
2019-08-30 02:00:00	ES	Futures	3173.48	3173.48	3164.54	3168.33	21985.0
2019-08-30 03:00:00	ES	Futures	3168.33	3178.62	3165.9	3177.81	55642.0
2019-08-30 04:00:00	ES	Futures	3177.81	3185.39	3176.72	3184.03	36134.0
2019-08-30 05:00:00	ES	Futures	3184.03	3190.53	3183.22	3189.45	38255.0
2019-08-30 06:00:00	ES	Futures	3189.45	3189.99	3186.47	3189.45	29719.0
2019-08-30 07:00:00	ES	Futures	3189.45	3189.99	3183.76	3188.64	23851.0
2019-08-30 08:00:00	ES	Futures	3188.36	3188.91	3184.85	3187.01	26101.0
2019-08-30 09:00:00	ES	Futures	3187.01	3187.55	3176.45	3178.62	153262.0
2019-08-30 10:00:00	ES	Futures	3178.62	3184.3	3172.12	3172.12	196009.0
2019-08-30 11:00:00	ES	Futures	3172.39	3173.48	3154.53	3165.08	247815.0
2019-08-30 12:00:00	ES	Futures	3164.81	3171.58	3162.38	3169.96	93764.0
2019-08-30 13:00:00	ES	Futures	3169.96	3171.31	3162.65	3164.54	69716.0
2019-08-30 14:00:00	ES	Futures	3164.54	3169.14	3160.21	3162.38	100946.0
2019-08-30 15:00:00	ES	Futures	3162.11	3171.85	3157.23	3165.35	319055.0
2019-08-30 16:00:00	ES	Futures	3165.35	3166.44	3161.02	3165.9	93193.0
2019-08-30 00:00:00	NQ	Futures	8970.04	8970.91	8962.5	8963.95	2080.0
2019-08-30 01:00:00	NQ	Futures	8964.24	8964.53	8951.76	8960.18	5758.0
2019-08-30 02:00:00	NQ	Futures	8959.89	8960.18	8927.39	8945.38	9744.0
2019-08-30 03:00:00	NQ	Futures	8945.38	8979.91	8934.36	8978.17	19650.0
2019-08-30 04:00:00	NQ	Futures	8977.88	9000.8	8974.4	8997.9	11543.0
2019-08-30 05:00:00	NQ	Futures	8997.61	9018.21	8995.87	9014.73	14614.0
2019-08-30 06:00:00	NQ	Futures	9014.44	9016.76	9002.54	9013.27	9053.0
2019-08-30 07:00:00	NQ	Futures	9012.98	9014.44	8995.0	9007.18	8723.0
2019-08-30 08:00:00	NQ	Futures	9007.18	9009.21	8997.61	9001.09	9133.0
2019-08-30 09:00:00	NQ	Futures	9001.38	9001.96	8960.47	8969.17	50621.0
2019-08-30 10:00:00	NQ	Futures	8968.3	8982.52	8936.97	8937.55	60384.0
2019-08-30 11:00:00	NQ	Futures	8937.84	8942.77	8873.72	8908.53	70399.0
2019-08-30 12:00:00	NQ	Futures	8908.24	8918.98	8892.58	8912.02	32007.0
2019-08-30 13:00:00	NQ	Futures	8911.72	8916.37	8894.61	8904.18	20924.0
2019-08-30 14:00:00	NQ	Futures	8903.89	8920.72	8896.35	8902.15	26102.0
2019-08-30 15:00:00	NQ	Futures	8902.15	8933.49	8886.19	8926.23	51985.0
2019-08-30 16:00:00	NQ	Futures	8925.94	8927.97	8900.99	8907.95	13258.0
2019-08-30 00:00:00	YM	Futures	28757.9	28760.0	28739.4	28742.6	735.0
2019-08-30 01:00:00	YM	Futures	28742.6	28742.6	28704.6	28727.4	2380.0
2019-08-30 02:00:00	YM	Futures	28727.4	28728.5	28648.0	28685.0	4127.0
2019-08-30 03:00:00	YM	Futures	28685.0	28774.2	28664.3	28768.7	6394.0
2019-08-30 04:00:00	YM	Futures	28767.6	28839.4	28758.9	28827.5	5550.0
2019-08-30 05:00:00	YM	Futures	28826.4	28882.9	28818.8	28874.2	5747.0
2019-08-30 06:00:00	YM	Futures	28873.1	28877.5	28847.0	28872.0	3457.0
2019-08-30 07:00:00	YM	Futures	28871.0	28876.4	28822.0	28852.5	3695.0
2019-08-30 08:00:00	YM	Futures	28852.5	28856.8	28827.5	28840.5	3568.0
2019-08-30 09:00:00	YM	Futures	28840.5	28842.7	28767.6	28787.2	21240.0
2019-08-30 10:00:00	YM	Futures	28789.4	28841.6	28760.0	28761.1	22543.0
2019-08-30 11:00:00	YM	Futures	28761.1	28772.0	28600.2	28687.2	35883.0
2019-08-30 12:00:00	YM	Futures	28688.3	28755.7	28666.5	28742.6	13579.0
2019-08-30 13:00:00	YM	Futures	28741.5	28752.4	28663.2	28687.2	8645.0
2019-08-30 14:00:00	YM	Futures	28686.1	28729.6	28639.3	28655.6	11741.0
2019-08-30 15:00:00	YM	Futures	28656.7	28755.7	28618.7	28703.5	24111.0

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

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