PREVIEW / futures_1hour / 2020-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-05.parquet
  size:    61 KB
  rows:    1,892

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-10-05 00:00:00	ES	Futures	3761.67	3766.71	3759.99	3766.15	5501.0
2020-10-05 01:00:00	ES	Futures	3766.15	3769.23	3764.47	3766.15	4253.0
2020-10-05 02:00:00	ES	Futures	3766.15	3766.99	3758.03	3763.91	12711.0
2020-10-05 03:00:00	ES	Futures	3763.63	3766.99	3749.34	3755.79	27891.0
2020-10-05 04:00:00	ES	Futures	3755.51	3763.07	3754.67	3759.71	12148.0
2020-10-05 05:00:00	ES	Futures	3759.71	3766.71	3757.19	3765.03	12794.0
2020-10-05 06:00:00	ES	Futures	3764.75	3767.83	3758.87	3767.83	14759.0
2020-10-05 07:00:00	ES	Futures	3767.83	3771.47	3764.47	3765.59	17186.0
2020-10-05 08:00:00	ES	Futures	3765.59	3766.71	3761.67	3765.31	22566.0
2020-10-05 09:00:00	ES	Futures	3765.31	3778.19	3764.19	3770.91	116483.0
2020-10-05 10:00:00	ES	Futures	3770.91	3793.6	3770.91	3789.96	151232.0
2020-10-05 11:00:00	ES	Futures	3789.96	3796.68	3788.84	3791.92	99634.0
2020-10-05 12:00:00	ES	Futures	3792.2	3795.0	3789.96	3793.88	43984.0
2020-10-05 13:00:00	ES	Futures	3794.16	3795.84	3783.8	3785.48	74522.0
2020-10-05 14:00:00	ES	Futures	3785.48	3800.6	3781.84	3800.04	100495.0
2020-10-05 15:00:00	ES	Futures	3800.04	3809.29	3797.52	3806.48	214779.0
2020-10-05 16:00:00	ES	Futures	3806.2	3807.32	3800.32	3800.6	59194.0
2020-10-05 18:00:00	ES	Futures	3800.32	3805.92	3800.32	3804.8	4684.0
2020-10-05 19:00:00	ES	Futures	3804.8	3805.08	3794.44	3797.52	18944.0
2020-10-05 20:00:00	ES	Futures	3797.52	3803.4	3792.2	3798.92	13813.0
2020-10-05 21:00:00	ES	Futures	3798.92	3806.76	3797.8	3803.96	12988.0
2020-10-05 22:00:00	ES	Futures	3803.96	3805.92	3801.72	3803.4	4393.0
2020-10-05 23:00:00	ES	Futures	3803.4	3808.44	3801.72	3803.96	11628.0
2020-10-05 00:00:00	NQ	Futures	13110.91	13129.43	13098.75	13126.83	4141.0
2020-10-05 01:00:00	NQ	Futures	13127.12	13140.72	13115.83	13125.96	4178.0
2020-10-05 02:00:00	NQ	Futures	13125.09	13127.98	13074.72	13113.8	8406.0
2020-10-05 03:00:00	NQ	Futures	13112.64	13131.46	13046.35	13083.99	12412.0
2020-10-05 04:00:00	NQ	Futures	13082.83	13123.06	13081.38	13109.17	5876.0
2020-10-05 05:00:00	NQ	Futures	13110.62	13140.43	13099.04	13134.35	5392.0
2020-10-05 06:00:00	NQ	Futures	13134.35	13153.46	13120.17	13152.88	5182.0
2020-10-05 07:00:00	NQ	Futures	13152.01	13155.48	13108.3	13110.91	8066.0
2020-10-05 08:00:00	NQ	Futures	13110.33	13122.48	13084.85	13102.51	14082.0
2020-10-05 09:00:00	NQ	Futures	13102.22	13167.35	13100.2	13160.4	48157.0
2020-10-05 10:00:00	NQ	Futures	13160.4	13238.56	13160.4	13213.67	58807.0
2020-10-05 11:00:00	NQ	Futures	13213.67	13243.77	13199.48	13231.32	35618.0
2020-10-05 12:00:00	NQ	Futures	13231.32	13256.22	13218.88	13251.59	23496.0
2020-10-05 13:00:00	NQ	Futures	13251.59	13260.56	13196.01	13210.19	26343.0
2020-10-05 14:00:00	NQ	Futures	13209.61	13274.46	13185.01	13272.72	38848.0
2020-10-05 15:00:00	NQ	Futures	13272.72	13312.67	13260.85	13302.53	45156.0
2020-10-05 16:00:00	NQ	Futures	13302.24	13304.85	13276.19	13279.96	10083.0
2020-10-05 18:00:00	NQ	Futures	13284.3	13305.14	13279.96	13297.32	3074.0
2020-10-05 19:00:00	NQ	Futures	13297.32	13299.64	13220.32	13240.01	12885.0
2020-10-05 20:00:00	NQ	Futures	13240.88	13278.51	13223.8	13247.82	8598.0
2020-10-05 21:00:00	NQ	Futures	13248.4	13268.09	13232.19	13258.82	6250.0
2020-10-05 22:00:00	NQ	Futures	13259.11	13266.93	13242.32	13255.06	3093.0
2020-10-05 23:00:00	NQ	Futures	13255.64	13277.64	13244.06	13258.53	6305.0
2020-10-05 00:00:00	YM	Futures	30657.7	30699.7	30643.3	30698.6	2361.0
2020-10-05 01:00:00	YM	Futures	30699.7	30730.7	30686.5	30710.8	2538.0
2020-10-05 02:00:00	YM	Futures	30710.8	30719.6	30648.9	30693.1	4997.0
2020-10-05 03:00:00	YM	Futures	30690.9	30711.9	30581.4	30626.8	8528.0

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

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