PREVIEW / futures_1hour / 2024-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2024/2024-06-19.parquet
  size:    52 KB
  rows:    1,644

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
2024-06-19 00:00:00	ES	Futures	5831.84	5832.1	5830.26	5831.05	1360.0
2024-06-19 01:00:00	ES	Futures	5831.31	5834.46	5830.79	5833.41	2455.0
2024-06-19 02:00:00	ES	Futures	5833.67	5836.29	5833.15	5834.46	5044.0
2024-06-19 03:00:00	ES	Futures	5834.46	5836.29	5831.05	5834.46	8321.0
2024-06-19 04:00:00	ES	Futures	5834.46	5836.29	5832.36	5833.15	6155.0
2024-06-19 05:00:00	ES	Futures	5833.15	5836.29	5832.89	5834.72	5182.0
2024-06-19 06:00:00	ES	Futures	5834.98	5836.56	5833.67	5836.29	4427.0
2024-06-19 07:00:00	ES	Futures	5836.29	5837.34	5834.46	5835.25	5106.0
2024-06-19 08:00:00	ES	Futures	5835.51	5836.03	5834.2	5834.72	4680.0
2024-06-19 09:00:00	ES	Futures	5834.98	5837.34	5834.2	5834.46	11203.0
2024-06-19 10:00:00	ES	Futures	5834.46	5835.51	5830.53	5833.67	12166.0
2024-06-19 11:00:00	ES	Futures	5833.67	5834.46	5832.89	5833.67	6706.0
2024-06-19 12:00:00	ES	Futures	5833.67	5833.93	5831.84	5832.36	3981.0
2024-06-19 18:00:00	ES	Futures	5832.62	5834.72	5831.57	5831.84	2347.0
2024-06-19 19:00:00	ES	Futures	5831.57	5833.93	5831.31	5833.67	1302.0
2024-06-19 20:00:00	ES	Futures	5833.41	5837.6	5833.41	5836.82	3336.0
2024-06-19 21:00:00	ES	Futures	5836.82	5839.7	5836.82	5838.13	3624.0
2024-06-19 22:00:00	ES	Futures	5838.13	5838.39	5836.03	5837.08	2346.0
2024-06-19 23:00:00	ES	Futures	5837.08	5843.11	5836.82	5841.8	3728.0
2024-06-19 00:00:00	NQ	Futures	21350.9	21354.34	21344.31	21348.53	1019.0
2024-06-19 01:00:00	NQ	Futures	21348.79	21357.24	21345.63	21353.28	1593.0
2024-06-19 02:00:00	NQ	Futures	21353.28	21372.55	21349.32	21367.54	3613.0
2024-06-19 03:00:00	NQ	Futures	21367.54	21370.7	21356.45	21366.22	3876.0
2024-06-19 04:00:00	NQ	Futures	21366.22	21371.23	21354.34	21360.94	3313.0
2024-06-19 05:00:00	NQ	Futures	21360.41	21371.5	21359.62	21368.33	2687.0
2024-06-19 06:00:00	NQ	Futures	21368.33	21376.51	21362.52	21374.4	2664.0
2024-06-19 07:00:00	NQ	Futures	21374.66	21377.83	21365.69	21367.54	2799.0
2024-06-19 08:00:00	NQ	Futures	21367.27	21380.21	21362.78	21374.14	3704.0
2024-06-19 09:00:00	NQ	Futures	21374.4	21385.22	21367.01	21370.18	10589.0
2024-06-19 10:00:00	NQ	Futures	21369.91	21374.14	21354.6	21368.86	9651.0
2024-06-19 11:00:00	NQ	Futures	21369.12	21380.73	21367.8	21376.51	6387.0
2024-06-19 12:00:00	NQ	Futures	21376.51	21376.51	21359.35	21362.52	4599.0
2024-06-19 18:00:00	NQ	Futures	21363.58	21373.34	21358.82	21359.35	1778.0
2024-06-19 19:00:00	NQ	Futures	21359.09	21370.18	21359.09	21367.8	1267.0
2024-06-19 20:00:00	NQ	Futures	21367.8	21389.97	21366.48	21383.64	3816.0
2024-06-19 21:00:00	NQ	Futures	21383.11	21401.06	21382.05	21394.46	3278.0
2024-06-19 22:00:00	NQ	Futures	21394.46	21399.21	21389.18	21393.93	2131.0
2024-06-19 23:00:00	NQ	Futures	21394.2	21428.52	21392.88	21425.08	4520.0
2024-06-19 00:00:00	YM	Futures	41245.3	41250.5	41236.9	41241.1	288.0
2024-06-19 01:00:00	YM	Futures	41242.1	41269.4	41237.9	41263.1	527.0
2024-06-19 02:00:00	YM	Futures	41264.2	41277.8	41256.8	41261.0	837.0
2024-06-19 03:00:00	YM	Futures	41260.0	41279.9	41232.7	41253.7	1057.0
2024-06-19 04:00:00	YM	Futures	41254.7	41258.9	41232.7	41246.3	1075.0
2024-06-19 05:00:00	YM	Futures	41245.3	41270.5	41245.3	41257.9	655.0
2024-06-19 06:00:00	YM	Futures	41256.8	41261.0	41239.0	41257.9	722.0
2024-06-19 07:00:00	YM	Futures	41260.0	41274.7	41246.3	41267.3	657.0
2024-06-19 08:00:00	YM	Futures	41268.4	41271.5	41246.3	41248.4	530.0
2024-06-19 09:00:00	YM	Futures	41249.5	41269.4	41230.6	41237.9	1811.0
2024-06-19 10:00:00	YM	Futures	41235.8	41239.0	41201.1	41222.2	2058.0
2024-06-19 11:00:00	YM	Futures	41221.1	41226.4	41207.4	41207.4	1580.0

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

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