PREVIEW / futures_1hour / 2020-08-06

all futures 1-hour files

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

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-08-06 00:00:00	ES	Futures	3704.17	3706.4	3700.54	3704.72	6985.0
2020-08-06 01:00:00	ES	Futures	3704.44	3709.19	3704.17	3705.56	10039.0
2020-08-06 02:00:00	ES	Futures	3705.56	3710.03	3705.56	3709.47	10307.0
2020-08-06 03:00:00	ES	Futures	3709.47	3717.57	3704.17	3711.43	29665.0
2020-08-06 04:00:00	ES	Futures	3711.43	3711.43	3703.05	3705.56	21096.0
2020-08-06 05:00:00	ES	Futures	3705.28	3708.63	3704.44	3708.35	12730.0
2020-08-06 06:00:00	ES	Futures	3708.35	3708.63	3691.88	3694.39	24361.0
2020-08-06 07:00:00	ES	Futures	3694.11	3698.86	3686.57	3691.6	33180.0
2020-08-06 08:00:00	ES	Futures	3691.6	3706.12	3687.69	3704.44	45556.0
2020-08-06 09:00:00	ES	Futures	3704.44	3711.43	3700.54	3710.59	158383.0
2020-08-06 10:00:00	ES	Futures	3710.59	3714.78	3697.74	3705.0	188608.0
2020-08-06 11:00:00	ES	Futures	3705.0	3707.8	3699.42	3703.89	158763.0
2020-08-06 12:00:00	ES	Futures	3703.89	3712.54	3703.05	3712.26	102377.0
2020-08-06 13:00:00	ES	Futures	3712.54	3717.57	3710.59	3716.73	61013.0
2020-08-06 14:00:00	ES	Futures	3716.45	3731.53	3716.45	3729.86	119468.0
2020-08-06 15:00:00	ES	Futures	3730.13	3735.16	3726.78	3733.49	239163.0
2020-08-06 16:00:00	ES	Futures	3733.77	3736.84	3732.93	3735.16	50114.0
2020-08-06 18:00:00	ES	Futures	3734.88	3735.44	3731.25	3732.65	5029.0
2020-08-06 19:00:00	ES	Futures	3732.37	3733.77	3730.69	3731.53	4646.0
2020-08-06 20:00:00	ES	Futures	3731.53	3738.79	3728.46	3734.04	17348.0
2020-08-06 21:00:00	ES	Futures	3734.04	3734.88	3728.46	3732.65	13658.0
2020-08-06 22:00:00	ES	Futures	3732.65	3733.49	3719.8	3723.15	22541.0
2020-08-06 23:00:00	ES	Futures	3723.15	3723.43	3714.22	3716.17	17260.0
2020-08-06 00:00:00	NQ	Futures	12819.28	12826.51	12803.09	12820.44	3985.0
2020-08-06 01:00:00	NQ	Futures	12820.44	12835.19	12816.39	12822.75	4176.0
2020-08-06 02:00:00	NQ	Futures	12822.75	12840.39	12819.28	12831.14	4570.0
2020-08-06 03:00:00	NQ	Futures	12831.14	12872.49	12820.44	12843.29	10629.0
2020-08-06 04:00:00	NQ	Futures	12842.71	12842.71	12818.13	12828.83	7467.0
2020-08-06 05:00:00	NQ	Futures	12827.96	12841.55	12821.89	12835.48	4818.0
2020-08-06 06:00:00	NQ	Futures	12835.19	12836.35	12787.76	12797.89	7988.0
2020-08-06 07:00:00	NQ	Futures	12797.6	12822.47	12783.14	12812.92	11381.0
2020-08-06 08:00:00	NQ	Futures	12812.63	12856.3	12798.46	12846.18	16227.0
2020-08-06 09:00:00	NQ	Futures	12846.18	12862.95	12808.3	12860.35	55149.0
2020-08-06 10:00:00	NQ	Futures	12860.06	12893.89	12817.55	12854.56	58441.0
2020-08-06 11:00:00	NQ	Futures	12854.28	12886.37	12846.18	12869.6	45317.0
2020-08-06 12:00:00	NQ	Futures	12869.6	12925.41	12865.55	12923.97	35037.0
2020-08-06 13:00:00	NQ	Futures	12923.97	12952.89	12910.66	12948.84	24322.0
2020-08-06 14:00:00	NQ	Futures	12948.84	13020.55	12947.68	13012.17	42659.0
2020-08-06 15:00:00	NQ	Futures	13012.74	13038.19	12993.95	13017.95	52704.0
2020-08-06 16:00:00	NQ	Futures	13018.24	13031.25	13011.3	13022.29	8196.0
2020-08-06 18:00:00	NQ	Futures	13025.18	13028.36	13011.3	13014.48	1987.0
2020-08-06 19:00:00	NQ	Futures	13014.19	13021.71	13009.27	13015.64	1559.0
2020-08-06 20:00:00	NQ	Futures	13015.93	13051.49	13004.65	13034.43	5193.0
2020-08-06 21:00:00	NQ	Futures	13034.43	13038.48	13011.59	13024.31	4882.0
2020-08-06 22:00:00	NQ	Futures	13024.31	13030.1	12977.47	12994.24	6807.0
2020-08-06 23:00:00	NQ	Futures	12994.24	12995.97	12945.94	12949.41	7870.0
2020-08-06 00:00:00	YM	Futures	29829.9	29846.4	29797.9	29833.2	1372.0
2020-08-06 01:00:00	YM	Futures	29832.1	29880.5	29829.9	29854.1	2068.0
2020-08-06 02:00:00	YM	Futures	29853.0	29893.7	29850.8	29892.6	2483.0
2020-08-06 03:00:00	YM	Futures	29891.5	29943.3	29825.5	29890.4	5858.0

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

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