PREVIEW / futures_1hour / 2020-06-05

all futures 1-hour files

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

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-06-05 00:00:00	ES	Futures	3429.9	3434.3	3429.08	3431.83	9244.0
2020-06-05 01:00:00	ES	Futures	3431.83	3444.17	3429.63	3440.88	18273.0
2020-06-05 02:00:00	ES	Futures	3441.16	3444.17	3438.14	3440.88	20777.0
2020-06-05 03:00:00	ES	Futures	3440.88	3452.68	3438.41	3451.31	43078.0
2020-06-05 04:00:00	ES	Futures	3451.31	3452.13	3440.33	3444.72	37945.0
2020-06-05 05:00:00	ES	Futures	3444.72	3448.02	3437.04	3442.25	27031.0
2020-06-05 06:00:00	ES	Futures	3441.98	3442.53	3433.75	3438.69	23788.0
2020-06-05 07:00:00	ES	Futures	3438.96	3444.45	3438.41	3442.25	21044.0
2020-06-05 08:00:00	ES	Futures	3441.98	3473.54	3437.86	3469.15	182878.0
2020-06-05 09:00:00	ES	Futures	3468.87	3494.67	3466.95	3483.69	372625.0
2020-06-05 10:00:00	ES	Futures	3483.42	3500.7	3481.77	3500.7	290237.0
2020-06-05 11:00:00	ES	Futures	3500.43	3524.03	3499.33	3513.33	288829.0
2020-06-05 12:00:00	ES	Futures	3513.33	3514.97	3501.25	3511.41	156105.0
2020-06-05 13:00:00	ES	Futures	3511.41	3517.99	3506.19	3510.58	121203.0
2020-06-05 14:00:00	ES	Futures	3510.58	3516.62	3501.53	3506.47	180696.0
2020-06-05 15:00:00	ES	Futures	3506.74	3511.41	3491.65	3500.98	389058.0
2020-06-05 16:00:00	ES	Futures	3501.25	3505.09	3496.04	3496.31	86166.0
2020-06-05 00:00:00	NQ	Futures	11032.01	11044.58	11027.44	11034.87	3449.0
2020-06-05 01:00:00	NQ	Futures	11035.15	11068.29	11027.73	11061.15	4966.0
2020-06-05 02:00:00	NQ	Futures	11061.72	11074.0	11052.01	11059.15	4623.0
2020-06-05 03:00:00	NQ	Futures	11058.58	11087.71	11049.44	11082.0	9596.0
2020-06-05 04:00:00	NQ	Futures	11081.14	11082.86	11038.3	11054.01	9399.0
2020-06-05 05:00:00	NQ	Futures	11054.01	11062.29	11031.73	11045.44	7013.0
2020-06-05 06:00:00	NQ	Futures	11045.72	11045.72	11021.16	11030.58	6280.0
2020-06-05 07:00:00	NQ	Futures	11031.16	11046.01	11020.3	11021.44	6917.0
2020-06-05 08:00:00	NQ	Futures	11020.87	11048.01	10970.6	11020.02	39721.0
2020-06-05 09:00:00	NQ	Futures	11020.59	11173.12	11018.02	11148.27	97691.0
2020-06-05 10:00:00	NQ	Futures	11147.7	11181.4	11124.27	11171.41	70118.0
2020-06-05 11:00:00	NQ	Futures	11171.41	11227.11	11167.41	11209.68	47722.0
2020-06-05 12:00:00	NQ	Futures	11209.68	11244.53	11201.97	11231.96	36030.0
2020-06-05 13:00:00	NQ	Futures	11232.25	11249.96	11208.25	11216.82	29061.0
2020-06-05 14:00:00	NQ	Futures	11216.82	11249.1	11204.54	11222.82	42275.0
2020-06-05 15:00:00	NQ	Futures	11223.11	11248.81	11185.12	11215.39	56798.0
2020-06-05 16:00:00	NQ	Futures	11214.82	11220.82	11195.11	11205.97	10775.0
2020-06-05 00:00:00	YM	Futures	28912.0	28956.9	28898.9	28935.0	2146.0
2020-06-05 01:00:00	YM	Futures	28932.8	29034.7	28917.5	29022.6	3793.0
2020-06-05 02:00:00	YM	Futures	29023.7	29054.4	29001.8	29022.6	3422.0
2020-06-05 03:00:00	YM	Futures	29024.8	29186.9	29006.2	29163.9	9049.0
2020-06-05 04:00:00	YM	Futures	29162.8	29184.7	29080.7	29116.8	10217.0
2020-06-05 05:00:00	YM	Futures	29119.0	29166.1	29058.8	29105.9	5832.0
2020-06-05 06:00:00	YM	Futures	29107.0	29111.3	29027.0	29078.5	4448.0
2020-06-05 07:00:00	YM	Futures	29079.6	29142.0	29074.1	29123.4	4013.0
2020-06-05 08:00:00	YM	Futures	29124.5	29506.8	29077.4	29450.9	24154.0
2020-06-05 09:00:00	YM	Futures	29453.1	29639.3	29436.7	29492.5	48813.0
2020-06-05 10:00:00	YM	Futures	29492.5	29678.7	29478.3	29675.4	28755.0
2020-06-05 11:00:00	YM	Futures	29674.3	29929.6	29664.5	29811.3	30755.0
2020-06-05 12:00:00	YM	Futures	29812.4	29834.3	29674.3	29806.9	20606.0
2020-06-05 13:00:00	YM	Futures	29805.8	29862.7	29742.3	29756.5	12579.0
2020-06-05 14:00:00	YM	Futures	29753.2	29811.3	29654.6	29699.5	28367.0
2020-06-05 15:00:00	YM	Futures	29700.6	29735.7	29580.1	29651.3	33400.0

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

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