PREVIEW / futures_1hour / 2020-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-08.parquet
  size:    61 KB
  rows:    1,831

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-04-08 00:00:00	ES	Futures	2904.13	2921.14	2898.91	2918.94	11091.0
2020-04-08 01:00:00	ES	Futures	2919.22	2942.27	2915.65	2933.21	20844.0
2020-04-08 02:00:00	ES	Futures	2933.49	2934.86	2883.82	2906.05	38255.0
2020-04-08 03:00:00	ES	Futures	2906.32	2921.14	2897.27	2916.75	32177.0
2020-04-08 04:00:00	ES	Futures	2916.75	2917.3	2885.74	2898.36	25350.0
2020-04-08 05:00:00	ES	Futures	2898.36	2905.22	2889.86	2895.89	19271.0
2020-04-08 06:00:00	ES	Futures	2896.17	2917.3	2893.97	2915.93	18738.0
2020-04-08 07:00:00	ES	Futures	2915.65	2928.82	2911.26	2924.71	31366.0
2020-04-08 08:00:00	ES	Futures	2924.43	2939.25	2921.14	2932.12	55147.0
2020-04-08 09:00:00	ES	Futures	2932.12	2951.33	2920.04	2922.79	190813.0
2020-04-08 10:00:00	ES	Futures	2922.51	2950.78	2912.63	2949.68	192541.0
2020-04-08 11:00:00	ES	Futures	2949.68	2980.14	2942.54	2970.26	213969.0
2020-04-08 12:00:00	ES	Futures	2970.53	2987.55	2963.95	2978.77	154619.0
2020-04-08 13:00:00	ES	Futures	2978.77	2985.35	2962.03	2965.05	135783.0
2020-04-08 14:00:00	ES	Futures	2964.77	3003.46	2963.67	3002.92	161699.0
2020-04-08 15:00:00	ES	Futures	3002.92	3021.3	2985.08	3005.93	364075.0
2020-04-08 16:00:00	ES	Futures	3005.66	3009.78	3000.45	3007.03	86732.0
2020-04-08 18:00:00	ES	Futures	3005.11	3006.21	2994.13	3000.45	10078.0
2020-04-08 19:00:00	ES	Futures	3000.72	3020.2	2996.88	3015.54	14179.0
2020-04-08 20:00:00	ES	Futures	3015.81	3018.01	3007.58	3011.15	14247.0
2020-04-08 21:00:00	ES	Futures	3011.42	3015.54	2993.31	2996.88	17269.0
2020-04-08 22:00:00	ES	Futures	2996.88	3004.29	2987.55	2992.76	14146.0
2020-04-08 23:00:00	ES	Futures	2992.76	3003.19	2989.2	3000.99	10936.0
2020-04-08 00:00:00	NQ	Futures	9187.63	9242.47	9173.35	9235.33	4986.0
2020-04-08 01:00:00	NQ	Futures	9235.62	9303.89	9222.76	9278.75	6634.0
2020-04-08 02:00:00	NQ	Futures	9281.04	9283.32	9121.93	9184.2	12710.0
2020-04-08 03:00:00	NQ	Futures	9185.35	9223.05	9161.64	9213.05	9491.0
2020-04-08 04:00:00	NQ	Futures	9213.91	9215.05	9118.79	9160.78	8430.0
2020-04-08 05:00:00	NQ	Futures	9161.35	9185.63	9138.22	9154.78	7651.0
2020-04-08 06:00:00	NQ	Futures	9155.07	9223.05	9150.5	9217.62	6862.0
2020-04-08 07:00:00	NQ	Futures	9216.77	9257.9	9202.2	9244.19	9402.0
2020-04-08 08:00:00	NQ	Futures	9243.62	9284.46	9232.48	9254.47	13880.0
2020-04-08 09:00:00	NQ	Futures	9254.76	9316.74	9213.91	9222.48	45085.0
2020-04-08 10:00:00	NQ	Futures	9222.48	9297.89	9191.34	9293.32	50898.0
2020-04-08 11:00:00	NQ	Futures	9292.75	9356.16	9267.04	9322.74	43014.0
2020-04-08 12:00:00	NQ	Futures	9322.45	9363.01	9307.89	9338.16	32273.0
2020-04-08 13:00:00	NQ	Futures	9338.16	9356.16	9277.32	9282.75	29075.0
2020-04-08 14:00:00	NQ	Futures	9283.32	9384.72	9279.32	9382.15	36550.0
2020-04-08 15:00:00	NQ	Futures	9382.15	9417.0	9320.74	9383.58	59415.0
2020-04-08 16:00:00	NQ	Futures	9383.58	9386.44	9353.59	9371.01	11745.0
2020-04-08 18:00:00	NQ	Futures	9363.59	9363.59	9322.74	9345.88	3507.0
2020-04-08 19:00:00	NQ	Futures	9345.88	9410.43	9334.16	9398.15	4117.0
2020-04-08 20:00:00	NQ	Futures	9398.43	9403.58	9366.73	9378.44	3747.0
2020-04-08 21:00:00	NQ	Futures	9377.87	9394.43	9314.46	9323.02	5389.0
2020-04-08 22:00:00	NQ	Futures	9323.88	9346.16	9295.03	9311.31	4646.0
2020-04-08 23:00:00	NQ	Futures	9312.74	9340.45	9300.46	9332.45	3771.0
2020-04-08 00:00:00	YM	Futures	24642.5	24817.7	24600.8	24803.5	3250.0
2020-04-08 01:00:00	YM	Futures	24799.1	25018.1	24767.3	24933.8	5680.0
2020-04-08 02:00:00	YM	Futures	24936.0	24948.0	24466.1	24698.3	7487.0
2020-04-08 03:00:00	YM	Futures	24698.3	24816.6	24607.4	24782.7	6796.0

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

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