PREVIEW / futures_1hour / 2020-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-02.parquet
  size:    57 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
2020-07-02 00:00:00	ES	Futures	3469.6	3473.79	3468.2	3469.04	5788.0
2020-07-02 01:00:00	ES	Futures	3469.32	3471.83	3465.13	3469.04	8716.0
2020-07-02 02:00:00	ES	Futures	3469.04	3481.05	3467.37	3479.37	19685.0
2020-07-02 03:00:00	ES	Futures	3479.09	3491.66	3475.74	3487.47	38041.0
2020-07-02 04:00:00	ES	Futures	3487.47	3496.97	3485.24	3489.71	29554.0
2020-07-02 05:00:00	ES	Futures	3489.71	3491.66	3483.84	3486.91	17890.0
2020-07-02 06:00:00	ES	Futures	3486.91	3491.1	3483.0	3490.26	18129.0
2020-07-02 07:00:00	ES	Futures	3490.54	3494.73	3489.71	3493.06	15800.0
2020-07-02 08:00:00	ES	Futures	3493.06	3514.84	3488.31	3514.0	99254.0
2020-07-02 09:00:00	ES	Futures	3514.0	3523.22	3507.86	3521.82	179100.0
2020-07-02 10:00:00	ES	Futures	3521.54	3525.73	3493.06	3494.17	292098.0
2020-07-02 11:00:00	ES	Futures	3494.45	3505.06	3484.12	3502.27	194011.0
2020-07-02 12:00:00	ES	Futures	3502.27	3504.51	3493.89	3503.39	107339.0
2020-07-02 13:00:00	ES	Futures	3503.11	3508.97	3499.76	3504.23	72149.0
2020-07-02 14:00:00	ES	Futures	3503.95	3511.21	3501.16	3507.86	86443.0
2020-07-02 15:00:00	ES	Futures	3507.58	3508.97	3478.54	3486.63	212274.0
2020-07-02 16:00:00	ES	Futures	3486.91	3496.13	3486.36	3491.38	51992.0
2020-07-02 18:00:00	ES	Futures	3490.82	3497.53	3488.59	3496.13	4499.0
2020-07-02 19:00:00	ES	Futures	3495.85	3497.8	3491.94	3493.06	4412.0
2020-07-02 20:00:00	ES	Futures	3493.06	3495.01	3489.15	3493.89	8415.0
2020-07-02 21:00:00	ES	Futures	3493.62	3497.8	3488.59	3489.99	10597.0
2020-07-02 22:00:00	ES	Futures	3489.99	3493.89	3487.19	3488.59	6177.0
2020-07-02 23:00:00	ES	Futures	3488.59	3493.06	3486.63	3491.1	4339.0
2020-07-02 00:00:00	NQ	Futures	11901.14	11910.97	11897.96	11900.28	2043.0
2020-07-02 01:00:00	NQ	Futures	11900.85	11908.08	11890.44	11899.12	2774.0
2020-07-02 02:00:00	NQ	Futures	11899.41	11938.16	11896.8	11930.06	6140.0
2020-07-02 03:00:00	NQ	Futures	11930.06	11942.21	11908.37	11934.11	10711.0
2020-07-02 04:00:00	NQ	Futures	11933.82	11955.51	11928.33	11940.18	9591.0
2020-07-02 05:00:00	NQ	Futures	11939.89	11942.5	11920.23	11927.75	5132.0
2020-07-02 06:00:00	NQ	Futures	11928.33	11932.37	11915.31	11930.06	5232.0
2020-07-02 07:00:00	NQ	Futures	11930.35	11958.98	11927.17	11956.95	6906.0
2020-07-02 08:00:00	NQ	Futures	11957.24	12007.85	11939.31	12000.33	24502.0
2020-07-02 09:00:00	NQ	Futures	12000.62	12052.38	11991.08	12045.15	55885.0
2020-07-02 10:00:00	NQ	Futures	12045.15	12055.56	11980.96	11998.02	68297.0
2020-07-02 11:00:00	NQ	Futures	11997.73	12015.66	11947.7	12009.87	52998.0
2020-07-02 12:00:00	NQ	Futures	12009.58	12022.31	11982.98	12016.24	29173.0
2020-07-02 13:00:00	NQ	Futures	12015.95	12031.85	12002.64	12008.43	20719.0
2020-07-02 14:00:00	NQ	Futures	12008.72	12033.59	11997.73	12028.96	23817.0
2020-07-02 15:00:00	NQ	Futures	12029.25	12035.32	11934.4	11954.93	48586.0
2020-07-02 16:00:00	NQ	Futures	11955.51	11980.67	11954.06	11971.7	10111.0
2020-07-02 18:00:00	NQ	Futures	11974.3	11987.32	11967.65	11979.51	1560.0
2020-07-02 19:00:00	NQ	Futures	11979.51	11984.14	11966.5	11972.28	1141.0
2020-07-02 20:00:00	NQ	Futures	11971.7	11983.85	11960.42	11980.96	2015.0
2020-07-02 21:00:00	NQ	Futures	11980.38	11997.44	11968.81	11971.12	3067.0
2020-07-02 22:00:00	NQ	Futures	11971.12	11985.58	11961.29	11967.36	2529.0
2020-07-02 23:00:00	NQ	Futures	11967.08	11980.38	11961.0	11975.75	1200.0
2020-07-02 00:00:00	YM	Futures	28201.3	28238.7	28189.2	28194.7	1894.0
2020-07-02 01:00:00	YM	Futures	28196.9	28212.3	28148.4	28187.0	1764.0
2020-07-02 02:00:00	YM	Futures	28185.9	28312.5	28171.6	28296.0	4852.0
2020-07-02 03:00:00	YM	Futures	28298.2	28436.9	28266.3	28389.6	12790.0

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

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