PREVIEW / futures_1hour / 2023-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-08.parquet
  size:    65 KB
  rows:    2,020

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-06-08 00:00:00	ES	Futures	4737.47	4737.47	4729.15	4731.65	13962.0
2023-06-08 01:00:00	ES	Futures	4731.65	4738.03	4730.54	4736.92	11200.0
2023-06-08 02:00:00	ES	Futures	4736.64	4736.64	4731.37	4734.14	11731.0
2023-06-08 03:00:00	ES	Futures	4734.14	4741.08	4731.93	4738.86	25115.0
2023-06-08 04:00:00	ES	Futures	4739.14	4745.52	4737.47	4742.74	13178.0
2023-06-08 05:00:00	ES	Futures	4743.02	4745.52	4741.08	4744.41	9543.0
2023-06-08 06:00:00	ES	Futures	4744.68	4746.9	4740.52	4740.52	10124.0
2023-06-08 07:00:00	ES	Futures	4740.52	4742.74	4737.2	4741.63	17529.0
2023-06-08 08:00:00	ES	Futures	4741.36	4747.18	4735.53	4743.58	42922.0
2023-06-08 09:00:00	ES	Futures	4743.3	4745.79	4731.09	4738.86	233920.0
2023-06-08 10:00:00	ES	Futures	4738.58	4755.78	4736.36	4755.22	249028.0
2023-06-08 11:00:00	ES	Futures	4755.22	4759.38	4753.01	4755.22	152996.0
2023-06-08 12:00:00	ES	Futures	4755.5	4768.81	4752.17	4762.44	137663.0
2023-06-08 13:00:00	ES	Futures	4762.44	4764.65	4752.17	4757.72	119528.0
2023-06-08 14:00:00	ES	Futures	4758.0	4767.7	4755.5	4766.32	115858.0
2023-06-08 15:00:00	ES	Futures	4766.32	4773.25	4764.1	4767.98	206533.0
2023-06-08 16:00:00	ES	Futures	4767.98	4770.2	4764.65	4768.54	52260.0
2023-06-08 18:00:00	ES	Futures	4767.98	4767.98	4764.65	4766.6	3051.0
2023-06-08 19:00:00	ES	Futures	4766.32	4767.15	4764.1	4764.65	2868.0
2023-06-08 20:00:00	ES	Futures	4764.65	4765.21	4761.05	4762.71	5942.0
2023-06-08 21:00:00	ES	Futures	4762.99	4764.1	4761.88	4763.54	2845.0
2023-06-08 22:00:00	ES	Futures	4763.82	4764.1	4762.16	4764.1	2752.0
2023-06-08 23:00:00	ES	Futures	4763.82	4766.04	4763.54	4765.21	3174.0
2023-06-08 00:00:00	NQ	Futures	16113.0	16114.41	16059.5	16072.45	9414.0
2023-06-08 01:00:00	NQ	Futures	16072.74	16097.23	16065.42	16085.41	6616.0
2023-06-08 02:00:00	NQ	Futures	16084.28	16084.28	16056.12	16069.08	7303.0
2023-06-08 03:00:00	NQ	Futures	16069.64	16112.15	16061.47	16095.82	9880.0
2023-06-08 04:00:00	NQ	Futures	16096.1	16143.69	16091.88	16131.02	9358.0
2023-06-08 05:00:00	NQ	Futures	16130.74	16158.05	16128.48	16155.23	7267.0
2023-06-08 06:00:00	NQ	Futures	16156.08	16164.8	16132.71	16139.75	6912.0
2023-06-08 07:00:00	NQ	Futures	16138.62	16145.66	16114.97	16127.92	9145.0
2023-06-08 08:00:00	NQ	Futures	16128.2	16185.92	16091.32	16171.56	29990.0
2023-06-08 09:00:00	NQ	Futures	16171.0	16214.08	16136.37	16193.24	109621.0
2023-06-08 10:00:00	NQ	Futures	16193.52	16284.18	16178.88	16282.21	95871.0
2023-06-08 11:00:00	NQ	Futures	16282.21	16346.69	16278.27	16323.88	71407.0
2023-06-08 12:00:00	NQ	Futures	16324.16	16356.54	16297.13	16309.52	55363.0
2023-06-08 13:00:00	NQ	Futures	16309.8	16322.19	16241.1	16270.39	51907.0
2023-06-08 14:00:00	NQ	Futures	16270.67	16318.25	16257.72	16312.06	41541.0
2023-06-08 15:00:00	NQ	Futures	16312.06	16347.53	16306.71	16329.79	55411.0
2023-06-08 16:00:00	NQ	Futures	16329.79	16360.2	16320.78	16354.01	13942.0
2023-06-08 18:00:00	NQ	Futures	16349.22	16353.16	16334.3	16341.62	1872.0
2023-06-08 19:00:00	NQ	Futures	16341.62	16347.25	16326.41	16330.64	2232.0
2023-06-08 20:00:00	NQ	Futures	16330.64	16333.74	16310.93	16316.84	3200.0
2023-06-08 21:00:00	NQ	Futures	16316.28	16325.85	16312.06	16318.25	2080.0
2023-06-08 22:00:00	NQ	Futures	16317.97	16333.17	16312.06	16331.2	1948.0
2023-06-08 23:00:00	NQ	Futures	16330.92	16336.55	16325.57	16330.07	1791.0
2023-06-08 00:00:00	YM	Futures	37210.2	37211.3	37177.0	37194.7	2749.0
2023-06-08 01:00:00	YM	Futures	37195.8	37246.7	37185.9	37241.2	2619.0
2023-06-08 02:00:00	YM	Futures	37241.2	37248.9	37203.6	37230.1	3087.0
2023-06-08 03:00:00	YM	Futures	37229.0	37278.7	37216.8	37262.2	6443.0

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

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