PREVIEW / futures_1hour / 2018-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-19.parquet
  size:    55 KB
  rows:    1,676

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
2018-03-19 00:00:00	ES	Futures	3001.44	3002.26	3000.9	3000.9	1789.0
2018-03-19 01:00:00	ES	Futures	3001.17	3001.72	2997.89	2999.26	5995.0
2018-03-19 02:00:00	ES	Futures	2999.26	3000.08	2996.8	2998.99	4759.0
2018-03-19 03:00:00	ES	Futures	2998.99	3000.9	2997.89	3000.08	5837.0
2018-03-19 04:00:00	ES	Futures	3000.08	3002.26	2983.43	2990.25	38118.0
2018-03-19 05:00:00	ES	Futures	2990.53	2994.89	2988.34	2993.8	18098.0
2018-03-19 06:00:00	ES	Futures	2993.8	2994.62	2991.62	2992.16	10291.0
2018-03-19 07:00:00	ES	Futures	2992.44	2992.98	2988.89	2992.44	14525.0
2018-03-19 08:00:00	ES	Futures	2992.44	2997.08	2992.16	2994.07	25134.0
2018-03-19 09:00:00	ES	Futures	2993.8	2996.8	2984.8	2989.71	157488.0
2018-03-19 10:00:00	ES	Futures	2989.43	2990.53	2975.79	2977.43	209965.0
2018-03-19 11:00:00	ES	Futures	2977.7	2979.88	2961.87	2964.6	229070.0
2018-03-19 12:00:00	ES	Futures	2964.33	2967.6	2955.87	2961.33	249673.0
2018-03-19 13:00:00	ES	Futures	2961.05	2962.14	2946.32	2958.05	271590.0
2018-03-19 14:00:00	ES	Futures	2957.78	2961.05	2944.4	2954.5	215067.0
2018-03-19 15:00:00	ES	Futures	2954.78	2968.15	2949.04	2965.15	340870.0
2018-03-19 16:00:00	ES	Futures	2965.15	2973.88	2964.05	2972.24	98543.0
2018-03-19 17:00:00	ES	Futures	2972.24	2972.24	2971.97	2971.97	9.0
2018-03-19 18:00:00	ES	Futures	2970.88	2971.15	2966.78	2968.69	9405.0
2018-03-19 19:00:00	ES	Futures	2968.42	2968.97	2965.15	2967.33	5480.0
2018-03-19 20:00:00	ES	Futures	2967.33	2973.88	2966.78	2968.42	11136.0
2018-03-19 21:00:00	ES	Futures	2968.15	2974.42	2967.88	2970.88	9354.0
2018-03-19 22:00:00	ES	Futures	2970.6	2971.42	2968.15	2968.69	5000.0
2018-03-19 23:00:00	ES	Futures	2968.97	2973.33	2968.97	2971.97	4939.0
2018-03-19 00:00:00	NQ	Futures	8281.7	8284.95	8277.56	8278.45	1917.0
2018-03-19 01:00:00	NQ	Futures	8278.45	8278.45	8249.48	8263.08	6129.0
2018-03-19 02:00:00	NQ	Futures	8263.37	8265.15	8252.74	8258.65	2504.0
2018-03-19 03:00:00	NQ	Futures	8259.24	8265.44	8253.92	8260.71	2426.0
2018-03-19 04:00:00	NQ	Futures	8261.01	8268.4	8189.79	8216.98	16215.0
2018-03-19 05:00:00	NQ	Futures	8216.98	8231.16	8209.88	8229.98	5466.0
2018-03-19 06:00:00	NQ	Futures	8230.27	8231.75	8209.29	8212.84	4847.0
2018-03-19 07:00:00	NQ	Futures	8212.84	8221.7	8203.97	8219.93	7216.0
2018-03-19 08:00:00	NQ	Futures	8219.64	8240.03	8217.86	8232.64	8829.0
2018-03-19 09:00:00	NQ	Futures	8232.34	8243.87	8207.22	8224.96	56958.0
2018-03-19 10:00:00	NQ	Futures	8224.66	8229.68	8162.6	8168.21	61961.0
2018-03-19 11:00:00	NQ	Futures	8168.21	8171.76	8086.65	8094.03	82426.0
2018-03-19 12:00:00	NQ	Futures	8094.03	8124.77	8079.85	8109.99	72615.0
2018-03-19 13:00:00	NQ	Futures	8109.7	8113.83	8069.21	8100.83	62586.0
2018-03-19 14:00:00	NQ	Futures	8100.83	8116.2	8063.59	8100.83	51485.0
2018-03-19 15:00:00	NQ	Futures	8100.54	8142.8	8086.35	8139.84	73860.0
2018-03-19 16:00:00	NQ	Futures	8139.25	8177.97	8138.07	8175.31	16815.0
2018-03-19 18:00:00	NQ	Futures	8170.58	8170.58	8151.37	8155.5	3456.0
2018-03-19 19:00:00	NQ	Futures	8155.21	8157.57	8135.11	8139.25	3641.0
2018-03-19 20:00:00	NQ	Futures	8139.55	8162.01	8134.52	8143.39	4802.0
2018-03-19 21:00:00	NQ	Futures	8143.09	8160.82	8140.43	8146.93	3669.0
2018-03-19 22:00:00	NQ	Futures	8146.34	8147.82	8135.7	8137.77	2992.0
2018-03-19 23:00:00	NQ	Futures	8138.36	8149.89	8138.36	8141.02	2197.0
2018-03-19 00:00:00	YM	Futures	27040.9	27049.6	27037.6	27043.1	682.0
2018-03-19 01:00:00	YM	Futures	27042.0	27071.3	27014.8	27047.4	2760.0
2018-03-19 02:00:00	YM	Futures	27047.4	27052.8	27026.8	27045.2	1513.0

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

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