PREVIEW / futures_1hour / 2020-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-02.parquet
  size:    61 KB
  rows:    1,888

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-12-02 00:00:00	ES	Futures	4092.74	4092.74	4086.86	4087.98	7295.0
2020-12-02 01:00:00	ES	Futures	4088.26	4097.22	4087.98	4096.66	8877.0
2020-12-02 02:00:00	ES	Futures	4096.38	4098.34	4092.18	4093.3	10671.0
2020-12-02 03:00:00	ES	Futures	4093.02	4093.58	4085.18	4091.9	18802.0
2020-12-02 04:00:00	ES	Futures	4092.18	4097.5	4090.78	4093.86	9258.0
2020-12-02 05:00:00	ES	Futures	4094.14	4097.5	4093.58	4096.94	10119.0
2020-12-02 06:00:00	ES	Futures	4096.94	4097.22	4090.22	4096.1	9425.0
2020-12-02 07:00:00	ES	Futures	4095.82	4095.82	4082.38	4087.42	20574.0
2020-12-02 08:00:00	ES	Futures	4087.42	4090.78	4084.9	4089.38	21524.0
2020-12-02 09:00:00	ES	Futures	4089.38	4095.26	4080.7	4094.14	177671.0
2020-12-02 10:00:00	ES	Futures	4094.14	4099.74	4089.1	4097.5	146621.0
2020-12-02 11:00:00	ES	Futures	4097.22	4105.35	4097.22	4103.66	103508.0
2020-12-02 12:00:00	ES	Futures	4103.38	4105.91	4099.74	4101.7	69655.0
2020-12-02 13:00:00	ES	Futures	4101.42	4104.78	4096.66	4097.5	56825.0
2020-12-02 14:00:00	ES	Futures	4097.22	4110.39	4094.98	4109.27	107814.0
2020-12-02 15:00:00	ES	Futures	4108.99	4111.51	4103.1	4109.55	143194.0
2020-12-02 16:00:00	ES	Futures	4109.55	4114.87	4109.27	4112.07	39358.0
2020-12-02 18:00:00	ES	Futures	4112.91	4115.71	4107.31	4108.43	7867.0
2020-12-02 19:00:00	ES	Futures	4108.43	4108.99	4104.78	4106.19	5952.0
2020-12-02 20:00:00	ES	Futures	4106.19	4112.07	4104.78	4109.55	9830.0
2020-12-02 21:00:00	ES	Futures	4109.55	4110.67	4105.35	4110.39	5700.0
2020-12-02 22:00:00	ES	Futures	4110.39	4116.83	4108.99	4111.79	9106.0
2020-12-02 23:00:00	ES	Futures	4111.79	4112.35	4102.26	4103.38	8492.0
2020-12-02 00:00:00	NQ	Futures	14401.65	14402.23	14366.91	14383.41	3675.0
2020-12-02 01:00:00	NQ	Futures	14383.7	14418.73	14383.7	14411.2	2844.0
2020-12-02 02:00:00	NQ	Futures	14410.33	14413.23	14383.12	14388.62	3647.0
2020-12-02 03:00:00	NQ	Futures	14388.33	14424.8	14370.38	14412.07	6839.0
2020-12-02 04:00:00	NQ	Futures	14411.2	14415.54	14399.33	14406.57	2892.0
2020-12-02 05:00:00	NQ	Futures	14406.57	14414.38	14393.25	14411.49	2606.0
2020-12-02 06:00:00	NQ	Futures	14411.2	14415.25	14382.25	14401.07	3700.0
2020-12-02 07:00:00	NQ	Futures	14401.07	14402.23	14348.67	14367.2	7250.0
2020-12-02 08:00:00	NQ	Futures	14366.91	14379.94	14348.67	14361.99	13998.0
2020-12-02 09:00:00	NQ	Futures	14361.7	14362.86	14256.33	14329.28	80794.0
2020-12-02 10:00:00	NQ	Futures	14328.99	14400.2	14315.39	14372.41	66851.0
2020-12-02 11:00:00	NQ	Futures	14372.12	14425.96	14372.12	14424.23	43122.0
2020-12-02 12:00:00	NQ	Futures	14424.23	14440.73	14391.52	14398.46	35727.0
2020-12-02 13:00:00	NQ	Futures	14398.75	14428.28	14370.96	14385.44	27632.0
2020-12-02 14:00:00	NQ	Futures	14386.02	14427.12	14373.86	14426.25	28403.0
2020-12-02 15:00:00	NQ	Futures	14426.25	14439.57	14395.28	14423.94	38478.0
2020-12-02 16:00:00	NQ	Futures	14424.51	14441.01	14421.33	14429.73	8123.0
2020-12-02 18:00:00	NQ	Futures	14441.01	14457.51	14430.88	14435.8	3471.0
2020-12-02 19:00:00	NQ	Futures	14434.65	14443.33	14427.41	14433.49	2101.0
2020-12-02 20:00:00	NQ	Futures	14433.49	14455.78	14425.67	14446.51	2864.0
2020-12-02 21:00:00	NQ	Futures	14446.51	14447.67	14421.91	14441.59	2710.0
2020-12-02 22:00:00	NQ	Futures	14442.17	14470.54	14438.12	14449.99	4004.0
2020-12-02 23:00:00	NQ	Futures	14450.86	14452.01	14428.57	14436.38	2399.0
2020-12-02 00:00:00	YM	Futures	32825.8	32828.1	32790.5	32793.8	1417.0
2020-12-02 01:00:00	YM	Futures	32796.0	32875.6	32791.6	32872.3	1834.0
2020-12-02 02:00:00	YM	Futures	32872.3	32897.7	32844.6	32845.7	2797.0
2020-12-02 03:00:00	YM	Futures	32843.5	32848.0	32762.8	32821.4	5169.0

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

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