PREVIEW / futures_1hour / 2019-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-03.parquet
  size:    58 KB
  rows:    1,785

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-01-03 00:00:00	ES	Futures	2691.4	2692.49	2684.07	2687.06	9844.0
2019-01-03 01:00:00	ES	Futures	2687.06	2688.14	2675.38	2685.43	11991.0
2019-01-03 02:00:00	ES	Futures	2685.43	2694.39	2685.16	2688.42	17300.0
2019-01-03 03:00:00	ES	Futures	2688.42	2695.21	2685.7	2688.42	25680.0
2019-01-03 04:00:00	ES	Futures	2688.42	2693.58	2683.26	2683.8	16056.0
2019-01-03 05:00:00	ES	Futures	2683.8	2687.87	2680.27	2682.71	17953.0
2019-01-03 06:00:00	ES	Futures	2682.44	2688.96	2678.91	2684.89	21727.0
2019-01-03 07:00:00	ES	Futures	2684.89	2694.93	2684.34	2694.93	25092.0
2019-01-03 08:00:00	ES	Futures	2694.93	2705.8	2693.03	2703.62	49906.0
2019-01-03 09:00:00	ES	Futures	2703.62	2708.78	2688.96	2693.85	206998.0
2019-01-03 10:00:00	ES	Futures	2693.58	2693.58	2658.54	2673.21	398373.0
2019-01-03 11:00:00	ES	Futures	2672.94	2703.9	2669.4	2692.22	353691.0
2019-01-03 12:00:00	ES	Futures	2692.49	2694.93	2680.54	2691.4	177084.0
2019-01-03 13:00:00	ES	Futures	2691.13	2691.4	2666.42	2671.31	188646.0
2019-01-03 14:00:00	ES	Futures	2671.03	2687.33	2663.7	2667.78	167783.0
2019-01-03 15:00:00	ES	Futures	2668.05	2673.75	2654.2	2659.63	339749.0
2019-01-03 16:00:00	ES	Futures	2659.63	2666.96	2657.45	2663.43	83630.0
2019-01-03 18:00:00	ES	Futures	2663.43	2668.05	2659.36	2660.99	10372.0
2019-01-03 19:00:00	ES	Futures	2660.71	2663.16	2649.04	2652.57	27077.0
2019-01-03 20:00:00	ES	Futures	2652.84	2664.52	2651.75	2660.17	17714.0
2019-01-03 21:00:00	ES	Futures	2660.17	2667.78	2656.37	2667.5	16538.0
2019-01-03 22:00:00	ES	Futures	2667.5	2674.29	2666.69	2671.03	18266.0
2019-01-03 23:00:00	ES	Futures	2671.03	2674.29	2669.68	2672.94	7210.0
2019-01-03 00:00:00	NQ	Futures	7284.86	7288.66	7250.68	7260.03	5787.0
2019-01-03 01:00:00	NQ	Futures	7260.61	7262.95	7232.56	7257.98	5742.0
2019-01-03 02:00:00	NQ	Futures	7257.4	7284.86	7257.11	7260.61	8026.0
2019-01-03 03:00:00	NQ	Futures	7260.61	7273.47	7242.2	7250.39	13567.0
2019-01-03 04:00:00	NQ	Futures	7250.68	7267.04	7242.5	7244.83	8095.0
2019-01-03 05:00:00	NQ	Futures	7244.83	7262.07	7233.15	7245.13	9289.0
2019-01-03 06:00:00	NQ	Futures	7244.54	7260.32	7238.11	7254.18	9474.0
2019-01-03 07:00:00	NQ	Futures	7254.18	7300.93	7252.43	7300.93	11732.0
2019-01-03 08:00:00	NQ	Futures	7301.23	7331.32	7292.46	7326.94	18726.0
2019-01-03 09:00:00	NQ	Futures	7326.94	7368.14	7290.71	7307.36	87083.0
2019-01-03 10:00:00	NQ	Futures	7306.19	7306.19	7210.94	7260.03	123277.0
2019-01-03 11:00:00	NQ	Futures	7260.32	7343.89	7254.18	7309.41	100988.0
2019-01-03 12:00:00	NQ	Futures	7309.41	7321.68	7267.04	7300.35	55341.0
2019-01-03 13:00:00	NQ	Futures	7299.77	7301.23	7222.34	7230.23	57892.0
2019-01-03 14:00:00	NQ	Futures	7230.52	7284.57	7213.86	7221.75	55345.0
2019-01-03 15:00:00	NQ	Futures	7222.04	7248.05	7186.1	7198.08	80700.0
2019-01-03 16:00:00	NQ	Futures	7198.38	7225.84	7195.75	7213.86	18037.0
2019-01-03 18:00:00	NQ	Futures	7209.77	7227.3	7200.71	7208.9	3843.0
2019-01-03 19:00:00	NQ	Futures	7208.02	7214.74	7172.08	7183.77	9301.0
2019-01-03 20:00:00	NQ	Futures	7184.35	7222.04	7182.01	7212.4	7732.0
2019-01-03 21:00:00	NQ	Futures	7211.82	7234.32	7198.38	7232.85	8273.0
2019-01-03 22:00:00	NQ	Futures	7233.44	7253.89	7229.35	7241.62	8318.0
2019-01-03 23:00:00	NQ	Futures	7241.62	7257.4	7241.04	7251.26	4641.0
2019-01-03 00:00:00	YM	Futures	24977.8	24985.4	24896.3	24931.1	2917.0
2019-01-03 01:00:00	YM	Futures	24932.2	24940.9	24835.5	24920.2	3114.0
2019-01-03 02:00:00	YM	Futures	24920.2	25006.0	24917.0	24956.1	6095.0
2019-01-03 03:00:00	YM	Futures	24958.2	25034.2	24933.3	24968.0	7958.0

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

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