PREVIEW / futures_1hour / 2020-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-08.parquet
  size:    63 KB
  rows:    1,867

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-09-08 00:00:00	ES	Futures	3830.1	3832.9	3828.15	3831.5	5136.0
2020-09-08 01:00:00	ES	Futures	3831.78	3844.35	3829.55	3844.35	8819.0
2020-09-08 02:00:00	ES	Futures	3844.35	3850.21	3840.99	3841.83	18468.0
2020-09-08 03:00:00	ES	Futures	3841.83	3844.35	3832.34	3835.97	27263.0
2020-09-08 04:00:00	ES	Futures	3835.97	3837.09	3799.11	3802.18	51705.0
2020-09-08 05:00:00	ES	Futures	3802.18	3810.0	3791.85	3793.8	38724.0
2020-09-08 06:00:00	ES	Futures	3794.08	3799.67	3781.24	3792.13	38892.0
2020-09-08 07:00:00	ES	Futures	3792.13	3799.39	3767.55	3779.0	56151.0
2020-09-08 08:00:00	ES	Futures	3779.0	3780.4	3756.38	3768.11	90805.0
2020-09-08 09:00:00	ES	Futures	3768.11	3770.35	3727.62	3759.73	351445.0
2020-09-08 10:00:00	ES	Futures	3759.73	3774.81	3738.23	3750.24	366466.0
2020-09-08 11:00:00	ES	Futures	3750.52	3766.72	3733.77	3745.77	250139.0
2020-09-08 12:00:00	ES	Futures	3745.77	3763.09	3743.54	3760.29	151316.0
2020-09-08 13:00:00	ES	Futures	3760.29	3771.46	3751.92	3765.32	126411.0
2020-09-08 14:00:00	ES	Futures	3765.32	3769.23	3718.41	3734.88	217825.0
2020-09-08 15:00:00	ES	Futures	3735.16	3746.61	3716.73	3722.04	423885.0
2020-09-08 16:00:00	ES	Futures	3722.04	3732.37	3720.64	3725.95	89105.0
2020-09-08 18:00:00	ES	Futures	3703.05	3708.91	3680.99	3705.84	43130.0
2020-09-08 19:00:00	ES	Futures	3706.12	3714.22	3698.58	3711.43	16419.0
2020-09-08 20:00:00	ES	Futures	3710.87	3727.62	3709.19	3724.83	23694.0
2020-09-08 21:00:00	ES	Futures	3724.83	3730.69	3715.06	3725.95	19225.0
2020-09-08 22:00:00	ES	Futures	3725.95	3731.25	3720.64	3727.9	12254.0
2020-09-08 23:00:00	ES	Futures	3727.62	3731.25	3725.11	3730.13	7463.0
2020-09-08 00:00:00	NQ	Futures	13297.3	13310.6	13285.73	13302.79	3182.0
2020-09-08 01:00:00	NQ	Futures	13301.35	13372.77	13295.27	13371.33	5774.0
2020-09-08 02:00:00	NQ	Futures	13371.9	13387.81	13345.59	13359.76	7330.0
2020-09-08 03:00:00	NQ	Futures	13358.89	13362.94	13309.44	13323.03	6724.0
2020-09-08 04:00:00	NQ	Futures	13324.48	13330.55	13113.09	13140.56	21659.0
2020-09-08 05:00:00	NQ	Futures	13140.85	13178.16	13031.54	13054.97	18075.0
2020-09-08 06:00:00	NQ	Futures	13053.23	13098.05	13003.78	13098.05	17052.0
2020-09-08 07:00:00	NQ	Futures	13098.34	13126.1	12960.98	12980.36	22923.0
2020-09-08 08:00:00	NQ	Futures	12979.78	13013.03	12895.63	12982.67	41519.0
2020-09-08 09:00:00	NQ	Futures	12982.38	13070.87	12859.19	13063.93	120200.0
2020-09-08 10:00:00	NQ	Futures	13063.06	13192.04	12999.44	13065.09	133559.0
2020-09-08 11:00:00	NQ	Futures	13065.66	13118.3	12936.69	13001.47	106471.0
2020-09-08 12:00:00	NQ	Futures	13001.47	13054.97	12969.95	13043.98	67943.0
2020-09-08 13:00:00	NQ	Futures	13043.98	13064.51	12968.21	13030.96	66621.0
2020-09-08 14:00:00	NQ	Futures	13031.25	13052.07	12817.55	12893.6	65002.0
2020-09-08 15:00:00	NQ	Futures	12893.31	12927.44	12784.58	12803.09	79640.0
2020-09-08 16:00:00	NQ	Futures	12803.09	12825.94	12770.7	12774.46	27310.0
2020-09-08 18:00:00	NQ	Futures	12730.8	12759.71	12648.96	12747.28	13692.0
2020-09-08 19:00:00	NQ	Futures	12749.01	12787.19	12724.43	12771.86	7489.0
2020-09-08 20:00:00	NQ	Futures	12770.41	12887.53	12766.94	12875.67	12315.0
2020-09-08 21:00:00	NQ	Futures	12876.25	12892.45	12825.94	12870.18	11490.0
2020-09-08 22:00:00	NQ	Futures	12870.18	12894.76	12851.09	12875.39	7684.0
2020-09-08 23:00:00	NQ	Futures	12875.1	12891.29	12864.69	12884.93	5059.0
2020-09-08 00:00:00	YM	Futures	31130.3	31147.9	31109.4	31135.8	1800.0
2020-09-08 01:00:00	YM	Futures	31135.8	31221.7	31119.3	31221.7	1871.0
2020-09-08 02:00:00	YM	Futures	31222.8	31276.8	31188.7	31198.6	3688.0
2020-09-08 03:00:00	YM	Futures	31193.1	31221.7	31119.3	31143.5	5111.0

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

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