PREVIEW / futures_1hour / 2018-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-29.parquet
  size:    56 KB
  rows:    1,709

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-01-29 00:00:00	ES	Futures	3142.18	3142.45	3139.72	3140.54	6202.0
2018-01-29 01:00:00	ES	Futures	3140.54	3142.18	3139.45	3141.63	4315.0
2018-01-29 02:00:00	ES	Futures	3141.63	3143.0	3141.09	3141.63	9375.0
2018-01-29 03:00:00	ES	Futures	3141.36	3141.63	3135.62	3135.62	22857.0
2018-01-29 04:00:00	ES	Futures	3135.89	3139.45	3131.79	3132.34	26707.0
2018-01-29 05:00:00	ES	Futures	3132.07	3135.35	3131.25	3135.07	15825.0
2018-01-29 06:00:00	ES	Futures	3135.35	3136.17	3132.34	3136.17	13713.0
2018-01-29 07:00:00	ES	Futures	3135.89	3136.17	3132.34	3134.53	18222.0
2018-01-29 08:00:00	ES	Futures	3134.53	3136.71	3132.34	3132.61	26719.0
2018-01-29 09:00:00	ES	Futures	3132.61	3139.17	3130.7	3136.99	166701.0
2018-01-29 10:00:00	ES	Futures	3137.26	3137.53	3122.23	3125.78	252593.0
2018-01-29 11:00:00	ES	Futures	3125.78	3132.89	3120.86	3128.51	174520.0
2018-01-29 12:00:00	ES	Futures	3128.24	3133.98	3125.78	3133.16	81005.0
2018-01-29 13:00:00	ES	Futures	3133.43	3135.89	3130.7	3131.25	61192.0
2018-01-29 14:00:00	ES	Futures	3131.52	3133.71	3126.05	3129.61	69262.0
2018-01-29 15:00:00	ES	Futures	3129.88	3131.25	3117.58	3119.22	263858.0
2018-01-29 16:00:00	ES	Futures	3119.49	3122.77	3118.13	3119.49	78311.0
2018-01-29 18:00:00	ES	Futures	3119.49	3123.87	3119.49	3123.59	9367.0
2018-01-29 19:00:00	ES	Futures	3123.32	3124.69	3120.04	3120.59	9856.0
2018-01-29 20:00:00	ES	Futures	3120.59	3120.59	3116.21	3119.22	15686.0
2018-01-29 21:00:00	ES	Futures	3118.95	3121.41	3118.95	3120.59	10159.0
2018-01-29 22:00:00	ES	Futures	3120.59	3121.13	3103.09	3105.83	39507.0
2018-01-29 23:00:00	ES	Futures	3106.1	3108.83	3095.17	3104.19	30901.0
2018-01-29 00:00:00	NQ	Futures	8340.82	8342.9	8333.41	8336.37	1747.0
2018-01-29 01:00:00	NQ	Futures	8336.67	8338.45	8330.74	8336.97	1641.0
2018-01-29 02:00:00	NQ	Futures	8336.97	8341.12	8334.89	8336.97	1484.0
2018-01-29 03:00:00	NQ	Futures	8337.26	8337.56	8317.1	8317.39	5061.0
2018-01-29 04:00:00	NQ	Futures	8317.39	8329.55	8308.49	8309.38	5386.0
2018-01-29 05:00:00	NQ	Futures	8309.38	8319.77	8305.53	8318.88	5054.0
2018-01-29 06:00:00	NQ	Futures	8318.58	8322.14	8307.61	8321.25	3182.0
2018-01-29 07:00:00	NQ	Futures	8321.25	8323.32	8308.79	8316.8	6945.0
2018-01-29 08:00:00	NQ	Futures	8316.8	8324.51	8313.24	8315.61	8333.0
2018-01-29 09:00:00	NQ	Futures	8315.61	8329.85	8295.74	8323.32	61621.0
2018-01-29 10:00:00	NQ	Futures	8323.62	8324.21	8282.69	8297.82	78192.0
2018-01-29 11:00:00	NQ	Futures	8297.82	8322.14	8281.5	8311.16	56942.0
2018-01-29 12:00:00	NQ	Futures	8311.16	8327.77	8303.45	8325.1	28961.0
2018-01-29 13:00:00	NQ	Futures	8325.1	8337.26	8317.69	8321.25	22835.0
2018-01-29 14:00:00	NQ	Futures	8321.25	8327.18	8306.42	8314.72	25644.0
2018-01-29 15:00:00	NQ	Futures	8314.72	8321.25	8280.91	8296.33	61151.0
2018-01-29 16:00:00	NQ	Futures	8296.04	8304.05	8292.48	8298.71	10400.0
2018-01-29 18:00:00	NQ	Futures	8294.55	8311.16	8294.55	8309.98	2049.0
2018-01-29 19:00:00	NQ	Futures	8309.68	8312.35	8301.38	8301.97	2429.0
2018-01-29 20:00:00	NQ	Futures	8301.97	8302.56	8290.7	8301.97	2852.0
2018-01-29 21:00:00	NQ	Futures	8302.27	8306.72	8300.19	8303.45	2053.0
2018-01-29 22:00:00	NQ	Futures	8303.75	8305.83	8246.51	8253.03	8472.0
2018-01-29 23:00:00	NQ	Futures	8253.62	8262.82	8216.55	8245.32	10107.0
2018-01-29 00:00:00	YM	Futures	28946.9	28954.5	28927.3	28934.9	1312.0
2018-01-29 01:00:00	YM	Futures	28936.0	28949.1	28915.4	28941.4	1734.0
2018-01-29 02:00:00	YM	Futures	28941.4	28956.7	28936.0	28949.1	1790.0
2018-01-29 03:00:00	YM	Futures	28948.0	28948.0	28894.7	28894.7	4717.0

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

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