PREVIEW / futures_1hour / 2018-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-23.parquet
  size:    48 KB
  rows:    1,394

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-03-23 00:00:00	ES	Futures	2868.54	2870.17	2866.9	2868.81	5953.0
2018-03-23 01:00:00	ES	Futures	2869.08	2870.17	2863.35	2865.26	7922.0
2018-03-23 02:00:00	ES	Futures	2865.26	2872.08	2862.81	2871.27	11519.0
2018-03-23 03:00:00	ES	Futures	2871.54	2885.46	2871.27	2884.37	28649.0
2018-03-23 04:00:00	ES	Futures	2884.37	2886.28	2873.72	2875.36	33490.0
2018-03-23 05:00:00	ES	Futures	2875.09	2877.0	2865.53	2867.99	33925.0
2018-03-23 06:00:00	ES	Futures	2867.99	2879.45	2864.99	2878.91	33271.0
2018-03-23 07:00:00	ES	Futures	2878.91	2886.0	2876.18	2885.18	37091.0
2018-03-23 08:00:00	ES	Futures	2884.91	2894.19	2883.55	2884.64	73952.0
2018-03-23 09:00:00	ES	Futures	2884.64	2902.38	2883.0	2890.37	279949.0
2018-03-23 10:00:00	ES	Futures	2890.64	2897.74	2883.82	2896.92	297725.0
2018-03-23 11:00:00	ES	Futures	2896.65	2899.38	2866.35	2867.44	256956.0
2018-03-23 12:00:00	ES	Futures	2867.17	2881.64	2866.63	2869.9	243536.0
2018-03-23 13:00:00	ES	Futures	2869.9	2892.01	2867.17	2889.0	203994.0
2018-03-23 14:00:00	ES	Futures	2889.0	2892.55	2847.8	2849.43	290410.0
2018-03-23 15:00:00	ES	Futures	2849.43	2854.89	2822.96	2824.87	666001.0
2018-03-23 16:00:00	ES	Futures	2825.14	2840.15	2823.78	2834.42	127736.0
2018-03-23 00:00:00	NQ	Futures	7838.4	7842.54	7828.35	7836.92	2689.0
2018-03-23 01:00:00	NQ	Futures	7837.51	7839.88	7817.42	7821.85	3114.0
2018-03-23 02:00:00	NQ	Futures	7821.85	7851.7	7810.32	7846.38	5245.0
2018-03-23 03:00:00	NQ	Futures	7846.97	7886.87	7846.97	7882.73	8703.0
2018-03-23 04:00:00	NQ	Futures	7883.02	7892.78	7840.76	7850.81	9168.0
2018-03-23 05:00:00	NQ	Futures	7850.52	7856.13	7816.83	7828.06	7790.0
2018-03-23 06:00:00	NQ	Futures	7828.06	7858.79	7817.42	7856.43	10401.0
2018-03-23 07:00:00	NQ	Futures	7856.72	7884.5	7851.4	7883.02	10517.0
2018-03-23 08:00:00	NQ	Futures	7882.73	7922.63	7881.84	7888.34	24398.0
2018-03-23 09:00:00	NQ	Futures	7888.64	7945.38	7862.93	7901.64	88027.0
2018-03-23 10:00:00	NQ	Futures	7901.64	7936.52	7874.75	7933.86	91296.0
2018-03-23 11:00:00	NQ	Futures	7933.56	7941.24	7828.94	7831.6	69233.0
2018-03-23 12:00:00	NQ	Futures	7831.6	7873.86	7829.83	7836.92	62492.0
2018-03-23 13:00:00	NQ	Futures	7836.63	7915.24	7824.21	7906.67	61714.0
2018-03-23 14:00:00	NQ	Futures	7905.78	7916.71	7782.84	7786.98	71429.0
2018-03-23 15:00:00	NQ	Futures	7786.98	7812.39	7707.48	7707.77	136773.0
2018-03-23 16:00:00	NQ	Futures	7707.77	7753.88	7706.3	7740.58	21323.0
2018-03-23 00:00:00	YM	Futures	25837.6	25865.8	25822.4	25851.7	2490.0
2018-03-23 01:00:00	YM	Futures	25853.9	25862.6	25793.1	25811.5	3459.0
2018-03-23 02:00:00	YM	Futures	25810.4	25865.8	25794.1	25860.4	6336.0
2018-03-23 03:00:00	YM	Futures	25859.3	25990.7	25859.3	25975.5	10121.0
2018-03-23 04:00:00	YM	Futures	25976.6	26003.7	25876.7	25903.8	10272.0
2018-03-23 05:00:00	YM	Futures	25902.7	25920.1	25790.9	25822.4	9181.0
2018-03-23 06:00:00	YM	Futures	25823.5	25934.2	25792.0	25929.9	8149.0
2018-03-23 07:00:00	YM	Futures	25929.9	25995.1	25908.2	25990.7	9475.0
2018-03-23 08:00:00	YM	Futures	25989.6	26098.2	25980.9	25983.1	16877.0
2018-03-23 09:00:00	YM	Futures	25984.2	26171.0	25972.2	26087.4	43732.0
2018-03-23 10:00:00	YM	Futures	26090.6	26164.5	26021.1	26142.8	50105.0
2018-03-23 11:00:00	YM	Futures	26140.6	26171.0	25871.2	25882.1	44987.0
2018-03-23 12:00:00	YM	Futures	25882.1	26035.2	25875.6	25924.5	37444.0
2018-03-23 13:00:00	YM	Futures	25923.4	26176.4	25898.4	26141.7	36691.0
2018-03-23 14:00:00	YM	Futures	26141.7	26175.3	25754.0	25762.6	49600.0
2018-03-23 15:00:00	YM	Futures	25764.8	25799.6	25517.2	25545.4	87522.0

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

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