PREVIEW / futures_1hour / 2023-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-16.parquet
  size:    54 KB
  rows:    1,653

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
2023-01-16 00:00:00	ES	Futures	4499.43	4499.71	4495.51	4496.63	3442.0
2023-01-16 01:00:00	ES	Futures	4496.63	4496.91	4489.92	4492.16	4565.0
2023-01-16 02:00:00	ES	Futures	4492.16	4492.16	4488.52	4491.04	4689.0
2023-01-16 03:00:00	ES	Futures	4491.04	4491.32	4472.59	4475.1	14811.0
2023-01-16 04:00:00	ES	Futures	4475.1	4477.62	4470.07	4471.47	11777.0
2023-01-16 05:00:00	ES	Futures	4471.47	4482.93	4471.47	4482.09	9258.0
2023-01-16 06:00:00	ES	Futures	4482.37	4487.69	4481.25	4484.33	8280.0
2023-01-16 07:00:00	ES	Futures	4484.05	4485.45	4479.3	4484.33	6231.0
2023-01-16 08:00:00	ES	Futures	4484.05	4492.16	4483.77	4490.48	9307.0
2023-01-16 09:00:00	ES	Futures	4490.48	4495.23	4489.08	4493.56	12159.0
2023-01-16 10:00:00	ES	Futures	4493.28	4496.63	4491.32	4494.12	10390.0
2023-01-16 11:00:00	ES	Futures	4493.84	4495.23	4485.45	4487.13	11079.0
2023-01-16 12:00:00	ES	Futures	4487.41	4490.48	4482.93	4484.61	8780.0
2023-01-16 18:00:00	ES	Futures	4484.89	4491.88	4484.61	4488.24	5956.0
2023-01-16 19:00:00	ES	Futures	4488.24	4493.28	4484.05	4489.08	6612.0
2023-01-16 20:00:00	ES	Futures	4489.08	4491.04	4481.81	4482.93	6369.0
2023-01-16 21:00:00	ES	Futures	4482.93	4487.13	4477.34	4480.42	7203.0
2023-01-16 22:00:00	ES	Futures	4480.42	4482.65	4477.34	4480.14	4430.0
2023-01-16 23:00:00	ES	Futures	4480.14	4482.09	4478.46	4479.58	2791.0
2023-01-16 00:00:00	NQ	Futures	13220.72	13222.72	13203.94	13206.5	1620.0
2023-01-16 01:00:00	NQ	Futures	13207.07	13208.49	13181.75	13190.28	2603.0
2023-01-16 02:00:00	NQ	Futures	13190.28	13190.85	13177.76	13190.57	2042.0
2023-01-16 03:00:00	NQ	Futures	13190.28	13190.57	13123.43	13129.97	8096.0
2023-01-16 04:00:00	NQ	Futures	13129.97	13134.52	13098.39	13103.8	8314.0
2023-01-16 05:00:00	NQ	Futures	13104.37	13149.32	13103.23	13147.04	5210.0
2023-01-16 06:00:00	NQ	Futures	13147.32	13180.04	13144.76	13158.42	6218.0
2023-01-16 07:00:00	NQ	Futures	13158.42	13169.23	13149.88	13164.96	4157.0
2023-01-16 08:00:00	NQ	Futures	13165.25	13196.83	13162.97	13186.3	6303.0
2023-01-16 09:00:00	NQ	Futures	13186.3	13213.33	13183.17	13199.96	8563.0
2023-01-16 10:00:00	NQ	Futures	13199.96	13209.91	13180.04	13195.12	6809.0
2023-01-16 11:00:00	NQ	Futures	13195.4	13199.1	13162.4	13167.81	5344.0
2023-01-16 12:00:00	NQ	Futures	13166.95	13183.17	13155.57	13159.56	4743.0
2023-01-16 18:00:00	NQ	Futures	13166.39	13198.53	13165.25	13183.74	3402.0
2023-01-16 19:00:00	NQ	Futures	13183.45	13202.8	13165.25	13186.58	4088.0
2023-01-16 20:00:00	NQ	Futures	13185.73	13190.85	13144.76	13151.88	4905.0
2023-01-16 21:00:00	NQ	Futures	13152.16	13167.24	13134.52	13145.9	3778.0
2023-01-16 22:00:00	NQ	Futures	13145.9	13152.16	13135.66	13146.47	2891.0
2023-01-16 23:00:00	NQ	Futures	13146.19	13150.74	13137.94	13138.79	2025.0
2023-01-16 00:00:00	YM	Futures	38386.9	38392.5	38363.5	38371.3	534.0
2023-01-16 01:00:00	YM	Futures	38371.3	38373.5	38329.0	38342.3	762.0
2023-01-16 02:00:00	YM	Futures	38341.2	38341.2	38310.0	38332.3	1122.0
2023-01-16 03:00:00	YM	Futures	38332.3	38342.3	38218.7	38248.7	2208.0
2023-01-16 04:00:00	YM	Futures	38246.5	38273.3	38227.6	38229.8	1614.0
2023-01-16 05:00:00	YM	Futures	38228.7	38296.7	38228.7	38291.1	1172.0
2023-01-16 06:00:00	YM	Futures	38288.9	38313.4	38285.5	38302.2	836.0
2023-01-16 07:00:00	YM	Futures	38298.9	38305.6	38262.1	38291.1	812.0
2023-01-16 08:00:00	YM	Futures	38290.0	38351.3	38283.3	38342.3	1487.0
2023-01-16 09:00:00	YM	Futures	38343.5	38373.5	38334.5	38350.1	2010.0
2023-01-16 10:00:00	YM	Futures	38349.0	38375.8	38336.8	38364.6	1676.0
2023-01-16 11:00:00	YM	Futures	38362.4	38373.5	38324.5	38325.6	1390.0

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

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