PREVIEW / futures_1hour / 2020-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-15.parquet
  size:    62 KB
  rows:    1,847

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-15 00:00:00	ES	Futures	3103.63	3111.58	3100.33	3107.47	6141.0
2020-04-15 01:00:00	ES	Futures	3107.19	3111.31	3095.12	3099.24	8921.0
2020-04-15 02:00:00	ES	Futures	3099.51	3109.66	3095.39	3099.78	19056.0
2020-04-15 03:00:00	ES	Futures	3100.06	3104.72	3073.44	3073.99	43055.0
2020-04-15 04:00:00	ES	Futures	3073.99	3082.5	3062.46	3067.13	36964.0
2020-04-15 05:00:00	ES	Futures	3067.4	3068.23	3058.62	3066.31	39277.0
2020-04-15 06:00:00	ES	Futures	3066.58	3072.89	3054.23	3064.38	38425.0
2020-04-15 07:00:00	ES	Futures	3064.38	3072.62	3062.19	3063.29	30470.0
2020-04-15 08:00:00	ES	Futures	3063.29	3066.85	3025.14	3028.44	93313.0
2020-04-15 09:00:00	ES	Futures	3028.71	3053.41	3023.5	3041.33	226089.0
2020-04-15 10:00:00	ES	Futures	3041.61	3043.53	3019.93	3034.75	229911.0
2020-04-15 11:00:00	ES	Futures	3035.02	3040.24	3021.3	3027.61	159330.0
2020-04-15 12:00:00	ES	Futures	3027.61	3046.82	3023.22	3041.33	130787.0
2020-04-15 13:00:00	ES	Futures	3041.33	3056.43	3037.49	3039.14	141277.0
2020-04-15 14:00:00	ES	Futures	3039.14	3063.84	3039.14	3063.01	157333.0
2020-04-15 15:00:00	ES	Futures	3063.29	3065.48	3038.59	3046.0	288431.0
2020-04-15 16:00:00	ES	Futures	3046.0	3049.29	3035.85	3039.14	52757.0
2020-04-15 18:00:00	ES	Futures	3038.04	3043.8	3021.85	3025.69	16749.0
2020-04-15 19:00:00	ES	Futures	3025.69	3027.06	3019.11	3022.67	10432.0
2020-04-15 20:00:00	ES	Futures	3022.67	3038.86	3014.17	3023.22	26780.0
2020-04-15 21:00:00	ES	Futures	3023.5	3036.94	3021.58	3025.69	19158.0
2020-04-15 22:00:00	ES	Futures	3025.42	3034.47	3021.3	3023.5	11809.0
2020-04-15 23:00:00	ES	Futures	3023.77	3031.73	3017.19	3029.26	12252.0
2020-04-15 00:00:00	NQ	Futures	9889.45	9919.44	9877.17	9904.59	3480.0
2020-04-15 01:00:00	NQ	Futures	9904.59	9915.73	9862.6	9868.6	4852.0
2020-04-15 02:00:00	NQ	Futures	9868.88	9904.02	9856.89	9887.45	7034.0
2020-04-15 03:00:00	NQ	Futures	9887.45	9910.59	9811.76	9817.18	15598.0
2020-04-15 04:00:00	NQ	Futures	9818.04	9845.18	9788.62	9807.19	11380.0
2020-04-15 05:00:00	NQ	Futures	9807.76	9811.18	9775.19	9804.61	9108.0
2020-04-15 06:00:00	NQ	Futures	9803.76	9820.9	9780.34	9812.04	8187.0
2020-04-15 07:00:00	NQ	Futures	9812.04	9846.89	9810.04	9819.47	9255.0
2020-04-15 08:00:00	NQ	Futures	9820.04	9826.61	9718.64	9729.78	20646.0
2020-04-15 09:00:00	NQ	Futures	9730.06	9788.33	9696.36	9733.49	52606.0
2020-04-15 10:00:00	NQ	Futures	9733.78	9806.33	9712.35	9793.47	54172.0
2020-04-15 11:00:00	NQ	Futures	9793.47	9805.47	9732.35	9744.06	40666.0
2020-04-15 12:00:00	NQ	Futures	9744.34	9811.47	9737.49	9791.76	29714.0
2020-04-15 13:00:00	NQ	Futures	9791.76	9820.33	9778.62	9794.62	25387.0
2020-04-15 14:00:00	NQ	Futures	9794.62	9880.88	9794.33	9880.02	33086.0
2020-04-15 15:00:00	NQ	Futures	9879.74	9890.31	9787.76	9804.9	46021.0
2020-04-15 16:00:00	NQ	Futures	9805.47	9825.18	9790.33	9799.19	8060.0
2020-04-15 18:00:00	NQ	Futures	9798.62	9815.18	9742.92	9758.34	4409.0
2020-04-15 19:00:00	NQ	Futures	9758.34	9758.34	9729.49	9749.49	2982.0
2020-04-15 20:00:00	NQ	Futures	9748.92	9790.62	9712.35	9741.77	7915.0
2020-04-15 21:00:00	NQ	Futures	9742.63	9790.62	9740.06	9757.48	6529.0
2020-04-15 22:00:00	NQ	Futures	9757.2	9786.91	9744.92	9752.91	5399.0
2020-04-15 23:00:00	NQ	Futures	9753.77	9765.48	9728.35	9756.34	4448.0
2020-04-15 00:00:00	YM	Futures	26021.5	26078.4	25989.7	26044.5	1917.0
2020-04-15 01:00:00	YM	Futures	26043.4	26076.2	25953.5	25991.9	3103.0
2020-04-15 02:00:00	YM	Futures	25991.9	26057.6	25939.3	25985.3	4161.0
2020-04-15 03:00:00	YM	Futures	25985.3	26026.9	25769.5	25775.0	8157.0

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

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