PREVIEW / futures_1hour / 2020-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-12.parquet
  size:    59 KB
  rows:    1,902

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-02-12 00:00:00	ES	Futures	3646.4	3649.2	3645.9	3648.3	7911.0
2020-02-12 01:00:00	ES	Futures	3648.1	3650.8	3647.3	3648.1	7158.0
2020-02-12 02:00:00	ES	Futures	3647.8	3650.2	3646.7	3647.8	10498.0
2020-02-12 03:00:00	ES	Futures	3647.5	3655.9	3645.9	3653.8	35681.0
2020-02-12 04:00:00	ES	Futures	3653.8	3654.6	3650.0	3651.3	15726.0
2020-02-12 05:00:00	ES	Futures	3651.3	3653.8	3650.2	3653.8	10518.0
2020-02-12 06:00:00	ES	Futures	3653.5	3654.8	3652.7	3653.8	12625.0
2020-02-12 07:00:00	ES	Futures	3653.5	3654.0	3650.2	3652.1	17367.0
2020-02-12 08:00:00	ES	Futures	3652.1	3655.7	3651.3	3654.0	25592.0
2020-02-12 09:00:00	ES	Futures	3654.0	3660.5	3653.2	3657.8	204279.0
2020-02-12 10:00:00	ES	Futures	3657.6	3659.7	3651.3	3653.2	193343.0
2020-02-12 11:00:00	ES	Futures	3653.2	3659.7	3652.9	3657.8	105282.0
2020-02-12 12:00:00	ES	Futures	3657.8	3660.3	3655.7	3657.6	77873.0
2020-02-12 13:00:00	ES	Futures	3657.8	3658.1	3652.4	3657.6	79831.0
2020-02-12 14:00:00	ES	Futures	3657.6	3661.1	3656.7	3659.7	61972.0
2020-02-12 15:00:00	ES	Futures	3659.7	3664.6	3656.7	3661.9	188395.0
2020-02-12 16:00:00	ES	Futures	3662.2	3665.4	3661.1	3664.3	73173.0
2020-02-12 18:00:00	ES	Futures	3665.1	3666.5	3646.2	3650.2	43483.0
2020-02-12 19:00:00	ES	Futures	3650.5	3655.1	3647.3	3651.3	40534.0
2020-02-12 20:00:00	ES	Futures	3651.1	3656.5	3650.5	3653.2	25645.0
2020-02-12 21:00:00	ES	Futures	3653.5	3655.9	3651.3	3654.0	12076.0
2020-02-12 22:00:00	ES	Futures	3654.3	3655.7	3652.1	3652.4	8101.0
2020-02-12 23:00:00	ES	Futures	3652.1	3654.0	3650.0	3650.2	7489.0
2020-02-12 00:00:00	NQ	Futures	11054.52	11063.48	11053.07	11061.75	3962.0
2020-02-12 01:00:00	NQ	Futures	11061.17	11068.97	11055.96	11059.72	4662.0
2020-02-12 02:00:00	NQ	Futures	11059.14	11065.5	11053.65	11056.54	5564.0
2020-02-12 03:00:00	NQ	Futures	11056.54	11086.32	11050.76	11075.91	12407.0
2020-02-12 04:00:00	NQ	Futures	11075.91	11079.1	11066.95	11071.58	5891.0
2020-02-12 05:00:00	NQ	Futures	11071.29	11077.36	11066.95	11076.49	4279.0
2020-02-12 06:00:00	NQ	Futures	11076.49	11082.85	11073.89	11078.81	3871.0
2020-02-12 07:00:00	NQ	Futures	11078.81	11079.1	11061.17	11068.69	6594.0
2020-02-12 08:00:00	NQ	Futures	11068.97	11081.7	11066.08	11076.2	9803.0
2020-02-12 09:00:00	NQ	Futures	11076.49	11108.88	11059.14	11084.01	82671.0
2020-02-12 10:00:00	NQ	Futures	11083.72	11093.55	11057.12	11072.73	81932.0
2020-02-12 11:00:00	NQ	Futures	11073.02	11117.27	11072.16	11106.86	56682.0
2020-02-12 12:00:00	NQ	Futures	11106.57	11127.39	11099.05	11121.03	34869.0
2020-02-12 13:00:00	NQ	Futures	11121.03	11123.63	11102.52	11114.66	25054.0
2020-02-12 14:00:00	NQ	Futures	11114.95	11120.74	11105.7	11112.64	22069.0
2020-02-12 15:00:00	NQ	Futures	11112.64	11132.01	11099.92	11127.39	41474.0
2020-02-12 16:00:00	NQ	Futures	11127.68	11136.93	11119.58	11131.44	11913.0
2020-02-12 18:00:00	NQ	Futures	11129.12	11134.62	11058.85	11077.36	13859.0
2020-02-12 19:00:00	NQ	Futures	11077.65	11100.49	11068.4	11084.88	19645.0
2020-02-12 20:00:00	NQ	Futures	11084.3	11103.1	11081.99	11093.55	13005.0
2020-02-12 21:00:00	NQ	Futures	11093.55	11101.07	11084.88	11095.87	5661.0
2020-02-12 22:00:00	NQ	Futures	11095.58	11099.63	11089.22	11089.51	3665.0
2020-02-12 23:00:00	NQ	Futures	11089.51	11094.42	11076.2	11076.78	4511.0
2020-02-12 00:00:00	YM	Futures	31888.2	31910.0	31881.6	31901.2	2685.0
2020-02-12 01:00:00	YM	Futures	31902.3	31919.8	31889.3	31900.2	1993.0
2020-02-12 02:00:00	YM	Futures	31899.1	31923.0	31890.4	31899.1	2311.0
2020-02-12 03:00:00	YM	Futures	31899.1	31990.5	31888.2	31969.8	7937.0

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

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