PREVIEW / futures_1hour / 2020-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-15.parquet
  size:    52 KB
  rows:    1,511

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
2020-05-15 00:00:00	ES	Futures	3125.58	3131.34	3122.29	3128.87	10781.0
2020-05-15 01:00:00	ES	Futures	3128.87	3134.09	3122.83	3122.83	9288.0
2020-05-15 02:00:00	ES	Futures	3123.11	3126.4	3119.54	3124.76	13319.0
2020-05-15 03:00:00	ES	Futures	3125.03	3143.14	3125.03	3140.12	42172.0
2020-05-15 04:00:00	ES	Futures	3140.4	3140.95	3130.79	3135.18	29244.0
2020-05-15 05:00:00	ES	Futures	3135.18	3138.48	3125.85	3128.87	26686.0
2020-05-15 06:00:00	ES	Futures	3128.87	3132.99	3103.9	3105.55	49119.0
2020-05-15 07:00:00	ES	Futures	3105.82	3106.37	3087.44	3089.36	82308.0
2020-05-15 08:00:00	ES	Futures	3089.36	3101.98	3085.24	3095.12	89157.0
2020-05-15 09:00:00	ES	Futures	3094.84	3115.7	3083.87	3111.04	237166.0
2020-05-15 10:00:00	ES	Futures	3111.31	3125.03	3097.59	3100.88	259920.0
2020-05-15 11:00:00	ES	Futures	3100.88	3105.55	3089.63	3103.63	168717.0
2020-05-15 12:00:00	ES	Futures	3103.35	3121.74	3101.43	3114.6	140225.0
2020-05-15 13:00:00	ES	Futures	3114.6	3125.85	3113.5	3124.21	117706.0
2020-05-15 14:00:00	ES	Futures	3124.21	3134.63	3118.17	3120.09	146531.0
2020-05-15 15:00:00	ES	Futures	3120.09	3138.75	3117.07	3138.2	251135.0
2020-05-15 16:00:00	ES	Futures	3138.2	3138.75	3123.38	3133.54	81302.0
2020-05-15 00:00:00	NQ	Futures	10391.61	10412.46	10382.18	10405.89	4005.0
2020-05-15 01:00:00	NQ	Futures	10405.6	10424.46	10383.04	10384.75	4101.0
2020-05-15 02:00:00	NQ	Futures	10385.04	10403.03	10373.61	10399.32	4984.0
2020-05-15 03:00:00	NQ	Futures	10399.32	10446.45	10398.18	10438.45	11515.0
2020-05-15 04:00:00	NQ	Futures	10438.17	10440.74	10412.17	10427.88	6883.0
2020-05-15 05:00:00	NQ	Futures	10428.45	10439.31	10399.89	10409.32	6703.0
2020-05-15 06:00:00	NQ	Futures	10410.17	10428.45	10321.62	10326.19	13754.0
2020-05-15 07:00:00	NQ	Futures	10326.48	10327.91	10224.22	10225.08	25826.0
2020-05-15 08:00:00	NQ	Futures	10225.36	10259.93	10201.08	10229.36	26958.0
2020-05-15 09:00:00	NQ	Futures	10229.08	10304.2	10197.94	10300.77	76170.0
2020-05-15 10:00:00	NQ	Futures	10300.49	10348.47	10245.07	10253.36	64418.0
2020-05-15 11:00:00	NQ	Futures	10253.07	10281.06	10221.08	10276.21	51062.0
2020-05-15 12:00:00	NQ	Futures	10276.21	10358.19	10269.92	10349.33	47502.0
2020-05-15 13:00:00	NQ	Futures	10349.9	10402.75	10337.62	10374.18	43621.0
2020-05-15 14:00:00	NQ	Futures	10373.9	10413.32	10357.62	10370.18	37093.0
2020-05-15 15:00:00	NQ	Futures	10370.75	10452.73	10361.04	10449.88	60166.0
2020-05-15 16:00:00	NQ	Futures	10449.88	10451.02	10387.04	10417.31	14695.0
2020-05-15 00:00:00	YM	Futures	25786.0	25840.7	25757.5	25818.8	2782.0
2020-05-15 01:00:00	YM	Futures	25817.7	25863.7	25770.6	25772.8	2485.0
2020-05-15 02:00:00	YM	Futures	25772.8	25806.8	25746.5	25791.4	3680.0
2020-05-15 03:00:00	YM	Futures	25792.5	25933.8	25791.4	25911.9	8809.0
2020-05-15 04:00:00	YM	Futures	25911.9	25924.0	25828.7	25868.1	6730.0
2020-05-15 05:00:00	YM	Futures	25870.3	25906.4	25796.9	25814.4	5446.0
2020-05-15 06:00:00	YM	Futures	25814.4	25851.7	25604.1	25618.4	8949.0
2020-05-15 07:00:00	YM	Futures	25618.4	25621.7	25470.5	25489.1	14690.0
2020-05-15 08:00:00	YM	Futures	25489.1	25604.1	25456.3	25552.7	15498.0
2020-05-15 09:00:00	YM	Futures	25553.8	25758.6	25474.9	25710.4	33965.0
2020-05-15 10:00:00	YM	Futures	25709.3	25812.3	25588.8	25614.0	30023.0
2020-05-15 11:00:00	YM	Futures	25612.9	25635.9	25504.5	25602.0	25356.0
2020-05-15 12:00:00	YM	Futures	25600.9	25748.7	25586.6	25677.5	20604.0
2020-05-15 13:00:00	YM	Futures	25677.5	25780.5	25671.0	25773.9	17579.0
2020-05-15 14:00:00	YM	Futures	25772.8	25896.6	25755.3	25767.3	21523.0
2020-05-15 15:00:00	YM	Futures	25767.3	25871.4	25717.0	25861.5	29151.0

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

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