PREVIEW / futures_1hour / 2020-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-02.parquet
  size:    62 KB
  rows:    1,874

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-06-02 00:00:00	ES	Futures	3337.98	3340.17	3335.78	3338.8	5355.0
2020-06-02 01:00:00	ES	Futures	3339.07	3348.95	3338.52	3348.68	14941.0
2020-06-02 02:00:00	ES	Futures	3348.4	3348.95	3343.19	3345.11	11182.0
2020-06-02 03:00:00	ES	Futures	3345.38	3353.34	3342.37	3350.05	38292.0
2020-06-02 04:00:00	ES	Futures	3350.05	3369.26	3349.78	3365.69	43158.0
2020-06-02 05:00:00	ES	Futures	3365.69	3375.84	3364.04	3373.1	30533.0
2020-06-02 06:00:00	ES	Futures	3373.38	3375.3	3370.36	3370.91	19330.0
2020-06-02 07:00:00	ES	Futures	3370.63	3370.91	3364.04	3365.97	23137.0
2020-06-02 08:00:00	ES	Futures	3365.97	3369.26	3360.48	3362.95	31330.0
2020-06-02 09:00:00	ES	Futures	3362.95	3363.77	3349.78	3358.28	164023.0
2020-06-02 10:00:00	ES	Futures	3358.01	3369.26	3353.34	3359.38	198175.0
2020-06-02 11:00:00	ES	Futures	3359.38	3359.93	3345.38	3353.34	203938.0
2020-06-02 12:00:00	ES	Futures	3353.62	3361.3	3352.25	3359.93	69684.0
2020-06-02 13:00:00	ES	Futures	3359.65	3367.61	3359.38	3366.79	75151.0
2020-06-02 14:00:00	ES	Futures	3366.51	3368.16	3356.91	3363.77	100022.0
2020-06-02 15:00:00	ES	Futures	3364.04	3378.86	3355.81	3378.59	221242.0
2020-06-02 16:00:00	ES	Futures	3378.31	3379.69	3374.2	3378.59	65281.0
2020-06-02 18:00:00	ES	Futures	3378.59	3380.51	3374.47	3376.67	9542.0
2020-06-02 19:00:00	ES	Futures	3376.39	3389.02	3376.12	3387.37	17747.0
2020-06-02 20:00:00	ES	Futures	3387.64	3392.04	3382.98	3390.66	20387.0
2020-06-02 21:00:00	ES	Futures	3390.39	3394.23	3384.9	3386.27	20241.0
2020-06-02 22:00:00	ES	Futures	3386.55	3388.19	3381.61	3384.08	13379.0
2020-06-02 23:00:00	ES	Futures	3384.08	3390.11	3383.8	3385.72	9301.0
2020-06-02 00:00:00	NQ	Futures	10942.89	10946.03	10933.18	10940.04	2755.0
2020-06-02 01:00:00	NQ	Futures	10940.89	10971.17	10940.32	10970.31	4384.0
2020-06-02 02:00:00	NQ	Futures	10970.31	10978.31	10961.17	10969.17	4555.0
2020-06-02 03:00:00	NQ	Futures	10969.17	10996.59	10958.32	10986.6	11632.0
2020-06-02 04:00:00	NQ	Futures	10986.6	11024.59	10983.17	11016.3	11012.0
2020-06-02 05:00:00	NQ	Futures	11015.73	11044.87	11014.02	11039.44	7817.0
2020-06-02 06:00:00	NQ	Futures	11040.01	11048.58	11022.87	11029.16	6023.0
2020-06-02 07:00:00	NQ	Futures	11029.16	11029.16	10996.31	10999.45	6941.0
2020-06-02 08:00:00	NQ	Futures	10999.16	11003.16	10966.32	10980.03	11002.0
2020-06-02 09:00:00	NQ	Futures	10979.74	10984.6	10920.9	10950.32	54810.0
2020-06-02 10:00:00	NQ	Futures	10949.75	10981.74	10894.62	10916.61	58730.0
2020-06-02 11:00:00	NQ	Futures	10916.9	10918.04	10859.77	10896.05	52139.0
2020-06-02 12:00:00	NQ	Futures	10895.19	10940.89	10894.91	10937.47	24140.0
2020-06-02 13:00:00	NQ	Futures	10937.47	10980.03	10934.89	10976.03	20873.0
2020-06-02 14:00:00	NQ	Futures	10976.31	10988.02	10954.03	10976.03	27782.0
2020-06-02 15:00:00	NQ	Futures	10975.74	11032.58	10952.89	11031.44	43147.0
2020-06-02 16:00:00	NQ	Futures	11030.87	11039.15	11017.16	11034.3	9331.0
2020-06-02 18:00:00	NQ	Futures	11034.3	11036.58	11009.16	11016.3	2776.0
2020-06-02 19:00:00	NQ	Futures	11016.59	11056.86	11014.02	11054.58	5115.0
2020-06-02 20:00:00	NQ	Futures	11054.86	11067.15	11036.58	11062.29	7068.0
2020-06-02 21:00:00	NQ	Futures	11062.01	11074.29	11042.01	11046.58	7622.0
2020-06-02 22:00:00	NQ	Futures	11046.87	11052.86	11027.73	11032.58	5470.0
2020-06-02 23:00:00	NQ	Futures	11032.3	11055.15	11030.87	11042.87	3447.0
2020-06-02 00:00:00	YM	Futures	27771.8	27787.1	27755.3	27776.2	1094.0
2020-06-02 01:00:00	YM	Futures	27775.1	27856.1	27775.1	27855.0	3067.0
2020-06-02 02:00:00	YM	Futures	27852.8	27863.8	27807.9	27822.2	2987.0
2020-06-02 03:00:00	YM	Futures	27823.3	27899.9	27792.6	27867.1	8176.0

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

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