PREVIEW / futures_1hour / 2020-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-31.parquet
  size:    63 KB
  rows:    1,854

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-31 00:00:00	ES	Futures	2872.02	2872.29	2848.42	2857.48	15891.0
2020-03-31 01:00:00	ES	Futures	2857.48	2871.47	2848.42	2862.96	18214.0
2020-03-31 02:00:00	ES	Futures	2862.96	2883.55	2851.44	2883.0	22492.0
2020-03-31 03:00:00	ES	Futures	2882.72	2891.5	2870.37	2881.35	44112.0
2020-03-31 04:00:00	ES	Futures	2881.08	2893.15	2877.78	2887.39	26277.0
2020-03-31 05:00:00	ES	Futures	2887.39	2891.78	2876.41	2882.72	16383.0
2020-03-31 06:00:00	ES	Futures	2882.72	2883.82	2861.59	2863.51	25610.0
2020-03-31 07:00:00	ES	Futures	2863.79	2865.43	2849.52	2855.28	33653.0
2020-03-31 08:00:00	ES	Futures	2855.56	2856.38	2823.72	2844.03	71075.0
2020-03-31 09:00:00	ES	Futures	2843.76	2860.49	2830.58	2840.46	187626.0
2020-03-31 10:00:00	ES	Futures	2840.46	2885.74	2840.19	2869.55	248014.0
2020-03-31 11:00:00	ES	Futures	2869.55	2886.29	2860.22	2877.78	193379.0
2020-03-31 12:00:00	ES	Futures	2877.51	2879.7	2833.05	2842.66	203348.0
2020-03-31 13:00:00	ES	Futures	2842.66	2853.36	2826.74	2850.89	175780.0
2020-03-31 14:00:00	ES	Futures	2851.16	2856.93	2836.07	2847.87	151666.0
2020-03-31 15:00:00	ES	Futures	2847.87	2855.28	2808.36	2824.0	515565.0
2020-03-31 16:00:00	ES	Futures	2823.72	2825.37	2805.34	2813.3	102382.0
2020-03-31 18:00:00	ES	Futures	2812.2	2812.47	2784.21	2794.36	24768.0
2020-03-31 19:00:00	ES	Futures	2794.36	2798.75	2785.31	2786.95	13090.0
2020-03-31 20:00:00	ES	Futures	2786.95	2796.01	2777.35	2794.36	18585.0
2020-03-31 21:00:00	ES	Futures	2794.09	2794.36	2780.09	2789.97	16130.0
2020-03-31 22:00:00	ES	Futures	2789.42	2793.26	2782.84	2786.13	8804.0
2020-03-31 23:00:00	ES	Futures	2785.85	2786.95	2773.78	2774.6	8903.0
2020-03-31 00:00:00	NQ	Futures	9003.96	9003.96	8929.13	8954.55	4459.0
2020-03-31 01:00:00	NQ	Futures	8953.41	8997.68	8925.7	8971.97	4873.0
2020-03-31 02:00:00	NQ	Futures	8971.4	9031.39	8937.98	9030.81	5600.0
2020-03-31 03:00:00	NQ	Futures	9030.24	9073.95	9009.11	9046.52	11838.0
2020-03-31 04:00:00	NQ	Futures	9045.95	9081.66	9038.81	9068.23	8152.0
2020-03-31 05:00:00	NQ	Futures	9069.09	9091.37	9043.95	9059.38	5935.0
2020-03-31 06:00:00	NQ	Futures	9060.52	9063.66	8985.97	8994.54	9237.0
2020-03-31 07:00:00	NQ	Futures	8995.11	9000.54	8959.12	8982.83	8714.0
2020-03-31 08:00:00	NQ	Futures	8983.11	8987.11	8871.14	8918.84	20988.0
2020-03-31 09:00:00	NQ	Futures	8919.13	8997.39	8908.56	8938.84	42396.0
2020-03-31 10:00:00	NQ	Futures	8938.27	9134.79	8933.7	9065.66	58693.0
2020-03-31 11:00:00	NQ	Futures	9067.09	9105.65	9033.96	9062.81	43522.0
2020-03-31 12:00:00	NQ	Futures	9062.52	9071.95	8929.41	8963.4	40353.0
2020-03-31 13:00:00	NQ	Futures	8963.4	9017.67	8924.56	9008.53	35686.0
2020-03-31 14:00:00	NQ	Futures	9007.96	9014.82	8957.4	8978.54	28232.0
2020-03-31 15:00:00	NQ	Futures	8978.26	9000.82	8852.0	8908.85	59158.0
2020-03-31 16:00:00	NQ	Futures	8909.7	8916.56	8862.0	8891.14	10358.0
2020-03-31 18:00:00	NQ	Futures	8880.57	8881.71	8805.73	8834.01	5461.0
2020-03-31 19:00:00	NQ	Futures	8833.44	8847.15	8803.44	8812.01	3391.0
2020-03-31 20:00:00	NQ	Futures	8810.01	8848.86	8783.45	8841.43	4593.0
2020-03-31 21:00:00	NQ	Futures	8842.86	8844.01	8797.73	8832.58	4869.0
2020-03-31 22:00:00	NQ	Futures	8830.29	8844.86	8812.59	8824.3	2855.0
2020-03-31 23:00:00	NQ	Futures	8823.15	8826.01	8786.59	8789.45	1999.0
2020-03-31 00:00:00	YM	Futures	24320.4	24320.4	24089.3	24173.7	2150.0
2020-03-31 01:00:00	YM	Futures	24173.7	24300.7	24093.7	24222.9	2061.0
2020-03-31 02:00:00	YM	Futures	24212.0	24401.5	24122.2	24401.5	2381.0
2020-03-31 03:00:00	YM	Futures	24394.9	24495.7	24302.9	24393.8	6247.0

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

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