PREVIEW / futures_1hour / 2019-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-04.parquet
  size:    60 KB
  rows:    1,853

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-04 00:00:00	ES	Futures	2984.84	2985.92	2982.94	2983.48	5186.0
2019-06-04 01:00:00	ES	Futures	2983.48	2985.65	2982.4	2984.84	7234.0
2019-06-04 02:00:00	ES	Futures	2985.11	2986.19	2979.41	2982.13	14922.0
2019-06-04 03:00:00	ES	Futures	2982.4	2994.32	2980.23	2992.7	44336.0
2019-06-04 04:00:00	ES	Futures	2992.7	2995.41	2988.9	2994.87	27668.0
2019-06-04 05:00:00	ES	Futures	2995.14	2996.22	2990.8	2995.68	27390.0
2019-06-04 06:00:00	ES	Futures	2995.68	2997.85	2993.24	2993.78	19414.0
2019-06-04 07:00:00	ES	Futures	2993.78	3003.0	2991.88	2998.66	43057.0
2019-06-04 08:00:00	ES	Futures	2998.66	3003.81	2996.76	3002.46	47114.0
2019-06-04 09:00:00	ES	Futures	3002.73	3008.42	2997.31	3002.46	245442.0
2019-06-04 10:00:00	ES	Futures	3002.46	3015.2	2998.12	3013.57	326945.0
2019-06-04 11:00:00	ES	Futures	3013.57	3027.4	3011.68	3024.96	235548.0
2019-06-04 12:00:00	ES	Futures	3025.23	3031.19	3019.81	3028.48	123771.0
2019-06-04 13:00:00	ES	Futures	3028.48	3032.55	3024.42	3032.01	125174.0
2019-06-04 14:00:00	ES	Futures	3032.01	3032.55	3026.31	3026.59	87547.0
2019-06-04 15:00:00	ES	Futures	3026.86	3041.77	3026.86	3039.87	242563.0
2019-06-04 16:00:00	ES	Futures	3040.14	3043.12	3039.6	3042.31	87614.0
2019-06-04 18:00:00	ES	Futures	3043.39	3050.98	3043.39	3045.29	19068.0
2019-06-04 19:00:00	ES	Futures	3045.02	3049.9	3044.75	3049.36	8485.0
2019-06-04 20:00:00	ES	Futures	3049.36	3050.17	3044.21	3049.09	15770.0
2019-06-04 21:00:00	ES	Futures	3049.36	3052.34	3048.55	3051.8	19073.0
2019-06-04 22:00:00	ES	Futures	3051.8	3052.88	3048.82	3049.36	12032.0
2019-06-04 23:00:00	ES	Futures	3049.09	3050.71	3048.55	3049.9	7611.0
2019-06-04 00:00:00	NQ	Futures	8153.83	8157.32	8148.0	8149.75	2125.0
2019-06-04 01:00:00	NQ	Futures	8150.04	8155.28	8147.13	8153.24	2605.0
2019-06-04 02:00:00	NQ	Futures	8153.53	8157.03	8134.9	8144.51	4647.0
2019-06-04 03:00:00	NQ	Futures	8144.8	8184.4	8139.27	8180.03	12710.0
2019-06-04 04:00:00	NQ	Futures	8180.03	8191.38	8169.55	8189.06	8314.0
2019-06-04 05:00:00	NQ	Futures	8189.06	8194.59	8175.66	8190.8	8721.0
2019-06-04 06:00:00	NQ	Futures	8190.51	8197.79	8178.57	8179.16	7047.0
2019-06-04 07:00:00	NQ	Futures	8179.16	8208.85	8172.17	8192.26	13528.0
2019-06-04 08:00:00	NQ	Futures	8191.68	8218.46	8187.02	8210.02	18255.0
2019-06-04 09:00:00	NQ	Futures	8210.31	8231.27	8184.11	8199.83	86097.0
2019-06-04 10:00:00	NQ	Futures	8199.83	8260.1	8187.02	8257.77	110276.0
2019-06-04 11:00:00	NQ	Futures	8257.77	8318.91	8251.65	8307.26	76016.0
2019-06-04 12:00:00	NQ	Futures	8307.56	8320.37	8283.97	8313.09	43549.0
2019-06-04 13:00:00	NQ	Futures	8313.09	8336.67	8304.35	8332.89	37925.0
2019-06-04 14:00:00	NQ	Futures	8333.18	8336.96	8311.05	8315.13	31343.0
2019-06-04 15:00:00	NQ	Futures	8315.13	8355.89	8314.54	8352.1	48885.0
2019-06-04 16:00:00	NQ	Futures	8352.1	8369.57	8349.77	8369.28	17142.0
2019-06-04 18:00:00	NQ	Futures	8372.48	8397.81	8372.19	8379.18	7323.0
2019-06-04 19:00:00	NQ	Futures	8378.6	8391.7	8377.72	8390.83	3787.0
2019-06-04 20:00:00	NQ	Futures	8390.83	8395.19	8378.02	8392.86	6466.0
2019-06-04 21:00:00	NQ	Futures	8392.57	8409.17	8390.83	8407.42	7449.0
2019-06-04 22:00:00	NQ	Futures	8406.84	8409.46	8391.12	8394.03	4286.0
2019-06-04 23:00:00	NQ	Futures	8393.74	8400.43	8391.41	8394.61	2676.0
2019-06-04 00:00:00	YM	Futures	27077.5	27091.6	27057.9	27062.2	1660.0
2019-06-04 01:00:00	YM	Futures	27063.3	27079.6	27053.5	27075.3	2097.0
2019-06-04 02:00:00	YM	Futures	27075.3	27085.1	27026.4	27054.6	3241.0
2019-06-04 03:00:00	YM	Futures	27054.6	27164.5	27036.1	27143.8	8943.0

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

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