PREVIEW / futures_1hour / 2020-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-22.parquet
  size:    61 KB
  rows:    1,871

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-10-22 00:00:00	ES	Futures	3815.45	3820.21	3815.17	3817.97	5588.0
2020-10-22 01:00:00	ES	Futures	3817.97	3831.41	3817.13	3823.57	11532.0
2020-10-22 02:00:00	ES	Futures	3823.57	3831.13	3823.01	3826.37	10897.0
2020-10-22 03:00:00	ES	Futures	3826.37	3831.41	3817.69	3830.85	30088.0
2020-10-22 04:00:00	ES	Futures	3830.85	3840.38	3828.33	3835.05	27999.0
2020-10-22 05:00:00	ES	Futures	3835.05	3837.01	3831.97	3834.49	14584.0
2020-10-22 06:00:00	ES	Futures	3834.77	3842.06	3829.17	3838.42	26904.0
2020-10-22 07:00:00	ES	Futures	3838.42	3842.06	3835.33	3840.66	14290.0
2020-10-22 08:00:00	ES	Futures	3840.66	3844.58	3834.21	3836.73	45288.0
2020-10-22 09:00:00	ES	Futures	3836.73	3852.14	3835.05	3848.22	136002.0
2020-10-22 10:00:00	ES	Futures	3848.22	3850.18	3816.85	3834.49	310484.0
2020-10-22 11:00:00	ES	Futures	3834.21	3847.66	3832.81	3835.33	194619.0
2020-10-22 12:00:00	ES	Futures	3835.33	3846.54	3831.41	3844.86	108426.0
2020-10-22 13:00:00	ES	Futures	3844.86	3860.82	3843.46	3858.3	136966.0
2020-10-22 14:00:00	ES	Futures	3858.58	3866.42	3857.46	3859.7	85324.0
2020-10-22 15:00:00	ES	Futures	3859.7	3868.67	3853.54	3862.5	172453.0
2020-10-22 16:00:00	ES	Futures	3862.22	3866.7	3858.58	3865.86	42858.0
2020-10-22 18:00:00	ES	Futures	3871.75	3873.15	3868.67	3870.07	7248.0
2020-10-22 19:00:00	ES	Futures	3870.07	3870.63	3862.78	3867.26	7454.0
2020-10-22 20:00:00	ES	Futures	3867.54	3867.82	3857.74	3863.62	10310.0
2020-10-22 21:00:00	ES	Futures	3863.9	3864.46	3855.22	3860.54	8670.0
2020-10-22 22:00:00	ES	Futures	3860.54	3867.26	3856.34	3866.7	7177.0
2020-10-22 23:00:00	ES	Futures	3866.7	3870.07	3866.14	3868.11	6283.0
2020-10-22 00:00:00	NQ	Futures	13442.64	13456.82	13435.4	13442.64	2486.0
2020-10-22 01:00:00	NQ	Futures	13441.48	13491.56	13433.66	13454.79	6018.0
2020-10-22 02:00:00	NQ	Futures	13454.79	13486.06	13454.51	13462.32	5721.0
2020-10-22 03:00:00	NQ	Futures	13462.32	13482.0	13437.14	13481.14	8212.0
2020-10-22 04:00:00	NQ	Futures	13480.27	13515.58	13471.0	13490.98	6254.0
2020-10-22 05:00:00	NQ	Futures	13492.14	13505.74	13481.14	13497.93	3511.0
2020-10-22 06:00:00	NQ	Futures	13498.21	13532.08	13472.45	13519.93	7291.0
2020-10-22 07:00:00	NQ	Futures	13520.21	13527.16	13503.43	13522.24	4608.0
2020-10-22 08:00:00	NQ	Futures	13521.08	13543.66	13502.56	13508.64	17485.0
2020-10-22 09:00:00	NQ	Futures	13508.93	13574.92	13506.32	13519.06	59804.0
2020-10-22 10:00:00	NQ	Futures	13518.19	13526.0	13328.3	13391.69	124274.0
2020-10-22 11:00:00	NQ	Futures	13391.11	13451.03	13370.85	13410.22	79308.0
2020-10-22 12:00:00	NQ	Futures	13409.93	13443.79	13367.66	13437.14	56983.0
2020-10-22 13:00:00	NQ	Futures	13436.85	13510.66	13428.16	13493.29	64154.0
2020-10-22 14:00:00	NQ	Futures	13493.58	13517.03	13475.64	13490.98	38520.0
2020-10-22 15:00:00	NQ	Futures	13491.27	13529.77	13457.69	13494.16	50793.0
2020-10-22 16:00:00	NQ	Futures	13494.74	13512.69	13466.37	13496.77	9128.0
2020-10-22 18:00:00	NQ	Futures	13511.53	13526.87	13503.14	13512.69	2839.0
2020-10-22 19:00:00	NQ	Futures	13512.69	13517.9	13479.4	13505.45	3071.0
2020-10-22 20:00:00	NQ	Futures	13505.45	13508.64	13479.4	13494.16	3201.0
2020-10-22 21:00:00	NQ	Futures	13494.74	13497.64	13461.45	13476.22	3910.0
2020-10-22 22:00:00	NQ	Futures	13475.64	13511.24	13457.98	13510.37	3614.0
2020-10-22 23:00:00	NQ	Futures	13510.08	13522.53	13506.61	13512.11	2639.0
2020-10-22 00:00:00	YM	Futures	30871.1	30902.1	30860.0	30892.1	701.0
2020-10-22 01:00:00	YM	Futures	30888.8	30982.8	30881.1	30928.6	1954.0
2020-10-22 02:00:00	YM	Futures	30928.6	30989.4	30928.6	30956.2	1776.0
2020-10-22 03:00:00	YM	Futures	30955.1	30996.0	30881.1	30990.5	3991.0

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

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