PREVIEW / futures_1hour / 2018-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-31.parquet
  size:    46 KB
  rows:    1,373

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
2018-08-31 00:00:00	ES	Futures	3162.52	3163.33	3161.97	3162.79	2060.0
2018-08-31 01:00:00	ES	Futures	3162.52	3164.97	3162.52	3163.06	6364.0
2018-08-31 02:00:00	ES	Futures	3163.06	3164.15	3161.7	3163.61	6306.0
2018-08-31 03:00:00	ES	Futures	3163.61	3163.61	3157.34	3158.7	21146.0
2018-08-31 04:00:00	ES	Futures	3158.7	3161.43	3157.61	3160.61	12175.0
2018-08-31 05:00:00	ES	Futures	3160.34	3163.06	3157.07	3157.61	13902.0
2018-08-31 06:00:00	ES	Futures	3157.88	3160.06	3155.98	3158.7	11684.0
2018-08-31 07:00:00	ES	Futures	3158.7	3159.25	3155.7	3155.98	12189.0
2018-08-31 08:00:00	ES	Futures	3155.98	3158.7	3155.16	3155.43	20365.0
2018-08-31 09:00:00	ES	Futures	3155.7	3162.79	3155.16	3161.43	114825.0
2018-08-31 10:00:00	ES	Futures	3161.43	3168.78	3161.15	3164.97	156763.0
2018-08-31 11:00:00	ES	Futures	3164.7	3166.6	3156.25	3156.25	155502.0
2018-08-31 12:00:00	ES	Futures	3156.52	3156.79	3151.62	3156.79	122533.0
2018-08-31 13:00:00	ES	Futures	3156.79	3158.16	3154.34	3157.34	69869.0
2018-08-31 14:00:00	ES	Futures	3157.07	3157.61	3152.16	3154.89	84524.0
2018-08-31 15:00:00	ES	Futures	3154.89	3164.7	3154.07	3161.97	312157.0
2018-08-31 16:00:00	ES	Futures	3162.24	3168.51	3161.43	3168.24	81974.0
2018-08-31 17:00:00	ES	Futures	3168.24	3168.24	3168.24	3168.24	5.0
2018-08-31 00:00:00	NQ	Futures	9015.67	9019.21	9015.08	9015.97	1048.0
2018-08-31 01:00:00	NQ	Futures	9015.97	9024.8	9015.38	9015.97	2937.0
2018-08-31 02:00:00	NQ	Futures	9016.26	9018.62	9010.08	9015.97	2561.0
2018-08-31 03:00:00	NQ	Futures	9016.26	9016.26	8993.0	8999.77	5963.0
2018-08-31 04:00:00	NQ	Futures	8999.77	9008.02	8995.36	9004.78	2922.0
2018-08-31 05:00:00	NQ	Futures	9005.07	9013.32	8995.65	8997.12	3196.0
2018-08-31 06:00:00	NQ	Futures	8998.01	9005.66	8993.59	9001.54	2863.0
2018-08-31 07:00:00	NQ	Futures	9000.95	9006.25	8994.18	8996.24	2665.0
2018-08-31 08:00:00	NQ	Futures	8995.95	9002.72	8993.59	8995.36	4845.0
2018-08-31 09:00:00	NQ	Futures	8995.06	9035.1	8991.82	9026.27	44786.0
2018-08-31 10:00:00	NQ	Futures	9026.57	9047.18	9024.21	9036.87	49620.0
2018-08-31 11:00:00	NQ	Futures	9036.87	9045.11	9003.9	9007.43	54649.0
2018-08-31 12:00:00	NQ	Futures	9007.72	9019.21	9000.36	9017.14	35395.0
2018-08-31 13:00:00	NQ	Futures	9017.14	9020.09	9003.01	9011.55	22695.0
2018-08-31 14:00:00	NQ	Futures	9011.55	9012.73	8989.47	9002.72	28132.0
2018-08-31 15:00:00	NQ	Futures	9003.01	9026.57	8995.06	9021.27	50772.0
2018-08-31 16:00:00	NQ	Futures	9021.27	9037.46	9016.26	9037.46	11072.0
2018-08-31 00:00:00	YM	Futures	28277.6	28288.5	28268.9	28272.1	881.0
2018-08-31 01:00:00	YM	Futures	28273.2	28297.1	28273.2	28274.3	1391.0
2018-08-31 02:00:00	YM	Futures	28274.3	28285.2	28264.5	28279.8	1391.0
2018-08-31 03:00:00	YM	Futures	28281.9	28281.9	28226.5	28242.8	4539.0
2018-08-31 04:00:00	YM	Futures	28242.8	28262.4	28230.8	28254.8	2157.0
2018-08-31 05:00:00	YM	Futures	28255.8	28275.4	28223.2	28225.4	2314.0
2018-08-31 06:00:00	YM	Futures	28227.6	28246.1	28209.1	28237.4	2090.0
2018-08-31 07:00:00	YM	Futures	28238.4	28241.7	28201.5	28206.9	1938.0
2018-08-31 08:00:00	YM	Futures	28205.8	28225.4	28196.0	28201.5	2906.0
2018-08-31 09:00:00	YM	Futures	28201.5	28262.4	28196.0	28254.8	12927.0
2018-08-31 10:00:00	YM	Futures	28254.8	28318.9	28254.8	28279.8	16965.0
2018-08-31 11:00:00	YM	Futures	28280.8	28300.4	28190.6	28191.7	16693.0
2018-08-31 12:00:00	YM	Futures	28190.6	28202.6	28152.6	28193.9	17238.0
2018-08-31 13:00:00	YM	Futures	28192.8	28213.4	28179.7	28199.3	7079.0
2018-08-31 14:00:00	YM	Futures	28200.4	28204.7	28161.3	28184.1	8192.0

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

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