PREVIEW / futures_1hour / 2022-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-27.parquet
  size:    69 KB
  rows:    2,084

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
2022-01-27 00:00:00	ES	Futures	4843.83	4854.86	4831.39	4847.79	18312.0
2022-01-27 01:00:00	ES	Futures	4847.23	4860.52	4827.43	4842.99	17965.0
2022-01-27 02:00:00	ES	Futures	4843.27	4873.53	4842.99	4862.78	28590.0
2022-01-27 03:00:00	ES	Futures	4863.06	4898.13	4861.65	4897.0	40773.0
2022-01-27 04:00:00	ES	Futures	4896.72	4923.02	4890.21	4917.36	39561.0
2022-01-27 05:00:00	ES	Futures	4917.08	4926.98	4888.23	4893.04	29560.0
2022-01-27 06:00:00	ES	Futures	4893.04	4923.02	4892.76	4922.17	27564.0
2022-01-27 07:00:00	ES	Futures	4922.17	4930.65	4899.83	4923.02	43162.0
2022-01-27 08:00:00	ES	Futures	4923.58	4951.3	4920.76	4950.17	68839.0
2022-01-27 09:00:00	ES	Futures	4949.89	4998.24	4947.91	4986.65	244174.0
2022-01-27 10:00:00	ES	Futures	4986.65	5002.2	4937.16	4974.21	299790.0
2022-01-27 11:00:00	ES	Futures	4974.21	4987.78	4949.6	4971.1	191407.0
2022-01-27 12:00:00	ES	Futures	4971.1	4972.51	4898.42	4915.1	229701.0
2022-01-27 13:00:00	ES	Futures	4915.1	4920.76	4870.13	4892.19	223470.0
2022-01-27 14:00:00	ES	Futures	4891.91	4917.93	4867.87	4882.3	196038.0
2022-01-27 15:00:00	ES	Futures	4882.58	4914.82	4862.78	4884.28	289143.0
2022-01-27 16:00:00	ES	Futures	4884.28	4914.82	4878.62	4913.97	75960.0
2022-01-27 18:00:00	ES	Futures	4918.49	4925.0	4904.07	4904.35	20399.0
2022-01-27 19:00:00	ES	Futures	4904.35	4912.84	4888.8	4908.6	20236.0
2022-01-27 20:00:00	ES	Futures	4908.31	4918.49	4899.26	4908.31	17170.0
2022-01-27 21:00:00	ES	Futures	4908.6	4927.26	4902.94	4925.56	13044.0
2022-01-27 22:00:00	ES	Futures	4925.85	4927.83	4908.6	4909.73	10770.0
2022-01-27 23:00:00	ES	Futures	4910.01	4914.25	4900.11	4901.81	10795.0
2022-01-27 00:00:00	NQ	Futures	16150.93	16198.46	16090.94	16152.96	11536.0
2022-01-27 01:00:00	NQ	Futures	16152.09	16208.89	16093.26	16141.66	11449.0
2022-01-27 02:00:00	NQ	Futures	16142.82	16248.6	16141.37	16199.33	16088.0
2022-01-27 03:00:00	NQ	Futures	16200.78	16374.67	16197.3	16369.74	24216.0
2022-01-27 04:00:00	NQ	Futures	16369.45	16497.84	16341.34	16473.5	20601.0
2022-01-27 05:00:00	NQ	Futures	16473.79	16513.49	16317.29	16340.76	16705.0
2022-01-27 06:00:00	NQ	Futures	16339.31	16487.12	16337.57	16481.03	17422.0
2022-01-27 07:00:00	NQ	Futures	16484.22	16536.97	16409.45	16499.58	21932.0
2022-01-27 08:00:00	NQ	Futures	16498.13	16583.34	16472.34	16574.35	31569.0
2022-01-27 09:00:00	NQ	Futures	16573.19	16689.7	16498.71	16642.17	96861.0
2022-01-27 10:00:00	NQ	Futures	16642.75	16704.19	16437.56	16572.61	114227.0
2022-01-27 11:00:00	NQ	Futures	16572.03	16638.69	16494.65	16572.61	73025.0
2022-01-27 12:00:00	NQ	Futures	16572.9	16577.25	16317.87	16400.75	70756.0
2022-01-27 13:00:00	NQ	Futures	16399.3	16430.31	16206.87	16313.52	68140.0
2022-01-27 14:00:00	NQ	Futures	16312.07	16408.58	16191.5	16241.35	63874.0
2022-01-27 15:00:00	NQ	Futures	16241.64	16355.25	16166.0	16215.85	74646.0
2022-01-27 16:00:00	NQ	Futures	16216.14	16362.5	16169.48	16361.63	27326.0
2022-01-27 18:00:00	NQ	Futures	16424.23	16442.49	16340.18	16342.21	11295.0
2022-01-27 19:00:00	NQ	Futures	16341.05	16391.19	16289.75	16371.77	11627.0
2022-01-27 20:00:00	NQ	Futures	16370.61	16412.64	16323.08	16354.38	10783.0
2022-01-27 21:00:00	NQ	Futures	16356.12	16437.27	16330.04	16425.1	9105.0
2022-01-27 22:00:00	NQ	Futures	16425.39	16440.75	16361.92	16369.16	8848.0
2022-01-27 23:00:00	NQ	Futures	16370.61	16389.74	16330.62	16341.63	6917.0
2022-01-27 00:00:00	YM	Futures	37815.9	37888.9	37751.8	37853.0	3969.0
2022-01-27 01:00:00	YM	Futures	37850.7	37941.7	37713.6	37819.2	4362.0
2022-01-27 02:00:00	YM	Futures	37820.4	38028.3	37820.4	37964.2	9534.0
2022-01-27 03:00:00	YM	Futures	37966.5	38166.5	37950.7	38159.8	12698.0

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

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