PREVIEW / futures_1hour / 2019-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-01.parquet
  size:    62 KB
  rows:    1,878

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-10-01 00:00:00	ES	Futures	3249.25	3250.34	3247.89	3248.43	4101.0
2019-10-01 01:00:00	ES	Futures	3248.43	3249.52	3247.35	3248.16	5245.0
2019-10-01 02:00:00	ES	Futures	3248.16	3252.51	3247.35	3250.88	12374.0
2019-10-01 03:00:00	ES	Futures	3250.88	3253.6	3246.26	3246.53	16581.0
2019-10-01 04:00:00	ES	Futures	3246.81	3250.34	3243.0	3245.72	17761.0
2019-10-01 05:00:00	ES	Futures	3245.99	3246.26	3241.1	3243.82	20553.0
2019-10-01 06:00:00	ES	Futures	3243.82	3245.99	3241.37	3241.92	15453.0
2019-10-01 07:00:00	ES	Futures	3242.19	3244.36	3240.83	3242.46	13273.0
2019-10-01 08:00:00	ES	Futures	3242.46	3247.62	3241.37	3245.72	21364.0
2019-10-01 09:00:00	ES	Futures	3245.45	3253.05	3243.27	3250.06	130386.0
2019-10-01 10:00:00	ES	Futures	3249.79	3249.79	3218.83	3219.64	353888.0
2019-10-01 11:00:00	ES	Futures	3219.37	3222.09	3210.13	3212.04	191255.0
2019-10-01 12:00:00	ES	Futures	3211.76	3212.31	3202.26	3204.7	148994.0
2019-10-01 13:00:00	ES	Futures	3204.43	3204.97	3193.57	3195.2	132998.0
2019-10-01 14:00:00	ES	Futures	3195.2	3205.79	3192.75	3202.26	132959.0
2019-10-01 15:00:00	ES	Futures	3201.99	3205.79	3193.57	3194.92	234987.0
2019-10-01 16:00:00	ES	Futures	3195.2	3197.37	3191.12	3197.1	68062.0
2019-10-01 18:00:00	ES	Futures	3196.82	3200.08	3193.57	3199.54	7986.0
2019-10-01 19:00:00	ES	Futures	3199.27	3200.9	3197.37	3200.9	4678.0
2019-10-01 20:00:00	ES	Futures	3200.63	3204.16	3197.1	3199.54	15143.0
2019-10-01 21:00:00	ES	Futures	3199.81	3201.44	3196.01	3197.37	12059.0
2019-10-01 22:00:00	ES	Futures	3197.1	3198.45	3194.92	3197.37	6919.0
2019-10-01 23:00:00	ES	Futures	3197.64	3200.08	3197.64	3199.54	4320.0
2019-10-01 00:00:00	NQ	Futures	9078.47	9082.53	9073.24	9075.27	2202.0
2019-10-01 01:00:00	NQ	Futures	9075.27	9079.34	9072.07	9075.56	1851.0
2019-10-01 02:00:00	NQ	Futures	9075.56	9094.44	9072.95	9083.98	5276.0
2019-10-01 03:00:00	NQ	Futures	9083.98	9092.7	9066.56	9067.72	6375.0
2019-10-01 04:00:00	NQ	Futures	9068.01	9081.37	9054.65	9065.68	7877.0
2019-10-01 05:00:00	NQ	Futures	9066.26	9067.14	9048.54	9058.42	7374.0
2019-10-01 06:00:00	NQ	Futures	9058.42	9066.56	9050.29	9052.03	5078.0
2019-10-01 07:00:00	NQ	Futures	9053.48	9060.16	9046.22	9053.77	4716.0
2019-10-01 08:00:00	NQ	Futures	9053.48	9068.3	9049.42	9059.58	8376.0
2019-10-01 09:00:00	NQ	Futures	9059.0	9111.58	9055.81	9103.74	50726.0
2019-10-01 10:00:00	NQ	Futures	9103.45	9103.45	8998.58	9001.49	108003.0
2019-10-01 11:00:00	NQ	Futures	9001.49	9018.04	8977.37	8986.67	59431.0
2019-10-01 12:00:00	NQ	Futures	8986.09	8987.54	8958.2	8971.56	46145.0
2019-10-01 13:00:00	NQ	Futures	8971.85	8974.18	8936.71	8944.26	38544.0
2019-10-01 14:00:00	NQ	Futures	8943.97	8983.77	8939.61	8973.6	38850.0
2019-10-01 15:00:00	NQ	Futures	8973.6	8986.09	8943.39	8948.62	50548.0
2019-10-01 16:00:00	NQ	Futures	8948.91	8959.65	8937.87	8958.2	11779.0
2019-10-01 18:00:00	NQ	Futures	8959.94	8973.31	8948.62	8970.11	3229.0
2019-10-01 19:00:00	NQ	Futures	8970.11	8973.31	8961.11	8973.02	1848.0
2019-10-01 20:00:00	NQ	Futures	8972.44	8982.6	8960.24	8968.66	5499.0
2019-10-01 21:00:00	NQ	Futures	8968.66	8973.6	8952.39	8955.59	5724.0
2019-10-01 22:00:00	NQ	Futures	8955.59	8959.65	8948.91	8956.17	2757.0
2019-10-01 23:00:00	NQ	Futures	8956.17	8968.66	8956.17	8967.5	2033.0
2019-10-01 00:00:00	YM	Futures	29383.3	29397.5	29374.6	29379.0	1082.0
2019-10-01 01:00:00	YM	Futures	29379.0	29391.0	29374.6	29381.2	1194.0
2019-10-01 02:00:00	YM	Futures	29381.2	29419.3	29375.7	29404.0	2631.0
2019-10-01 03:00:00	YM	Futures	29402.9	29429.0	29375.7	29380.1	4201.0

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

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