PREVIEW / futures_1hour / 2021-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-02.parquet
  size:    60 KB
  rows:    1,914

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
2021-06-02 00:00:00	ES	Futures	4719.16	4719.44	4716.35	4717.19	2494.0
2021-06-02 01:00:00	ES	Futures	4717.19	4721.41	4716.63	4718.6	3455.0
2021-06-02 02:00:00	ES	Futures	4718.6	4718.88	4714.67	4717.76	6172.0
2021-06-02 03:00:00	ES	Futures	4717.76	4723.66	4710.73	4715.51	19727.0
2021-06-02 04:00:00	ES	Futures	4715.51	4720.0	4712.7	4714.1	11912.0
2021-06-02 05:00:00	ES	Futures	4714.1	4720.0	4714.1	4719.44	7834.0
2021-06-02 06:00:00	ES	Futures	4719.44	4721.41	4716.91	4721.13	7472.0
2021-06-02 07:00:00	ES	Futures	4721.41	4722.53	4717.19	4721.13	13501.0
2021-06-02 08:00:00	ES	Futures	4721.13	4728.71	4720.28	4728.43	24264.0
2021-06-02 09:00:00	ES	Futures	4728.43	4730.96	4718.04	4727.59	150169.0
2021-06-02 10:00:00	ES	Futures	4727.87	4734.33	4725.62	4730.96	135955.0
2021-06-02 11:00:00	ES	Futures	4731.24	4737.14	4728.71	4732.65	107191.0
2021-06-02 12:00:00	ES	Futures	4732.93	4733.49	4724.5	4728.15	84025.0
2021-06-02 13:00:00	ES	Futures	4727.87	4729.28	4718.32	4720.85	109831.0
2021-06-02 14:00:00	ES	Futures	4720.85	4723.38	4715.23	4721.69	94242.0
2021-06-02 15:00:00	ES	Futures	4721.69	4728.71	4718.32	4727.31	165130.0
2021-06-02 16:00:00	ES	Futures	4727.31	4728.15	4721.97	4727.87	40339.0
2021-06-02 18:00:00	ES	Futures	4729.28	4729.84	4727.31	4727.87	3610.0
2021-06-02 19:00:00	ES	Futures	4728.15	4730.68	4727.03	4729.84	3959.0
2021-06-02 20:00:00	ES	Futures	4729.84	4735.18	4728.99	4734.05	8746.0
2021-06-02 21:00:00	ES	Futures	4734.33	4734.33	4730.4	4731.8	6929.0
2021-06-02 22:00:00	ES	Futures	4731.8	4733.21	4727.87	4730.68	4782.0
2021-06-02 23:00:00	ES	Futures	4730.4	4731.24	4728.99	4730.12	2596.0
2021-06-02 00:00:00	NQ	Futures	15798.63	15798.92	15789.36	15796.02	1268.0
2021-06-02 01:00:00	NQ	Futures	15795.44	15819.18	15792.84	15805.57	2249.0
2021-06-02 02:00:00	NQ	Futures	15804.71	15805.28	15785.6	15799.78	2877.0
2021-06-02 03:00:00	NQ	Futures	15800.36	15813.1	15767.94	15784.15	7219.0
2021-06-02 04:00:00	NQ	Futures	15783.28	15797.76	15769.97	15777.2	4574.0
2021-06-02 05:00:00	NQ	Futures	15776.33	15795.44	15772.86	15792.55	3241.0
2021-06-02 06:00:00	NQ	Futures	15791.97	15802.68	15782.7	15800.36	3280.0
2021-06-02 07:00:00	NQ	Futures	15800.36	15815.71	15793.99	15810.21	6226.0
2021-06-02 08:00:00	NQ	Futures	15810.78	15833.66	15804.99	15829.89	8862.0
2021-06-02 09:00:00	NQ	Futures	15830.18	15874.18	15808.47	15840.02	59810.0
2021-06-02 10:00:00	NQ	Futures	15840.02	15879.11	15815.13	15846.1	62435.0
2021-06-02 11:00:00	NQ	Futures	15846.39	15871.29	15836.55	15859.42	37694.0
2021-06-02 12:00:00	NQ	Futures	15860.0	15863.18	15813.39	15829.31	29383.0
2021-06-02 13:00:00	NQ	Futures	15829.31	15836.26	15763.89	15780.97	41784.0
2021-06-02 14:00:00	NQ	Futures	15780.68	15795.73	15752.31	15791.1	31799.0
2021-06-02 15:00:00	NQ	Futures	15791.1	15838.87	15778.65	15834.52	39642.0
2021-06-02 16:00:00	NQ	Futures	15834.23	15839.44	15821.5	15837.71	8862.0
2021-06-02 18:00:00	NQ	Futures	15840.6	15849.29	15836.55	15841.18	2050.0
2021-06-02 19:00:00	NQ	Futures	15840.31	15851.6	15832.79	15848.71	1903.0
2021-06-02 20:00:00	NQ	Futures	15849.29	15873.32	15844.08	15868.68	4214.0
2021-06-02 21:00:00	NQ	Futures	15868.97	15869.26	15853.92	15860.0	3562.0
2021-06-02 22:00:00	NQ	Futures	15860.0	15864.92	15841.47	15852.47	2825.0
2021-06-02 23:00:00	NQ	Futures	15852.18	15855.08	15844.95	15850.74	1424.0
2021-06-02 00:00:00	YM	Futures	38504.7	38506.9	38472.4	38479.1	500.0
2021-06-02 01:00:00	YM	Futures	38479.1	38508.0	38470.2	38492.4	720.0
2021-06-02 02:00:00	YM	Futures	38491.3	38498.0	38462.4	38484.7	1356.0
2021-06-02 03:00:00	YM	Futures	38485.8	38544.8	38435.6	38479.1	4429.0

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

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