PREVIEW / futures_1hour / 2020-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-26.parquet
  size:    65 KB
  rows:    1,946

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-26 00:00:00	ES	Futures	3414.2	3416.4	3408.8	3414.7	20575.0
2020-02-26 01:00:00	ES	Futures	3414.7	3415.3	3393.9	3397.9	30530.0
2020-02-26 02:00:00	ES	Futures	3397.9	3413.7	3395.2	3413.1	47520.0
2020-02-26 03:00:00	ES	Futures	3412.9	3416.6	3377.1	3379.8	112366.0
2020-02-26 04:00:00	ES	Futures	3379.8	3384.9	3350.5	3375.2	177291.0
2020-02-26 05:00:00	ES	Futures	3375.2	3396.0	3374.6	3380.3	100424.0
2020-02-26 06:00:00	ES	Futures	3380.3	3408.5	3380.1	3398.2	77042.0
2020-02-26 07:00:00	ES	Futures	3398.2	3406.6	3384.4	3401.7	107855.0
2020-02-26 08:00:00	ES	Futures	3401.7	3414.2	3394.4	3404.2	116639.0
2020-02-26 09:00:00	ES	Futures	3403.9	3441.8	3402.3	3421.0	400786.0
2020-02-26 10:00:00	ES	Futures	3420.7	3449.2	3411.5	3438.9	481288.0
2020-02-26 11:00:00	ES	Futures	3438.9	3444.8	3416.4	3419.6	291706.0
2020-02-26 12:00:00	ES	Futures	3419.4	3422.1	3390.1	3408.0	373644.0
2020-02-26 13:00:00	ES	Futures	3408.2	3412.9	3368.4	3372.7	380820.0
2020-02-26 14:00:00	ES	Futures	3372.7	3394.7	3369.0	3376.3	311210.0
2020-02-26 15:00:00	ES	Futures	3376.3	3398.2	3375.5	3377.9	389798.0
2020-02-26 16:00:00	ES	Futures	3377.9	3379.2	3358.1	3360.3	131967.0
2020-02-26 18:00:00	ES	Futures	3360.6	3378.7	3351.9	3363.8	63925.0
2020-02-26 19:00:00	ES	Futures	3363.8	3368.4	3336.4	3352.4	74549.0
2020-02-26 20:00:00	ES	Futures	3352.4	3357.8	3338.9	3343.5	48530.0
2020-02-26 21:00:00	ES	Futures	3343.5	3345.9	3329.4	3329.9	59134.0
2020-02-26 22:00:00	ES	Futures	3329.9	3338.1	3324.8	3326.7	45673.0
2020-02-26 23:00:00	ES	Futures	3326.7	3328.6	3316.4	3316.6	30848.0
2020-02-26 00:00:00	NQ	Futures	10315.1	10322.91	10294.86	10316.26	9307.0
2020-02-26 01:00:00	NQ	Futures	10316.83	10317.7	10243.96	10261.89	13056.0
2020-02-26 02:00:00	NQ	Futures	10261.31	10315.68	10248.88	10313.65	19057.0
2020-02-26 03:00:00	NQ	Futures	10313.65	10326.96	10161.26	10181.79	40629.0
2020-02-26 04:00:00	NQ	Futures	10181.5	10197.12	10074.22	10161.84	58293.0
2020-02-26 05:00:00	NQ	Futures	10162.13	10237.89	10160.39	10184.39	30123.0
2020-02-26 06:00:00	NQ	Futures	10184.39	10300.06	10184.39	10250.61	31877.0
2020-02-26 07:00:00	NQ	Futures	10251.19	10286.18	10200.01	10257.27	44206.0
2020-02-26 08:00:00	NQ	Futures	10258.13	10329.27	10235.87	10279.53	46126.0
2020-02-26 09:00:00	NQ	Futures	10279.24	10428.17	10267.68	10358.19	148569.0
2020-02-26 10:00:00	NQ	Futures	10358.19	10453.61	10324.35	10419.49	156857.0
2020-02-26 11:00:00	NQ	Futures	10420.07	10441.18	10352.98	10363.39	100342.0
2020-02-26 12:00:00	NQ	Futures	10363.68	10371.49	10255.24	10330.14	125015.0
2020-02-26 13:00:00	NQ	Futures	10330.14	10348.35	10198.27	10228.06	114421.0
2020-02-26 14:00:00	NQ	Futures	10228.06	10299.77	10214.76	10252.06	94601.0
2020-02-26 15:00:00	NQ	Futures	10251.48	10331.0	10250.04	10270.86	83292.0
2020-02-26 16:00:00	NQ	Futures	10270.86	10278.09	10190.47	10203.19	23041.0
2020-02-26 18:00:00	NQ	Futures	10192.2	10269.7	10162.71	10216.2	20096.0
2020-02-26 19:00:00	NQ	Futures	10215.91	10239.91	10119.91	10188.15	41531.0
2020-02-26 20:00:00	NQ	Futures	10188.15	10208.97	10135.81	10152.3	32629.0
2020-02-26 21:00:00	NQ	Futures	10152.3	10165.02	10106.9	10110.08	26603.0
2020-02-26 22:00:00	NQ	Futures	10110.65	10139.28	10090.7	10100.24	20216.0
2020-02-26 23:00:00	NQ	Futures	10100.82	10111.23	10064.39	10066.7	15637.0
2020-02-26 00:00:00	YM	Futures	29669.3	29674.8	29619.2	29665.0	5547.0
2020-02-26 01:00:00	YM	Futures	29667.1	29668.2	29478.8	29516.9	8173.0
2020-02-26 02:00:00	YM	Futures	29516.9	29650.8	29494.0	29642.1	12414.0
2020-02-26 03:00:00	YM	Futures	29641.0	29673.7	29329.6	29359.0	28030.0

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

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