PREVIEW / futures_1hour / 2018-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-01.parquet
  size:    48 KB
  rows:    1,445

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-05-01 00:00:00	ES	Futures	2892.01	2893.37	2891.46	2892.55	2090.0
2018-05-01 01:00:00	ES	Futures	2892.55	2896.92	2892.28	2896.37	6557.0
2018-05-01 02:00:00	ES	Futures	2896.1	2896.37	2890.64	2891.46	4466.0
2018-05-01 03:00:00	ES	Futures	2891.73	2895.01	2890.91	2891.46	9009.0
2018-05-01 04:00:00	ES	Futures	2891.73	2891.73	2884.64	2884.64	9018.0
2018-05-01 05:00:00	ES	Futures	2884.64	2887.91	2884.09	2887.09	5718.0
2018-05-01 06:00:00	ES	Futures	2887.37	2890.64	2884.64	2889.0	8307.0
2018-05-01 07:00:00	ES	Futures	2889.0	2892.28	2887.37	2888.19	9278.0
2018-05-01 08:00:00	ES	Futures	2887.91	2889.55	2885.73	2888.19	14579.0
2018-05-01 09:00:00	ES	Futures	2888.19	2888.46	2877.27	2883.27	165732.0
2018-05-01 10:00:00	ES	Futures	2883.0	2884.09	2872.63	2872.9	190159.0
2018-05-01 11:00:00	ES	Futures	2872.9	2875.9	2867.17	2868.81	168176.0
2018-05-01 12:00:00	ES	Futures	2868.54	2875.36	2868.26	2871.54	141991.0
2018-05-01 13:00:00	ES	Futures	2871.54	2880.82	2863.62	2880.54	122744.0
2018-05-01 14:00:00	ES	Futures	2880.54	2890.91	2880.0	2887.91	137404.0
2018-05-01 15:00:00	ES	Futures	2887.64	2896.1	2881.36	2894.74	187399.0
2018-05-01 16:00:00	ES	Futures	2894.74	2901.56	2892.83	2898.83	79433.0
2018-05-01 18:00:00	ES	Futures	2898.83	2899.92	2897.74	2899.38	4019.0
2018-05-01 19:00:00	ES	Futures	2899.1	2899.92	2896.37	2899.38	2674.0
2018-05-01 20:00:00	ES	Futures	2899.38	2899.65	2885.46	2892.28	15153.0
2018-05-01 21:00:00	ES	Futures	2892.28	2895.28	2889.28	2889.82	7453.0
2018-05-01 22:00:00	ES	Futures	2889.55	2891.19	2888.73	2891.19	4693.0
2018-05-01 23:00:00	ES	Futures	2891.19	2892.01	2890.91	2891.73	2474.0
2018-05-01 00:00:00	NQ	Futures	7821.26	7827.17	7819.19	7824.21	1198.0
2018-05-01 01:00:00	NQ	Futures	7824.51	7835.15	7824.21	7831.9	1507.0
2018-05-01 02:00:00	NQ	Futures	7831.6	7831.9	7815.64	7818.89	1594.0
2018-05-01 03:00:00	NQ	Futures	7819.19	7830.72	7815.94	7816.83	2082.0
2018-05-01 04:00:00	NQ	Futures	7816.53	7817.12	7793.77	7795.55	3596.0
2018-05-01 05:00:00	NQ	Futures	7795.84	7806.78	7792.89	7805.3	2821.0
2018-05-01 06:00:00	NQ	Futures	7805.3	7819.78	7793.77	7812.1	3125.0
2018-05-01 07:00:00	NQ	Futures	7812.1	7825.1	7803.23	7806.19	4806.0
2018-05-01 08:00:00	NQ	Futures	7805.89	7815.35	7796.43	7811.8	6424.0
2018-05-01 09:00:00	NQ	Futures	7811.8	7825.69	7776.93	7820.08	51914.0
2018-05-01 10:00:00	NQ	Futures	7819.78	7841.65	7797.62	7811.51	70450.0
2018-05-01 11:00:00	NQ	Futures	7811.8	7827.76	7786.68	7798.5	45332.0
2018-05-01 12:00:00	NQ	Futures	7798.8	7826.87	7798.21	7813.87	28505.0
2018-05-01 13:00:00	NQ	Futures	7813.57	7846.67	7790.82	7846.08	30876.0
2018-05-01 14:00:00	NQ	Futures	7846.38	7870.02	7842.54	7862.93	32483.0
2018-05-01 15:00:00	NQ	Futures	7862.34	7906.96	7857.9	7902.53	42960.0
2018-05-01 16:00:00	NQ	Futures	7902.23	7967.55	7899.28	7941.84	19931.0
2018-05-01 18:00:00	NQ	Futures	7938.58	7945.38	7935.04	7945.09	1889.0
2018-05-01 19:00:00	NQ	Futures	7944.79	7948.04	7939.18	7946.27	1445.0
2018-05-01 20:00:00	NQ	Futures	7946.27	7947.15	7904.6	7926.47	5518.0
2018-05-01 21:00:00	NQ	Futures	7927.65	7932.08	7911.4	7912.58	2861.0
2018-05-01 22:00:00	NQ	Futures	7913.17	7918.49	7908.14	7917.01	1729.0
2018-05-01 23:00:00	NQ	Futures	7917.31	7920.56	7915.53	7918.19	689.0
2018-05-01 00:00:00	YM	Futures	26224.2	26241.6	26223.1	26234.0	757.0
2018-05-01 01:00:00	YM	Futures	26234.0	26268.7	26231.8	26253.5	1372.0
2018-05-01 02:00:00	YM	Futures	26251.4	26252.4	26192.7	26199.2	1396.0
2018-05-01 03:00:00	YM	Futures	26199.2	26230.7	26196.0	26196.0	1560.0

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

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