PREVIEW / futures_1hour / 2020-06-11

all futures 1-hour files

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

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-06-11 00:00:00	ES	Futures	3462.56	3467.22	3455.7	3460.64	26606.0
2020-06-11 01:00:00	ES	Futures	3460.64	3462.56	3444.45	3447.74	35444.0
2020-06-11 02:00:00	ES	Futures	3447.74	3455.7	3443.35	3448.56	40644.0
2020-06-11 03:00:00	ES	Futures	3448.56	3449.94	3432.65	3433.2	63654.0
2020-06-11 04:00:00	ES	Futures	3433.2	3442.25	3424.69	3429.63	45020.0
2020-06-11 05:00:00	ES	Futures	3429.63	3452.68	3427.43	3450.76	44531.0
2020-06-11 06:00:00	ES	Futures	3450.76	3451.86	3433.75	3436.22	39880.0
2020-06-11 07:00:00	ES	Futures	3436.22	3439.51	3418.38	3425.79	63653.0
2020-06-11 08:00:00	ES	Futures	3425.79	3425.79	3400.82	3408.5	126202.0
2020-06-11 09:00:00	ES	Futures	3408.23	3422.77	3399.44	3417.56	309228.0
2020-06-11 10:00:00	ES	Futures	3417.83	3421.12	3387.64	3389.57	299164.0
2020-06-11 11:00:00	ES	Futures	3389.29	3394.78	3367.89	3377.22	321862.0
2020-06-11 12:00:00	ES	Futures	3377.22	3377.22	3330.29	3335.78	354034.0
2020-06-11 13:00:00	ES	Futures	3335.51	3353.34	3330.57	3340.99	269409.0
2020-06-11 14:00:00	ES	Futures	3340.72	3341.54	3300.11	3308.34	325673.0
2020-06-11 15:00:00	ES	Futures	3308.34	3320.41	3288.86	3297.09	558446.0
2020-06-11 16:00:00	ES	Futures	3297.09	3312.46	3293.79	3308.06	129462.0
2020-06-11 18:00:00	ES	Futures	3305.87	3321.24	3296.54	3320.41	22660.0
2020-06-11 19:00:00	ES	Futures	3320.69	3328.65	3311.63	3323.98	20635.0
2020-06-11 20:00:00	ES	Futures	3324.25	3330.29	3311.91	3318.77	31336.0
2020-06-11 21:00:00	ES	Futures	3318.22	3332.76	3305.87	3332.76	32337.0
2020-06-11 22:00:00	ES	Futures	3332.49	3343.19	3329.47	3336.05	25980.0
2020-06-11 23:00:00	ES	Futures	3336.05	3345.11	3329.74	3340.99	19621.0
2020-06-11 00:00:00	NQ	Futures	11455.33	11465.62	11427.05	11447.05	8999.0
2020-06-11 01:00:00	NQ	Futures	11446.76	11455.05	11405.06	11425.91	10809.0
2020-06-11 02:00:00	NQ	Futures	11426.77	11444.48	11400.49	11421.34	10905.0
2020-06-11 03:00:00	NQ	Futures	11422.2	11428.2	11363.07	11374.5	16845.0
2020-06-11 04:00:00	NQ	Futures	11375.35	11406.77	11339.08	11342.79	14062.0
2020-06-11 05:00:00	NQ	Futures	11343.36	11415.63	11336.79	11411.91	10217.0
2020-06-11 06:00:00	NQ	Futures	11412.2	11415.06	11358.79	11367.07	9676.0
2020-06-11 07:00:00	NQ	Futures	11367.35	11381.64	11329.65	11357.93	13728.0
2020-06-11 08:00:00	NQ	Futures	11358.79	11363.64	11306.51	11350.5	30690.0
2020-06-11 09:00:00	NQ	Futures	11349.93	11373.64	11283.95	11351.36	78950.0
2020-06-11 10:00:00	NQ	Futures	11351.07	11403.92	11297.66	11305.94	87118.0
2020-06-11 11:00:00	NQ	Futures	11305.66	11336.79	11252.24	11281.66	83928.0
2020-06-11 12:00:00	NQ	Futures	11281.38	11283.09	11087.14	11092.0	93449.0
2020-06-11 13:00:00	NQ	Futures	11091.14	11178.55	11084.0	11132.56	70274.0
2020-06-11 14:00:00	NQ	Futures	11132.27	11134.56	10988.31	11018.02	79946.0
2020-06-11 15:00:00	NQ	Futures	11017.73	11071.43	10950.89	10960.6	126791.0
2020-06-11 16:00:00	NQ	Futures	10960.6	11006.31	10952.89	10992.59	20710.0
2020-06-11 18:00:00	NQ	Futures	10986.88	11035.73	10964.32	11032.01	5992.0
2020-06-11 19:00:00	NQ	Futures	11032.87	11078.57	11004.88	11057.72	6807.0
2020-06-11 20:00:00	NQ	Futures	11058.58	11069.72	11009.73	11019.16	10442.0
2020-06-11 21:00:00	NQ	Futures	11018.3	11073.72	10972.03	11070.0	8760.0
2020-06-11 22:00:00	NQ	Futures	11070.86	11108.85	11058.58	11084.29	5959.0
2020-06-11 23:00:00	NQ	Futures	11083.43	11107.42	11060.58	11103.14	5134.0
2020-06-11 00:00:00	YM	Futures	29178.0	29205.5	29114.1	29138.4	143.0
2020-06-11 01:00:00	YM	Futures	29149.4	29169.2	29007.3	29031.6	148.0
2020-06-11 02:00:00	YM	Futures	29052.5	29092.1	28990.8	29023.8	235.0
2020-06-11 03:00:00	YM	Futures	29032.7	29033.8	28902.7	28902.7	295.0

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

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