PREVIEW / futures_1hour / 2020-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-03.parquet
  size:    61 KB
  rows:    1,861

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-03 00:00:00	ES	Futures	3385.72	3390.94	3385.72	3389.57	7539.0
2020-06-03 01:00:00	ES	Futures	3389.84	3392.58	3386.27	3391.49	11131.0
2020-06-03 02:00:00	ES	Futures	3391.49	3396.97	3388.47	3388.47	23231.0
2020-06-03 03:00:00	ES	Futures	3388.47	3393.41	3386.0	3391.49	26841.0
2020-06-03 04:00:00	ES	Futures	3391.49	3393.13	3386.0	3391.49	26096.0
2020-06-03 05:00:00	ES	Futures	3391.49	3397.52	3389.29	3395.33	21123.0
2020-06-03 06:00:00	ES	Futures	3395.33	3396.15	3387.37	3389.57	29251.0
2020-06-03 07:00:00	ES	Futures	3389.84	3395.6	3388.47	3393.41	28310.0
2020-06-03 08:00:00	ES	Futures	3393.41	3401.37	3391.76	3398.35	46710.0
2020-06-03 09:00:00	ES	Futures	3398.35	3408.77	3397.52	3405.21	216147.0
2020-06-03 10:00:00	ES	Futures	3405.48	3414.26	3404.11	3410.42	205060.0
2020-06-03 11:00:00	ES	Futures	3410.15	3421.95	3409.87	3418.38	190380.0
2020-06-03 12:00:00	ES	Futures	3418.1	3418.65	3412.62	3412.89	105939.0
2020-06-03 13:00:00	ES	Futures	3412.62	3417.56	3411.79	3414.26	76171.0
2020-06-03 14:00:00	ES	Futures	3414.26	3425.51	3413.44	3422.77	126513.0
2020-06-03 15:00:00	ES	Futures	3422.77	3435.12	3420.3	3423.87	267138.0
2020-06-03 16:00:00	ES	Futures	3423.87	3423.87	3419.48	3422.22	68164.0
2020-06-03 18:00:00	ES	Futures	3422.22	3423.32	3415.36	3421.67	11180.0
2020-06-03 19:00:00	ES	Futures	3421.67	3432.1	3421.4	3427.98	14027.0
2020-06-03 20:00:00	ES	Futures	3427.98	3429.63	3416.46	3420.03	23674.0
2020-06-03 21:00:00	ES	Futures	3420.3	3423.32	3415.36	3416.18	17257.0
2020-06-03 22:00:00	ES	Futures	3416.18	3416.46	3408.5	3409.32	19708.0
2020-06-03 23:00:00	ES	Futures	3409.6	3415.09	3409.05	3413.99	9802.0
2020-06-03 00:00:00	NQ	Futures	11042.3	11054.29	11041.15	11050.58	2667.0
2020-06-03 01:00:00	NQ	Futures	11050.58	11067.15	11038.87	11065.72	5038.0
2020-06-03 02:00:00	NQ	Futures	11066.0	11080.29	11046.29	11046.87	6790.0
2020-06-03 03:00:00	NQ	Futures	11047.15	11069.15	11039.44	11061.15	8326.0
2020-06-03 04:00:00	NQ	Futures	11060.86	11065.15	11041.72	11059.72	7136.0
2020-06-03 05:00:00	NQ	Futures	11059.43	11076.29	11051.72	11070.29	5830.0
2020-06-03 06:00:00	NQ	Futures	11071.15	11072.0	11045.72	11052.86	7747.0
2020-06-03 07:00:00	NQ	Futures	11053.44	11069.15	11043.72	11060.86	7595.0
2020-06-03 08:00:00	NQ	Futures	11060.58	11070.86	11025.44	11040.58	14877.0
2020-06-03 09:00:00	NQ	Futures	11040.58	11082.29	11026.59	11079.71	54681.0
2020-06-03 10:00:00	NQ	Futures	11079.43	11087.14	11038.01	11057.72	52329.0
2020-06-03 11:00:00	NQ	Futures	11057.43	11078.29	11038.58	11054.29	37415.0
2020-06-03 12:00:00	NQ	Futures	11054.01	11055.72	11015.16	11040.3	33046.0
2020-06-03 13:00:00	NQ	Futures	11040.3	11065.43	11035.73	11054.58	19863.0
2020-06-03 14:00:00	NQ	Futures	11054.86	11090.0	11051.44	11081.71	24424.0
2020-06-03 15:00:00	NQ	Futures	11081.71	11115.13	11070.0	11080.0	41555.0
2020-06-03 16:00:00	NQ	Futures	11079.14	11080.57	11059.72	11072.0	9533.0
2020-06-03 18:00:00	NQ	Futures	11066.29	11075.72	11045.44	11063.15	2997.0
2020-06-03 19:00:00	NQ	Futures	11064.0	11091.43	11062.29	11079.43	4156.0
2020-06-03 20:00:00	NQ	Futures	11078.86	11084.57	11049.72	11065.43	7027.0
2020-06-03 21:00:00	NQ	Futures	11065.43	11072.29	11053.44	11056.86	5709.0
2020-06-03 22:00:00	NQ	Futures	11056.58	11057.43	11021.73	11023.73	7030.0
2020-06-03 23:00:00	NQ	Futures	11023.44	11046.58	11021.16	11044.01	4472.0
2020-06-03 00:00:00	YM	Futures	28257.0	28293.1	28253.7	28282.2	1592.0
2020-06-03 01:00:00	YM	Futures	28281.1	28311.8	28260.3	28308.5	2625.0
2020-06-03 02:00:00	YM	Futures	28307.4	28354.5	28296.4	28298.6	4470.0
2020-06-03 03:00:00	YM	Futures	28296.4	28346.8	28274.5	28331.5	5587.0

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

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