PREVIEW / futures_1hour / 2020-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-29.parquet
  size:    64 KB
  rows:    1,905

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-29 00:00:00	ES	Futures	3694.73	3697.25	3693.89	3696.13	4804.0
2020-10-29 01:00:00	ES	Futures	3696.13	3697.81	3693.89	3697.53	8158.0
2020-10-29 02:00:00	ES	Futures	3697.81	3709.29	3695.85	3699.49	14018.0
2020-10-29 03:00:00	ES	Futures	3699.49	3700.05	3679.6	3688.28	25974.0
2020-10-29 04:00:00	ES	Futures	3688.28	3698.37	3678.48	3684.36	45533.0
2020-10-29 05:00:00	ES	Futures	3684.36	3693.89	3681.28	3686.88	26362.0
2020-10-29 06:00:00	ES	Futures	3686.88	3686.88	3675.96	3679.88	26786.0
2020-10-29 07:00:00	ES	Futures	3679.6	3680.44	3647.67	3649.07	50059.0
2020-10-29 08:00:00	ES	Futures	3649.35	3671.48	3649.35	3664.48	66616.0
2020-10-29 09:00:00	ES	Futures	3664.2	3678.2	3641.51	3672.32	245685.0
2020-10-29 10:00:00	ES	Futures	3672.6	3694.45	3663.64	3687.72	258080.0
2020-10-29 11:00:00	ES	Futures	3687.44	3695.29	3671.76	3678.76	175970.0
2020-10-29 12:00:00	ES	Futures	3679.04	3693.33	3673.72	3687.44	133219.0
2020-10-29 13:00:00	ES	Futures	3687.72	3714.05	3680.44	3713.49	167323.0
2020-10-29 14:00:00	ES	Futures	3713.49	3735.06	3712.93	3720.22	193659.0
2020-10-29 15:00:00	ES	Futures	3720.5	3726.1	3695.85	3696.97	294056.0
2020-10-29 16:00:00	ES	Futures	3696.97	3709.85	3664.48	3669.8	121253.0
2020-10-29 18:00:00	ES	Futures	3661.4	3668.68	3657.19	3663.92	15944.0
2020-10-29 19:00:00	ES	Futures	3664.2	3676.24	3663.64	3670.36	11463.0
2020-10-29 20:00:00	ES	Futures	3670.64	3672.88	3660.27	3661.4	15421.0
2020-10-29 21:00:00	ES	Futures	3661.12	3669.52	3659.43	3668.12	12893.0
2020-10-29 22:00:00	ES	Futures	3668.12	3670.64	3663.08	3663.64	7422.0
2020-10-29 23:00:00	ES	Futures	3663.36	3668.96	3663.36	3667.84	4758.0
2020-10-29 00:00:00	NQ	Futures	13019.72	13030.43	13014.8	13024.07	2819.0
2020-10-29 01:00:00	NQ	Futures	13024.64	13031.88	13016.25	13030.14	3732.0
2020-10-29 02:00:00	NQ	Futures	13029.28	13079.35	13022.04	13052.14	7397.0
2020-10-29 03:00:00	NQ	Futures	13052.43	13054.17	12982.38	13021.75	10526.0
2020-10-29 04:00:00	NQ	Futures	13021.17	13059.67	13002.93	13025.22	14677.0
2020-10-29 05:00:00	NQ	Futures	13025.22	13069.8	13022.33	13038.54	7504.0
2020-10-29 06:00:00	NQ	Futures	13038.25	13039.12	12994.25	13022.62	8095.0
2020-10-29 07:00:00	NQ	Futures	13022.62	13024.07	12904.51	12910.3	15205.0
2020-10-29 08:00:00	NQ	Futures	12911.17	12991.36	12911.17	12969.07	25879.0
2020-10-29 09:00:00	NQ	Futures	12969.36	13051.56	12934.04	13038.83	73123.0
2020-10-29 10:00:00	NQ	Futures	13039.12	13092.38	13022.04	13067.2	80956.0
2020-10-29 11:00:00	NQ	Futures	13066.62	13125.09	13041.14	13065.17	64243.0
2020-10-29 12:00:00	NQ	Futures	13065.75	13123.35	13050.7	13105.7	45733.0
2020-10-29 13:00:00	NQ	Futures	13105.98	13184.72	13092.67	13180.38	47981.0
2020-10-29 14:00:00	NQ	Futures	13180.38	13266.64	13178.35	13207.88	53641.0
2020-10-29 15:00:00	NQ	Futures	13208.75	13243.77	13111.2	13112.64	66854.0
2020-10-29 16:00:00	NQ	Futures	13113.22	13237.4	12991.36	13020.01	40526.0
2020-10-29 18:00:00	NQ	Futures	12983.54	13002.64	12940.7	12962.99	8829.0
2020-10-29 19:00:00	NQ	Futures	12962.99	13012.2	12961.83	12984.41	6181.0
2020-10-29 20:00:00	NQ	Futures	12984.99	12989.62	12918.7	12925.36	6932.0
2020-10-29 21:00:00	NQ	Futures	12927.67	12973.99	12923.04	12969.93	5740.0
2020-10-29 22:00:00	NQ	Futures	12969.65	12985.28	12946.78	12952.28	4971.0
2020-10-29 23:00:00	NQ	Futures	12952.86	12982.09	12951.7	12973.12	2276.0
2020-10-29 00:00:00	YM	Futures	29497.9	29533.3	29491.3	29524.5	1430.0
2020-10-29 01:00:00	YM	Futures	29525.6	29531.1	29495.7	29515.6	2152.0
2020-10-29 02:00:00	YM	Futures	29513.4	29633.9	29502.3	29535.5	4164.0
2020-10-29 03:00:00	YM	Futures	29535.5	29546.6	29340.9	29422.7	8321.0

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

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