PREVIEW / futures_1hour / 2020-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-30.parquet
  size:    54 KB
  rows:    1,549

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-30 00:00:00	ES	Futures	3667.84	3671.2	3661.4	3663.36	6219.0
2020-10-30 01:00:00	ES	Futures	3663.08	3664.76	3627.22	3627.78	34852.0
2020-10-30 02:00:00	ES	Futures	3627.78	3631.43	3614.34	3622.74	35070.0
2020-10-30 03:00:00	ES	Futures	3623.02	3640.67	3622.74	3633.11	29207.0
2020-10-30 04:00:00	ES	Futures	3633.39	3654.11	3632.83	3643.19	51430.0
2020-10-30 05:00:00	ES	Futures	3643.19	3672.04	3640.67	3665.6	41151.0
2020-10-30 06:00:00	ES	Futures	3665.6	3675.96	3660.27	3674.84	34283.0
2020-10-30 07:00:00	ES	Futures	3674.56	3686.88	3670.08	3671.76	33413.0
2020-10-30 08:00:00	ES	Futures	3672.04	3679.32	3657.19	3674.56	44034.0
2020-10-30 09:00:00	ES	Futures	3674.28	3693.05	3660.84	3673.72	214937.0
2020-10-30 10:00:00	ES	Futures	3673.44	3680.16	3620.22	3620.5	371601.0
2020-10-30 11:00:00	ES	Futures	3620.5	3645.71	3620.22	3638.15	253592.0
2020-10-30 12:00:00	ES	Futures	3637.87	3659.71	3634.23	3639.55	166857.0
2020-10-30 13:00:00	ES	Futures	3639.55	3645.99	3621.34	3634.51	162205.0
2020-10-30 14:00:00	ES	Futures	3634.51	3647.67	3613.22	3625.26	230534.0
2020-10-30 15:00:00	ES	Futures	3625.54	3661.68	3617.14	3658.31	523256.0
2020-10-30 16:00:00	ES	Futures	3658.31	3677.64	3655.79	3672.88	118840.0
2020-10-30 00:00:00	NQ	Futures	12973.12	12983.25	12951.12	12956.33	3655.0
2020-10-30 01:00:00	NQ	Futures	12956.33	12964.15	12809.86	12818.83	13112.0
2020-10-30 02:00:00	NQ	Futures	12819.41	12840.83	12782.36	12807.25	10330.0
2020-10-30 03:00:00	NQ	Futures	12807.54	12867.46	12801.17	12841.7	8209.0
2020-10-30 04:00:00	NQ	Futures	12841.99	12907.12	12840.83	12869.2	12486.0
2020-10-30 05:00:00	NQ	Futures	12869.78	12962.99	12858.49	12944.46	11168.0
2020-10-30 06:00:00	NQ	Futures	12944.46	13011.33	12929.12	12998.59	11758.0
2020-10-30 07:00:00	NQ	Futures	12996.86	13022.33	12982.96	13002.36	9311.0
2020-10-30 08:00:00	NQ	Futures	13001.49	13035.35	12945.33	13016.54	18841.0
2020-10-30 09:00:00	NQ	Futures	13016.25	13062.28	12889.17	12928.83	84254.0
2020-10-30 10:00:00	NQ	Futures	12928.25	12956.62	12723.02	12724.47	128988.0
2020-10-30 11:00:00	NQ	Futures	12724.75	12813.33	12714.04	12742.41	101165.0
2020-10-30 12:00:00	NQ	Futures	12742.12	12849.52	12729.68	12763.54	71205.0
2020-10-30 13:00:00	NQ	Futures	12762.96	12789.89	12689.44	12722.44	61958.0
2020-10-30 14:00:00	NQ	Futures	12721.86	12769.62	12672.36	12703.91	70741.0
2020-10-30 15:00:00	NQ	Futures	12703.62	12808.99	12672.94	12800.6	112334.0
2020-10-30 16:00:00	NQ	Futures	12800.88	12848.94	12793.07	12839.67	28041.0
2020-10-30 00:00:00	YM	Futures	29146.3	29172.9	29080.0	29095.5	1967.0
2020-10-30 01:00:00	YM	Futures	29093.3	29106.5	28825.7	28835.7	9815.0
2020-10-30 02:00:00	YM	Futures	28834.6	28866.6	28694.1	28778.2	11768.0
2020-10-30 03:00:00	YM	Futures	28777.1	28906.4	28776.0	28837.9	8583.0
2020-10-30 04:00:00	YM	Futures	28839.0	29001.5	28833.4	28909.7	12191.0
2020-10-30 05:00:00	YM	Futures	28909.7	29149.7	28890.9	29105.4	9815.0
2020-10-30 06:00:00	YM	Futures	29105.4	29167.3	29028.0	29151.9	6074.0
2020-10-30 07:00:00	YM	Futures	29148.6	29259.1	29119.8	29135.3	5618.0
2020-10-30 08:00:00	YM	Futures	29135.3	29176.2	29024.7	29129.8	6569.0
2020-10-30 09:00:00	YM	Futures	29127.5	29317.7	29087.7	29191.7	26132.0
2020-10-30 10:00:00	YM	Futures	29189.5	29247.0	28791.4	28793.6	38024.0
2020-10-30 11:00:00	YM	Futures	28794.8	28996.0	28791.4	28986.0	29635.0
2020-10-30 12:00:00	YM	Futures	28983.8	29136.4	28959.5	28992.7	18794.0
2020-10-30 13:00:00	YM	Futures	28991.6	29041.3	28839.0	28949.5	18707.0
2020-10-30 14:00:00	YM	Futures	28955.1	29060.1	28772.6	28873.3	26030.0
2020-10-30 15:00:00	YM	Futures	28874.4	29207.1	28834.6	29183.9	42908.0

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

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