PREVIEW / futures_1hour / 2018-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-26.parquet
  size:    54 KB
  rows:    1,686

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-02-26 00:00:00	ES	Futures	3006.88	3009.34	3006.33	3009.07	3655.0
2018-02-26 01:00:00	ES	Futures	3008.79	3011.25	3008.79	3009.07	5490.0
2018-02-26 02:00:00	ES	Futures	3009.34	3011.53	3006.88	3009.34	13367.0
2018-02-26 03:00:00	ES	Futures	3009.34	3017.81	3007.97	3017.27	24441.0
2018-02-26 04:00:00	ES	Futures	3017.54	3019.18	3013.99	3014.53	15134.0
2018-02-26 05:00:00	ES	Futures	3014.53	3018.09	3014.53	3017.54	10541.0
2018-02-26 06:00:00	ES	Futures	3017.81	3018.91	3015.63	3016.45	8828.0
2018-02-26 07:00:00	ES	Futures	3016.45	3018.63	3013.71	3017.27	14557.0
2018-02-26 08:00:00	ES	Futures	3017.27	3018.63	3013.99	3015.63	18431.0
2018-02-26 09:00:00	ES	Futures	3015.35	3025.47	3014.26	3020.27	162721.0
2018-02-26 10:00:00	ES	Futures	3020.0	3021.91	3009.61	3013.71	163828.0
2018-02-26 11:00:00	ES	Futures	3013.71	3023.83	3011.53	3020.82	107809.0
2018-02-26 12:00:00	ES	Futures	3021.09	3031.21	3020.55	3029.84	105564.0
2018-02-26 13:00:00	ES	Futures	3030.11	3032.57	3029.02	3031.75	68997.0
2018-02-26 14:00:00	ES	Futures	3031.48	3034.76	3027.93	3031.48	102228.0
2018-02-26 15:00:00	ES	Futures	3031.21	3039.95	3030.39	3038.59	252740.0
2018-02-26 16:00:00	ES	Futures	3038.86	3045.97	3037.77	3043.78	74257.0
2018-02-26 18:00:00	ES	Futures	3043.23	3045.69	3042.41	3043.51	6047.0
2018-02-26 19:00:00	ES	Futures	3043.51	3044.05	3041.05	3043.78	5446.0
2018-02-26 20:00:00	ES	Futures	3043.51	3047.06	3042.69	3044.33	5989.0
2018-02-26 21:00:00	ES	Futures	3044.6	3045.69	3042.41	3042.41	4137.0
2018-02-26 22:00:00	ES	Futures	3042.41	3042.69	3039.68	3040.5	5864.0
2018-02-26 23:00:00	ES	Futures	3040.23	3040.77	3038.31	3039.41	3799.0
2018-02-26 00:00:00	NQ	Futures	8189.56	8199.94	8188.67	8198.75	1706.0
2018-02-26 01:00:00	NQ	Futures	8198.46	8201.72	8196.98	8198.46	1281.0
2018-02-26 02:00:00	NQ	Futures	8198.16	8200.83	8187.78	8194.01	4263.0
2018-02-26 03:00:00	NQ	Futures	8194.01	8215.36	8189.86	8213.58	6556.0
2018-02-26 04:00:00	NQ	Futures	8213.29	8217.74	8204.09	8205.58	4324.0
2018-02-26 05:00:00	NQ	Futures	8205.87	8216.25	8204.98	8216.25	2317.0
2018-02-26 06:00:00	NQ	Futures	8216.25	8222.78	8214.77	8220.11	3592.0
2018-02-26 07:00:00	NQ	Futures	8219.81	8231.08	8218.63	8230.19	5838.0
2018-02-26 08:00:00	NQ	Futures	8230.49	8234.05	8223.97	8226.63	6728.0
2018-02-26 09:00:00	NQ	Futures	8226.93	8262.82	8221.0	8255.4	43872.0
2018-02-26 10:00:00	NQ	Futures	8255.11	8264.9	8226.34	8235.24	50632.0
2018-02-26 11:00:00	NQ	Futures	8235.24	8264.6	8229.01	8255.7	32771.0
2018-02-26 12:00:00	NQ	Futures	8256.0	8272.31	8254.22	8269.34	24926.0
2018-02-26 13:00:00	NQ	Futures	8269.05	8274.98	8264.6	8270.83	13714.0
2018-02-26 14:00:00	NQ	Futures	8271.12	8286.84	8270.83	8277.95	23811.0
2018-02-26 15:00:00	NQ	Futures	8277.35	8296.63	8274.98	8295.44	34121.0
2018-02-26 16:00:00	NQ	Futures	8296.04	8313.54	8292.78	8308.79	8828.0
2018-02-26 18:00:00	NQ	Futures	8308.79	8310.27	8302.56	8305.83	2064.0
2018-02-26 19:00:00	NQ	Futures	8305.83	8307.9	8299.6	8307.01	2409.0
2018-02-26 20:00:00	NQ	Futures	8307.01	8315.32	8304.94	8310.27	3396.0
2018-02-26 21:00:00	NQ	Futures	8310.57	8312.65	8301.67	8301.67	1976.0
2018-02-26 22:00:00	NQ	Futures	8301.97	8304.34	8296.63	8299.6	2586.0
2018-02-26 23:00:00	NQ	Futures	8299.0	8301.67	8295.15	8299.3	1126.0
2018-02-26 00:00:00	YM	Futures	27569.8	27602.4	27565.5	27598.1	1862.0
2018-02-26 01:00:00	YM	Futures	27598.1	27642.6	27598.1	27624.1	2941.0
2018-02-26 02:00:00	YM	Futures	27624.1	27653.5	27618.7	27632.8	4448.0
2018-02-26 03:00:00	YM	Futures	27632.8	27725.2	27619.8	27714.4	6713.0

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

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