PREVIEW / futures_1hour / 2019-12-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-13.parquet
  size:    50 KB
  rows:    1,478

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
2019-12-13 00:00:00	ES	Futures	3455.15	3457.32	3454.06	3455.42	4922.0
2019-12-13 01:00:00	ES	Futures	3455.69	3457.6	3454.3	3456.2	7422.0
2019-12-13 02:00:00	ES	Futures	3456.2	3458.4	3454.1	3457.0	12460.0
2019-12-13 03:00:00	ES	Futures	3457.0	3457.6	3452.7	3455.7	25844.0
2019-12-13 04:00:00	ES	Futures	3455.4	3457.6	3454.3	3457.0	17550.0
2019-12-13 05:00:00	ES	Futures	3457.0	3460.6	3456.8	3459.5	13248.0
2019-12-13 06:00:00	ES	Futures	3459.8	3459.8	3454.6	3456.0	17055.0
2019-12-13 07:00:00	ES	Futures	3455.7	3456.2	3436.1	3445.4	46997.0
2019-12-13 08:00:00	ES	Futures	3445.4	3454.9	3442.4	3451.6	56447.0
2019-12-13 09:00:00	ES	Futures	3451.6	3451.6	3433.4	3444.0	210739.0
2019-12-13 10:00:00	ES	Futures	3444.3	3459.5	3435.6	3435.9	268348.0
2019-12-13 11:00:00	ES	Futures	3435.9	3443.2	3429.9	3442.1	113122.0
2019-12-13 12:00:00	ES	Futures	3442.1	3446.7	3439.9	3446.5	62309.0
2019-12-13 13:00:00	ES	Futures	3446.2	3447.0	3443.2	3445.6	39087.0
2019-12-13 14:00:00	ES	Futures	3445.6	3446.5	3441.8	3444.3	35682.0
2019-12-13 15:00:00	ES	Futures	3444.0	3446.5	3442.4	3444.0	88115.0
2019-12-13 16:00:00	ES	Futures	3444.0	3447.0	3443.5	3446.5	35273.0
2019-12-13 00:00:00	NQ	Futures	9884.87	9893.88	9881.97	9887.78	1676.0
2019-12-13 01:00:00	NQ	Futures	9888.07	9895.91	9883.71	9891.55	2422.0
2019-12-13 02:00:00	NQ	Futures	9891.26	9895.33	9882.55	9891.26	4064.0
2019-12-13 03:00:00	NQ	Futures	9892.43	9895.33	9876.45	9888.07	6426.0
2019-12-13 04:00:00	NQ	Futures	9888.07	9892.43	9882.55	9890.1	5263.0
2019-12-13 05:00:00	NQ	Futures	9889.52	9904.34	9888.36	9899.98	4312.0
2019-12-13 06:00:00	NQ	Futures	9899.4	9901.14	9883.13	9888.07	3688.0
2019-12-13 07:00:00	NQ	Futures	9887.49	9888.07	9820.96	9853.5	10129.0
2019-12-13 08:00:00	NQ	Futures	9851.47	9881.39	9841.88	9872.38	14800.0
2019-12-13 09:00:00	NQ	Futures	9872.67	9873.83	9801.79	9852.05	46602.0
2019-12-13 10:00:00	NQ	Futures	9853.21	9899.98	9835.2	9843.33	73681.0
2019-12-13 11:00:00	NQ	Futures	9843.91	9867.15	9824.45	9861.92	21355.0
2019-12-13 12:00:00	NQ	Futures	9861.92	9882.55	9861.05	9881.39	12817.0
2019-12-13 13:00:00	NQ	Futures	9881.68	9883.42	9866.86	9872.38	6973.0
2019-12-13 14:00:00	NQ	Futures	9872.96	9875.58	9863.38	9872.38	6021.0
2019-12-13 15:00:00	NQ	Futures	9872.67	9878.19	9863.09	9867.15	13741.0
2019-12-13 16:00:00	NQ	Futures	9867.15	9873.25	9863.67	9871.22	5512.0
2019-12-13 00:00:00	YM	Futures	30753.7	30776.6	30746.1	30760.2	1478.0
2019-12-13 01:00:00	YM	Futures	30759.2	30776.6	30748.3	30765.7	1904.0
2019-12-13 02:00:00	YM	Futures	30765.7	30778.7	30747.2	30767.9	3433.0
2019-12-13 03:00:00	YM	Futures	30767.9	30778.7	30734.1	30757.0	5860.0
2019-12-13 04:00:00	YM	Futures	30755.9	30775.5	30741.7	30775.5	4405.0
2019-12-13 05:00:00	YM	Futures	30773.3	30809.2	30763.5	30798.3	2809.0
2019-12-13 06:00:00	YM	Futures	30798.3	30799.4	30750.4	30760.2	3124.0
2019-12-13 07:00:00	YM	Futures	30759.2	30770.0	30602.4	30680.8	6828.0
2019-12-13 08:00:00	YM	Futures	30681.9	30749.4	30657.9	30729.8	8427.0
2019-12-13 09:00:00	YM	Futures	30729.8	30731.9	30575.2	30665.5	26374.0
2019-12-13 10:00:00	YM	Futures	30666.6	30819.0	30587.1	30594.8	37839.0
2019-12-13 11:00:00	YM	Futures	30594.8	30643.7	30529.4	30626.3	16528.0
2019-12-13 12:00:00	YM	Futures	30625.2	30659.0	30611.1	30656.8	9910.0
2019-12-13 13:00:00	YM	Futures	30656.8	30664.4	30630.7	30656.8	5228.0
2019-12-13 14:00:00	YM	Futures	30656.8	30664.4	30615.4	30642.7	5111.0
2019-12-13 15:00:00	YM	Futures	30643.7	30669.9	30627.4	30641.6	10245.0

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

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