PREVIEW / futures_1hour / 2020-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-25.parquet
  size:    64 KB
  rows:    1,864

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-25 00:00:00	ES	Futures	2641.51	2675.27	2619.01	2665.11	24989.0
2020-03-25 01:00:00	ES	Futures	2665.39	2682.67	2624.22	2680.2	38322.0
2020-03-25 02:00:00	ES	Futures	2680.75	2692.83	2651.39	2685.14	26840.0
2020-03-25 03:00:00	ES	Futures	2685.42	2709.02	2679.38	2708.74	36379.0
2020-03-25 04:00:00	ES	Futures	2708.74	2728.5	2687.61	2723.56	67319.0
2020-03-25 05:00:00	ES	Futures	2723.56	2741.95	2710.12	2717.8	56094.0
2020-03-25 06:00:00	ES	Futures	2718.07	2719.45	2635.75	2637.4	82772.0
2020-03-25 07:00:00	ES	Futures	2637.4	2664.56	2620.11	2644.53	94065.0
2020-03-25 08:00:00	ES	Futures	2644.81	2666.21	2638.22	2664.84	74177.0
2020-03-25 09:00:00	ES	Futures	2664.56	2728.78	2653.86	2657.15	320284.0
2020-03-25 10:00:00	ES	Futures	2656.88	2693.38	2627.24	2689.53	289212.0
2020-03-25 11:00:00	ES	Futures	2689.53	2705.18	2677.73	2693.93	195739.0
2020-03-25 12:00:00	ES	Futures	2693.93	2764.72	2692.83	2749.08	283605.0
2020-03-25 13:00:00	ES	Futures	2749.36	2810.83	2745.52	2785.03	255992.0
2020-03-25 14:00:00	ES	Futures	2785.03	2796.56	2751.55	2789.42	286621.0
2020-03-25 15:00:00	ES	Futures	2789.15	2801.77	2693.93	2707.37	492258.0
2020-03-25 16:00:00	ES	Futures	2707.37	2724.66	2698.86	2708.19	125319.0
2020-03-25 18:00:00	ES	Futures	2712.31	2732.89	2701.06	2714.51	22661.0
2020-03-25 19:00:00	ES	Futures	2714.78	2714.78	2694.47	2709.57	16755.0
2020-03-25 20:00:00	ES	Futures	2709.57	2741.4	2701.61	2713.96	28975.0
2020-03-25 21:00:00	ES	Futures	2714.23	2714.78	2676.64	2682.13	34469.0
2020-03-25 22:00:00	ES	Futures	2682.4	2699.41	2667.86	2692.55	24159.0
2020-03-25 23:00:00	ES	Futures	2692.55	2712.31	2669.5	2694.2	26199.0
2020-03-25 00:00:00	NQ	Futures	8492.95	8589.5	8428.68	8558.94	6309.0
2020-03-25 01:00:00	NQ	Futures	8560.08	8633.77	8435.25	8627.78	12716.0
2020-03-25 02:00:00	NQ	Futures	8628.63	8657.77	8540.66	8627.49	7928.0
2020-03-25 03:00:00	NQ	Futures	8626.06	8740.6	8608.35	8738.32	8585.0
2020-03-25 04:00:00	NQ	Futures	8740.03	8810.59	8677.76	8795.73	12022.0
2020-03-25 05:00:00	NQ	Futures	8797.45	8864.0	8752.31	8774.31	13887.0
2020-03-25 06:00:00	NQ	Futures	8773.45	8776.31	8504.95	8509.52	17226.0
2020-03-25 07:00:00	NQ	Futures	8509.52	8606.35	8474.96	8540.94	19902.0
2020-03-25 08:00:00	NQ	Futures	8542.37	8609.78	8516.95	8594.36	14756.0
2020-03-25 09:00:00	NQ	Futures	8594.36	8756.89	8529.23	8537.8	68194.0
2020-03-25 10:00:00	NQ	Futures	8537.51	8589.21	8422.4	8577.5	94399.0
2020-03-25 11:00:00	NQ	Futures	8577.79	8610.64	8526.66	8566.93	67535.0
2020-03-25 12:00:00	NQ	Futures	8566.08	8725.18	8561.79	8684.9	65003.0
2020-03-25 13:00:00	NQ	Futures	8685.19	8867.43	8675.48	8789.45	57253.0
2020-03-25 14:00:00	NQ	Futures	8790.02	8802.02	8692.62	8777.74	59920.0
2020-03-25 15:00:00	NQ	Futures	8777.17	8811.73	8490.38	8527.23	66898.0
2020-03-25 16:00:00	NQ	Futures	8523.8	8566.93	8506.09	8544.08	16368.0
2020-03-25 18:00:00	NQ	Futures	8550.37	8618.64	8526.37	8556.65	5511.0
2020-03-25 19:00:00	NQ	Futures	8559.51	8559.51	8492.1	8545.51	5033.0
2020-03-25 20:00:00	NQ	Futures	8544.08	8625.78	8512.38	8549.22	7525.0
2020-03-25 21:00:00	NQ	Futures	8552.08	8553.22	8428.68	8466.39	8780.0
2020-03-25 22:00:00	NQ	Futures	8466.67	8500.67	8404.69	8489.81	6935.0
2020-03-25 23:00:00	NQ	Futures	8489.24	8546.08	8428.97	8506.95	6874.0
2020-03-25 00:00:00	YM	Futures	22394.9	22692.8	22211.9	22607.4	2967.0
2020-03-25 01:00:00	YM	Futures	22610.6	22771.7	22247.0	22758.5	7080.0
2020-03-25 02:00:00	YM	Futures	22761.8	22864.8	22536.2	22802.3	3601.0
2020-03-25 03:00:00	YM	Futures	22806.7	23179.1	22744.3	23122.2	7182.0

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

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