PREVIEW / futures_1hour / 2021-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-01.parquet
  size:    59 KB
  rows:    1,760

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
2021-04-01 00:00:00	ES	Futures	4459.55	4461.51	4457.86	4460.11	3313.0
2021-04-01 01:00:00	ES	Futures	4460.11	4464.04	4459.26	4461.79	5893.0
2021-04-01 02:00:00	ES	Futures	4461.51	4468.82	4460.67	4468.54	10218.0
2021-04-01 03:00:00	ES	Futures	4468.54	4474.16	4464.88	4473.03	21069.0
2021-04-01 04:00:00	ES	Futures	4473.31	4476.97	4471.91	4476.68	16927.0
2021-04-01 05:00:00	ES	Futures	4476.4	4478.09	4473.31	4473.87	12076.0
2021-04-01 06:00:00	ES	Futures	4474.16	4474.16	4469.1	4469.1	9122.0
2021-04-01 07:00:00	ES	Futures	4469.1	4476.4	4469.1	4475.56	17209.0
2021-04-01 08:00:00	ES	Futures	4475.84	4479.21	4474.44	4478.37	21682.0
2021-04-01 09:00:00	ES	Futures	4478.37	4485.96	4476.12	4481.74	175846.0
2021-04-01 10:00:00	ES	Futures	4482.02	4492.14	4480.06	4492.14	189165.0
2021-04-01 11:00:00	ES	Futures	4492.14	4496.07	4488.48	4490.73	127845.0
2021-04-01 12:00:00	ES	Futures	4490.73	4498.32	4490.17	4497.2	88140.0
2021-04-01 13:00:00	ES	Futures	4497.2	4498.32	4492.42	4496.35	78059.0
2021-04-01 14:00:00	ES	Futures	4496.35	4500.0	4495.51	4499.44	57574.0
2021-04-01 15:00:00	ES	Futures	4499.16	4507.87	4493.54	4506.19	225595.0
2021-04-01 16:00:00	ES	Futures	4506.19	4512.65	4505.91	4511.52	63979.0
2021-04-01 18:00:00	ES	Futures	4511.81	4512.65	4509.56	4512.37	3866.0
2021-04-01 19:00:00	ES	Futures	4512.37	4514.62	4512.09	4513.49	3029.0
2021-04-01 20:00:00	ES	Futures	4513.77	4514.05	4512.65	4513.49	5169.0
2021-04-01 21:00:00	ES	Futures	4513.77	4514.62	4512.37	4513.21	2744.0
2021-04-01 22:00:00	ES	Futures	4512.93	4514.62	4511.81	4513.77	3262.0
2021-04-01 23:00:00	ES	Futures	4513.77	4514.05	4513.21	4514.05	1607.0
2021-04-01 00:00:00	NQ	Futures	15195.03	15207.19	15190.98	15199.95	2046.0
2021-04-01 01:00:00	NQ	Futures	15199.08	15222.82	15194.74	15212.69	3463.0
2021-04-01 02:00:00	NQ	Futures	15212.98	15258.43	15208.63	15248.01	6520.0
2021-04-01 03:00:00	NQ	Futures	15248.01	15311.41	15239.03	15305.04	10795.0
2021-04-01 04:00:00	NQ	Futures	15305.62	15327.33	15275.8	15301.85	11110.0
2021-04-01 05:00:00	NQ	Futures	15301.85	15319.51	15289.11	15303.88	6272.0
2021-04-01 06:00:00	NQ	Futures	15304.46	15305.04	15284.19	15289.69	3816.0
2021-04-01 07:00:00	NQ	Futures	15288.54	15320.67	15287.67	15307.64	6541.0
2021-04-01 08:00:00	NQ	Futures	15309.09	15338.91	15309.09	15328.2	11290.0
2021-04-01 09:00:00	NQ	Futures	15327.33	15403.47	15326.17	15391.89	64513.0
2021-04-01 10:00:00	NQ	Futures	15391.89	15426.05	15356.86	15405.78	75057.0
2021-04-01 11:00:00	NQ	Futures	15405.78	15417.65	15359.17	15372.2	51020.0
2021-04-01 12:00:00	NQ	Futures	15373.07	15404.62	15365.83	15396.81	31100.0
2021-04-01 13:00:00	NQ	Futures	15397.39	15405.2	15354.83	15379.73	31057.0
2021-04-01 14:00:00	NQ	Futures	15379.73	15412.15	15372.49	15402.89	24854.0
2021-04-01 15:00:00	NQ	Futures	15402.89	15424.02	15374.52	15418.23	49698.0
2021-04-01 16:00:00	NQ	Futures	15417.65	15438.78	15416.2	15432.7	11947.0
2021-04-01 18:00:00	NQ	Futures	15436.47	15442.84	15430.68	15437.34	1684.0
2021-04-01 19:00:00	NQ	Futures	15437.34	15458.47	15433.86	15453.84	2671.0
2021-04-01 20:00:00	NQ	Futures	15454.71	15468.6	15452.39	15453.84	3722.0
2021-04-01 21:00:00	NQ	Futures	15453.26	15461.94	15448.34	15452.39	1794.0
2021-04-01 22:00:00	NQ	Futures	15452.68	15484.81	15449.78	15477.29	4244.0
2021-04-01 23:00:00	NQ	Futures	15477.0	15477.87	15465.42	15469.76	1636.0
2021-04-01 00:00:00	YM	Futures	36600.1	36611.2	36584.5	36606.8	791.0
2021-04-01 01:00:00	YM	Futures	36605.6	36631.3	36599.0	36614.6	1564.0
2021-04-01 02:00:00	YM	Futures	36612.3	36672.5	36604.5	36665.8	2368.0
2021-04-01 03:00:00	YM	Futures	36665.8	36682.5	36627.9	36674.7	3888.0

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

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