PREVIEW / futures_1hour / 2021-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-15.parquet
  size:    53 KB
  rows:    1,550

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-15 00:00:00	ES	Futures	4241.71	4241.71	4227.12	4228.24	18750.0
2021-01-15 01:00:00	ES	Futures	4228.52	4235.26	4227.12	4233.01	13545.0
2021-01-15 02:00:00	ES	Futures	4232.73	4241.43	4230.77	4240.03	11220.0
2021-01-15 03:00:00	ES	Futures	4239.75	4247.32	4239.47	4241.99	18444.0
2021-01-15 04:00:00	ES	Futures	4241.99	4246.48	4241.15	4243.11	11163.0
2021-01-15 05:00:00	ES	Futures	4242.83	4248.73	4238.62	4241.71	12314.0
2021-01-15 06:00:00	ES	Futures	4241.71	4243.11	4233.85	4240.31	19620.0
2021-01-15 07:00:00	ES	Futures	4240.31	4244.8	4233.85	4236.38	27716.0
2021-01-15 08:00:00	ES	Futures	4236.38	4243.96	4233.01	4235.26	38973.0
2021-01-15 09:00:00	ES	Futures	4235.26	4244.24	4229.64	4238.9	200537.0
2021-01-15 10:00:00	ES	Futures	4238.62	4241.43	4200.45	4218.42	372215.0
2021-01-15 11:00:00	ES	Futures	4218.42	4236.94	4207.19	4228.52	221433.0
2021-01-15 12:00:00	ES	Futures	4228.52	4235.82	4222.91	4233.85	99898.0
2021-01-15 13:00:00	ES	Futures	4233.85	4241.15	4228.52	4234.98	101091.0
2021-01-15 14:00:00	ES	Futures	4235.26	4240.03	4230.2	4232.17	126308.0
2021-01-15 15:00:00	ES	Futures	4232.17	4240.59	4219.82	4223.19	258153.0
2021-01-15 16:00:00	ES	Futures	4223.19	4223.47	4203.82	4205.79	74060.0
2021-01-15 00:00:00	NQ	Futures	14912.2	14912.2	14853.74	14857.5	7691.0
2021-01-15 01:00:00	NQ	Futures	14856.92	14897.15	14853.74	14892.81	4883.0
2021-01-15 02:00:00	NQ	Futures	14891.94	14920.89	14885.0	14910.18	4550.0
2021-01-15 03:00:00	NQ	Futures	14909.89	14930.44	14903.81	14924.36	5941.0
2021-01-15 04:00:00	NQ	Futures	14924.65	14934.49	14906.13	14908.73	4126.0
2021-01-15 05:00:00	NQ	Futures	14908.44	14930.15	14892.23	14900.92	5419.0
2021-01-15 06:00:00	NQ	Futures	14900.63	14905.84	14877.47	14896.29	6312.0
2021-01-15 07:00:00	NQ	Futures	14896.29	14933.91	14891.66	14929.28	11148.0
2021-01-15 08:00:00	NQ	Futures	14929.28	14946.65	14924.36	14927.26	13431.0
2021-01-15 09:00:00	NQ	Futures	14926.97	14970.96	14901.21	14935.94	71495.0
2021-01-15 10:00:00	NQ	Futures	14935.94	14946.07	14764.01	14824.22	118779.0
2021-01-15 11:00:00	NQ	Futures	14824.8	14904.1	14753.6	14863.29	75692.0
2021-01-15 12:00:00	NQ	Futures	14863.0	14887.89	14845.35	14876.6	37402.0
2021-01-15 13:00:00	NQ	Futures	14876.89	14919.73	14853.45	14899.18	34432.0
2021-01-15 14:00:00	NQ	Futures	14899.47	14913.36	14850.56	14852.87	33397.0
2021-01-15 15:00:00	NQ	Futures	14853.45	14879.79	14810.9	14817.56	59430.0
2021-01-15 16:00:00	NQ	Futures	14818.14	14819.01	14767.49	14771.54	13489.0
2021-01-15 00:00:00	YM	Futures	34148.8	34148.8	34044.5	34068.9	4261.0
2021-01-15 01:00:00	YM	Futures	34070.0	34115.5	34057.8	34094.4	2836.0
2021-01-15 02:00:00	YM	Futures	34093.3	34157.7	34076.7	34141.0	3041.0
2021-01-15 03:00:00	YM	Futures	34141.0	34199.8	34127.7	34153.2	3918.0
2021-01-15 04:00:00	YM	Futures	34154.3	34198.7	34149.9	34183.2	2501.0
2021-01-15 05:00:00	YM	Futures	34184.3	34225.3	34147.7	34178.7	2658.0
2021-01-15 06:00:00	YM	Futures	34178.7	34188.7	34112.2	34148.8	4432.0
2021-01-15 07:00:00	YM	Futures	34147.7	34165.4	34075.6	34076.7	6030.0
2021-01-15 08:00:00	YM	Futures	34077.8	34149.9	34058.9	34085.6	5475.0
2021-01-15 09:00:00	YM	Futures	34084.5	34155.4	34015.7	34139.9	22252.0
2021-01-15 10:00:00	YM	Futures	34141.0	34158.8	33837.1	34016.8	39867.0
2021-01-15 11:00:00	YM	Futures	34016.8	34145.5	33946.9	34103.3	24553.0
2021-01-15 12:00:00	YM	Futures	34104.4	34176.5	34072.3	34157.7	10710.0
2021-01-15 13:00:00	YM	Futures	34157.7	34198.7	34122.2	34158.8	10722.0
2021-01-15 14:00:00	YM	Futures	34159.9	34194.3	34125.5	34155.4	10020.0
2021-01-15 15:00:00	YM	Futures	34156.6	34207.6	34047.9	34073.4	20074.0

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

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