PREVIEW / futures_1hour / 2018-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-24.parquet
  size:    57 KB
  rows:    1,687

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-24 00:00:00	ES	Futures	3104.19	3105.01	3103.64	3103.91	3795.0
2018-01-24 01:00:00	ES	Futures	3103.64	3107.74	3103.09	3107.19	5734.0
2018-01-24 02:00:00	ES	Futures	3107.19	3108.01	3106.1	3106.65	4815.0
2018-01-24 03:00:00	ES	Futures	3106.92	3110.75	3106.65	3109.11	13776.0
2018-01-24 04:00:00	ES	Futures	3109.11	3110.47	3108.01	3108.56	10771.0
2018-01-24 05:00:00	ES	Futures	3108.56	3112.39	3108.29	3109.93	14239.0
2018-01-24 06:00:00	ES	Futures	3109.93	3111.29	3108.29	3108.29	19529.0
2018-01-24 07:00:00	ES	Futures	3108.29	3113.21	3108.29	3110.75	23092.0
2018-01-24 08:00:00	ES	Futures	3110.47	3116.21	3110.47	3114.03	34023.0
2018-01-24 09:00:00	ES	Futures	3114.03	3117.85	3111.02	3117.03	164983.0
2018-01-24 10:00:00	ES	Futures	3117.31	3121.68	3114.3	3115.39	214086.0
2018-01-24 11:00:00	ES	Futures	3115.67	3117.58	3097.35	3103.91	358917.0
2018-01-24 12:00:00	ES	Futures	3103.91	3105.83	3093.8	3098.72	183375.0
2018-01-24 13:00:00	ES	Futures	3098.72	3106.65	3089.15	3103.64	257694.0
2018-01-24 14:00:00	ES	Futures	3103.64	3110.75	3101.73	3107.74	113741.0
2018-01-24 15:00:00	ES	Futures	3107.74	3111.02	3102.82	3104.19	229581.0
2018-01-24 16:00:00	ES	Futures	3104.19	3106.92	3102.82	3105.83	68327.0
2018-01-24 18:00:00	ES	Futures	3105.01	3105.01	3099.81	3102.0	14788.0
2018-01-24 19:00:00	ES	Futures	3102.0	3105.55	3100.09	3104.73	11965.0
2018-01-24 20:00:00	ES	Futures	3104.73	3108.56	3104.73	3105.01	11576.0
2018-01-24 21:00:00	ES	Futures	3105.28	3105.83	3102.27	3104.19	7997.0
2018-01-24 22:00:00	ES	Futures	3104.46	3106.37	3103.91	3104.73	4444.0
2018-01-24 23:00:00	ES	Futures	3104.73	3105.83	3103.09	3103.64	3861.0
2018-01-24 00:00:00	NQ	Futures	8263.71	8267.27	8263.71	8264.6	973.0
2018-01-24 01:00:00	NQ	Futures	8264.6	8274.68	8261.34	8272.01	1377.0
2018-01-24 02:00:00	NQ	Futures	8272.31	8274.09	8269.34	8271.12	1111.0
2018-01-24 03:00:00	NQ	Futures	8271.42	8280.91	8271.12	8274.68	2701.0
2018-01-24 04:00:00	NQ	Futures	8274.68	8280.32	8272.61	8275.57	2185.0
2018-01-24 05:00:00	NQ	Futures	8275.57	8288.33	8274.09	8276.46	4491.0
2018-01-24 06:00:00	NQ	Futures	8276.46	8284.47	8270.23	8272.31	3621.0
2018-01-24 07:00:00	NQ	Futures	8272.61	8281.5	8272.01	8274.68	4718.0
2018-01-24 08:00:00	NQ	Futures	8274.39	8299.3	8273.79	8291.59	10847.0
2018-01-24 09:00:00	NQ	Futures	8291.29	8297.22	8263.71	8284.17	54897.0
2018-01-24 10:00:00	NQ	Futures	8284.47	8309.68	8278.24	8284.77	62446.0
2018-01-24 11:00:00	NQ	Futures	8285.06	8289.81	8204.09	8233.16	109047.0
2018-01-24 12:00:00	NQ	Futures	8232.86	8238.8	8194.6	8212.69	68229.0
2018-01-24 13:00:00	NQ	Futures	8212.4	8237.61	8172.06	8223.97	71495.0
2018-01-24 14:00:00	NQ	Futures	8223.67	8255.4	8219.81	8242.35	45228.0
2018-01-24 15:00:00	NQ	Futures	8242.65	8244.43	8212.69	8221.3	59416.0
2018-01-24 16:00:00	NQ	Futures	8220.7	8229.6	8214.47	8228.41	10168.0
2018-01-24 18:00:00	NQ	Futures	8225.75	8226.04	8211.51	8220.7	2332.0
2018-01-24 19:00:00	NQ	Futures	8220.7	8234.94	8215.36	8231.97	3103.0
2018-01-24 20:00:00	NQ	Futures	8232.27	8239.39	8228.12	8228.71	3372.0
2018-01-24 21:00:00	NQ	Futures	8228.71	8231.38	8218.63	8225.45	2649.0
2018-01-24 22:00:00	NQ	Futures	8225.45	8231.97	8224.26	8226.04	1556.0
2018-01-24 23:00:00	NQ	Futures	8226.04	8229.9	8220.11	8221.3	1111.0
2018-01-24 00:00:00	YM	Futures	28490.4	28502.3	28490.4	28495.8	613.0
2018-01-24 01:00:00	YM	Futures	28495.8	28517.6	28485.0	28512.1	986.0
2018-01-24 02:00:00	YM	Futures	28512.1	28518.6	28502.3	28506.7	1070.0
2018-01-24 03:00:00	YM	Futures	28507.8	28549.1	28505.6	28529.5	2838.0

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

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