PREVIEW / futures_1hour / 2020-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-01.parquet
  size:    19 KB
  rows:    400

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
2020-03-01 18:00:00	ES	Futures	3143.5	3173.8	3131.8	3164.4	101216.0
2020-03-01 19:00:00	ES	Futures	3164.1	3174.9	3153.0	3163.3	51816.0
2020-03-01 20:00:00	ES	Futures	3163.3	3213.7	3162.5	3193.6	76963.0
2020-03-01 21:00:00	ES	Futures	3193.6	3234.0	3189.0	3225.1	54147.0
2020-03-01 22:00:00	ES	Futures	3225.3	3233.5	3213.9	3219.6	37502.0
2020-03-01 23:00:00	ES	Futures	3219.4	3225.1	3203.1	3213.7	28206.0
2020-03-01 18:00:00	NQ	Futures	9657.52	9700.03	9512.93	9665.04	30836.0
2020-03-01 19:00:00	NQ	Futures	9664.75	9704.08	9619.35	9657.23	26380.0
2020-03-01 20:00:00	NQ	Futures	9656.94	9833.34	9656.07	9767.69	38238.0
2020-03-01 21:00:00	NQ	Futures	9767.69	9897.53	9752.95	9869.19	34487.0
2020-03-01 22:00:00	NQ	Futures	9868.04	9904.18	9831.89	9848.66	24821.0
2020-03-01 23:00:00	NQ	Futures	9847.22	9869.77	9791.7	9829.29	24592.0
2020-03-01 18:00:00	YM	Futures	27432.0	27432.0	27056.3	27319.8	11701.0
2020-03-01 19:00:00	YM	Futures	27316.5	27421.1	27259.9	27354.7	8916.0
2020-03-01 20:00:00	YM	Futures	27355.7	27801.0	27347.0	27621.4	15200.0
2020-03-01 21:00:00	YM	Futures	27619.2	27983.9	27572.4	27892.5	12004.0
2020-03-01 22:00:00	YM	Futures	27891.4	27978.5	27789.1	27851.1	9443.0
2020-03-01 23:00:00	YM	Futures	27850.0	27880.5	27692.2	27786.9	6957.0
2020-03-01 18:00:00	CL	Futures	38.53	39.41	38.2	39.33	23077.0
2020-03-01 19:00:00	CL	Futures	39.32	39.65	39.18	39.21	13178.0
2020-03-01 20:00:00	CL	Futures	39.22	40.24	39.21	39.79	38415.0
2020-03-01 21:00:00	CL	Futures	39.79	40.93	39.74	40.68	27501.0
2020-03-01 22:00:00	CL	Futures	40.68	40.93	40.58	40.68	15504.0
2020-03-01 23:00:00	CL	Futures	40.69	40.76	40.58	40.63	8770.0
2020-03-01 18:00:00	GC	Futures	1989.5	1991.4	1968.9	1981.1	15692.0
2020-03-01 19:00:00	GC	Futures	1980.9	1998.2	1976.6	1996.1	17573.0
2020-03-01 20:00:00	GC	Futures	1996.0	2008.4	1994.1	1994.4	35446.0
2020-03-01 21:00:00	GC	Futures	1994.2	1998.6	1988.3	1994.0	15904.0
2020-03-01 22:00:00	GC	Futures	1993.9	2000.7	1990.5	1998.2	11920.0
2020-03-01 23:00:00	GC	Futures	1998.2	2003.6	1997.4	2000.2	6319.0
2020-03-01 18:00:00	ZN	Futures	135.192519	135.474105	135.192519	135.333312	1664.0
2020-03-01 19:00:00	ZN	Futures	135.333312	135.896484	135.23945	135.88084	1926.0
2020-03-01 20:00:00	ZN	Futures	135.88084	136.005989	135.505392	135.614898	3950.0
2020-03-01 21:00:00	ZN	Futures	135.614898	135.614898	135.161232	135.302025	651.0
2020-03-01 22:00:00	ZN	Futures	135.317668	135.458461	135.255094	135.41153	748.0
2020-03-01 23:00:00	ZN	Futures	135.427174	135.786978	135.427174	135.614898	563.0

> showing 36 of 400 rows — these rows as CSV

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