PREVIEW / futures_1hour / 2019-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-07.parquet
  size:    64 KB
  rows:    1,901

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-08-07 00:00:00	ES	Futures	3098.49	3100.93	3096.6	3096.6	13616.0
2019-08-07 01:00:00	ES	Futures	3096.6	3106.88	3095.51	3103.36	17302.0
2019-08-07 02:00:00	ES	Futures	3103.36	3111.21	3101.74	3110.67	28866.0
2019-08-07 03:00:00	ES	Futures	3110.94	3119.06	3103.9	3118.25	38117.0
2019-08-07 04:00:00	ES	Futures	3117.98	3125.02	3115.82	3122.58	35570.0
2019-08-07 05:00:00	ES	Futures	3122.58	3128.54	3119.88	3125.83	26600.0
2019-08-07 06:00:00	ES	Futures	3125.83	3127.46	3120.96	3121.23	22176.0
2019-08-07 07:00:00	ES	Futures	3121.5	3123.67	3114.19	3114.46	46556.0
2019-08-07 08:00:00	ES	Futures	3114.19	3114.19	3081.17	3083.06	157849.0
2019-08-07 09:00:00	ES	Futures	3083.06	3086.31	3057.07	3071.69	390513.0
2019-08-07 10:00:00	ES	Futures	3071.96	3105.26	3066.28	3101.2	432918.0
2019-08-07 11:00:00	ES	Futures	3101.2	3104.18	3084.14	3088.47	273269.0
2019-08-07 12:00:00	ES	Futures	3088.47	3098.76	3080.08	3097.95	207115.0
2019-08-07 13:00:00	ES	Futures	3097.95	3117.17	3096.32	3108.51	190160.0
2019-08-07 14:00:00	ES	Futures	3108.51	3123.4	3103.36	3123.12	209381.0
2019-08-07 15:00:00	ES	Futures	3123.12	3130.97	3113.65	3122.04	303386.0
2019-08-07 16:00:00	ES	Futures	3122.04	3125.83	3116.9	3118.52	64901.0
2019-08-07 18:00:00	ES	Futures	3117.44	3122.85	3114.19	3121.23	7615.0
2019-08-07 19:00:00	ES	Futures	3121.5	3124.48	3112.03	3112.57	10723.0
2019-08-07 20:00:00	ES	Futures	3112.57	3116.09	3110.13	3110.13	13693.0
2019-08-07 21:00:00	ES	Futures	3110.4	3134.22	3108.24	3131.79	46772.0
2019-08-07 22:00:00	ES	Futures	3132.06	3132.33	3120.69	3122.04	15680.0
2019-08-07 23:00:00	ES	Futures	3121.77	3133.68	3121.77	3133.68	14053.0
2019-08-07 00:00:00	NQ	Futures	8675.26	8685.7	8665.68	8665.97	4484.0
2019-08-07 01:00:00	NQ	Futures	8666.26	8701.08	8659.59	8689.19	8276.0
2019-08-07 02:00:00	NQ	Futures	8688.61	8717.91	8682.51	8716.46	12560.0
2019-08-07 03:00:00	NQ	Futures	8716.75	8751.28	8694.41	8744.89	14203.0
2019-08-07 04:00:00	NQ	Futures	8744.6	8772.17	8740.83	8764.62	14096.0
2019-08-07 05:00:00	NQ	Futures	8765.2	8784.35	8757.37	8777.1	8213.0
2019-08-07 06:00:00	NQ	Futures	8777.1	8781.74	8753.89	8756.79	7224.0
2019-08-07 07:00:00	NQ	Futures	8757.08	8768.97	8732.71	8733.87	13201.0
2019-08-07 08:00:00	NQ	Futures	8733.29	8733.29	8625.64	8632.61	47573.0
2019-08-07 09:00:00	NQ	Futures	8632.61	8661.91	8573.71	8627.68	123632.0
2019-08-07 10:00:00	NQ	Futures	8627.39	8742.86	8611.14	8727.19	141765.0
2019-08-07 11:00:00	NQ	Futures	8727.19	8735.03	8666.55	8679.03	90781.0
2019-08-07 12:00:00	NQ	Futures	8679.61	8702.82	8643.92	8691.51	70298.0
2019-08-07 13:00:00	NQ	Futures	8691.8	8763.17	8686.28	8735.03	67101.0
2019-08-07 14:00:00	NQ	Futures	8735.32	8777.39	8716.17	8774.78	72715.0
2019-08-07 15:00:00	NQ	Futures	8775.07	8794.22	8742.28	8772.75	84704.0
2019-08-07 16:00:00	NQ	Futures	8772.46	8783.48	8756.79	8762.88	9635.0
2019-08-07 18:00:00	NQ	Futures	8766.36	8779.42	8750.41	8775.07	4570.0
2019-08-07 19:00:00	NQ	Futures	8775.07	8786.96	8746.63	8747.79	5931.0
2019-08-07 20:00:00	NQ	Futures	8748.37	8762.3	8739.09	8741.99	6702.0
2019-08-07 21:00:00	NQ	Futures	8742.28	8820.33	8734.45	8816.56	19440.0
2019-08-07 22:00:00	NQ	Futures	8816.56	8818.3	8781.74	8786.09	7934.0
2019-08-07 23:00:00	NQ	Futures	8786.09	8825.55	8786.09	8821.49	6686.0
2019-08-07 00:00:00	YM	Futures	28056.4	28086.9	28040.1	28041.2	3130.0
2019-08-07 01:00:00	YM	Futures	28041.2	28134.7	28029.2	28104.3	4213.0
2019-08-07 02:00:00	YM	Futures	28103.2	28165.2	28090.1	28163.0	5454.0
2019-08-07 03:00:00	YM	Futures	28163.0	28239.1	28104.3	28227.2	6077.0

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

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