PREVIEW / futures_1hour / 2020-03-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	2504.03	2524.34	2497.17	2520.77	15943.0
2020-03-24 01:00:00	ES	Futures	2520.77	2535.31	2500.74	2518.57	17728.0
2020-03-24 02:00:00	ES	Futures	2518.57	2555.89	2517.2	2545.74	31560.0
2020-03-24 03:00:00	ES	Futures	2546.02	2547.66	2529.28	2544.37	25333.0
2020-03-24 04:00:00	ES	Futures	2543.82	2559.74	2530.37	2550.68	44502.0
2020-03-24 05:00:00	ES	Futures	2550.41	2561.38	2545.19	2561.38	22366.0
2020-03-24 06:00:00	ES	Futures	2561.38	2561.38	2561.38	2561.38	409.0
2020-03-24 07:00:00	ES	Futures	2561.38	2561.38	2541.08	2553.97	57993.0
2020-03-24 08:00:00	ES	Futures	2554.52	2561.38	2525.43	2561.38	68997.0
2020-03-24 09:00:00	ES	Futures	2561.38	2610.23	2549.58	2580.59	228589.0
2020-03-24 10:00:00	ES	Futures	2580.59	2621.48	2569.62	2602.0	287650.0
2020-03-24 11:00:00	ES	Futures	2601.72	2636.3	2587.73	2635.75	237995.0
2020-03-24 12:00:00	ES	Futures	2635.75	2664.29	2626.69	2627.52	238588.0
2020-03-24 13:00:00	ES	Futures	2627.52	2638.77	2594.86	2600.35	197783.0
2020-03-24 14:00:00	ES	Futures	2600.08	2637.94	2575.65	2636.85	229240.0
2020-03-24 15:00:00	ES	Futures	2636.85	2675.81	2632.73	2670.6	488707.0
2020-03-24 16:00:00	ES	Futures	2670.6	2686.79	2653.31	2681.03	129960.0
2020-03-24 18:00:00	ES	Futures	2681.3	2711.21	2664.29	2696.67	44677.0
2020-03-24 19:00:00	ES	Futures	2696.39	2696.94	2648.1	2658.25	32684.0
2020-03-24 20:00:00	ES	Futures	2658.25	2668.95	2629.99	2642.88	34931.0
2020-03-24 21:00:00	ES	Futures	2642.88	2670.87	2642.06	2648.65	22824.0
2020-03-24 22:00:00	ES	Futures	2648.92	2655.51	2631.91	2648.37	19174.0
2020-03-24 23:00:00	ES	Futures	2648.65	2655.51	2632.18	2640.96	19391.0
2020-03-24 00:00:00	NQ	Futures	8172.75	8243.59	8149.04	8232.45	3771.0
2020-03-24 01:00:00	NQ	Futures	8233.59	8275.29	8152.47	8224.45	4890.0
2020-03-24 02:00:00	NQ	Futures	8223.59	8355.27	8223.59	8327.0	8676.0
2020-03-24 03:00:00	NQ	Futures	8326.71	8344.71	8275.58	8317.57	5450.0
2020-03-24 04:00:00	NQ	Futures	8315.86	8369.27	8278.72	8353.56	11547.0
2020-03-24 05:00:00	NQ	Futures	8352.99	8408.69	8332.99	8408.69	7738.0
2020-03-24 06:00:00	NQ	Futures	8408.69	8408.69	8408.69	8408.69	228.0
2020-03-24 07:00:00	NQ	Futures	8408.69	8408.69	8305.0	8334.99	12371.0
2020-03-24 08:00:00	NQ	Futures	8338.42	8404.4	8264.15	8387.55	21173.0
2020-03-24 09:00:00	NQ	Futures	8387.84	8495.52	8358.13	8381.84	52404.0
2020-03-24 10:00:00	NQ	Futures	8381.55	8523.23	8356.42	8433.83	71784.0
2020-03-24 11:00:00	NQ	Futures	8433.54	8529.52	8390.69	8516.38	44905.0
2020-03-24 12:00:00	NQ	Futures	8515.8	8602.35	8490.67	8493.81	41818.0
2020-03-24 13:00:00	NQ	Futures	8494.38	8522.09	8388.12	8399.83	52860.0
2020-03-24 14:00:00	NQ	Futures	8399.83	8533.51	8334.14	8530.37	67397.0
2020-03-24 15:00:00	NQ	Futures	8530.09	8608.64	8510.66	8604.92	81465.0
2020-03-24 16:00:00	NQ	Futures	8606.92	8651.77	8546.37	8630.06	17678.0
2020-03-24 18:00:00	NQ	Futures	8620.35	8722.32	8582.64	8668.34	8700.0
2020-03-24 19:00:00	NQ	Futures	8665.48	8668.62	8532.66	8566.93	7489.0
2020-03-24 20:00:00	NQ	Futures	8563.79	8601.78	8474.39	8510.38	7873.0
2020-03-24 21:00:00	NQ	Futures	8507.81	8601.21	8507.81	8534.94	6008.0
2020-03-24 22:00:00	NQ	Futures	8537.23	8561.22	8476.1	8525.52	4846.0
2020-03-24 23:00:00	NQ	Futures	8528.37	8547.8	8468.67	8495.24	4861.0
2020-03-24 00:00:00	YM	Futures	20796.8	20968.8	20728.9	20941.4	2834.0
2020-03-24 01:00:00	YM	Futures	20942.5	21050.9	20763.9	20914.0	3642.0
2020-03-24 02:00:00	YM	Futures	20919.5	21218.5	20898.7	21137.4	5164.0
2020-03-24 03:00:00	YM	Futures	21129.8	21168.1	21008.2	21134.2	4469.0

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

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