PREVIEW / futures_1hour / 2023-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-02.parquet
  size:    68 KB
  rows:    2,062

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-08-02 00:00:00	ES	Futures	5029.6	5030.42	5026.85	5027.68	8750.0
2023-08-02 01:00:00	ES	Futures	5027.95	5033.72	5026.03	5029.6	13076.0
2023-08-02 02:00:00	ES	Futures	5029.32	5029.87	5023.01	5024.38	22802.0
2023-08-02 03:00:00	ES	Futures	5024.38	5026.3	5008.74	5009.01	43073.0
2023-08-02 04:00:00	ES	Futures	5008.74	5010.11	4998.58	5009.28	43939.0
2023-08-02 05:00:00	ES	Futures	5009.28	5015.87	5004.89	5014.23	33726.0
2023-08-02 06:00:00	ES	Futures	5013.95	5028.5	5013.68	5028.5	31668.0
2023-08-02 07:00:00	ES	Futures	5028.23	5032.89	5025.21	5027.13	30058.0
2023-08-02 08:00:00	ES	Futures	5026.85	5029.87	5018.07	5019.72	49909.0
2023-08-02 09:00:00	ES	Futures	5019.99	5020.26	5005.44	5012.3	221948.0
2023-08-02 10:00:00	ES	Futures	5012.58	5013.68	4983.75	4986.5	290762.0
2023-08-02 11:00:00	ES	Futures	4986.23	4997.75	4982.38	4982.66	207831.0
2023-08-02 12:00:00	ES	Futures	4982.38	4991.44	4978.81	4988.7	169360.0
2023-08-02 13:00:00	ES	Futures	4988.42	4995.01	4984.3	4985.4	106106.0
2023-08-02 14:00:00	ES	Futures	4985.68	4991.17	4982.11	4985.95	113429.0
2023-08-02 15:00:00	ES	Futures	4986.23	4989.24	4971.68	4981.01	296313.0
2023-08-02 16:00:00	ES	Futures	4981.28	4984.58	4976.34	4979.09	74991.0
2023-08-02 18:00:00	ES	Futures	4978.81	4988.15	4978.81	4987.6	7019.0
2023-08-02 19:00:00	ES	Futures	4987.6	4989.52	4986.77	4989.24	4646.0
2023-08-02 20:00:00	ES	Futures	4988.97	4990.89	4982.93	4987.6	9690.0
2023-08-02 21:00:00	ES	Futures	4987.6	4993.36	4985.68	4989.79	10040.0
2023-08-02 22:00:00	ES	Futures	4990.07	4990.34	4982.11	4984.3	9828.0
2023-08-02 23:00:00	ES	Futures	4984.3	4988.15	4983.48	4987.87	5249.0
2023-08-02 00:00:00	NQ	Futures	17497.23	17500.01	17478.6	17486.38	3700.0
2023-08-02 01:00:00	NQ	Futures	17485.83	17501.68	17470.81	17481.1	6592.0
2023-08-02 02:00:00	NQ	Futures	17481.38	17487.22	17435.48	17441.6	9366.0
2023-08-02 03:00:00	NQ	Futures	17441.6	17455.23	17383.75	17384.03	14689.0
2023-08-02 04:00:00	NQ	Futures	17384.03	17396.82	17344.54	17394.04	18979.0
2023-08-02 05:00:00	NQ	Futures	17394.32	17415.74	17375.13	17401.83	12856.0
2023-08-02 06:00:00	NQ	Futures	17401.83	17459.4	17399.33	17458.01	13147.0
2023-08-02 07:00:00	NQ	Futures	17457.74	17488.61	17455.51	17465.52	15183.0
2023-08-02 08:00:00	NQ	Futures	17464.97	17479.99	17422.69	17444.39	23368.0
2023-08-02 09:00:00	NQ	Futures	17444.66	17444.94	17334.8	17356.5	112719.0
2023-08-02 10:00:00	NQ	Futures	17357.33	17366.23	17227.72	17234.12	114336.0
2023-08-02 11:00:00	NQ	Futures	17233.84	17270.28	17184.61	17186.28	88521.0
2023-08-02 12:00:00	NQ	Futures	17186.0	17226.89	17148.45	17221.32	76531.0
2023-08-02 13:00:00	NQ	Futures	17221.32	17254.14	17199.63	17209.64	53815.0
2023-08-02 14:00:00	NQ	Futures	17209.92	17260.26	17206.86	17234.95	43846.0
2023-08-02 15:00:00	NQ	Futures	17234.95	17251.64	17168.76	17208.81	86690.0
2023-08-02 16:00:00	NQ	Futures	17208.81	17221.6	17184.33	17189.62	18951.0
2023-08-02 18:00:00	NQ	Futures	17194.9	17233.01	17189.62	17232.45	4599.0
2023-08-02 19:00:00	NQ	Futures	17232.45	17242.46	17226.33	17234.95	3644.0
2023-08-02 20:00:00	NQ	Futures	17234.67	17244.13	17204.64	17233.28	5892.0
2023-08-02 21:00:00	NQ	Futures	17233.01	17252.47	17222.99	17233.01	5051.0
2023-08-02 22:00:00	NQ	Futures	17233.01	17236.06	17197.4	17208.53	5442.0
2023-08-02 23:00:00	NQ	Futures	17208.81	17221.6	17199.91	17219.1	2964.0
2023-08-02 00:00:00	YM	Futures	39047.4	39054.0	39033.2	39039.8	882.0
2023-08-02 01:00:00	YM	Futures	39039.8	39075.9	39034.3	39056.2	1598.0
2023-08-02 02:00:00	YM	Futures	39056.2	39056.2	39025.5	39036.5	3039.0
2023-08-02 03:00:00	YM	Futures	39036.5	39040.8	38912.7	38918.1	4715.0

> showing 50 of 2,062 rows — these rows as CSV

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