PREVIEW / futures_1hour / 2019-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-27.parquet
  size:    50 KB
  rows:    1,507

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-09-27 00:00:00	ES	Futures	3232.95	3235.12	3231.87	3233.77	4630.0
2019-09-27 01:00:00	ES	Futures	3234.04	3243.27	3233.5	3243.0	14493.0
2019-09-27 02:00:00	ES	Futures	3243.0	3244.36	3241.37	3242.46	12629.0
2019-09-27 03:00:00	ES	Futures	3242.46	3244.09	3239.47	3240.83	14832.0
2019-09-27 04:00:00	ES	Futures	3240.83	3247.35	3240.29	3245.99	14552.0
2019-09-27 05:00:00	ES	Futures	3246.26	3247.35	3243.27	3246.26	11825.0
2019-09-27 06:00:00	ES	Futures	3246.26	3251.97	3243.82	3249.52	21149.0
2019-09-27 07:00:00	ES	Futures	3249.25	3249.52	3246.81	3247.89	9819.0
2019-09-27 08:00:00	ES	Futures	3247.89	3249.52	3244.9	3246.53	24904.0
2019-09-27 09:00:00	ES	Futures	3246.53	3248.43	3234.04	3236.48	138637.0
2019-09-27 10:00:00	ES	Futures	3236.48	3245.18	3230.24	3244.09	172246.0
2019-09-27 11:00:00	ES	Futures	3244.09	3245.45	3218.83	3233.77	279707.0
2019-09-27 12:00:00	ES	Futures	3233.77	3234.85	3214.75	3214.75	185766.0
2019-09-27 13:00:00	ES	Futures	3214.75	3222.9	3211.49	3218.01	151595.0
2019-09-27 14:00:00	ES	Futures	3217.74	3218.28	3201.17	3204.43	168821.0
2019-09-27 15:00:00	ES	Futures	3204.16	3220.46	3202.53	3219.1	255120.0
2019-09-27 16:00:00	ES	Futures	3219.1	3226.16	3218.83	3225.35	76178.0
2019-09-27 00:00:00	NQ	Futures	9021.24	9027.05	9018.04	9025.6	1731.0
2019-09-27 01:00:00	NQ	Futures	9025.6	9056.1	9023.85	9053.48	5182.0
2019-09-27 02:00:00	NQ	Futures	9053.77	9060.75	9047.96	9054.06	5574.0
2019-09-27 03:00:00	NQ	Futures	9054.06	9059.87	9043.32	9048.84	7268.0
2019-09-27 04:00:00	NQ	Futures	9048.84	9071.78	9047.09	9067.43	6675.0
2019-09-27 05:00:00	NQ	Futures	9067.43	9071.49	9056.68	9066.26	4552.0
2019-09-27 06:00:00	NQ	Futures	9066.56	9088.92	9059.58	9079.63	8844.0
2019-09-27 07:00:00	NQ	Futures	9079.63	9080.21	9067.14	9070.04	4717.0
2019-09-27 08:00:00	NQ	Futures	9070.04	9076.43	9058.71	9066.26	11024.0
2019-09-27 09:00:00	NQ	Futures	9066.56	9076.14	9009.91	9018.33	58375.0
2019-09-27 10:00:00	NQ	Futures	9018.33	9049.42	8997.42	9046.51	73138.0
2019-09-27 11:00:00	NQ	Futures	9046.8	9056.68	8956.75	9014.56	97170.0
2019-09-27 12:00:00	NQ	Futures	9014.27	9022.69	8936.41	8936.41	67694.0
2019-09-27 13:00:00	NQ	Futures	8936.12	8962.56	8922.47	8946.87	62001.0
2019-09-27 14:00:00	NQ	Futures	8946.87	8948.33	8878.61	8891.68	64667.0
2019-09-27 15:00:00	NQ	Futures	8891.68	8949.49	8889.06	8945.71	74112.0
2019-09-27 16:00:00	NQ	Futures	8945.71	8967.21	8943.1	8967.21	14420.0
2019-09-27 00:00:00	YM	Futures	29220.1	29235.3	29210.3	29224.4	890.0
2019-09-27 01:00:00	YM	Futures	29225.5	29307.2	29221.2	29299.5	3559.0
2019-09-27 02:00:00	YM	Futures	29300.6	29312.6	29288.6	29299.5	2904.0
2019-09-27 03:00:00	YM	Futures	29299.5	29306.1	29272.3	29285.4	3756.0
2019-09-27 04:00:00	YM	Futures	29285.4	29340.9	29279.9	29328.9	3155.0
2019-09-27 05:00:00	YM	Futures	29328.9	29337.6	29308.2	29325.7	2938.0
2019-09-27 06:00:00	YM	Futures	29325.7	29376.8	29306.1	29352.9	4682.0
2019-09-27 07:00:00	YM	Futures	29354.0	29356.1	29327.8	29336.5	2090.0
2019-09-27 08:00:00	YM	Futures	29335.4	29351.8	29307.2	29325.7	4743.0
2019-09-27 09:00:00	YM	Futures	29324.6	29346.3	29272.3	29285.4	20515.0
2019-09-27 10:00:00	YM	Futures	29284.3	29371.4	29240.8	29360.5	23407.0
2019-09-27 11:00:00	YM	Futures	29362.7	29370.3	29155.9	29285.4	41247.0
2019-09-27 12:00:00	YM	Futures	29284.3	29296.3	29135.2	29137.4	24536.0
2019-09-27 13:00:00	YM	Futures	29138.5	29198.3	29106.9	29153.7	19023.0
2019-09-27 14:00:00	YM	Futures	29154.8	29157.0	29047.0	29065.5	21481.0
2019-09-27 15:00:00	YM	Futures	29064.4	29173.3	29052.5	29162.4	28222.0

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

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