PREVIEW / futures_1hour / 2023-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-19.parquet
  size:    66 KB
  rows:    2,051

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-12-19 00:00:00	ES	Futures	5149.96	5151.3	5149.69	5151.03	2820.0
2023-12-19 01:00:00	ES	Futures	5150.76	5151.84	5148.34	5149.42	4212.0
2023-12-19 02:00:00	ES	Futures	5149.42	5151.84	5149.15	5149.42	7328.0
2023-12-19 03:00:00	ES	Futures	5149.42	5155.06	5149.42	5152.91	11892.0
2023-12-19 04:00:00	ES	Futures	5152.64	5155.6	5152.1	5152.91	8646.0
2023-12-19 05:00:00	ES	Futures	5152.91	5154.25	5151.57	5153.18	7115.0
2023-12-19 06:00:00	ES	Futures	5152.91	5155.87	5151.03	5153.72	9579.0
2023-12-19 07:00:00	ES	Futures	5153.72	5161.51	5153.18	5160.16	20593.0
2023-12-19 08:00:00	ES	Futures	5160.43	5161.24	5156.94	5158.01	22140.0
2023-12-19 09:00:00	ES	Futures	5158.01	5166.34	5153.18	5164.46	158271.0
2023-12-19 10:00:00	ES	Futures	5164.46	5170.91	5159.36	5170.91	187400.0
2023-12-19 11:00:00	ES	Futures	5170.64	5175.2	5168.22	5168.76	114842.0
2023-12-19 12:00:00	ES	Futures	5169.03	5171.98	5165.8	5170.37	82919.0
2023-12-19 13:00:00	ES	Futures	5170.37	5173.59	5165.8	5171.71	93295.0
2023-12-19 14:00:00	ES	Futures	5171.71	5174.4	5169.56	5171.44	69278.0
2023-12-19 15:00:00	ES	Futures	5171.71	5180.04	5167.95	5178.7	178896.0
2023-12-19 16:00:00	ES	Futures	5178.7	5180.04	5173.86	5176.55	54769.0
2023-12-19 18:00:00	ES	Futures	5176.82	5178.16	5175.47	5175.74	4912.0
2023-12-19 19:00:00	ES	Futures	5175.74	5177.89	5175.74	5176.55	5039.0
2023-12-19 20:00:00	ES	Futures	5176.82	5178.96	5176.01	5178.7	4383.0
2023-12-19 21:00:00	ES	Futures	5178.43	5180.31	5177.62	5179.77	2812.0
2023-12-19 22:00:00	ES	Futures	5179.77	5182.19	5179.77	5180.58	4848.0
2023-12-19 23:00:00	ES	Futures	5180.31	5181.38	5178.7	5180.84	3825.0
2023-12-19 00:00:00	NQ	Futures	18364.15	18370.38	18363.06	18367.4	2100.0
2023-12-19 01:00:00	NQ	Futures	18367.4	18371.2	18352.76	18360.35	3494.0
2023-12-19 02:00:00	NQ	Futures	18360.62	18371.2	18355.2	18359.54	4258.0
2023-12-19 03:00:00	NQ	Futures	18359.54	18386.66	18359.54	18377.71	6849.0
2023-12-19 04:00:00	NQ	Futures	18377.71	18388.28	18372.28	18381.23	5806.0
2023-12-19 05:00:00	NQ	Futures	18380.69	18386.66	18377.71	18383.94	3373.0
2023-12-19 06:00:00	NQ	Futures	18384.49	18402.39	18375.54	18392.89	7747.0
2023-12-19 07:00:00	NQ	Futures	18392.62	18430.32	18387.2	18411.06	14093.0
2023-12-19 08:00:00	NQ	Futures	18410.79	18412.96	18388.83	18397.23	12316.0
2023-12-19 09:00:00	NQ	Futures	18397.23	18437.1	18381.77	18421.1	87536.0
2023-12-19 10:00:00	NQ	Futures	18421.37	18450.12	18392.35	18442.8	88979.0
2023-12-19 11:00:00	NQ	Futures	18443.34	18455.54	18421.1	18422.46	54108.0
2023-12-19 12:00:00	NQ	Futures	18422.73	18444.69	18404.56	18435.74	38260.0
2023-12-19 13:00:00	NQ	Futures	18435.74	18447.41	18404.28	18434.66	38939.0
2023-12-19 14:00:00	NQ	Futures	18435.2	18452.02	18432.76	18441.71	28334.0
2023-12-19 15:00:00	NQ	Futures	18442.25	18471.81	18425.17	18464.76	56957.0
2023-12-19 16:00:00	NQ	Futures	18464.49	18473.98	18457.98	18470.19	14685.0
2023-12-19 18:00:00	NQ	Futures	18468.02	18478.05	18463.95	18471.81	3072.0
2023-12-19 19:00:00	NQ	Futures	18471.81	18483.75	18471.81	18479.14	3613.0
2023-12-19 20:00:00	NQ	Futures	18478.87	18484.56	18473.71	18483.21	3193.0
2023-12-19 21:00:00	NQ	Futures	18482.66	18489.71	18478.32	18487.0	2397.0
2023-12-19 22:00:00	NQ	Futures	18487.0	18491.61	18481.85	18484.83	3868.0
2023-12-19 23:00:00	NQ	Futures	18484.56	18487.54	18478.05	18486.46	2370.0
2023-12-19 00:00:00	YM	Futures	40459.4	40470.2	40455.1	40466.9	403.0
2023-12-19 01:00:00	YM	Futures	40468.0	40474.5	40454.1	40460.5	615.0
2023-12-19 02:00:00	YM	Futures	40461.6	40474.5	40456.2	40457.3	1349.0
2023-12-19 03:00:00	YM	Futures	40457.3	40495.9	40457.3	40477.7	1732.0

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

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