PREVIEW / futures_1hour / 2020-10-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	3774.27	3777.91	3771.75	3772.59	4034.0
2020-10-01 01:00:00	ES	Futures	3772.59	3776.79	3770.07	3776.51	8875.0
2020-10-01 02:00:00	ES	Futures	3776.23	3788.84	3775.67	3786.88	15099.0
2020-10-01 03:00:00	ES	Futures	3786.88	3790.52	3779.88	3783.8	25379.0
2020-10-01 04:00:00	ES	Futures	3783.8	3788.84	3771.47	3775.11	22612.0
2020-10-01 05:00:00	ES	Futures	3775.11	3792.2	3774.27	3790.52	29142.0
2020-10-01 06:00:00	ES	Futures	3790.52	3794.44	3785.2	3788.56	19651.0
2020-10-01 07:00:00	ES	Futures	3788.28	3795.84	3786.6	3793.32	24954.0
2020-10-01 08:00:00	ES	Futures	3793.6	3794.16	3782.68	3783.52	43553.0
2020-10-01 09:00:00	ES	Futures	3783.24	3795.28	3772.03	3773.43	212150.0
2020-10-01 10:00:00	ES	Futures	3772.87	3780.44	3759.71	3772.03	222891.0
2020-10-01 11:00:00	ES	Futures	3772.31	3783.24	3762.23	3778.47	168166.0
2020-10-01 12:00:00	ES	Futures	3778.47	3780.44	3767.27	3777.63	108832.0
2020-10-01 13:00:00	ES	Futures	3777.63	3783.8	3763.07	3767.27	100010.0
2020-10-01 14:00:00	ES	Futures	3767.27	3778.19	3753.27	3775.11	195415.0
2020-10-01 15:00:00	ES	Futures	3774.83	3781.28	3761.95	3775.95	171780.0
2020-10-01 16:00:00	ES	Futures	3775.95	3781.0	3771.47	3773.43	45033.0
2020-10-01 18:00:00	ES	Futures	3772.31	3781.84	3766.71	3777.91	16678.0
2020-10-01 19:00:00	ES	Futures	3777.91	3778.47	3770.35	3772.59	6021.0
2020-10-01 20:00:00	ES	Futures	3772.31	3778.47	3759.43	3762.23	21146.0
2020-10-01 21:00:00	ES	Futures	3762.23	3767.55	3761.39	3763.07	13278.0
2020-10-01 22:00:00	ES	Futures	3763.07	3765.03	3755.23	3759.15	11552.0
2020-10-01 23:00:00	ES	Futures	3759.43	3767.55	3757.47	3767.27	7359.0
2020-10-01 00:00:00	NQ	Futures	13271.56	13284.01	13262.3	13265.77	1904.0
2020-10-01 01:00:00	NQ	Futures	13265.48	13277.93	13249.27	13276.77	3425.0
2020-10-01 02:00:00	NQ	Futures	13275.9	13324.53	13274.17	13308.9	6068.0
2020-10-01 03:00:00	NQ	Futures	13308.9	13328.01	13287.77	13305.72	8947.0
2020-10-01 04:00:00	NQ	Futures	13305.14	13337.56	13271.85	13294.43	8798.0
2020-10-01 05:00:00	NQ	Futures	13293.27	13373.16	13289.51	13366.8	10072.0
2020-10-01 06:00:00	NQ	Futures	13366.51	13399.51	13356.09	13382.14	10594.0
2020-10-01 07:00:00	NQ	Futures	13381.27	13404.43	13364.19	13395.45	10438.0
2020-10-01 08:00:00	NQ	Futures	13395.74	13426.72	13364.19	13382.43	26128.0
2020-10-01 09:00:00	NQ	Futures	13381.85	13401.82	13327.14	13342.77	72774.0
2020-10-01 10:00:00	NQ	Futures	13341.9	13365.35	13297.61	13334.38	75613.0
2020-10-01 11:00:00	NQ	Futures	13334.67	13382.43	13285.46	13351.45	65096.0
2020-10-01 12:00:00	NQ	Futures	13351.74	13368.82	13313.53	13365.93	42044.0
2020-10-01 13:00:00	NQ	Futures	13366.51	13406.74	13349.72	13367.09	43253.0
2020-10-01 14:00:00	NQ	Futures	13367.09	13420.35	13311.8	13409.64	82782.0
2020-10-01 15:00:00	NQ	Futures	13409.93	13430.48	13352.61	13399.51	52476.0
2020-10-01 16:00:00	NQ	Futures	13400.09	13427.58	13391.98	13400.09	10839.0
2020-10-01 18:00:00	NQ	Futures	13392.85	13436.85	13378.95	13419.77	7380.0
2020-10-01 19:00:00	NQ	Futures	13420.35	13424.4	13389.09	13398.35	3029.0
2020-10-01 20:00:00	NQ	Futures	13397.48	13420.93	13359.56	13366.22	10057.0
2020-10-01 21:00:00	NQ	Futures	13367.09	13383.87	13356.95	13365.35	4703.0
2020-10-01 22:00:00	NQ	Futures	13365.64	13371.72	13334.09	13352.32	5218.0
2020-10-01 23:00:00	NQ	Futures	13352.32	13381.27	13344.22	13380.69	4605.0
2020-10-01 00:00:00	YM	Futures	30783.8	30823.6	30763.9	30776.0	2020.0
2020-10-01 01:00:00	YM	Futures	30773.8	30809.2	30748.4	30802.6	2522.0
2020-10-01 02:00:00	YM	Futures	30802.6	30898.7	30795.9	30882.2	4999.0
2020-10-01 03:00:00	YM	Futures	30882.2	30915.3	30812.5	30845.7	10418.0

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

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