PREVIEW / futures_1hour / 2023-11-02

all futures 1-hour files

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

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-11-02 00:00:00	ES	Futures	4635.23	4635.5	4632.79	4633.87	3755.0
2023-11-02 01:00:00	ES	Futures	4633.87	4634.69	4632.51	4633.33	4008.0
2023-11-02 02:00:00	ES	Futures	4633.06	4634.14	4629.26	4632.51	6420.0
2023-11-02 03:00:00	ES	Futures	4632.51	4635.77	4630.34	4635.77	9024.0
2023-11-02 04:00:00	ES	Futures	4635.77	4646.64	4633.06	4644.46	32646.0
2023-11-02 05:00:00	ES	Futures	4644.73	4650.17	4644.46	4646.36	27854.0
2023-11-02 06:00:00	ES	Futures	4646.36	4647.99	4642.83	4646.64	23365.0
2023-11-02 07:00:00	ES	Futures	4646.64	4651.52	4645.55	4649.08	26625.0
2023-11-02 08:00:00	ES	Futures	4648.81	4668.63	4646.91	4667.0	82323.0
2023-11-02 09:00:00	ES	Futures	4667.0	4680.31	4660.76	4674.06	260540.0
2023-11-02 10:00:00	ES	Futures	4674.06	4694.43	4666.19	4694.16	265344.0
2023-11-02 11:00:00	ES	Futures	4694.43	4694.7	4681.12	4688.18	185779.0
2023-11-02 12:00:00	ES	Futures	4688.46	4696.87	4684.38	4691.99	137891.0
2023-11-02 13:00:00	ES	Futures	4691.99	4708.55	4689.81	4704.75	141130.0
2023-11-02 14:00:00	ES	Futures	4705.02	4706.92	4698.5	4704.75	112289.0
2023-11-02 15:00:00	ES	Futures	4704.48	4711.81	4702.58	4710.18	264370.0
2023-11-02 16:00:00	ES	Futures	4709.91	4713.98	4698.77	4706.92	91591.0
2023-11-02 18:00:00	ES	Futures	4700.68	4706.38	4698.5	4702.3	10752.0
2023-11-02 19:00:00	ES	Futures	4702.3	4703.39	4700.13	4700.95	4175.0
2023-11-02 20:00:00	ES	Futures	4701.22	4704.21	4700.13	4703.39	7742.0
2023-11-02 21:00:00	ES	Futures	4703.39	4706.92	4702.03	4706.11	6611.0
2023-11-02 22:00:00	ES	Futures	4706.38	4708.01	4705.83	4707.46	5355.0
2023-11-02 23:00:00	ES	Futures	4707.46	4708.55	4705.56	4705.56	4193.0
2023-11-02 00:00:00	NQ	Futures	16265.89	16270.56	16260.12	16265.61	1973.0
2023-11-02 01:00:00	NQ	Futures	16265.06	16267.81	16257.37	16259.57	2252.0
2023-11-02 02:00:00	NQ	Futures	16259.3	16264.51	16238.97	16252.98	4340.0
2023-11-02 03:00:00	NQ	Futures	16252.98	16283.19	16246.66	16282.64	7165.0
2023-11-02 04:00:00	NQ	Futures	16282.09	16310.38	16267.81	16301.87	13508.0
2023-11-02 05:00:00	NQ	Futures	16302.42	16329.06	16301.59	16314.23	11668.0
2023-11-02 06:00:00	NQ	Futures	16313.68	16334.0	16310.11	16327.96	9448.0
2023-11-02 07:00:00	NQ	Futures	16327.69	16354.06	16321.92	16346.64	12975.0
2023-11-02 08:00:00	NQ	Futures	16346.91	16428.76	16338.12	16420.25	40488.0
2023-11-02 09:00:00	NQ	Futures	16420.8	16427.67	16370.81	16388.11	98872.0
2023-11-02 10:00:00	NQ	Futures	16386.74	16441.4	16336.48	16434.53	101750.0
2023-11-02 11:00:00	NQ	Futures	16435.08	16449.09	16399.92	16413.93	69184.0
2023-11-02 12:00:00	NQ	Futures	16414.21	16445.52	16394.98	16428.21	49850.0
2023-11-02 13:00:00	NQ	Futures	16428.49	16479.3	16417.23	16472.71	50350.0
2023-11-02 14:00:00	NQ	Futures	16472.71	16488.64	16453.48	16478.48	40503.0
2023-11-02 15:00:00	NQ	Futures	16478.48	16489.19	16465.02	16479.3	63832.0
2023-11-02 16:00:00	NQ	Futures	16479.03	16498.8	16406.24	16447.44	32565.0
2023-11-02 18:00:00	NQ	Futures	16400.75	16437.83	16398.0	16420.52	6296.0
2023-11-02 19:00:00	NQ	Futures	16421.35	16428.76	16414.21	16417.5	2233.0
2023-11-02 20:00:00	NQ	Futures	16418.33	16430.41	16410.91	16426.84	3247.0
2023-11-02 21:00:00	NQ	Futures	16426.29	16440.57	16422.72	16435.91	3628.0
2023-11-02 22:00:00	NQ	Futures	16435.63	16442.77	16430.96	16439.48	2635.0
2023-11-02 23:00:00	NQ	Futures	16440.03	16442.77	16432.88	16432.88	1802.0
2023-11-02 00:00:00	YM	Futures	36202.8	36203.9	36183.3	36190.9	519.0
2023-11-02 01:00:00	YM	Futures	36189.8	36197.4	36181.1	36186.5	795.0
2023-11-02 02:00:00	YM	Futures	36185.5	36200.6	36170.3	36189.8	2698.0
2023-11-02 03:00:00	YM	Futures	36188.7	36207.2	36181.1	36205.0	2356.0

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

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