PREVIEW / futures_1hour / 2020-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-07.parquet
  size:    51 KB
  rows:    1,512

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-07 00:00:00	ES	Futures	3621.2	3622.1	3618.0	3621.0	8377.0
2020-02-07 01:00:00	ES	Futures	3621.0	3628.8	3619.3	3626.7	10632.0
2020-02-07 02:00:00	ES	Futures	3626.7	3628.6	3620.2	3622.9	15843.0
2020-02-07 03:00:00	ES	Futures	3622.6	3625.3	3619.3	3622.9	29237.0
2020-02-07 04:00:00	ES	Futures	3622.9	3624.0	3614.7	3615.6	25748.0
2020-02-07 05:00:00	ES	Futures	3615.6	3616.9	3609.3	3609.3	40804.0
2020-02-07 06:00:00	ES	Futures	3609.0	3614.5	3606.9	3614.2	29850.0
2020-02-07 07:00:00	ES	Futures	3614.2	3617.7	3613.9	3616.9	22278.0
2020-02-07 08:00:00	ES	Futures	3616.9	3625.8	3609.6	3613.1	101823.0
2020-02-07 09:00:00	ES	Futures	3613.1	3615.8	3603.4	3606.9	250377.0
2020-02-07 10:00:00	ES	Futures	3606.9	3616.6	3603.1	3612.8	217672.0
2020-02-07 11:00:00	ES	Futures	3612.6	3621.8	3610.1	3616.4	149179.0
2020-02-07 12:00:00	ES	Futures	3616.6	3619.9	3614.7	3616.6	66572.0
2020-02-07 13:00:00	ES	Futures	3616.6	3616.9	3606.6	3606.6	106717.0
2020-02-07 14:00:00	ES	Futures	3606.9	3608.2	3599.6	3607.4	174782.0
2020-02-07 15:00:00	ES	Futures	3607.4	3610.7	3601.7	3606.1	211588.0
2020-02-07 16:00:00	ES	Futures	3606.1	3607.4	3601.7	3602.0	80123.0
2020-02-07 00:00:00	NQ	Futures	10917.45	10918.89	10902.99	10915.13	4475.0
2020-02-07 01:00:00	NQ	Futures	10914.85	10947.23	10909.64	10939.14	7510.0
2020-02-07 02:00:00	NQ	Futures	10939.14	10947.52	10914.85	10923.23	8562.0
2020-02-07 03:00:00	NQ	Futures	10923.23	10930.75	10911.38	10924.1	12346.0
2020-02-07 04:00:00	NQ	Futures	10924.39	10928.15	10893.16	10896.34	11298.0
2020-02-07 05:00:00	NQ	Futures	10896.63	10900.39	10874.94	10875.52	14204.0
2020-02-07 06:00:00	NQ	Futures	10875.23	10897.49	10867.13	10896.63	12338.0
2020-02-07 07:00:00	NQ	Futures	10896.34	10908.77	10894.89	10905.01	8130.0
2020-02-07 08:00:00	NQ	Futures	10905.01	10935.67	10874.65	10887.37	35731.0
2020-02-07 09:00:00	NQ	Futures	10887.66	10900.68	10855.56	10872.05	79747.0
2020-02-07 10:00:00	NQ	Futures	10871.76	10918.6	10859.03	10905.3	76992.0
2020-02-07 11:00:00	NQ	Futures	10905.3	10946.37	10894.6	10933.35	58804.0
2020-02-07 12:00:00	NQ	Futures	10933.35	10945.79	10926.41	10934.22	31631.0
2020-02-07 13:00:00	NQ	Futures	10934.22	10934.8	10889.11	10889.69	41148.0
2020-02-07 14:00:00	NQ	Futures	10889.69	10894.02	10856.72	10891.71	65560.0
2020-02-07 15:00:00	NQ	Futures	10891.42	10895.18	10868.87	10885.64	57973.0
2020-02-07 16:00:00	NQ	Futures	10885.64	10888.82	10872.34	10873.49	11834.0
2020-02-07 00:00:00	YM	Futures	31875.1	31884.9	31845.7	31874.0	1790.0
2020-02-07 01:00:00	YM	Futures	31874.0	31945.9	31856.6	31924.1	3047.0
2020-02-07 02:00:00	YM	Futures	31924.1	31942.6	31859.9	31887.1	4375.0
2020-02-07 03:00:00	YM	Futures	31887.1	31913.2	31855.5	31888.2	5968.0
2020-02-07 04:00:00	YM	Futures	31889.3	31898.0	31821.8	31831.6	5296.0
2020-02-07 05:00:00	YM	Futures	31831.6	31844.6	31767.3	31768.4	8057.0
2020-02-07 06:00:00	YM	Futures	31768.4	31810.9	31746.6	31809.8	6265.0
2020-02-07 07:00:00	YM	Futures	31808.7	31839.2	31802.2	31833.7	4820.0
2020-02-07 08:00:00	YM	Futures	31834.8	31911.0	31777.1	31807.6	17155.0
2020-02-07 09:00:00	YM	Futures	31804.3	31830.5	31686.8	31704.2	30274.0
2020-02-07 10:00:00	YM	Futures	31705.3	31784.7	31668.3	31717.2	29563.0
2020-02-07 11:00:00	YM	Futures	31716.2	31781.5	31688.9	31737.9	20197.0
2020-02-07 12:00:00	YM	Futures	31735.8	31761.9	31704.2	31726.0	10752.0
2020-02-07 13:00:00	YM	Futures	31726.0	31732.5	31642.1	31643.2	13322.0
2020-02-07 14:00:00	YM	Futures	31644.3	31650.8	31580.1	31636.7	21532.0
2020-02-07 15:00:00	YM	Futures	31637.8	31666.1	31594.2	31632.3	20654.0

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

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