PREVIEW / futures_1hour / 2020-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-06.parquet
  size:    54 KB
  rows:    1,524

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-06 00:00:00	ES	Futures	3229.7	3230.7	3221.0	3228.0	23627.0
2020-03-06 01:00:00	ES	Futures	3228.3	3244.8	3225.1	3231.3	23441.0
2020-03-06 02:00:00	ES	Futures	3231.3	3246.5	3231.3	3234.0	32675.0
2020-03-06 03:00:00	ES	Futures	3234.0	3248.6	3222.9	3234.3	57947.0
2020-03-06 04:00:00	ES	Futures	3234.3	3244.8	3202.6	3202.8	65121.0
2020-03-06 05:00:00	ES	Futures	3203.1	3205.3	3171.7	3186.8	84985.0
2020-03-06 06:00:00	ES	Futures	3186.8	3198.8	3174.9	3188.7	60689.0
2020-03-06 07:00:00	ES	Futures	3188.7	3199.3	3159.7	3175.5	67069.0
2020-03-06 08:00:00	ES	Futures	3175.2	3190.1	3162.5	3175.7	107501.0
2020-03-06 09:00:00	ES	Futures	3175.5	3191.2	3150.3	3175.7	332562.0
2020-03-06 10:00:00	ES	Futures	3175.7	3225.9	3167.6	3216.1	411854.0
2020-03-06 11:00:00	ES	Futures	3216.7	3221.0	3183.9	3193.1	225479.0
2020-03-06 12:00:00	ES	Futures	3193.1	3205.5	3171.7	3189.0	202966.0
2020-03-06 13:00:00	ES	Futures	3188.7	3212.6	3175.7	3179.3	177539.0
2020-03-06 14:00:00	ES	Futures	3179.0	3182.5	3145.7	3150.3	220627.0
2020-03-06 15:00:00	ES	Futures	3150.0	3234.8	3141.3	3219.9	547080.0
2020-03-06 16:00:00	ES	Futures	3219.9	3221.8	3204.5	3212.6	128137.0
2020-03-06 00:00:00	NQ	Futures	9883.36	9887.41	9855.31	9879.6	12529.0
2020-03-06 01:00:00	NQ	Futures	9879.03	9929.92	9869.19	9893.49	13984.0
2020-03-06 02:00:00	NQ	Futures	9893.2	9936.57	9891.17	9895.22	16460.0
2020-03-06 03:00:00	NQ	Futures	9896.38	9941.49	9863.7	9898.4	27737.0
2020-03-06 04:00:00	NQ	Futures	9898.69	9929.05	9791.99	9792.85	27492.0
2020-03-06 05:00:00	NQ	Futures	9793.43	9804.42	9690.77	9729.81	37697.0
2020-03-06 06:00:00	NQ	Futures	9729.81	9750.63	9692.22	9718.54	28335.0
2020-03-06 07:00:00	NQ	Futures	9718.82	9758.15	9643.64	9683.83	30212.0
2020-03-06 08:00:00	NQ	Futures	9682.39	9730.1	9647.4	9706.97	37442.0
2020-03-06 09:00:00	NQ	Futures	9706.1	9786.78	9612.7	9737.33	112901.0
2020-03-06 10:00:00	NQ	Futures	9736.75	9883.65	9706.68	9842.59	158965.0
2020-03-06 11:00:00	NQ	Futures	9842.59	9852.71	9739.07	9757.86	94536.0
2020-03-06 12:00:00	NQ	Futures	9757.28	9797.77	9698.87	9739.93	71386.0
2020-03-06 13:00:00	NQ	Futures	9739.36	9813.09	9705.23	9712.46	61986.0
2020-03-06 14:00:00	NQ	Futures	9712.17	9725.76	9628.89	9645.37	77015.0
2020-03-06 15:00:00	NQ	Futures	9644.51	9913.73	9619.64	9864.28	152902.0
2020-03-06 16:00:00	NQ	Futures	9864.86	9869.77	9808.18	9833.92	20786.0
2020-03-06 00:00:00	YM	Futures	28070.0	28080.8	27983.9	28051.4	5251.0
2020-03-06 01:00:00	YM	Futures	28052.5	28193.0	28023.1	28093.9	6453.0
2020-03-06 02:00:00	YM	Futures	28093.9	28224.6	28091.7	28115.7	7695.0
2020-03-06 03:00:00	YM	Futures	28116.8	28232.2	28007.9	28102.6	12822.0
2020-03-06 04:00:00	YM	Futures	28107.0	28188.6	27828.3	27834.8	14041.0
2020-03-06 05:00:00	YM	Futures	27835.9	27858.7	27609.4	27741.2	18667.0
2020-03-06 06:00:00	YM	Futures	27739.0	27826.1	27648.6	27730.3	12961.0
2020-03-06 07:00:00	YM	Futures	27731.4	27813.0	27490.7	27605.1	13306.0
2020-03-06 08:00:00	YM	Futures	27599.6	27745.5	27502.7	27624.7	16801.0
2020-03-06 09:00:00	YM	Futures	27622.5	27681.3	27428.7	27610.5	66139.0
2020-03-06 10:00:00	YM	Futures	27609.4	28056.9	27534.3	27974.1	96669.0
2020-03-06 11:00:00	YM	Futures	27974.1	28011.2	27752.0	27853.3	54854.0
2020-03-06 12:00:00	YM	Futures	27853.3	27981.8	27653.0	27844.6	40239.0
2020-03-06 13:00:00	YM	Futures	27841.3	28047.1	27776.0	27801.0	30658.0
2020-03-06 14:00:00	YM	Futures	27801.0	27809.7	27495.1	27529.9	39749.0
2020-03-06 15:00:00	YM	Futures	27531.0	28274.6	27460.3	28144.0	83953.0

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

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