PREVIEW / futures_1hour / 2019-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-03.parquet
  size:    62 KB
  rows:    1,851

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-06-03 00:00:00	ES	Futures	2969.65	2969.93	2965.86	2965.86	9927.0
2019-06-03 01:00:00	ES	Futures	2965.86	2972.09	2965.86	2971.28	11505.0
2019-06-03 02:00:00	ES	Futures	2971.28	2974.53	2969.93	2971.55	21159.0
2019-06-03 03:00:00	ES	Futures	2971.82	2972.91	2961.79	2964.77	39326.0
2019-06-03 04:00:00	ES	Futures	2964.77	2971.82	2964.77	2971.01	25305.0
2019-06-03 05:00:00	ES	Futures	2971.01	2976.16	2970.47	2975.08	27623.0
2019-06-03 06:00:00	ES	Futures	2975.08	2978.33	2972.64	2973.45	23793.0
2019-06-03 07:00:00	ES	Futures	2973.72	2979.14	2973.72	2976.7	30445.0
2019-06-03 08:00:00	ES	Futures	2976.7	2982.13	2974.81	2981.85	35111.0
2019-06-03 09:00:00	ES	Futures	2981.85	2992.7	2975.08	2975.35	258283.0
2019-06-03 10:00:00	ES	Futures	2975.35	2997.04	2969.11	2994.6	323396.0
2019-06-03 11:00:00	ES	Futures	2994.32	2995.41	2980.77	2981.58	179938.0
2019-06-03 12:00:00	ES	Futures	2981.58	2983.21	2966.4	2969.38	203565.0
2019-06-03 13:00:00	ES	Futures	2969.38	2989.44	2965.59	2979.14	296401.0
2019-06-03 14:00:00	ES	Futures	2979.14	2985.38	2966.4	2969.38	187626.0
2019-06-03 15:00:00	ES	Futures	2969.65	2978.6	2959.08	2975.35	378122.0
2019-06-03 16:00:00	ES	Futures	2975.08	2986.73	2974.81	2986.19	82819.0
2019-06-03 18:00:00	ES	Futures	2986.46	2988.36	2984.56	2984.84	7842.0
2019-06-03 19:00:00	ES	Futures	2984.84	2987.28	2982.13	2983.48	9178.0
2019-06-03 20:00:00	ES	Futures	2983.21	2985.38	2979.14	2983.75	15127.0
2019-06-03 21:00:00	ES	Futures	2983.75	2984.56	2978.33	2978.6	13178.0
2019-06-03 22:00:00	ES	Futures	2978.33	2982.4	2975.62	2982.13	13372.0
2019-06-03 23:00:00	ES	Futures	2982.13	2985.92	2981.58	2984.84	9807.0
2019-06-03 00:00:00	NQ	Futures	8247.0	8248.45	8233.02	8233.89	4024.0
2019-06-03 01:00:00	NQ	Futures	8234.18	8254.86	8234.18	8252.82	5314.0
2019-06-03 02:00:00	NQ	Futures	8252.53	8268.25	8249.91	8260.68	8190.0
2019-06-03 03:00:00	NQ	Futures	8260.97	8265.34	8230.11	8239.43	12157.0
2019-06-03 04:00:00	NQ	Futures	8240.01	8258.35	8237.68	8255.73	8508.0
2019-06-03 05:00:00	NQ	Futures	8255.44	8270.58	8254.57	8266.5	8328.0
2019-06-03 06:00:00	NQ	Futures	8266.21	8276.69	8256.89	8259.81	7979.0
2019-06-03 07:00:00	NQ	Futures	8260.39	8276.4	8258.35	8268.25	9162.0
2019-06-03 08:00:00	NQ	Futures	8268.54	8286.01	8260.68	8284.55	11504.0
2019-06-03 09:00:00	NQ	Futures	8284.55	8306.68	8213.51	8213.51	88010.0
2019-06-03 10:00:00	NQ	Futures	8213.22	8258.93	8185.56	8256.02	106820.0
2019-06-03 11:00:00	NQ	Futures	8255.73	8264.76	8216.71	8221.96	66400.0
2019-06-03 12:00:00	NQ	Futures	8221.66	8227.49	8145.09	8157.03	85061.0
2019-06-03 13:00:00	NQ	Futures	8157.32	8211.18	8114.81	8156.74	112317.0
2019-06-03 14:00:00	NQ	Futures	8156.74	8177.41	8112.48	8123.25	68056.0
2019-06-03 15:00:00	NQ	Futures	8123.54	8138.39	8083.95	8129.37	100695.0
2019-06-03 16:00:00	NQ	Futures	8129.37	8166.93	8125.58	8162.56	16706.0
2019-06-03 18:00:00	NQ	Futures	8162.56	8169.26	8157.03	8158.77	3643.0
2019-06-03 19:00:00	NQ	Futures	8158.77	8167.51	8150.04	8153.83	4017.0
2019-06-03 20:00:00	NQ	Futures	8153.83	8159.36	8141.6	8150.33	6965.0
2019-06-03 21:00:00	NQ	Futures	8150.33	8152.66	8135.48	8138.98	5604.0
2019-06-03 22:00:00	NQ	Futures	8139.27	8146.26	8131.12	8146.26	4904.0
2019-06-03 23:00:00	NQ	Futures	8145.96	8157.03	8143.05	8153.53	3758.0
2019-06-03 00:00:00	YM	Futures	26842.5	26844.7	26813.2	26813.2	2602.0
2019-06-03 01:00:00	YM	Futures	26815.3	26866.5	26815.3	26857.8	2565.0
2019-06-03 02:00:00	YM	Futures	26857.8	26882.8	26843.6	26851.2	4508.0
2019-06-03 03:00:00	YM	Futures	26851.2	26862.1	26767.5	26794.7	7759.0

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

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