PREVIEW / futures_1hour / 2020-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-29.parquet
  size:    60 KB
  rows:    1,926

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-29 00:00:00	ES	Futures	4200.17	4207.19	4200.17	4204.38	7205.0
2020-12-29 01:00:00	ES	Futures	4204.38	4204.66	4202.42	4204.1	4016.0
2020-12-29 02:00:00	ES	Futures	4204.1	4206.07	4202.42	4204.94	6829.0
2020-12-29 03:00:00	ES	Futures	4204.94	4207.47	4202.14	4204.66	12953.0
2020-12-29 04:00:00	ES	Futures	4204.94	4206.35	4203.26	4203.54	5647.0
2020-12-29 05:00:00	ES	Futures	4203.54	4205.51	4203.54	4204.94	4367.0
2020-12-29 06:00:00	ES	Futures	4204.66	4204.94	4200.73	4203.54	6112.0
2020-12-29 07:00:00	ES	Futures	4203.26	4205.22	4201.58	4202.14	7101.0
2020-12-29 08:00:00	ES	Futures	4202.14	4202.98	4199.33	4201.86	12628.0
2020-12-29 09:00:00	ES	Futures	4202.14	4205.79	4185.3	4189.51	146478.0
2020-12-29 10:00:00	ES	Futures	4189.23	4193.44	4181.09	4191.47	163742.0
2020-12-29 11:00:00	ES	Futures	4191.19	4193.16	4182.77	4189.79	102960.0
2020-12-29 12:00:00	ES	Futures	4189.79	4190.07	4170.14	4178.0	128517.0
2020-12-29 13:00:00	ES	Futures	4178.28	4181.37	4173.51	4179.96	58497.0
2020-12-29 14:00:00	ES	Futures	4180.25	4180.53	4170.42	4175.19	97829.0
2020-12-29 15:00:00	ES	Futures	4175.47	4183.05	4172.67	4177.72	135967.0
2020-12-29 16:00:00	ES	Futures	4177.72	4182.49	4176.32	4181.09	31679.0
2020-12-29 18:00:00	ES	Futures	4181.37	4183.89	4175.19	4178.28	5586.0
2020-12-29 19:00:00	ES	Futures	4178.28	4178.84	4172.39	4176.04	9940.0
2020-12-29 20:00:00	ES	Futures	4176.04	4183.61	4174.07	4180.53	8388.0
2020-12-29 21:00:00	ES	Futures	4180.81	4187.26	4180.53	4186.7	5680.0
2020-12-29 22:00:00	ES	Futures	4186.42	4188.67	4182.77	4186.14	5422.0
2020-12-29 23:00:00	ES	Futures	4185.86	4192.59	4185.58	4190.63	5499.0
2020-12-29 00:00:00	NQ	Futures	14895.42	14917.7	14894.55	14910.18	5365.0
2020-12-29 01:00:00	NQ	Futures	14910.47	14917.41	14907.28	14915.1	2659.0
2020-12-29 02:00:00	NQ	Futures	14915.39	14929.86	14913.36	14928.41	4316.0
2020-12-29 03:00:00	NQ	Futures	14927.54	14933.33	14921.47	14925.52	4493.0
2020-12-29 04:00:00	NQ	Futures	14925.52	14926.1	14918.57	14920.02	2749.0
2020-12-29 05:00:00	NQ	Futures	14919.73	14922.62	14911.92	14918.57	2371.0
2020-12-29 06:00:00	NQ	Futures	14919.15	14920.02	14904.68	14914.81	3127.0
2020-12-29 07:00:00	NQ	Futures	14914.52	14926.97	14914.23	14919.44	4121.0
2020-12-29 08:00:00	NQ	Futures	14919.44	14926.39	14915.39	14924.36	4782.0
2020-12-29 09:00:00	NQ	Futures	14924.36	14955.91	14874.87	14888.18	66070.0
2020-12-29 10:00:00	NQ	Futures	14888.18	14919.15	14831.45	14912.49	81106.0
2020-12-29 11:00:00	NQ	Futures	14912.2	14922.05	14871.11	14890.5	44184.0
2020-12-29 12:00:00	NQ	Futures	14890.5	14891.66	14828.56	14873.13	49626.0
2020-12-29 13:00:00	NQ	Futures	14873.13	14893.97	14864.16	14889.34	24922.0
2020-12-29 14:00:00	NQ	Futures	14889.63	14890.21	14841.58	14869.66	30668.0
2020-12-29 15:00:00	NQ	Futures	14869.95	14893.1	14847.37	14873.13	36544.0
2020-12-29 16:00:00	NQ	Futures	14873.42	14887.31	14862.13	14885.87	6370.0
2020-12-29 18:00:00	NQ	Futures	14889.34	14893.68	14868.79	14871.68	2563.0
2020-12-29 19:00:00	NQ	Futures	14871.39	14873.13	14855.48	14859.53	3463.0
2020-12-29 20:00:00	NQ	Futures	14858.66	14878.05	14851.42	14876.32	3982.0
2020-12-29 21:00:00	NQ	Futures	14876.32	14914.81	14876.32	14909.6	4203.0
2020-12-29 22:00:00	NQ	Futures	14909.89	14917.99	14898.6	14906.42	3298.0
2020-12-29 23:00:00	NQ	Futures	14906.13	14917.99	14904.39	14914.81	2146.0
2020-12-29 00:00:00	YM	Futures	33778.3	33832.7	33778.3	33814.9	1945.0
2020-12-29 01:00:00	YM	Futures	33813.8	33817.1	33797.2	33814.9	900.0
2020-12-29 02:00:00	YM	Futures	33814.9	33823.8	33777.2	33809.4	1919.0
2020-12-29 03:00:00	YM	Futures	33807.2	33813.8	33757.2	33791.6	3227.0

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

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