PREVIEW / futures_1hour / 2020-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-22.parquet
  size:    58 KB
  rows:    1,822

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-07-22 00:00:00	ES	Futures	3644.41	3644.69	3630.72	3632.96	9412.0
2020-07-22 01:00:00	ES	Futures	3632.68	3633.52	3628.21	3632.4	10118.0
2020-07-22 02:00:00	ES	Futures	3632.68	3634.63	3630.17	3633.8	13987.0
2020-07-22 03:00:00	ES	Futures	3633.8	3639.1	3620.67	3623.74	47732.0
2020-07-22 04:00:00	ES	Futures	3623.74	3624.3	3610.06	3614.25	40666.0
2020-07-22 05:00:00	ES	Futures	3613.97	3620.95	3604.75	3619.28	36789.0
2020-07-22 06:00:00	ES	Futures	3619.55	3623.46	3613.97	3620.67	21172.0
2020-07-22 07:00:00	ES	Futures	3620.95	3629.05	3620.67	3627.37	20085.0
2020-07-22 08:00:00	ES	Futures	3627.37	3629.05	3622.91	3627.65	27945.0
2020-07-22 09:00:00	ES	Futures	3627.93	3642.45	3622.35	3637.43	155905.0
2020-07-22 10:00:00	ES	Futures	3637.71	3641.34	3625.98	3632.12	179069.0
2020-07-22 11:00:00	ES	Futures	3632.12	3638.82	3624.02	3636.87	125030.0
2020-07-22 12:00:00	ES	Futures	3636.59	3644.97	3634.63	3639.66	79885.0
2020-07-22 13:00:00	ES	Futures	3639.66	3641.34	3626.81	3627.09	100521.0
2020-07-22 14:00:00	ES	Futures	3627.37	3640.22	3626.81	3638.26	117543.0
2020-07-22 15:00:00	ES	Futures	3638.26	3654.46	3636.87	3649.99	224908.0
2020-07-22 16:00:00	ES	Futures	3650.27	3653.9	3645.24	3648.88	52119.0
2020-07-22 18:00:00	ES	Futures	3649.99	3652.51	3644.97	3648.04	7956.0
2020-07-22 19:00:00	ES	Futures	3648.04	3649.15	3640.78	3642.45	6525.0
2020-07-22 20:00:00	ES	Futures	3642.45	3648.32	3640.22	3642.73	8413.0
2020-07-22 21:00:00	ES	Futures	3642.73	3651.95	3639.66	3650.83	11322.0
2020-07-22 22:00:00	ES	Futures	3650.83	3651.11	3640.78	3643.01	8236.0
2020-07-22 23:00:00	ES	Futures	3643.29	3650.27	3643.01	3648.32	5635.0
2020-07-22 00:00:00	NQ	Futures	12602.4	12603.56	12550.35	12555.26	5060.0
2020-07-22 01:00:00	NQ	Futures	12554.98	12566.83	12544.28	12561.05	4676.0
2020-07-22 02:00:00	NQ	Futures	12560.76	12566.25	12542.25	12564.81	5061.0
2020-07-22 03:00:00	NQ	Futures	12564.23	12580.42	12496.85	12505.81	15217.0
2020-07-22 04:00:00	NQ	Futures	12505.24	12515.07	12472.27	12493.38	12111.0
2020-07-22 05:00:00	NQ	Futures	12493.09	12540.81	12471.4	12530.97	12857.0
2020-07-22 06:00:00	NQ	Futures	12530.97	12579.84	12527.5	12570.3	9181.0
2020-07-22 07:00:00	NQ	Futures	12570.01	12589.39	12560.47	12561.92	7148.0
2020-07-22 08:00:00	NQ	Futures	12562.78	12585.34	12542.25	12568.86	12146.0
2020-07-22 09:00:00	NQ	Futures	12568.86	12603.27	12517.38	12580.42	68546.0
2020-07-22 10:00:00	NQ	Futures	12581.0	12607.32	12475.45	12491.93	71883.0
2020-07-22 11:00:00	NQ	Futures	12491.93	12540.52	12447.69	12530.4	58660.0
2020-07-22 12:00:00	NQ	Futures	12530.11	12563.65	12508.42	12526.93	36849.0
2020-07-22 13:00:00	NQ	Futures	12526.35	12540.81	12474.01	12477.76	34951.0
2020-07-22 14:00:00	NQ	Futures	12477.76	12526.93	12475.16	12512.18	37813.0
2020-07-22 15:00:00	NQ	Futures	12512.18	12581.58	12509.57	12561.63	45682.0
2020-07-22 16:00:00	NQ	Futures	12561.63	12579.27	12487.02	12544.56	16935.0
2020-07-22 18:00:00	NQ	Futures	12550.35	12563.07	12529.53	12546.59	2953.0
2020-07-22 19:00:00	NQ	Futures	12547.75	12552.95	12511.89	12519.12	2585.0
2020-07-22 20:00:00	NQ	Futures	12517.96	12538.78	12499.45	12514.2	4253.0
2020-07-22 21:00:00	NQ	Futures	12513.04	12553.24	12504.08	12548.9	5178.0
2020-07-22 22:00:00	NQ	Futures	12549.19	12549.19	12499.74	12509.29	4836.0
2020-07-22 23:00:00	NQ	Futures	12509.57	12540.81	12509.0	12532.13	2922.0
2020-07-22 00:00:00	YM	Futures	29560.1	29562.3	29437.9	29463.2	2355.0
2020-07-22 01:00:00	YM	Futures	29463.2	29466.5	29418.1	29457.7	2223.0
2020-07-22 02:00:00	YM	Futures	29458.8	29483.0	29433.5	29468.7	2151.0
2020-07-22 03:00:00	YM	Futures	29469.8	29526.0	29349.8	29379.5	9365.0

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

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