PREVIEW / futures_1hour / 2020-04-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	3048.19	3059.99	3047.1	3056.43	12750.0
2020-04-23 01:00:00	ES	Futures	3056.43	3067.95	3055.6	3060.54	12752.0
2020-04-23 02:00:00	ES	Futures	3060.82	3079.75	3055.6	3073.44	17136.0
2020-04-23 03:00:00	ES	Futures	3073.71	3074.54	3049.29	3051.49	28151.0
2020-04-23 04:00:00	ES	Futures	3051.49	3062.74	3048.47	3055.6	22231.0
2020-04-23 05:00:00	ES	Futures	3055.6	3070.7	3054.51	3069.6	15498.0
2020-04-23 06:00:00	ES	Futures	3069.87	3070.15	3055.88	3056.43	14367.0
2020-04-23 07:00:00	ES	Futures	3056.43	3064.66	3055.88	3061.91	13440.0
2020-04-23 08:00:00	ES	Futures	3062.19	3080.58	3055.88	3079.2	49375.0
2020-04-23 09:00:00	ES	Futures	3079.48	3096.49	3072.07	3087.16	161850.0
2020-04-23 10:00:00	ES	Futures	3086.89	3113.78	3081.67	3106.64	199014.0
2020-04-23 11:00:00	ES	Futures	3106.92	3108.29	3090.45	3095.94	142393.0
2020-04-23 12:00:00	ES	Futures	3096.22	3105.27	3058.07	3081.95	265535.0
2020-04-23 13:00:00	ES	Futures	3082.22	3092.65	3060.27	3069.32	204233.0
2020-04-23 14:00:00	ES	Futures	3069.05	3087.71	3056.98	3085.24	139802.0
2020-04-23 15:00:00	ES	Futures	3085.24	3086.61	3059.45	3060.27	227483.0
2020-04-23 16:00:00	ES	Futures	3059.99	3060.27	3050.39	3053.41	66117.0
2020-04-23 18:00:00	ES	Futures	3048.19	3054.23	3034.2	3040.24	18208.0
2020-04-23 19:00:00	ES	Futures	3040.51	3043.25	3035.57	3040.51	8308.0
2020-04-23 20:00:00	ES	Futures	3040.78	3044.63	3026.24	3031.18	16508.0
2020-04-23 21:00:00	ES	Futures	3031.45	3036.94	3024.32	3027.89	15275.0
2020-04-23 22:00:00	ES	Futures	3027.34	3039.69	3026.24	3035.85	8497.0
2020-04-23 23:00:00	ES	Futures	3035.85	3039.69	3033.65	3036.12	4613.0
2020-04-23 00:00:00	NQ	Futures	9818.04	9854.6	9814.61	9843.75	3772.0
2020-04-23 01:00:00	NQ	Futures	9844.03	9877.74	9842.32	9857.74	4815.0
2020-04-23 02:00:00	NQ	Futures	9859.74	9914.59	9840.03	9900.02	6829.0
2020-04-23 03:00:00	NQ	Futures	9899.45	9904.02	9827.18	9830.32	11066.0
2020-04-23 04:00:00	NQ	Futures	9830.32	9859.74	9820.33	9843.46	7437.0
2020-04-23 05:00:00	NQ	Futures	9843.18	9892.88	9838.61	9890.31	5660.0
2020-04-23 06:00:00	NQ	Futures	9890.59	9891.16	9842.89	9849.75	5295.0
2020-04-23 07:00:00	NQ	Futures	9850.03	9883.45	9848.89	9877.74	5600.0
2020-04-23 08:00:00	NQ	Futures	9877.74	9936.3	9856.03	9934.58	14185.0
2020-04-23 09:00:00	NQ	Futures	9934.01	9989.71	9896.88	9966.57	44079.0
2020-04-23 10:00:00	NQ	Futures	9966.29	10039.13	9950.86	10018.27	50733.0
2020-04-23 11:00:00	NQ	Futures	10018.27	10020.27	9960.0	9972.0	35113.0
2020-04-23 12:00:00	NQ	Futures	9972.86	10013.42	9840.03	9942.87	62892.0
2020-04-23 13:00:00	NQ	Futures	9944.29	9979.43	9844.6	9872.31	52021.0
2020-04-23 14:00:00	NQ	Futures	9872.03	9949.15	9834.61	9941.72	38526.0
2020-04-23 15:00:00	NQ	Futures	9940.87	9945.15	9850.03	9857.74	43579.0
2020-04-23 16:00:00	NQ	Futures	9857.74	9858.89	9814.61	9826.89	12232.0
2020-04-23 18:00:00	NQ	Futures	9812.61	9817.18	9748.34	9770.34	5762.0
2020-04-23 19:00:00	NQ	Futures	9768.62	9780.05	9756.06	9771.77	2595.0
2020-04-23 20:00:00	NQ	Futures	9772.62	9786.62	9725.78	9743.2	6145.0
2020-04-23 21:00:00	NQ	Futures	9743.77	9758.91	9709.78	9732.35	5745.0
2020-04-23 22:00:00	NQ	Futures	9731.49	9774.34	9728.35	9761.48	3608.0
2020-04-23 23:00:00	NQ	Futures	9761.2	9772.62	9749.77	9752.63	1977.0
2020-04-23 00:00:00	YM	Futures	25480.4	25570.2	25472.7	25552.7	2435.0
2020-04-23 01:00:00	YM	Futures	25552.7	25651.2	25546.1	25584.4	3246.0
2020-04-23 02:00:00	YM	Futures	25587.7	25734.5	25540.6	25684.1	4452.0
2020-04-23 03:00:00	YM	Futures	25687.4	25687.4	25481.5	25501.2	7022.0

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

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