PREVIEW / futures_1hour / 2020-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-24.parquet
  size:    60 KB
  rows:    1,836

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-24 00:00:00	ES	Futures	3798.83	3799.67	3797.71	3799.39	5400.0
2020-08-24 01:00:00	ES	Futures	3799.39	3802.74	3798.83	3802.18	4373.0
2020-08-24 02:00:00	ES	Futures	3802.46	3807.21	3802.18	3805.81	13348.0
2020-08-24 03:00:00	ES	Futures	3805.81	3813.63	3805.81	3811.12	37996.0
2020-08-24 04:00:00	ES	Futures	3810.84	3817.54	3810.0	3816.14	28945.0
2020-08-24 05:00:00	ES	Futures	3815.86	3817.82	3814.19	3816.14	18034.0
2020-08-24 06:00:00	ES	Futures	3816.14	3821.73	3815.3	3820.89	16465.0
2020-08-24 07:00:00	ES	Futures	3821.17	3824.24	3819.77	3823.4	13005.0
2020-08-24 08:00:00	ES	Futures	3823.4	3824.52	3819.49	3821.17	23328.0
2020-08-24 09:00:00	ES	Futures	3821.17	3822.84	3813.63	3817.54	143891.0
2020-08-24 10:00:00	ES	Futures	3817.82	3823.96	3808.32	3811.39	218704.0
2020-08-24 11:00:00	ES	Futures	3811.12	3818.93	3809.72	3816.42	119042.0
2020-08-24 12:00:00	ES	Futures	3816.42	3819.77	3814.47	3815.58	80613.0
2020-08-24 13:00:00	ES	Futures	3815.86	3819.77	3813.35	3816.42	103432.0
2020-08-24 14:00:00	ES	Futures	3816.7	3818.66	3811.12	3813.35	95470.0
2020-08-24 15:00:00	ES	Futures	3813.35	3830.66	3809.44	3829.55	202036.0
2020-08-24 16:00:00	ES	Futures	3829.55	3830.1	3824.8	3827.59	58738.0
2020-08-24 18:00:00	ES	Futures	3827.87	3829.82	3827.59	3828.99	4492.0
2020-08-24 19:00:00	ES	Futures	3829.27	3835.69	3827.59	3834.85	7151.0
2020-08-24 20:00:00	ES	Futures	3834.85	3841.27	3831.78	3839.88	14238.0
2020-08-24 21:00:00	ES	Futures	3839.88	3847.98	3839.32	3847.42	15746.0
2020-08-24 22:00:00	ES	Futures	3847.42	3849.09	3845.74	3846.58	10355.0
2020-08-24 23:00:00	ES	Futures	3846.58	3848.53	3844.62	3846.02	6189.0
2020-08-24 00:00:00	NQ	Futures	13423.67	13428.58	13418.17	13423.67	3412.0
2020-08-24 01:00:00	NQ	Futures	13423.96	13431.48	13417.88	13428.58	2181.0
2020-08-24 02:00:00	NQ	Futures	13428.58	13448.54	13428.58	13437.84	5661.0
2020-08-24 03:00:00	NQ	Futures	13437.84	13481.21	13437.55	13471.96	11598.0
2020-08-24 04:00:00	NQ	Futures	13471.67	13506.08	13471.67	13500.59	10419.0
2020-08-24 05:00:00	NQ	Futures	13501.17	13503.48	13488.15	13489.89	5555.0
2020-08-24 06:00:00	NQ	Futures	13490.47	13501.75	13480.35	13493.07	5052.0
2020-08-24 07:00:00	NQ	Futures	13493.36	13517.65	13488.15	13517.65	6613.0
2020-08-24 08:00:00	NQ	Futures	13517.36	13528.64	13504.93	13518.52	11242.0
2020-08-24 09:00:00	NQ	Futures	13518.23	13559.58	13434.08	13482.66	81337.0
2020-08-24 10:00:00	NQ	Futures	13482.66	13494.52	13334.89	13356.87	134591.0
2020-08-24 11:00:00	NQ	Futures	13357.16	13444.2	13345.88	13434.08	78012.0
2020-08-24 12:00:00	NQ	Futures	13433.79	13465.6	13413.55	13423.96	56968.0
2020-08-24 13:00:00	NQ	Futures	13423.67	13459.53	13396.77	13421.93	44529.0
2020-08-24 14:00:00	NQ	Futures	13421.93	13440.44	13371.04	13384.05	55560.0
2020-08-24 15:00:00	NQ	Futures	13383.47	13450.85	13356.87	13448.25	61760.0
2020-08-24 16:00:00	NQ	Futures	13448.25	13466.18	13435.81	13457.5	12602.0
2020-08-24 18:00:00	NQ	Futures	13459.53	13467.04	13456.06	13463.29	2047.0
2020-08-24 19:00:00	NQ	Futures	13463.57	13476.88	13453.74	13472.25	2721.0
2020-08-24 20:00:00	NQ	Futures	13472.54	13483.82	13461.84	13478.61	4410.0
2020-08-24 21:00:00	NQ	Futures	13478.61	13517.94	13475.14	13515.05	6748.0
2020-08-24 22:00:00	NQ	Futures	13515.34	13521.99	13507.24	13513.31	4592.0
2020-08-24 23:00:00	NQ	Futures	13513.31	13515.05	13501.46	13505.22	2719.0
2020-08-24 00:00:00	YM	Futures	30757.0	30761.4	30747.1	30758.1	701.0
2020-08-24 01:00:00	YM	Futures	30759.2	30790.1	30757.0	30787.9	686.0
2020-08-24 02:00:00	YM	Futures	30785.7	30835.2	30785.7	30828.6	2301.0
2020-08-24 03:00:00	YM	Futures	30826.4	30885.9	30825.3	30863.9	4916.0

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

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