PREVIEW / futures_1hour / 2020-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-11.parquet
  size:    61 KB
  rows:    1,764

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-03-11 00:00:00	ES	Futures	3047.29	3047.83	3035.09	3036.72	16664.0
2020-03-11 01:00:00	ES	Futures	3036.99	3037.26	3011.79	3018.02	21489.0
2020-03-11 02:00:00	ES	Futures	3018.02	3045.39	3011.24	3017.48	25006.0
2020-03-11 03:00:00	ES	Futures	3017.21	3047.56	3016.93	3046.2	32240.0
2020-03-11 04:00:00	ES	Futures	3045.66	3075.2	3022.35	3063.54	68677.0
2020-03-11 05:00:00	ES	Futures	3063.54	3065.98	3036.17	3049.45	29574.0
2020-03-11 06:00:00	ES	Futures	3049.18	3058.67	3027.5	3045.12	38320.0
2020-03-11 07:00:00	ES	Futures	3045.66	3048.64	3013.68	3027.77	52959.0
2020-03-11 08:00:00	ES	Futures	3027.77	3037.26	2996.34	2998.24	78933.0
2020-03-11 09:00:00	ES	Futures	2997.69	3050.81	2996.61	3034.28	255760.0
2020-03-11 10:00:00	ES	Futures	3034.28	3045.12	2999.05	3012.87	282556.0
2020-03-11 11:00:00	ES	Futures	3013.14	3022.9	2987.4	3006.64	261230.0
2020-03-11 12:00:00	ES	Futures	3006.64	3036.99	2979.81	2990.65	287004.0
2020-03-11 13:00:00	ES	Futures	2990.65	2996.88	2971.14	2984.96	210735.0
2020-03-11 14:00:00	ES	Futures	2984.96	2990.11	2956.23	2960.03	248132.0
2020-03-11 15:00:00	ES	Futures	2960.3	2989.02	2929.68	2967.89	508196.0
2020-03-11 16:00:00	ES	Futures	2967.89	2980.89	2962.47	2971.14	119566.0
2020-03-11 18:00:00	ES	Futures	2967.89	3006.91	2964.09	2999.32	41288.0
2020-03-11 19:00:00	ES	Futures	2999.32	2999.59	2956.23	2962.19	37258.0
2020-03-11 20:00:00	ES	Futures	2962.19	2972.76	2940.79	2958.67	37516.0
2020-03-11 21:00:00	ES	Futures	2959.21	2964.63	2845.4	2845.94	168208.0
2020-03-11 22:00:00	ES	Futures	2845.67	2870.33	2826.16	2847.84	101767.0
2020-03-11 23:00:00	ES	Futures	2848.11	2857.05	2832.39	2837.0	31431.0
2020-03-11 00:00:00	NQ	Futures	9459.44	9465.8	9423.29	9429.07	4816.0
2020-03-11 01:00:00	NQ	Futures	9430.52	9430.52	9351.86	9369.79	9305.0
2020-03-11 02:00:00	NQ	Futures	9370.08	9440.93	9353.02	9374.71	11207.0
2020-03-11 03:00:00	NQ	Futures	9374.42	9458.28	9372.39	9453.36	15857.0
2020-03-11 04:00:00	NQ	Futures	9453.36	9539.25	9374.71	9505.99	23252.0
2020-03-11 05:00:00	NQ	Futures	9506.86	9515.82	9427.34	9468.4	10823.0
2020-03-11 06:00:00	NQ	Futures	9468.98	9491.82	9398.42	9459.44	10409.0
2020-03-11 07:00:00	NQ	Futures	9461.46	9475.34	9374.42	9412.3	12990.0
2020-03-11 08:00:00	NQ	Futures	9412.88	9441.8	9335.67	9343.48	22516.0
2020-03-11 09:00:00	NQ	Futures	9343.19	9504.26	9339.72	9461.46	105631.0
2020-03-11 10:00:00	NQ	Futures	9460.59	9510.62	9354.18	9388.01	127628.0
2020-03-11 11:00:00	NQ	Futures	9388.3	9415.48	9326.99	9369.79	106961.0
2020-03-11 12:00:00	NQ	Futures	9369.79	9457.7	9291.72	9319.48	95252.0
2020-03-11 13:00:00	NQ	Futures	9318.32	9332.2	9260.2	9299.23	82485.0
2020-03-11 14:00:00	NQ	Futures	9299.23	9315.72	9210.17	9228.68	103523.0
2020-03-11 15:00:00	NQ	Futures	9228.96	9332.78	9129.49	9251.52	155446.0
2020-03-11 16:00:00	NQ	Futures	9252.1	9293.45	9232.72	9259.33	15301.0
2020-03-11 18:00:00	NQ	Futures	9252.1	9378.47	9236.48	9357.65	14836.0
2020-03-11 19:00:00	NQ	Futures	9357.36	9359.09	9230.7	9247.76	14294.0
2020-03-11 20:00:00	NQ	Futures	9248.05	9275.52	9167.08	9236.19	14532.0
2020-03-11 21:00:00	NQ	Futures	9234.75	9251.23	8817.18	8817.18	39386.0
2020-03-11 22:00:00	NQ	Futures	8816.89	8929.67	8792.6	8859.4	23166.0
2020-03-11 23:00:00	NQ	Futures	8861.43	8891.21	8816.31	8833.95	7997.0
2020-03-11 00:00:00	YM	Futures	26589.9	26596.5	26502.3	26502.3	25.0
2020-03-11 01:00:00	YM	Futures	26453.0	26453.0	26287.6	26319.4	54.0
2020-03-11 02:00:00	YM	Futures	26505.6	26559.3	26315.0	26353.3	34.0
2020-03-11 03:00:00	YM	Futures	26478.2	26591.0	26362.1	26561.4	42.0

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

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