PREVIEW / futures_1hour / 2020-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-24.parquet
  size:    63 KB
  rows:    1,918

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-02-24 00:00:00	ES	Futures	3570.0	3571.4	3566.5	3567.0	14356.0
2020-02-24 01:00:00	ES	Futures	3566.8	3569.8	3566.5	3568.9	18618.0
2020-02-24 02:00:00	ES	Futures	3569.2	3570.0	3557.0	3558.6	46962.0
2020-02-24 03:00:00	ES	Futures	3558.6	3560.0	3536.2	3539.1	159552.0
2020-02-24 04:00:00	ES	Futures	3539.1	3541.0	3514.7	3534.3	155711.0
2020-02-24 05:00:00	ES	Futures	3534.0	3534.3	3517.5	3519.9	70857.0
2020-02-24 06:00:00	ES	Futures	3519.9	3537.0	3513.9	3532.1	85708.0
2020-02-24 07:00:00	ES	Futures	3532.1	3540.2	3524.0	3528.3	72836.0
2020-02-24 08:00:00	ES	Futures	3528.0	3534.0	3517.2	3518.8	89935.0
2020-02-24 09:00:00	ES	Futures	3518.8	3531.5	3500.7	3528.3	453094.0
2020-02-24 10:00:00	ES	Futures	3528.6	3533.7	3509.3	3521.8	392064.0
2020-02-24 11:00:00	ES	Futures	3522.1	3523.4	3503.1	3508.0	281638.0
2020-02-24 12:00:00	ES	Futures	3508.2	3508.2	3493.6	3495.8	264152.0
2020-02-24 13:00:00	ES	Futures	3495.8	3504.7	3483.6	3502.0	268606.0
2020-02-24 14:00:00	ES	Futures	3502.3	3522.9	3492.3	3521.0	260571.0
2020-02-24 15:00:00	ES	Futures	3521.0	3526.4	3496.3	3496.3	461858.0
2020-02-24 16:00:00	ES	Futures	3496.3	3500.9	3490.9	3497.9	134976.0
2020-02-24 18:00:00	ES	Futures	3493.6	3513.7	3484.1	3511.8	44172.0
2020-02-24 19:00:00	ES	Futures	3512.0	3521.0	3509.3	3520.4	39619.0
2020-02-24 20:00:00	ES	Futures	3520.7	3533.2	3519.6	3526.1	54287.0
2020-02-24 21:00:00	ES	Futures	3526.1	3530.2	3519.4	3520.2	31605.0
2020-02-24 22:00:00	ES	Futures	3520.2	3525.0	3517.7	3524.5	20924.0
2020-02-24 23:00:00	ES	Futures	3524.5	3525.9	3520.4	3525.9	10332.0
2020-02-24 00:00:00	NQ	Futures	10749.73	10754.35	10731.51	10737.87	9112.0
2020-02-24 01:00:00	NQ	Futures	10737.58	10749.44	10736.14	10744.23	8063.0
2020-02-24 02:00:00	NQ	Futures	10743.65	10748.28	10697.68	10706.64	22289.0
2020-02-24 03:00:00	NQ	Futures	10706.64	10713.87	10613.24	10629.14	53304.0
2020-02-24 04:00:00	NQ	Futures	10629.14	10635.5	10554.82	10619.89	53930.0
2020-02-24 05:00:00	NQ	Futures	10619.89	10627.12	10570.15	10579.98	27699.0
2020-02-24 06:00:00	NQ	Futures	10579.69	10646.49	10566.39	10631.46	27739.0
2020-02-24 07:00:00	NQ	Futures	10631.17	10675.41	10612.08	10629.14	32607.0
2020-02-24 08:00:00	NQ	Futures	10628.56	10659.79	10596.18	10602.25	37221.0
2020-02-24 09:00:00	NQ	Futures	10602.83	10629.72	10457.95	10622.78	160124.0
2020-02-24 10:00:00	NQ	Futures	10622.78	10644.47	10540.08	10588.08	124030.0
2020-02-24 11:00:00	NQ	Futures	10588.37	10593.57	10514.05	10538.05	96999.0
2020-02-24 12:00:00	NQ	Futures	10537.47	10550.49	10488.89	10510.29	91309.0
2020-02-24 13:00:00	NQ	Futures	10510.58	10537.18	10463.16	10529.96	88776.0
2020-02-24 14:00:00	NQ	Futures	10529.96	10607.74	10489.18	10601.96	82808.0
2020-02-24 15:00:00	NQ	Futures	10602.54	10625.09	10507.69	10507.69	99790.0
2020-02-24 16:00:00	NQ	Futures	10507.69	10532.85	10493.52	10522.73	19158.0
2020-02-24 18:00:00	NQ	Futures	10515.5	10577.38	10472.41	10573.04	17939.0
2020-02-24 19:00:00	NQ	Futures	10573.33	10606.88	10561.19	10605.14	20864.0
2020-02-24 20:00:00	NQ	Futures	10605.72	10661.53	10600.22	10632.03	21647.0
2020-02-24 21:00:00	NQ	Futures	10631.74	10651.41	10603.12	10605.43	14749.0
2020-02-24 22:00:00	NQ	Futures	10604.85	10627.12	10595.6	10624.23	10283.0
2020-02-24 23:00:00	NQ	Futures	10623.94	10634.64	10610.92	10632.03	5047.0
2020-02-24 00:00:00	YM	Futures	31123.9	31140.2	31097.7	31109.7	3606.0
2020-02-24 01:00:00	YM	Futures	31107.5	31138.0	31105.4	31127.1	3742.0
2020-02-24 02:00:00	YM	Futures	31125.0	31136.9	31019.4	31035.7	11455.0
2020-02-24 03:00:00	YM	Futures	31036.8	31040.0	30848.4	30898.5	26445.0

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

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