PREVIEW / futures_1hour / 2020-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-01.parquet
  size:    63 KB
  rows:    1,925

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-12-01 00:00:00	ES	Futures	4092.46	4095.82	4091.34	4093.58	7137.0
2020-12-01 01:00:00	ES	Futures	4093.86	4094.7	4091.34	4093.02	4927.0
2020-12-01 02:00:00	ES	Futures	4093.3	4096.94	4091.62	4093.02	8975.0
2020-12-01 03:00:00	ES	Futures	4093.3	4100.58	4084.9	4096.66	30483.0
2020-12-01 04:00:00	ES	Futures	4096.66	4104.22	4096.1	4098.9	18900.0
2020-12-01 05:00:00	ES	Futures	4098.62	4104.22	4097.5	4103.94	12685.0
2020-12-01 06:00:00	ES	Futures	4103.66	4105.63	4101.98	4102.82	14583.0
2020-12-01 07:00:00	ES	Futures	4103.1	4103.1	4098.62	4101.7	18358.0
2020-12-01 08:00:00	ES	Futures	4101.7	4102.82	4094.14	4100.02	29916.0
2020-12-01 09:00:00	ES	Futures	4100.02	4105.91	4089.66	4103.38	171473.0
2020-12-01 10:00:00	ES	Futures	4103.1	4117.95	4099.74	4105.06	238541.0
2020-12-01 11:00:00	ES	Futures	4105.06	4113.75	4101.98	4104.78	145374.0
2020-12-01 12:00:00	ES	Futures	4104.78	4111.79	4103.1	4106.19	87094.0
2020-12-01 13:00:00	ES	Futures	4106.19	4115.15	4106.19	4114.03	59089.0
2020-12-01 14:00:00	ES	Futures	4114.03	4120.19	4109.27	4110.11	95099.0
2020-12-01 15:00:00	ES	Futures	4110.11	4110.95	4095.54	4101.42	233039.0
2020-12-01 16:00:00	ES	Futures	4101.42	4103.38	4096.66	4100.58	49663.0
2020-12-01 18:00:00	ES	Futures	4101.98	4107.31	4092.18	4098.9	14046.0
2020-12-01 19:00:00	ES	Futures	4099.18	4099.46	4091.34	4092.74	12457.0
2020-12-01 20:00:00	ES	Futures	4092.74	4092.74	4080.98	4086.3	15187.0
2020-12-01 21:00:00	ES	Futures	4086.3	4091.34	4082.66	4088.82	7635.0
2020-12-01 22:00:00	ES	Futures	4088.82	4091.34	4088.26	4089.38	3776.0
2020-12-01 23:00:00	ES	Futures	4089.66	4093.3	4088.26	4092.74	4300.0
2020-12-01 00:00:00	NQ	Futures	14327.83	14340.28	14322.04	14335.36	2017.0
2020-12-01 01:00:00	NQ	Futures	14333.91	14343.46	14325.23	14342.02	1804.0
2020-12-01 02:00:00	NQ	Futures	14342.02	14357.65	14338.54	14343.46	3969.0
2020-12-01 03:00:00	NQ	Futures	14343.17	14343.17	14299.46	14313.94	10540.0
2020-12-01 04:00:00	NQ	Futures	14313.94	14332.17	14309.6	14319.73	5134.0
2020-12-01 05:00:00	NQ	Futures	14318.28	14348.67	14307.86	14346.07	4620.0
2020-12-01 06:00:00	NQ	Futures	14345.2	14356.49	14334.78	14340.57	3904.0
2020-12-01 07:00:00	NQ	Futures	14340.86	14353.31	14335.36	14350.99	3574.0
2020-12-01 08:00:00	NQ	Futures	14350.99	14355.33	14312.78	14334.2	12137.0
2020-12-01 09:00:00	NQ	Futures	14334.49	14352.15	14281.52	14346.94	68976.0
2020-12-01 10:00:00	NQ	Futures	14346.36	14395.28	14299.75	14353.88	83116.0
2020-12-01 11:00:00	NQ	Futures	14353.88	14417.28	14350.41	14412.94	57328.0
2020-12-01 12:00:00	NQ	Futures	14413.23	14459.54	14408.02	14425.96	42997.0
2020-12-01 13:00:00	NQ	Futures	14426.25	14481.25	14422.78	14460.99	30150.0
2020-12-01 14:00:00	NQ	Futures	14461.28	14487.62	14427.12	14436.09	32826.0
2020-12-01 15:00:00	NQ	Futures	14435.8	14437.83	14381.09	14415.83	57775.0
2020-12-01 16:00:00	NQ	Futures	14415.54	14441.3	14405.12	14425.38	11478.0
2020-12-01 18:00:00	NQ	Futures	14422.78	14442.75	14398.46	14417.57	3721.0
2020-12-01 19:00:00	NQ	Futures	14417.86	14419.59	14396.15	14400.2	3590.0
2020-12-01 20:00:00	NQ	Futures	14399.91	14401.65	14373.86	14380.23	5161.0
2020-12-01 21:00:00	NQ	Futures	14379.94	14394.99	14364.02	14387.46	3954.0
2020-12-01 22:00:00	NQ	Futures	14387.75	14401.07	14383.99	14384.57	2566.0
2020-12-01 23:00:00	NQ	Futures	14384.86	14405.99	14381.67	14402.52	2032.0
2020-12-01 00:00:00	YM	Futures	33019.3	33035.9	33000.5	33016.0	1535.0
2020-12-01 01:00:00	YM	Futures	33017.1	33030.4	32999.4	33011.6	1155.0
2020-12-01 02:00:00	YM	Futures	33011.6	33049.2	32992.8	33011.6	2218.0
2020-12-01 03:00:00	YM	Futures	33012.7	33129.9	32966.3	33095.6	8256.0

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

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