PREVIEW / futures_1hour / 2020-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-12.parquet
  size:    61 KB
  rows:    1,859

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-08-12 00:00:00	ES	Futures	3723.15	3724.83	3718.41	3718.97	4352.0
2020-08-12 01:00:00	ES	Futures	3719.24	3727.06	3716.17	3724.83	7821.0
2020-08-12 02:00:00	ES	Futures	3724.83	3739.35	3724.83	3735.72	20936.0
2020-08-12 03:00:00	ES	Futures	3735.72	3748.56	3734.32	3747.45	36645.0
2020-08-12 04:00:00	ES	Futures	3747.17	3749.4	3742.98	3746.61	18221.0
2020-08-12 05:00:00	ES	Futures	3746.61	3751.64	3744.93	3746.33	12336.0
2020-08-12 06:00:00	ES	Futures	3746.33	3753.87	3746.05	3747.73	12760.0
2020-08-12 07:00:00	ES	Futures	3748.01	3748.01	3742.98	3745.77	16731.0
2020-08-12 08:00:00	ES	Futures	3746.05	3749.4	3739.91	3747.45	39182.0
2020-08-12 09:00:00	ES	Futures	3747.45	3757.78	3745.21	3756.66	176723.0
2020-08-12 10:00:00	ES	Futures	3756.66	3769.23	3753.59	3766.72	224182.0
2020-08-12 11:00:00	ES	Futures	3766.72	3771.18	3762.53	3766.44	145671.0
2020-08-12 12:00:00	ES	Futures	3766.44	3772.86	3763.92	3764.48	94819.0
2020-08-12 13:00:00	ES	Futures	3764.48	3773.98	3758.9	3773.42	107487.0
2020-08-12 14:00:00	ES	Futures	3773.42	3774.53	3769.79	3773.14	98276.0
2020-08-12 15:00:00	ES	Futures	3773.14	3778.16	3766.44	3767.83	220888.0
2020-08-12 16:00:00	ES	Futures	3767.83	3768.39	3762.25	3763.09	61221.0
2020-08-12 18:00:00	ES	Futures	3761.69	3765.6	3759.46	3764.2	5712.0
2020-08-12 19:00:00	ES	Futures	3763.92	3766.16	3762.53	3765.04	4007.0
2020-08-12 20:00:00	ES	Futures	3765.04	3770.63	3758.62	3760.01	14895.0
2020-08-12 21:00:00	ES	Futures	3760.01	3765.88	3756.94	3761.97	12733.0
2020-08-12 22:00:00	ES	Futures	3762.25	3765.88	3759.18	3765.6	7882.0
2020-08-12 23:00:00	ES	Futures	3765.32	3765.88	3761.41	3762.81	6077.0
2020-08-12 00:00:00	NQ	Futures	12620.91	12627.85	12598.93	12604.71	1478.0
2020-08-12 01:00:00	NQ	Futures	12603.27	12637.68	12594.3	12629.01	3034.0
2020-08-12 02:00:00	NQ	Futures	12630.16	12670.36	12627.56	12656.19	7182.0
2020-08-12 03:00:00	NQ	Futures	12656.48	12691.47	12650.12	12687.13	8378.0
2020-08-12 04:00:00	NQ	Futures	12686.84	12706.79	12676.72	12690.6	5393.0
2020-08-12 05:00:00	NQ	Futures	12690.89	12706.22	12681.64	12686.55	3013.0
2020-08-12 06:00:00	NQ	Futures	12686.84	12713.45	12686.84	12700.43	3843.0
2020-08-12 07:00:00	NQ	Futures	12701.01	12705.35	12672.96	12680.77	6297.0
2020-08-12 08:00:00	NQ	Futures	12680.19	12692.91	12646.36	12664.28	14512.0
2020-08-12 09:00:00	NQ	Futures	12663.42	12801.36	12648.09	12794.99	72717.0
2020-08-12 10:00:00	NQ	Futures	12794.99	12856.59	12781.98	12847.33	71187.0
2020-08-12 11:00:00	NQ	Futures	12847.33	12882.33	12836.06	12875.96	42069.0
2020-08-12 12:00:00	NQ	Futures	12876.25	12914.42	12868.73	12872.78	37691.0
2020-08-12 13:00:00	NQ	Futures	12872.78	12933.8	12856.88	12928.59	35109.0
2020-08-12 14:00:00	NQ	Futures	12928.59	12938.72	12893.6	12904.01	31035.0
2020-08-12 15:00:00	NQ	Futures	12904.01	12926.28	12865.26	12892.74	47919.0
2020-08-12 16:00:00	NQ	Futures	12893.03	12893.03	12856.88	12858.61	10159.0
2020-08-12 18:00:00	NQ	Futures	12857.46	12873.65	12847.62	12865.55	2085.0
2020-08-12 19:00:00	NQ	Futures	12864.97	12880.59	12861.22	12876.83	1628.0
2020-08-12 20:00:00	NQ	Futures	12875.96	12897.36	12840.68	12846.76	5560.0
2020-08-12 21:00:00	NQ	Futures	12847.05	12881.17	12832.88	12862.66	5492.0
2020-08-12 22:00:00	NQ	Futures	12861.79	12875.96	12845.89	12869.6	2606.0
2020-08-12 23:00:00	NQ	Futures	12869.6	12869.6	12851.38	12855.43	1672.0
2020-08-12 00:00:00	YM	Futures	30468.5	30479.6	30434.4	30437.7	1164.0
2020-08-12 01:00:00	YM	Futures	30438.8	30501.6	30416.8	30478.5	1943.0
2020-08-12 02:00:00	YM	Futures	30479.6	30637.0	30478.5	30609.5	5408.0
2020-08-12 03:00:00	YM	Futures	30610.6	30718.5	30594.1	30709.7	7051.0

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

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