PREVIEW / futures_1hour / 2018-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-27.parquet
  size:    51 KB
  rows:    1,562

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-27 00:00:00	ES	Futures	3142.9	3143.17	3142.08	3142.63	2269.0
2018-08-27 01:00:00	ES	Futures	3142.9	3143.44	3142.08	3142.08	4687.0
2018-08-27 02:00:00	ES	Futures	3142.08	3142.63	3140.99	3141.81	5048.0
2018-08-27 03:00:00	ES	Futures	3141.81	3142.9	3140.17	3140.72	9348.0
2018-08-27 04:00:00	ES	Futures	3140.45	3143.72	3140.17	3142.9	9351.0
2018-08-27 05:00:00	ES	Futures	3143.17	3143.99	3142.35	3142.35	8359.0
2018-08-27 06:00:00	ES	Futures	3142.63	3143.44	3141.54	3142.63	8557.0
2018-08-27 07:00:00	ES	Futures	3142.63	3144.26	3142.63	3144.26	8739.0
2018-08-27 08:00:00	ES	Futures	3143.99	3147.53	3143.72	3147.26	27401.0
2018-08-27 09:00:00	ES	Futures	3147.53	3153.8	3146.44	3153.52	147463.0
2018-08-27 10:00:00	ES	Futures	3153.52	3157.34	3151.89	3155.16	144107.0
2018-08-27 11:00:00	ES	Futures	3155.16	3159.52	3152.44	3159.25	125277.0
2018-08-27 12:00:00	ES	Futures	3159.25	3159.79	3157.07	3158.97	67487.0
2018-08-27 13:00:00	ES	Futures	3158.97	3159.52	3156.52	3157.88	57560.0
2018-08-27 14:00:00	ES	Futures	3158.16	3158.7	3156.25	3158.16	50431.0
2018-08-27 15:00:00	ES	Futures	3158.16	3158.43	3155.16	3158.16	151983.0
2018-08-27 16:00:00	ES	Futures	3157.88	3160.06	3156.25	3159.79	59678.0
2018-08-27 18:00:00	ES	Futures	3159.52	3161.7	3159.52	3161.15	5245.0
2018-08-27 19:00:00	ES	Futures	3161.15	3161.7	3160.61	3161.7	3089.0
2018-08-27 20:00:00	ES	Futures	3161.43	3163.88	3161.15	3163.61	8034.0
2018-08-27 21:00:00	ES	Futures	3163.61	3164.7	3163.06	3163.61	6453.0
2018-08-27 22:00:00	ES	Futures	3163.61	3163.61	3161.97	3162.24	6998.0
2018-08-27 23:00:00	ES	Futures	3161.97	3162.52	3161.15	3161.7	3009.0
2018-08-27 00:00:00	NQ	Futures	8864.05	8864.34	8859.93	8862.58	1018.0
2018-08-27 01:00:00	NQ	Futures	8862.58	8864.34	8858.16	8859.34	1891.0
2018-08-27 02:00:00	NQ	Futures	8859.04	8861.4	8856.69	8860.22	1657.0
2018-08-27 03:00:00	NQ	Futures	8859.93	8864.64	8857.86	8858.45	2714.0
2018-08-27 04:00:00	NQ	Futures	8858.45	8866.11	8854.92	8864.34	3067.0
2018-08-27 05:00:00	NQ	Futures	8864.34	8870.52	8862.87	8862.87	2395.0
2018-08-27 06:00:00	NQ	Futures	8863.16	8864.05	8857.57	8859.34	2133.0
2018-08-27 07:00:00	NQ	Futures	8859.04	8864.34	8857.57	8863.46	2364.0
2018-08-27 08:00:00	NQ	Futures	8863.16	8872.88	8863.16	8870.82	4735.0
2018-08-27 09:00:00	NQ	Futures	8870.82	8884.66	8853.45	8881.42	51958.0
2018-08-27 10:00:00	NQ	Futures	8881.42	8910.27	8877.88	8909.09	57505.0
2018-08-27 11:00:00	NQ	Futures	8909.09	8912.04	8892.31	8909.68	37794.0
2018-08-27 12:00:00	NQ	Futures	8909.39	8911.74	8903.79	8909.39	17390.0
2018-08-27 13:00:00	NQ	Futures	8909.39	8909.39	8899.38	8905.56	21398.0
2018-08-27 14:00:00	NQ	Futures	8905.27	8909.09	8896.73	8909.09	14897.0
2018-08-27 15:00:00	NQ	Futures	8908.8	8912.63	8898.79	8912.33	29814.0
2018-08-27 16:00:00	NQ	Futures	8912.04	8913.8	8905.56	8912.92	9387.0
2018-08-27 18:00:00	NQ	Futures	8912.92	8927.94	8912.92	8921.16	1793.0
2018-08-27 19:00:00	NQ	Futures	8921.46	8929.11	8921.16	8928.52	1585.0
2018-08-27 20:00:00	NQ	Futures	8928.52	8936.18	8928.52	8933.82	3568.0
2018-08-27 21:00:00	NQ	Futures	8933.82	8940.01	8932.94	8933.82	3579.0
2018-08-27 22:00:00	NQ	Futures	8933.82	8934.71	8927.05	8927.94	2702.0
2018-08-27 23:00:00	NQ	Futures	8927.64	8932.94	8925.88	8927.64	1677.0
2018-08-27 00:00:00	YM	Futures	28142.8	28142.8	28130.8	28134.1	634.0
2018-08-27 01:00:00	YM	Futures	28134.1	28142.8	28129.7	28134.1	832.0
2018-08-27 02:00:00	YM	Futures	28133.0	28134.1	28111.2	28123.2	1652.0
2018-08-27 03:00:00	YM	Futures	28122.1	28127.6	28105.8	28109.1	1511.0

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

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