PREVIEW / futures_1hour / 2020-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-05.parquet
  size:    66 KB
  rows:    1,908

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-03-05 00:00:00	ES	Futures	3348.4	3364.1	3348.4	3361.1	16318.0
2020-03-05 01:00:00	ES	Futures	3360.8	3361.4	3349.2	3350.3	13902.0
2020-03-05 02:00:00	ES	Futures	3350.3	3350.5	3339.7	3347.3	24924.0
2020-03-05 03:00:00	ES	Futures	3347.3	3347.5	3331.3	3331.6	41170.0
2020-03-05 04:00:00	ES	Futures	3331.8	3332.4	3319.6	3325.9	42989.0
2020-03-05 05:00:00	ES	Futures	3325.9	3327.2	3304.7	3307.7	53403.0
2020-03-05 06:00:00	ES	Futures	3307.7	3319.1	3301.7	3313.4	47843.0
2020-03-05 07:00:00	ES	Futures	3313.4	3320.7	3305.3	3310.7	52696.0
2020-03-05 08:00:00	ES	Futures	3310.7	3316.1	3292.0	3307.2	78872.0
2020-03-05 09:00:00	ES	Futures	3307.2	3319.4	3286.0	3298.2	286568.0
2020-03-05 10:00:00	ES	Futures	3298.2	3325.1	3292.3	3313.9	289416.0
2020-03-05 11:00:00	ES	Futures	3313.9	3341.0	3306.1	3311.0	235686.0
2020-03-05 12:00:00	ES	Futures	3311.0	3314.8	3270.9	3275.5	250096.0
2020-03-05 13:00:00	ES	Futures	3275.5	3294.2	3264.3	3286.6	244662.0
2020-03-05 14:00:00	ES	Futures	3286.3	3286.8	3260.3	3273.8	216350.0
2020-03-05 15:00:00	ES	Futures	3273.8	3283.3	3248.1	3275.2	481661.0
2020-03-05 16:00:00	ES	Futures	3275.2	3278.2	3266.0	3276.3	110706.0
2020-03-05 18:00:00	ES	Futures	3278.2	3280.6	3269.8	3280.6	17353.0
2020-03-05 19:00:00	ES	Futures	3280.6	3292.0	3268.1	3277.4	34253.0
2020-03-05 20:00:00	ES	Futures	3277.4	3277.6	3249.4	3250.3	41710.0
2020-03-05 21:00:00	ES	Futures	3250.3	3252.2	3230.5	3230.5	61855.0
2020-03-05 22:00:00	ES	Futures	3230.7	3242.7	3227.0	3229.4	31138.0
2020-03-05 23:00:00	ES	Futures	3229.4	3236.4	3225.9	3229.4	14028.0
2020-03-05 00:00:00	NQ	Futures	10211.58	10267.68	10211.58	10256.69	13071.0
2020-03-05 01:00:00	NQ	Futures	10257.27	10257.84	10220.54	10224.01	10988.0
2020-03-05 02:00:00	NQ	Futures	10224.59	10224.59	10191.91	10214.47	12592.0
2020-03-05 03:00:00	NQ	Futures	10214.76	10217.94	10154.61	10156.34	23424.0
2020-03-05 04:00:00	NQ	Futures	10156.34	10159.52	10119.33	10137.26	23219.0
2020-03-05 05:00:00	NQ	Futures	10136.97	10139.57	10074.8	10084.34	28010.0
2020-03-05 06:00:00	NQ	Futures	10083.76	10118.46	10071.91	10103.14	26359.0
2020-03-05 07:00:00	NQ	Futures	10103.14	10123.96	10085.21	10088.68	24200.0
2020-03-05 08:00:00	NQ	Futures	10088.97	10115.57	10044.14	10083.76	29914.0
2020-03-05 09:00:00	NQ	Futures	10084.05	10157.79	10030.84	10108.92	109167.0
2020-03-05 10:00:00	NQ	Futures	10106.61	10210.71	10080.58	10173.12	109785.0
2020-03-05 11:00:00	NQ	Futures	10173.4	10257.27	10149.98	10164.73	86442.0
2020-03-05 12:00:00	NQ	Futures	10165.31	10178.32	10033.16	10047.04	83532.0
2020-03-05 13:00:00	NQ	Futures	10046.75	10115.86	10012.91	10087.81	86209.0
2020-03-05 14:00:00	NQ	Futures	10087.23	10087.23	10008.29	10044.14	72293.0
2020-03-05 15:00:00	NQ	Futures	10045.01	10062.94	9959.99	10030.84	110488.0
2020-03-05 16:00:00	NQ	Futures	10030.26	10040.67	9991.8	10033.16	17691.0
2020-03-05 18:00:00	NQ	Futures	10036.63	10057.16	10014.36	10055.71	6583.0
2020-03-05 19:00:00	NQ	Futures	10056.29	10093.88	10014.36	10041.83	19456.0
2020-03-05 20:00:00	NQ	Futures	10041.83	10043.28	9955.95	9958.55	16782.0
2020-03-05 21:00:00	NQ	Futures	9957.97	9964.04	9898.98	9900.14	32034.0
2020-03-05 22:00:00	NQ	Futures	9900.43	9937.15	9875.85	9883.36	17429.0
2020-03-05 23:00:00	NQ	Futures	9883.65	9904.76	9871.51	9883.65	9513.0
2020-03-05 00:00:00	YM	Futures	29134.7	29274.1	29134.7	29252.3	5449.0
2020-03-05 01:00:00	YM	Futures	29250.2	29252.3	29145.6	29156.5	4820.0
2020-03-05 02:00:00	YM	Futures	29156.5	29158.7	29066.2	29128.2	7688.0
2020-03-05 03:00:00	YM	Futures	29130.4	29134.7	28980.1	28982.3	12324.0

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

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