PREVIEW / futures_1hour / 2019-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-07.parquet
  size:    49 KB
  rows:    1,460

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-07 00:00:00	ES	Futures	3090.29	3091.11	3090.02	3090.57	2807.0
2019-06-07 01:00:00	ES	Futures	3090.57	3091.38	3089.21	3091.11	4347.0
2019-06-07 02:00:00	ES	Futures	3090.84	3091.65	3087.85	3089.21	10282.0
2019-06-07 03:00:00	ES	Futures	3089.48	3094.36	3088.94	3091.92	21554.0
2019-06-07 04:00:00	ES	Futures	3091.92	3096.53	3091.92	3094.36	18241.0
2019-06-07 05:00:00	ES	Futures	3094.36	3096.53	3093.82	3094.9	14008.0
2019-06-07 06:00:00	ES	Futures	3094.63	3097.89	3093.82	3097.07	17272.0
2019-06-07 07:00:00	ES	Futures	3097.34	3097.34	3094.63	3094.9	17535.0
2019-06-07 08:00:00	ES	Futures	3094.63	3102.77	3086.5	3093.01	138185.0
2019-06-07 09:00:00	ES	Futures	3093.01	3110.63	3091.92	3110.36	244989.0
2019-06-07 10:00:00	ES	Futures	3110.36	3128.79	3109.54	3128.79	286129.0
2019-06-07 11:00:00	ES	Futures	3128.79	3129.88	3117.41	3119.03	196966.0
2019-06-07 12:00:00	ES	Futures	3119.03	3126.08	3116.59	3126.08	109787.0
2019-06-07 13:00:00	ES	Futures	3126.08	3127.16	3119.84	3123.64	89502.0
2019-06-07 14:00:00	ES	Futures	3123.91	3124.72	3117.41	3117.95	92659.0
2019-06-07 15:00:00	ES	Futures	3117.95	3123.64	3114.97	3116.05	203421.0
2019-06-07 16:00:00	ES	Futures	3116.05	3120.93	3113.07	3120.39	83216.0
2019-06-07 00:00:00	NQ	Futures	8489.82	8493.31	8489.53	8489.82	1278.0
2019-06-07 01:00:00	NQ	Futures	8489.82	8492.73	8485.74	8491.28	1808.0
2019-06-07 02:00:00	NQ	Futures	8491.57	8492.44	8481.08	8485.16	2955.0
2019-06-07 03:00:00	NQ	Futures	8484.87	8500.59	8482.83	8493.31	6451.0
2019-06-07 04:00:00	NQ	Futures	8493.6	8516.9	8493.02	8511.36	7218.0
2019-06-07 05:00:00	NQ	Futures	8511.36	8520.39	8510.2	8514.28	3845.0
2019-06-07 06:00:00	NQ	Futures	8514.28	8526.21	8510.49	8524.18	4374.0
2019-06-07 07:00:00	NQ	Futures	8524.18	8525.34	8511.07	8512.24	4475.0
2019-06-07 08:00:00	NQ	Futures	8512.24	8543.1	8485.74	8511.95	34558.0
2019-06-07 09:00:00	NQ	Futures	8511.95	8588.23	8505.25	8585.9	88058.0
2019-06-07 10:00:00	NQ	Futures	8585.9	8671.79	8585.61	8670.92	92756.0
2019-06-07 11:00:00	NQ	Futures	8670.92	8679.94	8635.4	8645.3	66292.0
2019-06-07 12:00:00	NQ	Futures	8645.59	8663.64	8637.44	8662.77	30226.0
2019-06-07 13:00:00	NQ	Futures	8663.06	8666.84	8645.88	8660.73	24046.0
2019-06-07 14:00:00	NQ	Futures	8660.73	8665.39	8640.06	8641.22	27750.0
2019-06-07 15:00:00	NQ	Futures	8641.22	8658.69	8638.02	8642.97	43762.0
2019-06-07 16:00:00	NQ	Futures	8642.68	8652.58	8631.61	8652.28	14902.0
2019-06-07 00:00:00	YM	Futures	28040.1	28048.8	28036.8	28042.2	823.0
2019-06-07 01:00:00	YM	Futures	28042.2	28050.9	28032.4	28045.5	1094.0
2019-06-07 02:00:00	YM	Futures	28045.5	28054.2	28020.5	28029.2	2748.0
2019-06-07 03:00:00	YM	Futures	28029.2	28076.0	28024.8	28060.7	4372.0
2019-06-07 04:00:00	YM	Futures	28059.6	28101.0	28057.5	28082.5	4100.0
2019-06-07 05:00:00	YM	Futures	28082.5	28097.7	28077.0	28081.4	2470.0
2019-06-07 06:00:00	YM	Futures	28080.3	28104.2	28069.4	28098.8	2762.0
2019-06-07 07:00:00	YM	Futures	28098.8	28102.1	28076.0	28079.2	2410.0
2019-06-07 08:00:00	YM	Futures	28079.2	28127.1	27995.5	28045.5	20157.0
2019-06-07 09:00:00	YM	Futures	28045.5	28211.9	28035.7	28205.4	28424.0
2019-06-07 10:00:00	YM	Futures	28205.4	28362.0	28203.2	28360.9	32036.0
2019-06-07 11:00:00	YM	Futures	28360.9	28371.8	28258.7	28279.3	25010.0
2019-06-07 12:00:00	YM	Futures	28278.3	28337.0	28251.1	28334.8	13873.0
2019-06-07 13:00:00	YM	Futures	28335.9	28342.4	28281.5	28318.5	11638.0
2019-06-07 14:00:00	YM	Futures	28319.6	28342.4	28287.0	28289.1	11461.0
2019-06-07 15:00:00	YM	Futures	28289.1	28331.6	28253.2	28271.7	18836.0

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

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