PREVIEW / futures_1hour / 2022-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-23.parquet
  size:    59 KB
  rows:    1,645

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
2022-09-23 00:00:00	ES	Futures	4246.73	4247.85	4235.73	4239.12	11722.0
2022-09-23 01:00:00	ES	Futures	4239.12	4251.8	4238.83	4246.73	10074.0
2022-09-23 02:00:00	ES	Futures	4246.73	4254.34	4242.5	4243.91	13363.0
2022-09-23 03:00:00	ES	Futures	4243.63	4244.75	4229.53	4236.02	33937.0
2022-09-23 04:00:00	ES	Futures	4236.3	4241.65	4225.02	4225.58	33059.0
2022-09-23 05:00:00	ES	Futures	4225.87	4227.28	4208.11	4219.67	42397.0
2022-09-23 06:00:00	ES	Futures	4219.67	4219.95	4192.32	4193.17	46233.0
2022-09-23 07:00:00	ES	Futures	4193.45	4202.19	4190.91	4199.65	62303.0
2022-09-23 08:00:00	ES	Futures	4199.93	4204.44	4188.94	4194.58	65663.0
2022-09-23 09:00:00	ES	Futures	4194.29	4216.56	4178.23	4179.35	361123.0
2022-09-23 10:00:00	ES	Futures	4179.35	4190.91	4174.0	4175.13	397227.0
2022-09-23 11:00:00	ES	Futures	4175.13	4190.91	4159.9	4167.8	302685.0
2022-09-23 12:00:00	ES	Futures	4167.8	4168.92	4144.96	4166.11	249402.0
2022-09-23 13:00:00	ES	Futures	4165.82	4171.74	4152.57	4159.9	205666.0
2022-09-23 14:00:00	ES	Futures	4160.19	4165.82	4127.2	4129.74	277393.0
2022-09-23 15:00:00	ES	Futures	4129.46	4184.71	4128.61	4180.48	558694.0
2022-09-23 16:00:00	ES	Futures	4180.48	4187.53	4175.69	4184.99	89544.0
2022-09-23 00:00:00	NQ	Futures	13258.37	13262.96	13216.99	13231.36	6859.0
2022-09-23 01:00:00	NQ	Futures	13231.07	13278.19	13229.92	13257.5	6677.0
2022-09-23 02:00:00	NQ	Futures	13257.22	13283.94	13247.16	13254.06	6769.0
2022-09-23 03:00:00	NQ	Futures	13254.34	13256.93	13200.33	13237.1	14827.0
2022-09-23 04:00:00	NQ	Futures	13237.68	13256.07	13183.37	13185.39	12694.0
2022-09-23 05:00:00	NQ	Futures	13185.67	13191.13	13123.32	13164.7	15009.0
2022-09-23 06:00:00	NQ	Futures	13164.7	13166.13	13083.1	13089.71	17652.0
2022-09-23 07:00:00	NQ	Futures	13089.42	13122.46	13078.5	13115.56	23121.0
2022-09-23 08:00:00	NQ	Futures	13114.7	13135.96	13094.3	13113.84	23682.0
2022-09-23 09:00:00	NQ	Futures	13113.84	13196.3	13044.88	13048.62	113464.0
2022-09-23 10:00:00	NQ	Futures	13049.48	13123.9	13031.09	13077.35	105056.0
2022-09-23 11:00:00	NQ	Futures	13077.06	13132.52	13029.37	13057.24	79687.0
2022-09-23 12:00:00	NQ	Futures	13057.52	13064.42	12983.97	13050.92	72158.0
2022-09-23 13:00:00	NQ	Futures	13051.2	13069.88	12995.75	13021.03	53632.0
2022-09-23 14:00:00	NQ	Futures	13021.03	13040.29	12905.53	12914.72	80588.0
2022-09-23 15:00:00	NQ	Futures	12914.44	13085.97	12910.99	13071.89	115962.0
2022-09-23 16:00:00	NQ	Futures	13071.89	13094.59	13066.14	13088.27	18889.0
2022-09-23 00:00:00	YM	Futures	33794.9	33802.8	33718.6	33742.2	2054.0
2022-09-23 01:00:00	YM	Futures	33741.1	33824.1	33738.8	33794.9	1450.0
2022-09-23 02:00:00	YM	Futures	33792.7	33846.6	33761.3	33773.6	2063.0
2022-09-23 03:00:00	YM	Futures	33772.5	33781.5	33665.9	33705.2	6002.0
2022-09-23 04:00:00	YM	Futures	33704.0	33743.3	33641.2	33649.1	4694.0
2022-09-23 05:00:00	YM	Futures	33646.8	33659.2	33515.5	33590.7	6304.0
2022-09-23 06:00:00	YM	Futures	33588.5	33591.8	33383.1	33390.9	6371.0
2022-09-23 07:00:00	YM	Futures	33389.8	33456.0	33383.1	33445.9	8330.0
2022-09-23 08:00:00	YM	Futures	33444.8	33476.2	33339.3	33380.8	8670.0
2022-09-23 09:00:00	YM	Futures	33380.8	33532.3	33365.1	33377.5	33983.0
2022-09-23 10:00:00	YM	Futures	33376.4	33442.6	33294.4	33301.2	23497.0
2022-09-23 11:00:00	YM	Futures	33300.0	33396.6	33169.9	33205.8	17915.0
2022-09-23 12:00:00	YM	Futures	33204.6	33208.0	33016.1	33171.0	16870.0
2022-09-23 13:00:00	YM	Futures	33171.0	33227.1	33093.5	33144.0	13342.0
2022-09-23 14:00:00	YM	Futures	33144.0	33184.4	32898.3	32914.0	18918.0
2022-09-23 15:00:00	YM	Futures	32915.1	33314.6	32907.3	33288.8	31199.0

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

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