PREVIEW / futures_1hour / 2020-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-27.parquet
  size:    66 KB
  rows:    1,945

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-27 00:00:00	ES	Futures	3316.6	3329.4	3316.4	3327.5	36532.0
2020-02-27 01:00:00	ES	Futures	3327.2	3345.1	3318.3	3342.9	40546.0
2020-02-27 02:00:00	ES	Futures	3342.9	3358.1	3334.3	3347.3	78050.0
2020-02-27 03:00:00	ES	Futures	3347.3	3356.2	3334.8	3353.8	92919.0
2020-02-27 04:00:00	ES	Futures	3353.8	3364.6	3348.1	3351.1	70142.0
2020-02-27 05:00:00	ES	Futures	3351.1	3355.4	3335.9	3335.9	54158.0
2020-02-27 06:00:00	ES	Futures	3335.9	3347.3	3333.7	3337.0	48935.0
2020-02-27 07:00:00	ES	Futures	3337.0	3343.5	3323.7	3325.1	92417.0
2020-02-27 08:00:00	ES	Futures	3325.1	3331.6	3317.7	3319.4	127627.0
2020-02-27 09:00:00	ES	Futures	3319.1	3326.9	3287.9	3307.7	576348.0
2020-02-27 10:00:00	ES	Futures	3307.4	3315.8	3258.4	3311.5	634075.0
2020-02-27 11:00:00	ES	Futures	3311.5	3327.2	3290.6	3322.6	469307.0
2020-02-27 12:00:00	ES	Futures	3322.3	3356.2	3317.2	3336.4	373748.0
2020-02-27 13:00:00	ES	Futures	3336.4	3352.4	3291.2	3300.1	391043.0
2020-02-27 14:00:00	ES	Futures	3299.8	3308.5	3284.7	3285.8	306764.0
2020-02-27 15:00:00	ES	Futures	3285.8	3298.5	3223.4	3223.4	602530.0
2020-02-27 16:00:00	ES	Futures	3223.4	3237.8	3191.7	3196.9	279613.0
2020-02-27 18:00:00	ES	Futures	3197.7	3221.5	3181.7	3216.4	69699.0
2020-02-27 19:00:00	ES	Futures	3216.1	3223.2	3202.3	3218.0	52859.0
2020-02-27 20:00:00	ES	Futures	3218.0	3222.3	3200.7	3220.4	53225.0
2020-02-27 21:00:00	ES	Futures	3220.4	3230.7	3203.9	3206.1	49198.0
2020-02-27 22:00:00	ES	Futures	3206.1	3208.5	3169.0	3196.1	74540.0
2020-02-27 23:00:00	ES	Futures	3195.8	3201.5	3176.8	3180.3	38459.0
2020-02-27 00:00:00	NQ	Futures	10067.28	10113.55	10066.7	10105.16	21569.0
2020-02-27 01:00:00	NQ	Futures	10105.16	10151.14	10060.05	10144.49	25574.0
2020-02-27 02:00:00	NQ	Futures	10143.91	10203.48	10114.41	10166.18	40327.0
2020-02-27 03:00:00	NQ	Futures	10166.46	10194.8	10119.91	10182.95	41658.0
2020-02-27 04:00:00	NQ	Futures	10182.66	10231.24	10163.86	10176.59	32988.0
2020-02-27 05:00:00	NQ	Futures	10177.16	10193.36	10129.45	10129.74	20911.0
2020-02-27 06:00:00	NQ	Futures	10129.45	10180.06	10122.51	10134.94	22963.0
2020-02-27 07:00:00	NQ	Futures	10134.66	10152.87	10065.54	10067.57	42486.0
2020-02-27 08:00:00	NQ	Futures	10067.57	10097.35	10035.18	10047.61	53310.0
2020-02-27 09:00:00	NQ	Futures	10047.33	10089.26	9954.21	10029.11	182035.0
2020-02-27 10:00:00	NQ	Futures	10028.82	10060.92	9855.03	10025.06	210023.0
2020-02-27 11:00:00	NQ	Futures	10025.06	10104.0	9958.55	10062.94	172130.0
2020-02-27 12:00:00	NQ	Futures	10062.65	10170.8	10039.23	10105.16	129150.0
2020-02-27 13:00:00	NQ	Futures	10105.16	10155.19	9961.44	9994.41	126082.0
2020-02-27 14:00:00	NQ	Futures	9994.7	10016.09	9931.08	9933.68	96833.0
2020-02-27 15:00:00	NQ	Futures	9933.97	9985.44	9751.5	9752.95	134939.0
2020-02-27 16:00:00	NQ	Futures	9752.95	9792.85	9640.17	9658.1	49551.0
2020-02-27 18:00:00	NQ	Futures	9654.92	9748.32	9613.85	9732.42	24053.0
2020-02-27 19:00:00	NQ	Futures	9731.55	9751.5	9684.41	9734.44	20554.0
2020-02-27 20:00:00	NQ	Futures	9734.44	9747.45	9675.74	9737.33	18653.0
2020-02-27 21:00:00	NQ	Futures	9737.62	9770.88	9678.05	9685.57	23074.0
2020-02-27 22:00:00	NQ	Futures	9686.44	9695.11	9547.06	9642.48	41089.0
2020-02-27 23:00:00	NQ	Futures	9641.33	9656.65	9555.44	9571.64	25217.0
2020-02-27 00:00:00	YM	Futures	28822.3	28943.1	28821.2	28930.1	8989.0
2020-02-27 01:00:00	YM	Futures	28929.0	29076.0	28854.9	29066.2	10010.0
2020-02-27 02:00:00	YM	Futures	29064.0	29195.7	29000.8	29095.6	17104.0
2020-02-27 03:00:00	YM	Futures	29096.6	29175.0	28996.5	29147.8	16376.0

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

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