PREVIEW / futures_1hour / 2019-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-08.parquet
  size:    47 KB
  rows:    1,425

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-03-08 00:00:00	ES	Futures	2980.37	2982.0	2978.2	2979.55	5574.0
2019-03-08 01:00:00	ES	Futures	2979.83	2980.37	2975.21	2976.84	6998.0
2019-03-08 02:00:00	ES	Futures	2976.84	2977.65	2972.22	2972.49	13607.0
2019-03-08 03:00:00	ES	Futures	2972.49	2979.55	2972.49	2974.94	16588.0
2019-03-08 04:00:00	ES	Futures	2974.67	2979.28	2974.39	2975.21	11704.0
2019-03-08 05:00:00	ES	Futures	2975.21	2977.11	2970.86	2974.67	13619.0
2019-03-08 06:00:00	ES	Futures	2974.67	2976.84	2972.49	2973.31	10569.0
2019-03-08 07:00:00	ES	Futures	2973.31	2975.75	2971.95	2971.95	13690.0
2019-03-08 08:00:00	ES	Futures	2971.95	2976.57	2961.36	2963.53	67987.0
2019-03-08 09:00:00	ES	Futures	2963.53	2968.42	2957.83	2962.99	159006.0
2019-03-08 10:00:00	ES	Futures	2962.99	2973.31	2957.01	2965.7	141278.0
2019-03-08 11:00:00	ES	Futures	2965.43	2972.76	2963.26	2965.7	72872.0
2019-03-08 12:00:00	ES	Futures	2965.98	2966.52	2957.83	2958.37	44386.0
2019-03-08 13:00:00	ES	Futures	2958.37	2965.16	2957.83	2963.53	38384.0
2019-03-08 14:00:00	ES	Futures	2963.53	2976.3	2960.81	2972.22	50044.0
2019-03-08 15:00:00	ES	Futures	2972.22	2981.46	2966.52	2980.1	121377.0
2019-03-08 16:00:00	ES	Futures	2980.1	2986.07	2978.74	2986.07	33412.0
2019-03-08 00:00:00	NQ	Futures	8191.82	8197.37	8184.22	8189.19	2049.0
2019-03-08 01:00:00	NQ	Futures	8189.19	8191.24	8173.12	8173.7	3051.0
2019-03-08 02:00:00	NQ	Futures	8173.7	8176.04	8155.3	8157.63	3704.0
2019-03-08 03:00:00	NQ	Futures	8158.22	8181.01	8158.22	8166.69	5017.0
2019-03-08 04:00:00	NQ	Futures	8166.4	8180.13	8164.35	8167.28	2856.0
2019-03-08 05:00:00	NQ	Futures	8167.57	8175.17	8155.59	8167.86	3237.0
2019-03-08 06:00:00	NQ	Futures	8168.15	8176.33	8159.97	8164.35	2586.0
2019-03-08 07:00:00	NQ	Futures	8164.35	8172.24	8158.8	8159.97	3376.0
2019-03-08 08:00:00	NQ	Futures	8159.97	8169.61	8127.83	8129.58	15044.0
2019-03-08 09:00:00	NQ	Futures	8130.46	8154.42	8110.01	8138.35	47152.0
2019-03-08 10:00:00	NQ	Futures	8138.35	8178.38	8114.39	8157.34	47219.0
2019-03-08 11:00:00	NQ	Futures	8157.05	8184.22	8152.96	8159.09	31709.0
2019-03-08 12:00:00	NQ	Futures	8159.68	8163.19	8132.51	8135.43	17721.0
2019-03-08 13:00:00	NQ	Futures	8135.43	8160.85	8131.34	8153.25	14324.0
2019-03-08 14:00:00	NQ	Futures	8153.25	8194.16	8145.36	8182.47	16371.0
2019-03-08 15:00:00	NQ	Futures	8182.47	8207.01	8161.43	8203.51	27184.0
2019-03-08 16:00:00	NQ	Futures	8203.22	8219.87	8200.29	8217.53	7929.0
2019-03-08 00:00:00	YM	Futures	27590.0	27601.9	27562.8	27579.1	1036.0
2019-03-08 01:00:00	YM	Futures	27580.2	27587.8	27541.1	27553.1	1141.0
2019-03-08 02:00:00	YM	Futures	27552.0	27559.6	27517.2	27521.6	2767.0
2019-03-08 03:00:00	YM	Futures	27522.7	27585.6	27522.7	27544.4	3697.0
2019-03-08 04:00:00	YM	Futures	27545.5	27588.9	27541.1	27546.6	1729.0
2019-03-08 05:00:00	YM	Futures	27547.6	27556.3	27514.0	27532.4	1701.0
2019-03-08 06:00:00	YM	Futures	27533.5	27548.7	27504.2	27518.3	1930.0
2019-03-08 07:00:00	YM	Futures	27519.4	27539.0	27497.7	27501.0	2316.0
2019-03-08 08:00:00	YM	Futures	27501.0	27534.6	27401.1	27423.9	9291.0
2019-03-08 09:00:00	YM	Futures	27423.9	27512.9	27373.9	27464.0	22959.0
2019-03-08 10:00:00	YM	Futures	27461.9	27587.8	27435.8	27511.8	22274.0
2019-03-08 11:00:00	YM	Futures	27510.7	27569.4	27484.7	27508.6	12722.0
2019-03-08 12:00:00	YM	Futures	27509.6	27517.2	27439.1	27445.6	8251.0
2019-03-08 13:00:00	YM	Futures	27444.5	27507.5	27442.3	27497.7	5116.0
2019-03-08 14:00:00	YM	Futures	27498.8	27587.8	27468.4	27545.5	6097.0
2019-03-08 15:00:00	YM	Futures	27542.2	27646.4	27509.6	27626.9	12987.0

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

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