PREVIEW / futures_1hour / 2020-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-07.parquet
  size:    64 KB
  rows:    1,864

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-07 00:00:00	ES	Futures	2884.64	2903.3	2882.72	2903.03	20599.0
2020-04-07 01:00:00	ES	Futures	2902.75	2924.43	2899.19	2919.77	17172.0
2020-04-07 02:00:00	ES	Futures	2920.04	2955.72	2915.1	2954.62	40168.0
2020-04-07 03:00:00	ES	Futures	2954.62	2982.88	2944.74	2970.53	71488.0
2020-04-07 04:00:00	ES	Futures	2970.53	2987.27	2966.97	2969.71	45143.0
2020-04-07 05:00:00	ES	Futures	2969.71	2985.35	2969.44	2981.51	39304.0
2020-04-07 06:00:00	ES	Futures	2981.24	3013.07	2979.32	3006.76	72482.0
2020-04-07 07:00:00	ES	Futures	3006.76	3007.31	2982.61	2983.71	44688.0
2020-04-07 08:00:00	ES	Futures	2983.98	3002.37	2980.96	3000.17	66779.0
2020-04-07 09:00:00	ES	Futures	2999.9	3018.56	2981.51	3002.37	285445.0
2020-04-07 10:00:00	ES	Futures	3002.37	3004.84	2940.07	2951.05	330120.0
2020-04-07 11:00:00	ES	Futures	2951.05	2990.02	2943.09	2978.22	244828.0
2020-04-07 12:00:00	ES	Futures	2978.49	3005.66	2977.67	2991.12	179737.0
2020-04-07 13:00:00	ES	Futures	2991.12	2997.7	2967.79	2970.53	161080.0
2020-04-07 14:00:00	ES	Futures	2970.26	2971.91	2919.22	2925.81	223173.0
2020-04-07 15:00:00	ES	Futures	2926.08	2962.58	2906.05	2908.52	378276.0
2020-04-07 16:00:00	ES	Futures	2908.52	2910.99	2892.05	2894.8	96247.0
2020-04-07 18:00:00	ES	Futures	2898.36	2901.38	2883.55	2891.5	16779.0
2020-04-07 19:00:00	ES	Futures	2891.78	2919.49	2889.03	2909.61	16089.0
2020-04-07 20:00:00	ES	Futures	2909.07	2912.08	2876.69	2882.17	30686.0
2020-04-07 21:00:00	ES	Futures	2881.62	2907.42	2878.33	2890.13	21703.0
2020-04-07 22:00:00	ES	Futures	2890.68	2907.42	2889.58	2891.5	14015.0
2020-04-07 23:00:00	ES	Futures	2891.5	2905.77	2887.94	2904.13	8687.0
2020-04-07 00:00:00	NQ	Futures	9097.08	9150.5	9090.8	9147.36	5215.0
2020-04-07 01:00:00	NQ	Futures	9146.78	9218.48	9135.64	9205.91	7705.0
2020-04-07 02:00:00	NQ	Futures	9207.05	9315.03	9194.2	9308.74	11531.0
2020-04-07 03:00:00	NQ	Futures	9308.17	9408.43	9273.61	9374.44	18400.0
2020-04-07 04:00:00	NQ	Futures	9373.3	9422.71	9359.02	9370.16	11916.0
2020-04-07 05:00:00	NQ	Futures	9371.3	9410.72	9363.59	9388.15	8515.0
2020-04-07 06:00:00	NQ	Futures	9386.44	9486.98	9382.44	9474.7	16076.0
2020-04-07 07:00:00	NQ	Futures	9473.84	9476.99	9411.57	9415.0	10958.0
2020-04-07 08:00:00	NQ	Futures	9415.86	9463.27	9406.15	9455.56	13201.0
2020-04-07 09:00:00	NQ	Futures	9454.99	9481.56	9369.87	9438.99	52163.0
2020-04-07 10:00:00	NQ	Futures	9438.99	9446.99	9221.91	9256.18	81469.0
2020-04-07 11:00:00	NQ	Futures	9256.47	9366.16	9227.34	9339.02	52194.0
2020-04-07 12:00:00	NQ	Futures	9339.59	9435.28	9336.74	9396.43	38484.0
2020-04-07 13:00:00	NQ	Futures	9397.29	9414.14	9324.45	9336.16	31462.0
2020-04-07 14:00:00	NQ	Futures	9335.31	9340.45	9196.2	9213.62	43854.0
2020-04-07 15:00:00	NQ	Futures	9214.77	9327.6	9176.21	9187.92	73462.0
2020-04-07 16:00:00	NQ	Futures	9187.92	9199.91	9129.07	9138.22	11301.0
2020-04-07 18:00:00	NQ	Futures	9157.64	9166.78	9117.65	9136.5	4034.0
2020-04-07 19:00:00	NQ	Futures	9136.5	9217.34	9129.93	9189.63	4040.0
2020-04-07 20:00:00	NQ	Futures	9187.92	9197.34	9087.09	9108.22	7994.0
2020-04-07 21:00:00	NQ	Futures	9108.51	9195.34	9098.23	9148.78	8146.0
2020-04-07 22:00:00	NQ	Futures	9149.36	9201.34	9147.36	9150.5	3882.0
2020-04-07 23:00:00	NQ	Futures	9151.07	9191.92	9140.5	9188.49	3900.0
2020-04-07 00:00:00	YM	Futures	24471.6	24626.0	24447.5	24618.4	2620.0
2020-04-07 01:00:00	YM	Futures	24619.5	24804.6	24581.1	24766.2	4013.0
2020-04-07 02:00:00	YM	Futures	24769.5	25154.0	24724.6	25141.9	8856.0
2020-04-07 03:00:00	YM	Futures	25139.7	25402.6	25054.3	25292.0	12943.0

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

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