PREVIEW / futures_1hour / 2021-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-29.parquet
  size:    55 KB
  rows:    1,593

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-01-29 00:00:00	ES	Futures	4194.0	4195.96	4182.21	4192.31	18114.0
2021-01-29 01:00:00	ES	Futures	4192.31	4206.91	4183.89	4205.79	19298.0
2021-01-29 02:00:00	ES	Futures	4205.79	4211.96	4179.12	4192.59	33929.0
2021-01-29 03:00:00	ES	Futures	4192.59	4206.91	4178.0	4202.14	46180.0
2021-01-29 04:00:00	ES	Futures	4202.14	4212.8	4194.28	4199.33	30492.0
2021-01-29 05:00:00	ES	Futures	4199.33	4206.91	4189.79	4205.22	23181.0
2021-01-29 06:00:00	ES	Futures	4204.94	4226.84	4195.96	4217.29	32210.0
2021-01-29 07:00:00	ES	Futures	4217.57	4225.15	4206.07	4208.31	28967.0
2021-01-29 08:00:00	ES	Futures	4208.59	4237.78	4184.74	4226.84	135631.0
2021-01-29 09:00:00	ES	Futures	4226.84	4231.33	4192.59	4215.61	253865.0
2021-01-29 10:00:00	ES	Futures	4215.89	4232.73	4207.19	4220.1	254140.0
2021-01-29 11:00:00	ES	Futures	4220.1	4223.75	4176.88	4191.19	274775.0
2021-01-29 12:00:00	ES	Futures	4190.91	4193.44	4140.67	4148.53	316143.0
2021-01-29 13:00:00	ES	Futures	4148.53	4170.42	4137.58	4154.99	237110.0
2021-01-29 14:00:00	ES	Futures	4154.99	4176.32	4153.3	4165.93	188774.0
2021-01-29 15:00:00	ES	Futures	4166.49	4193.16	4156.39	4159.48	477018.0
2021-01-29 16:00:00	ES	Futures	4159.2	4174.07	4148.81	4149.93	120625.0
2021-01-29 00:00:00	NQ	Futures	15061.26	15070.81	15016.4	15052.87	6440.0
2021-01-29 01:00:00	NQ	Futures	15052.87	15122.62	15021.61	15120.6	7523.0
2021-01-29 02:00:00	NQ	Futures	15119.15	15137.09	15010.03	15052.0	15274.0
2021-01-29 03:00:00	NQ	Futures	15051.71	15082.68	14973.56	15073.42	17577.0
2021-01-29 04:00:00	NQ	Futures	15071.97	15102.36	15024.22	15043.9	15414.0
2021-01-29 05:00:00	NQ	Futures	15042.74	15101.49	14981.09	15095.13	13002.0
2021-01-29 06:00:00	NQ	Futures	15094.55	15161.99	15063.29	15123.49	13203.0
2021-01-29 07:00:00	NQ	Futures	15122.91	15166.04	15091.36	15102.36	11569.0
2021-01-29 08:00:00	NQ	Futures	15102.65	15243.9	15045.63	15201.64	34261.0
2021-01-29 09:00:00	NQ	Futures	15200.77	15211.19	15048.24	15146.36	78220.0
2021-01-29 10:00:00	NQ	Futures	15147.8	15232.61	15078.34	15172.12	81711.0
2021-01-29 11:00:00	NQ	Futures	15172.41	15192.67	15007.14	15085.87	78417.0
2021-01-29 12:00:00	NQ	Futures	15085.58	15103.52	14852.58	14884.42	86891.0
2021-01-29 13:00:00	NQ	Futures	14884.42	14993.83	14855.48	14920.89	66778.0
2021-01-29 14:00:00	NQ	Futures	14921.47	15001.06	14900.63	14948.96	51571.0
2021-01-29 15:00:00	NQ	Futures	14948.67	15074.87	14936.81	14950.7	85848.0
2021-01-29 16:00:00	NQ	Futures	14950.12	14986.59	14892.52	14900.63	22329.0
2021-01-29 00:00:00	YM	Futures	33526.5	33528.8	33396.8	33479.9	5435.0
2021-01-29 01:00:00	YM	Futures	33481.1	33600.8	33427.8	33577.6	4939.0
2021-01-29 02:00:00	YM	Futures	33578.7	33626.4	33402.3	33495.5	7445.0
2021-01-29 03:00:00	YM	Futures	33495.5	33578.7	33391.2	33544.3	11563.0
2021-01-29 04:00:00	YM	Futures	33544.3	33615.3	33498.8	33546.5	7706.0
2021-01-29 05:00:00	YM	Futures	33546.5	33584.2	33494.4	33567.6	6116.0
2021-01-29 06:00:00	YM	Futures	33565.4	33767.2	33517.7	33675.2	8546.0
2021-01-29 07:00:00	YM	Futures	33676.3	33727.3	33582.0	33602.0	6916.0
2021-01-29 08:00:00	YM	Futures	33605.3	33716.2	33394.5	33646.3	21141.0
2021-01-29 09:00:00	YM	Futures	33644.1	33676.3	33369.0	33563.1	34881.0
2021-01-29 10:00:00	YM	Futures	33563.1	33694.0	33534.3	33604.2	28385.0
2021-01-29 11:00:00	YM	Futures	33605.3	33627.5	33313.6	33396.8	31899.0
2021-01-29 12:00:00	YM	Futures	33395.6	33409.0	33042.9	33108.4	33240.0
2021-01-29 13:00:00	YM	Futures	33108.4	33221.5	33003.0	33122.8	24598.0
2021-01-29 14:00:00	YM	Futures	33120.6	33279.2	33109.5	33200.4	17199.0
2021-01-29 15:00:00	YM	Futures	33201.5	33395.6	33113.9	33136.1	33092.0

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

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