PREVIEW / futures_1hour / 2020-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-13.parquet
  size:    55 KB
  rows:    1,504

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-13 00:00:00	ES	Futures	2600.96	2712.07	2598.25	2708.82	43987.0
2020-03-13 01:00:00	ES	Futures	2709.09	2780.36	2705.02	2733.21	52945.0
2020-03-13 02:00:00	ES	Futures	2734.56	2743.51	2687.41	2736.73	25681.0
2020-03-13 03:00:00	ES	Futures	2736.73	2809.63	2719.39	2788.49	41659.0
2020-03-13 04:00:00	ES	Futures	2787.95	2810.71	2737.0	2749.74	43799.0
2020-03-13 05:00:00	ES	Futures	2748.93	2794.18	2734.83	2792.55	31425.0
2020-03-13 06:00:00	ES	Futures	2792.83	2799.33	2773.31	2794.45	31350.0
2020-03-13 07:00:00	ES	Futures	2794.45	2812.88	2793.1	2812.88	12769.0
2020-03-13 08:00:00	ES	Futures	2812.88	2812.88	2812.88	2812.88	1182.0
2020-03-13 09:00:00	ES	Futures	2812.88	2857.32	2760.31	2773.86	216318.0
2020-03-13 10:00:00	ES	Futures	2773.31	2828.05	2747.84	2749.47	235430.0
2020-03-13 11:00:00	ES	Futures	2749.47	2779.0	2697.71	2734.02	241794.0
2020-03-13 12:00:00	ES	Futures	2734.02	2785.78	2710.99	2760.04	191111.0
2020-03-13 13:00:00	ES	Futures	2760.04	2812.61	2745.67	2803.94	152539.0
2020-03-13 14:00:00	ES	Futures	2803.94	2804.75	2742.42	2778.46	161644.0
2020-03-13 15:00:00	ES	Futures	2777.92	2933.2	2737.0	2930.76	396911.0
2020-03-13 16:00:00	ES	Futures	2930.49	2935.1	2879.0	2888.49	177785.0
2020-03-13 00:00:00	NQ	Futures	8043.64	8415.23	8037.57	8414.65	16161.0
2020-03-13 01:00:00	NQ	Futures	8413.5	8661.32	8402.22	8521.07	20343.0
2020-03-13 02:00:00	NQ	Futures	8522.51	8567.34	8405.69	8546.81	9422.0
2020-03-13 03:00:00	NQ	Futures	8544.78	8796.65	8492.44	8722.33	14893.0
2020-03-13 04:00:00	NQ	Futures	8719.73	8802.43	8560.69	8613.03	15380.0
2020-03-13 05:00:00	NQ	Futures	8608.4	8746.33	8557.5	8738.82	8898.0
2020-03-13 06:00:00	NQ	Futures	8741.71	8781.04	8685.61	8757.32	11032.0
2020-03-13 07:00:00	NQ	Futures	8756.17	8817.18	8751.83	8817.18	6345.0
2020-03-13 08:00:00	NQ	Futures	8817.18	8817.18	8817.18	8817.18	52.0
2020-03-13 09:00:00	NQ	Futures	8817.18	8948.18	8635.87	8689.95	47642.0
2020-03-13 10:00:00	NQ	Futures	8689.95	8840.03	8610.13	8612.16	51921.0
2020-03-13 11:00:00	NQ	Futures	8612.74	8704.12	8434.9	8567.63	60386.0
2020-03-13 12:00:00	NQ	Futures	8566.47	8732.74	8482.9	8638.47	43211.0
2020-03-13 13:00:00	NQ	Futures	8639.92	8787.98	8600.01	8757.32	27797.0
2020-03-13 14:00:00	NQ	Futures	8758.48	8759.35	8562.42	8673.17	29335.0
2020-03-13 15:00:00	NQ	Futures	8670.86	9214.22	8539.29	9186.17	61471.0
2020-03-13 16:00:00	NQ	Futures	9190.79	9228.1	9026.25	9048.81	30438.0
2020-03-13 00:00:00	YM	Futures	22221.8	23212.0	22197.7	23176.9	2608.0
2020-03-13 01:00:00	YM	Futures	23178.0	23813.3	23155.0	23330.3	4088.0
2020-03-13 02:00:00	YM	Futures	23318.2	23438.7	22930.5	23406.9	1996.0
2020-03-13 03:00:00	YM	Futures	23396.0	24036.7	23230.6	23818.8	3505.0
2020-03-13 04:00:00	YM	Futures	23839.6	24045.5	23390.5	23507.7	2947.0
2020-03-13 05:00:00	YM	Futures	23488.0	23950.2	23388.3	23937.1	1809.0
2020-03-13 06:00:00	YM	Futures	23933.8	23967.7	23755.2	23920.6	1490.0
2020-03-13 07:00:00	YM	Futures	23908.6	24156.1	23885.6	24156.1	649.0
2020-03-13 08:00:00	YM	Futures	24156.1	24156.1	24156.1	24156.1	11.0
2020-03-13 09:00:00	YM	Futures	24156.1	24518.7	23553.7	23675.3	16884.0
2020-03-13 10:00:00	YM	Futures	23676.4	24175.8	23513.2	23538.4	27135.0
2020-03-13 11:00:00	YM	Futures	23536.2	23859.3	23118.9	23459.5	31413.0
2020-03-13 12:00:00	YM	Futures	23455.1	23904.2	23263.4	23684.1	25547.0
2020-03-13 13:00:00	YM	Futures	23683.0	24183.5	23585.5	24116.7	18048.0
2020-03-13 14:00:00	YM	Futures	24120.0	24122.2	23573.4	23885.6	16864.0
2020-03-13 15:00:00	YM	Futures	23890.0	25191.2	23526.3	25189.0	26171.0

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

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