PREVIEW / futures_1hour / 2020-02-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-10.parquet
  size:    58 KB
  rows:    1,862

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-10 00:00:00	ES	Futures	3604.2	3609.0	3603.4	3607.7	8434.0
2020-02-10 01:00:00	ES	Futures	3607.7	3612.0	3605.8	3610.4	8169.0
2020-02-10 02:00:00	ES	Futures	3610.7	3612.6	3605.8	3606.1	16584.0
2020-02-10 03:00:00	ES	Futures	3605.8	3609.6	3597.4	3601.5	45557.0
2020-02-10 04:00:00	ES	Futures	3601.5	3608.2	3600.6	3601.2	29026.0
2020-02-10 05:00:00	ES	Futures	3601.2	3609.3	3598.5	3606.1	34372.0
2020-02-10 06:00:00	ES	Futures	3606.1	3608.0	3605.0	3606.3	12943.0
2020-02-10 07:00:00	ES	Futures	3606.3	3608.2	3602.0	3603.6	19010.0
2020-02-10 08:00:00	ES	Futures	3603.6	3605.8	3597.9	3599.8	34522.0
2020-02-10 09:00:00	ES	Futures	3600.1	3612.0	3593.1	3611.8	196006.0
2020-02-10 10:00:00	ES	Futures	3611.8	3622.1	3611.5	3618.0	199309.0
2020-02-10 11:00:00	ES	Futures	3618.0	3622.3	3615.8	3618.5	104859.0
2020-02-10 12:00:00	ES	Futures	3618.5	3618.5	3613.1	3614.7	81989.0
2020-02-10 13:00:00	ES	Futures	3615.0	3618.5	3614.2	3616.4	48933.0
2020-02-10 14:00:00	ES	Futures	3616.4	3623.4	3614.5	3623.1	52058.0
2020-02-10 15:00:00	ES	Futures	3622.9	3633.2	3622.6	3632.9	198682.0
2020-02-10 16:00:00	ES	Futures	3632.9	3635.1	3631.3	3633.7	84246.0
2020-02-10 18:00:00	ES	Futures	3632.4	3634.5	3631.0	3632.9	10188.0
2020-02-10 19:00:00	ES	Futures	3632.9	3640.2	3630.5	3637.8	16984.0
2020-02-10 20:00:00	ES	Futures	3637.8	3644.8	3637.0	3644.3	21167.0
2020-02-10 21:00:00	ES	Futures	3644.3	3647.3	3643.7	3644.5	13365.0
2020-02-10 22:00:00	ES	Futures	3644.3	3645.6	3642.9	3644.8	7289.0
2020-02-10 23:00:00	ES	Futures	3644.8	3644.8	3642.9	3644.5	3240.0
2020-02-10 00:00:00	NQ	Futures	10882.46	10904.15	10879.86	10898.94	4867.0
2020-02-10 01:00:00	NQ	Futures	10898.65	10913.11	10891.13	10905.88	4273.0
2020-02-10 02:00:00	NQ	Futures	10905.88	10912.24	10886.51	10890.27	6675.0
2020-02-10 03:00:00	NQ	Futures	10889.69	10902.99	10854.99	10871.47	17159.0
2020-02-10 04:00:00	NQ	Futures	10870.89	10898.94	10869.44	10877.54	10409.0
2020-02-10 05:00:00	NQ	Futures	10877.54	10908.19	10867.42	10896.05	10292.0
2020-02-10 06:00:00	NQ	Futures	10896.34	10906.17	10893.45	10898.94	4706.0
2020-02-10 07:00:00	NQ	Futures	10898.65	10903.86	10881.01	10885.35	7417.0
2020-02-10 08:00:00	NQ	Futures	10885.35	10893.16	10864.82	10873.2	14337.0
2020-02-10 09:00:00	NQ	Futures	10872.92	10929.3	10848.34	10928.44	73230.0
2020-02-10 10:00:00	NQ	Futures	10928.15	10964.29	10923.81	10940.87	71143.0
2020-02-10 11:00:00	NQ	Futures	10940.87	10971.52	10935.67	10961.4	44305.0
2020-02-10 12:00:00	NQ	Futures	10961.4	10961.69	10938.27	10948.68	33175.0
2020-02-10 13:00:00	NQ	Futures	10948.68	10964.0	10946.65	10955.91	21243.0
2020-02-10 14:00:00	NQ	Futures	10955.91	10981.35	10948.68	10979.62	26473.0
2020-02-10 15:00:00	NQ	Futures	10979.62	11018.37	10978.46	11017.5	54918.0
2020-02-10 16:00:00	NQ	Futures	11017.5	11025.02	11011.43	11018.66	12782.0
2020-02-10 18:00:00	NQ	Futures	11017.5	11022.13	11007.67	11018.08	5190.0
2020-02-10 19:00:00	NQ	Futures	11017.79	11048.15	11010.56	11038.9	9166.0
2020-02-10 20:00:00	NQ	Futures	11038.9	11072.44	11036.59	11070.13	12337.0
2020-02-10 21:00:00	NQ	Futures	11070.13	11084.88	11068.4	11070.71	9080.0
2020-02-10 22:00:00	NQ	Futures	11070.71	11075.05	11064.93	11071.58	4077.0
2020-02-10 23:00:00	NQ	Futures	11071.29	11073.31	11065.22	11071.29	2198.0
2020-02-10 00:00:00	YM	Futures	31609.5	31647.6	31601.8	31636.7	3154.0
2020-02-10 01:00:00	YM	Futures	31635.6	31672.6	31622.5	31656.3	3525.0
2020-02-10 02:00:00	YM	Futures	31657.4	31672.6	31616.0	31617.1	4743.0
2020-02-10 03:00:00	YM	Futures	31616.0	31651.9	31539.8	31576.8	9435.0

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

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