PREVIEW / futures_1hour / 2020-02-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-28.parquet
  size:    56 KB
  rows:    1,567

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-02-28 00:00:00	ES	Futures	3180.9	3181.2	3151.1	3158.7	59288.0
2020-02-28 01:00:00	ES	Futures	3158.9	3164.6	3144.6	3164.1	58003.0
2020-02-28 02:00:00	ES	Futures	3164.1	3189.6	3156.8	3174.9	107324.0
2020-02-28 03:00:00	ES	Futures	3175.2	3195.2	3145.7	3160.0	148895.0
2020-02-28 04:00:00	ES	Futures	3160.0	3163.0	3120.7	3148.1	143860.0
2020-02-28 05:00:00	ES	Futures	3148.1	3182.0	3141.9	3179.0	111853.0
2020-02-28 06:00:00	ES	Futures	3179.0	3186.6	3167.9	3170.3	86943.0
2020-02-28 07:00:00	ES	Futures	3170.6	3201.7	3162.5	3189.3	113336.0
2020-02-28 08:00:00	ES	Futures	3189.0	3193.1	3142.7	3143.5	192456.0
2020-02-28 09:00:00	ES	Futures	3143.5	3177.1	3106.1	3115.3	640291.0
2020-02-28 10:00:00	ES	Futures	3115.0	3147.0	3092.8	3141.0	688063.0
2020-02-28 11:00:00	ES	Futures	3141.0	3207.7	3114.2	3160.6	598993.0
2020-02-28 12:00:00	ES	Futures	3160.3	3193.1	3140.8	3191.2	366697.0
2020-02-28 13:00:00	ES	Futures	3190.9	3196.9	3127.8	3143.5	346414.0
2020-02-28 14:00:00	ES	Futures	3143.5	3187.7	3120.2	3159.5	455239.0
2020-02-28 15:00:00	ES	Futures	3159.2	3215.0	3119.9	3212.6	740172.0
2020-02-28 16:00:00	ES	Futures	3212.9	3247.5	3203.4	3238.9	259771.0
2020-02-28 00:00:00	NQ	Futures	9571.92	9572.79	9475.63	9505.7	33183.0
2020-02-28 01:00:00	NQ	Futures	9506.57	9550.53	9447.87	9549.66	32671.0
2020-02-28 02:00:00	NQ	Futures	9549.37	9636.12	9519.87	9605.47	49364.0
2020-02-28 03:00:00	NQ	Futures	9606.05	9667.93	9500.5	9554.0	58972.0
2020-02-28 04:00:00	NQ	Futures	9556.02	9559.78	9403.05	9501.66	49673.0
2020-02-28 05:00:00	NQ	Futures	9501.08	9610.67	9483.73	9602.0	42808.0
2020-02-28 06:00:00	NQ	Futures	9601.13	9648.56	9587.83	9604.02	34617.0
2020-02-28 07:00:00	NQ	Futures	9602.58	9696.27	9565.27	9647.4	46281.0
2020-02-28 08:00:00	NQ	Futures	9647.11	9660.7	9488.35	9490.67	66120.0
2020-02-28 09:00:00	NQ	Futures	9490.67	9626.0	9399.58	9466.38	168404.0
2020-02-28 10:00:00	NQ	Futures	9466.09	9594.48	9411.72	9587.25	163448.0
2020-02-28 11:00:00	NQ	Futures	9586.67	9829.0	9487.49	9661.57	170778.0
2020-02-28 12:00:00	NQ	Futures	9661.86	9749.48	9594.77	9736.46	94854.0
2020-02-28 13:00:00	NQ	Futures	9738.49	9767.12	9525.37	9574.24	106447.0
2020-02-28 14:00:00	NQ	Futures	9573.66	9727.79	9503.1	9629.18	90903.0
2020-02-28 15:00:00	NQ	Futures	9630.34	9806.73	9529.42	9803.84	109985.0
2020-02-28 16:00:00	NQ	Futures	9803.84	9918.35	9767.98	9887.41	39001.0
2020-02-28 00:00:00	YM	Futures	27634.5	27634.5	27373.2	27437.4	16255.0
2020-02-28 01:00:00	YM	Futures	27438.5	27486.4	27324.2	27484.2	14353.0
2020-02-28 02:00:00	YM	Futures	27483.1	27716.1	27429.8	27557.2	28291.0
2020-02-28 03:00:00	YM	Futures	27555.0	27729.2	27301.3	27421.1	38730.0
2020-02-28 04:00:00	YM	Futures	27424.3	27447.2	27082.5	27319.8	31675.0
2020-02-28 05:00:00	YM	Futures	27316.5	27599.6	27264.3	27574.6	15173.0
2020-02-28 06:00:00	YM	Futures	27570.2	27641.0	27465.7	27487.5	12631.0
2020-02-28 07:00:00	YM	Futures	27488.6	27778.2	27442.8	27679.1	18558.0
2020-02-28 08:00:00	YM	Futures	27679.1	27734.6	27338.3	27344.9	25506.0
2020-02-28 09:00:00	YM	Futures	27340.5	27619.2	27000.8	27067.2	86905.0
2020-02-28 10:00:00	YM	Futures	27071.6	27261.0	26864.7	27219.6	91211.0
2020-02-28 11:00:00	YM	Futures	27216.4	27752.0	26964.9	27299.1	78314.0
2020-02-28 12:00:00	YM	Futures	27300.2	27577.8	27138.0	27563.7	46375.0
2020-02-28 13:00:00	YM	Futures	27565.9	27614.9	27036.7	27147.8	41063.0
2020-02-28 14:00:00	YM	Futures	27144.5	27553.9	26957.3	27288.2	60273.0
2020-02-28 15:00:00	YM	Futures	27290.4	27710.7	26942.0	27697.6	36508.0

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

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