PREVIEW / futures_1hour / 2020-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-21.parquet
  size:    51 KB
  rows:    1,495

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-21 00:00:00	ES	Futures	3785.43	3787.1	3784.31	3785.98	3727.0
2020-08-21 01:00:00	ES	Futures	3785.98	3787.66	3781.79	3783.75	4727.0
2020-08-21 02:00:00	ES	Futures	3783.75	3784.03	3779.56	3782.91	9901.0
2020-08-21 03:00:00	ES	Futures	3782.91	3784.03	3772.02	3778.44	29966.0
2020-08-21 04:00:00	ES	Futures	3778.44	3778.44	3770.35	3773.14	24094.0
2020-08-21 05:00:00	ES	Futures	3773.14	3778.44	3770.9	3777.33	14234.0
2020-08-21 06:00:00	ES	Futures	3777.33	3778.44	3766.72	3769.79	22324.0
2020-08-21 07:00:00	ES	Futures	3769.79	3771.74	3754.71	3755.55	32171.0
2020-08-21 08:00:00	ES	Futures	3755.83	3763.92	3749.4	3761.69	60409.0
2020-08-21 09:00:00	ES	Futures	3761.41	3781.79	3758.06	3781.52	214070.0
2020-08-21 10:00:00	ES	Futures	3781.52	3785.43	3773.7	3781.52	154726.0
2020-08-21 11:00:00	ES	Futures	3781.24	3782.35	3773.14	3773.98	116560.0
2020-08-21 12:00:00	ES	Futures	3773.98	3783.19	3773.42	3780.96	67289.0
2020-08-21 13:00:00	ES	Futures	3780.96	3785.15	3778.16	3784.03	61497.0
2020-08-21 14:00:00	ES	Futures	3783.75	3790.73	3781.79	3789.33	85512.0
2020-08-21 15:00:00	ES	Futures	3789.33	3793.52	3787.1	3790.73	171345.0
2020-08-21 16:00:00	ES	Futures	3790.73	3793.24	3788.22	3788.22	53238.0
2020-08-21 00:00:00	NQ	Futures	13307.13	13318.12	13302.21	13309.15	1509.0
2020-08-21 01:00:00	NQ	Futures	13310.02	13313.49	13295.27	13302.79	1581.0
2020-08-21 02:00:00	NQ	Futures	13302.79	13310.31	13293.83	13306.26	2423.0
2020-08-21 03:00:00	NQ	Futures	13306.26	13309.15	13262.88	13285.73	8522.0
2020-08-21 04:00:00	NQ	Futures	13286.6	13286.6	13257.39	13276.48	7080.0
2020-08-21 05:00:00	NQ	Futures	13275.9	13297.3	13269.25	13292.67	4650.0
2020-08-21 06:00:00	NQ	Futures	13292.67	13294.12	13239.17	13258.26	7225.0
2020-08-21 07:00:00	NQ	Futures	13257.97	13273.01	13218.93	13224.13	10841.0
2020-08-21 08:00:00	NQ	Futures	13224.13	13267.22	13194.64	13260.57	24260.0
2020-08-21 09:00:00	NQ	Futures	13260.57	13308.0	13243.8	13296.14	75053.0
2020-08-21 10:00:00	NQ	Futures	13297.01	13369.3	13265.2	13355.13	61306.0
2020-08-21 11:00:00	NQ	Futures	13354.84	13359.47	13286.31	13292.96	50509.0
2020-08-21 12:00:00	NQ	Futures	13292.96	13352.53	13286.6	13346.75	31122.0
2020-08-21 13:00:00	NQ	Futures	13347.32	13351.95	13317.54	13330.26	25486.0
2020-08-21 14:00:00	NQ	Futures	13330.26	13372.48	13325.06	13365.54	25199.0
2020-08-21 15:00:00	NQ	Futures	13365.25	13387.23	13336.34	13365.25	44380.0
2020-08-21 16:00:00	NQ	Futures	13365.25	13382.6	13362.07	13373.64	10680.0
2020-08-21 00:00:00	YM	Futures	30548.9	30564.3	30540.1	30554.4	707.0
2020-08-21 01:00:00	YM	Futures	30556.6	30567.6	30514.8	30525.8	1417.0
2020-08-21 02:00:00	YM	Futures	30526.9	30531.3	30491.7	30526.9	1928.0
2020-08-21 03:00:00	YM	Futures	30525.8	30540.1	30439.9	30496.1	5339.0
2020-08-21 04:00:00	YM	Futures	30497.2	30497.2	30434.4	30455.3	4005.0
2020-08-21 05:00:00	YM	Futures	30454.2	30499.4	30434.4	30484.0	2245.0
2020-08-21 06:00:00	YM	Futures	30484.0	30496.1	30399.2	30420.1	4024.0
2020-08-21 07:00:00	YM	Futures	30421.2	30438.8	30305.6	30310.0	4926.0
2020-08-21 08:00:00	YM	Futures	30311.1	30384.9	30251.6	30365.0	9496.0
2020-08-21 09:00:00	YM	Futures	30363.9	30579.8	30333.1	30565.4	32120.0
2020-08-21 10:00:00	YM	Futures	30566.5	30599.6	30501.6	30548.9	25843.0
2020-08-21 11:00:00	YM	Futures	30547.8	30596.3	30510.4	30514.8	18644.0
2020-08-21 12:00:00	YM	Futures	30514.8	30605.1	30509.3	30587.5	10518.0
2020-08-21 13:00:00	YM	Futures	30587.5	30653.5	30575.4	30639.2	9925.0
2020-08-21 14:00:00	YM	Futures	30641.4	30706.4	30623.8	30693.2	12484.0
2020-08-21 15:00:00	YM	Futures	30693.2	30726.2	30666.7	30695.4	17609.0

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

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