PREVIEW / futures_1hour / 2020-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-08.parquet
  size:    61 KB
  rows:    1,875

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-01-08 00:00:00	ES	Futures	3495.0	3498.2	3492.3	3493.9	16675.0
2020-01-08 01:00:00	ES	Futures	3493.9	3498.5	3493.1	3496.9	11570.0
2020-01-08 02:00:00	ES	Futures	3496.6	3503.9	3496.0	3501.2	29432.0
2020-01-08 03:00:00	ES	Futures	3501.5	3506.9	3498.5	3501.5	47052.0
2020-01-08 04:00:00	ES	Futures	3501.5	3505.5	3500.7	3503.6	25567.0
2020-01-08 05:00:00	ES	Futures	3503.6	3515.6	3502.5	3513.9	35477.0
2020-01-08 06:00:00	ES	Futures	3514.2	3518.8	3511.2	3513.1	41577.0
2020-01-08 07:00:00	ES	Futures	3513.1	3516.9	3511.2	3515.3	30495.0
2020-01-08 08:00:00	ES	Futures	3515.6	3518.8	3509.6	3512.0	48619.0
2020-01-08 09:00:00	ES	Futures	3511.8	3520.7	3507.7	3519.1	184475.0
2020-01-08 10:00:00	ES	Futures	3519.4	3522.3	3510.1	3514.7	194354.0
2020-01-08 11:00:00	ES	Futures	3514.7	3535.9	3512.3	3531.5	313190.0
2020-01-08 12:00:00	ES	Futures	3531.5	3534.5	3530.2	3532.4	133421.0
2020-01-08 13:00:00	ES	Futures	3532.4	3533.4	3528.3	3529.4	81054.0
2020-01-08 14:00:00	ES	Futures	3529.4	3536.4	3529.4	3536.4	79898.0
2020-01-08 15:00:00	ES	Futures	3536.4	3542.1	3525.0	3526.9	304010.0
2020-01-08 16:00:00	ES	Futures	3527.2	3535.3	3526.1	3533.4	81004.0
2020-01-08 18:00:00	ES	Futures	3535.1	3538.9	3532.6	3535.9	12732.0
2020-01-08 19:00:00	ES	Futures	3535.9	3539.9	3534.0	3537.2	12143.0
2020-01-08 20:00:00	ES	Futures	3537.0	3539.4	3536.4	3538.0	8711.0
2020-01-08 21:00:00	ES	Futures	3538.0	3538.3	3535.9	3536.2	5284.0
2020-01-08 22:00:00	ES	Futures	3535.9	3536.4	3531.3	3535.6	7474.0
2020-01-08 23:00:00	ES	Futures	3535.3	3537.5	3534.5	3537.0	3047.0
2020-01-08 00:00:00	NQ	Futures	10187.29	10204.92	10180.06	10183.82	9788.0
2020-01-08 01:00:00	NQ	Futures	10184.1	10196.54	10177.74	10190.76	6103.0
2020-01-08 02:00:00	NQ	Futures	10190.47	10218.23	10185.84	10210.71	13901.0
2020-01-08 03:00:00	NQ	Futures	10211.0	10228.64	10202.03	10216.2	21065.0
2020-01-08 04:00:00	NQ	Futures	10216.2	10230.95	10211.86	10224.59	14513.0
2020-01-08 05:00:00	NQ	Futures	10224.59	10264.78	10220.83	10256.69	14661.0
2020-01-08 06:00:00	NQ	Futures	10256.98	10277.51	10248.3	10258.71	15691.0
2020-01-08 07:00:00	NQ	Futures	10258.42	10273.17	10251.77	10265.94	14661.0
2020-01-08 08:00:00	NQ	Futures	10265.94	10281.56	10245.99	10256.69	19158.0
2020-01-08 09:00:00	NQ	Futures	10256.4	10289.94	10234.42	10283.29	61870.0
2020-01-08 10:00:00	NQ	Futures	10283.58	10291.68	10243.67	10261.89	55757.0
2020-01-08 11:00:00	NQ	Futures	10261.89	10338.23	10250.61	10324.64	87343.0
2020-01-08 12:00:00	NQ	Futures	10324.64	10346.33	10324.06	10340.26	40388.0
2020-01-08 13:00:00	NQ	Futures	10340.26	10346.33	10330.43	10333.9	24175.0
2020-01-08 14:00:00	NQ	Futures	10333.9	10352.4	10333.9	10351.82	24186.0
2020-01-08 15:00:00	NQ	Futures	10352.11	10378.14	10322.04	10328.98	70716.0
2020-01-08 16:00:00	NQ	Futures	10328.98	10355.58	10326.09	10349.51	15961.0
2020-01-08 18:00:00	NQ	Futures	10350.96	10368.02	10344.31	10355.01	6361.0
2020-01-08 19:00:00	NQ	Futures	10355.01	10369.75	10349.51	10359.05	6744.0
2020-01-08 20:00:00	NQ	Futures	10358.76	10367.73	10352.69	10357.32	5365.0
2020-01-08 21:00:00	NQ	Futures	10357.32	10360.79	10350.09	10351.54	2618.0
2020-01-08 22:00:00	NQ	Futures	10351.54	10354.43	10332.16	10349.22	4480.0
2020-01-08 23:00:00	NQ	Futures	10348.93	10359.05	10344.88	10357.03	2823.0
2020-01-08 00:00:00	YM	Futures	30865.8	30886.5	30829.9	30843.0	4412.0
2020-01-08 01:00:00	YM	Futures	30844.1	30888.7	30834.3	30880.0	4534.0
2020-01-08 02:00:00	YM	Futures	30878.9	30975.8	30874.6	30936.6	9371.0
2020-01-08 03:00:00	YM	Futures	30939.9	30973.6	30919.2	30944.2	10541.0

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

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