PREVIEW / futures_1hour / 2020-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-06.parquet
  size:    60 KB
  rows:    1,893

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-06 00:00:00	ES	Futures	3634.0	3637.2	3633.4	3635.1	21178.0
2020-02-06 01:00:00	ES	Futures	3635.3	3639.7	3631.5	3632.1	21433.0
2020-02-06 02:00:00	ES	Futures	3632.1	3635.1	3628.6	3634.5	15884.0
2020-02-06 03:00:00	ES	Futures	3634.3	3635.6	3630.2	3630.7	35631.0
2020-02-06 04:00:00	ES	Futures	3631.0	3632.9	3622.6	3624.5	33057.0
2020-02-06 05:00:00	ES	Futures	3624.5	3626.1	3621.0	3621.8	27006.0
2020-02-06 06:00:00	ES	Futures	3621.5	3631.0	3621.2	3630.2	27305.0
2020-02-06 07:00:00	ES	Futures	3630.2	3631.0	3624.5	3626.1	24346.0
2020-02-06 08:00:00	ES	Futures	3626.1	3629.9	3623.4	3625.6	37352.0
2020-02-06 09:00:00	ES	Futures	3625.8	3627.5	3612.6	3622.9	241702.0
2020-02-06 10:00:00	ES	Futures	3622.6	3625.0	3613.9	3620.2	223068.0
2020-02-06 11:00:00	ES	Futures	3620.2	3626.4	3618.3	3619.9	156079.0
2020-02-06 12:00:00	ES	Futures	3619.9	3626.9	3619.1	3626.4	72138.0
2020-02-06 13:00:00	ES	Futures	3626.4	3627.5	3620.2	3624.2	60514.0
2020-02-06 14:00:00	ES	Futures	3624.2	3626.7	3622.3	3622.9	70244.0
2020-02-06 15:00:00	ES	Futures	3622.9	3626.7	3619.9	3625.3	166702.0
2020-02-06 16:00:00	ES	Futures	3625.3	3629.4	3622.6	3629.1	70824.0
2020-02-06 18:00:00	ES	Futures	3630.2	3631.3	3628.3	3630.2	8463.0
2020-02-06 19:00:00	ES	Futures	3630.5	3631.3	3616.4	3621.0	26378.0
2020-02-06 20:00:00	ES	Futures	3621.0	3624.2	3616.4	3620.2	28423.0
2020-02-06 21:00:00	ES	Futures	3620.4	3625.3	3619.9	3620.7	15041.0
2020-02-06 22:00:00	ES	Futures	3620.7	3623.1	3620.2	3623.1	10528.0
2020-02-06 23:00:00	ES	Futures	3623.1	3623.4	3620.7	3621.5	5222.0
2020-02-06 00:00:00	NQ	Futures	10925.83	10936.24	10923.23	10929.88	7871.0
2020-02-06 01:00:00	NQ	Futures	10930.17	10943.18	10918.03	10919.47	7355.0
2020-02-06 02:00:00	NQ	Futures	10919.76	10934.22	10907.33	10929.3	8271.0
2020-02-06 03:00:00	NQ	Futures	10929.01	10933.35	10909.93	10911.95	13322.0
2020-02-06 04:00:00	NQ	Futures	10911.66	10922.65	10883.9	10891.71	15050.0
2020-02-06 05:00:00	NQ	Futures	10891.71	10897.78	10874.07	10876.1	9257.0
2020-02-06 06:00:00	NQ	Futures	10876.1	10914.27	10874.36	10911.66	10295.0
2020-02-06 07:00:00	NQ	Futures	10911.38	10915.13	10886.51	10892.0	10023.0
2020-02-06 08:00:00	NQ	Futures	10892.58	10901.54	10876.39	10882.17	18692.0
2020-02-06 09:00:00	NQ	Futures	10881.88	10889.69	10829.54	10889.11	93719.0
2020-02-06 10:00:00	NQ	Futures	10889.11	10900.39	10861.93	10894.02	84070.0
2020-02-06 11:00:00	NQ	Futures	10894.02	10925.83	10887.37	10902.41	62112.0
2020-02-06 12:00:00	NQ	Futures	10902.7	10932.48	10899.81	10930.17	35752.0
2020-02-06 13:00:00	NQ	Futures	10929.88	10934.22	10909.93	10922.07	28863.0
2020-02-06 14:00:00	NQ	Futures	10922.36	10928.44	10909.06	10910.22	30897.0
2020-02-06 15:00:00	NQ	Futures	10910.22	10937.69	10902.99	10934.22	45989.0
2020-02-06 16:00:00	NQ	Futures	10934.22	10946.94	10924.1	10946.94	11350.0
2020-02-06 18:00:00	NQ	Futures	10950.41	10955.04	10942.61	10950.12	4070.0
2020-02-06 19:00:00	NQ	Futures	10950.12	10953.88	10905.3	10919.18	12346.0
2020-02-06 20:00:00	NQ	Futures	10918.6	10929.88	10900.1	10914.85	15269.0
2020-02-06 21:00:00	NQ	Futures	10914.85	10932.77	10913.69	10916.87	7313.0
2020-02-06 22:00:00	NQ	Futures	10916.58	10926.12	10915.13	10924.39	5659.0
2020-02-06 23:00:00	NQ	Futures	10924.39	10924.68	10913.98	10917.74	5316.0
2020-02-06 00:00:00	YM	Futures	32046.0	32076.5	32038.4	32045.0	4722.0
2020-02-06 01:00:00	YM	Futures	32046.0	32090.7	32018.8	32022.1	4670.0
2020-02-06 02:00:00	YM	Futures	32023.2	32054.8	31998.1	32048.2	3616.0
2020-02-06 03:00:00	YM	Futures	32047.1	32058.0	32004.7	32015.6	6477.0

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

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