PREVIEW / futures_1hour / 2020-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-05.parquet
  size:    61 KB
  rows:    1,862

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-05-05 00:00:00	ES	Futures	3119.27	3130.52	3118.99	3127.77	7629.0
2020-05-05 01:00:00	ES	Futures	3127.77	3128.87	3124.21	3125.03	3911.0
2020-05-05 02:00:00	ES	Futures	3124.76	3131.07	3122.83	3129.7	13019.0
2020-05-05 03:00:00	ES	Futures	3129.97	3143.42	3123.93	3140.12	38831.0
2020-05-05 04:00:00	ES	Futures	3140.12	3144.79	3109.94	3110.76	51334.0
2020-05-05 05:00:00	ES	Futures	3110.76	3130.24	3109.11	3128.6	35478.0
2020-05-05 06:00:00	ES	Futures	3128.87	3135.46	3125.03	3133.54	26285.0
2020-05-05 07:00:00	ES	Futures	3133.54	3138.48	3129.97	3134.63	30134.0
2020-05-05 08:00:00	ES	Futures	3134.91	3144.24	3134.36	3140.67	39950.0
2020-05-05 09:00:00	ES	Futures	3140.67	3159.33	3138.2	3158.78	166703.0
2020-05-05 10:00:00	ES	Futures	3158.78	3163.17	3150.55	3157.41	181467.0
2020-05-05 11:00:00	ES	Futures	3157.69	3168.39	3155.76	3167.56	128952.0
2020-05-05 12:00:00	ES	Futures	3167.29	3171.68	3161.25	3162.35	113381.0
2020-05-05 13:00:00	ES	Futures	3162.35	3168.11	3157.69	3166.19	96174.0
2020-05-05 14:00:00	ES	Futures	3166.19	3171.95	3162.9	3171.41	89295.0
2020-05-05 15:00:00	ES	Futures	3171.41	3171.41	3132.99	3137.93	323785.0
2020-05-05 16:00:00	ES	Futures	3137.93	3139.85	3130.79	3139.03	51754.0
2020-05-05 18:00:00	ES	Futures	3136.83	3149.45	3133.26	3148.9	11130.0
2020-05-05 19:00:00	ES	Futures	3148.63	3149.45	3144.24	3146.43	5153.0
2020-05-05 20:00:00	ES	Futures	3146.43	3146.98	3121.19	3125.03	20049.0
2020-05-05 21:00:00	ES	Futures	3125.3	3134.91	3121.19	3132.71	19520.0
2020-05-05 22:00:00	ES	Futures	3132.99	3135.73	3125.58	3134.91	9764.0
2020-05-05 23:00:00	ES	Futures	3134.63	3143.42	3134.09	3139.57	10462.0
2020-05-05 00:00:00	NQ	Futures	10104.25	10142.53	10101.68	10134.53	3116.0
2020-05-05 01:00:00	NQ	Futures	10134.53	10138.53	10117.96	10120.82	1984.0
2020-05-05 02:00:00	NQ	Futures	10121.1	10138.81	10111.68	10133.1	4686.0
2020-05-05 03:00:00	NQ	Futures	10133.39	10182.52	10115.11	10174.52	11989.0
2020-05-05 04:00:00	NQ	Futures	10174.81	10187.94	10082.83	10086.26	15304.0
2020-05-05 05:00:00	NQ	Futures	10087.11	10147.38	10079.97	10143.38	11563.0
2020-05-05 06:00:00	NQ	Futures	10143.38	10166.24	10133.96	10160.81	7348.0
2020-05-05 07:00:00	NQ	Futures	10161.67	10181.95	10151.1	10174.81	8965.0
2020-05-05 08:00:00	NQ	Futures	10174.23	10198.51	10172.52	10183.09	12986.0
2020-05-05 09:00:00	NQ	Futures	10183.09	10234.5	10163.38	10233.65	42445.0
2020-05-05 10:00:00	NQ	Futures	10233.65	10251.64	10211.65	10240.79	46208.0
2020-05-05 11:00:00	NQ	Futures	10240.5	10268.21	10228.51	10265.92	30400.0
2020-05-05 12:00:00	NQ	Futures	10265.64	10281.63	10243.36	10255.36	25899.0
2020-05-05 13:00:00	NQ	Futures	10254.78	10284.78	10244.79	10278.78	20646.0
2020-05-05 14:00:00	NQ	Futures	10279.06	10305.91	10270.21	10304.49	23232.0
2020-05-05 15:00:00	NQ	Futures	10304.2	10304.2	10151.38	10190.23	67860.0
2020-05-05 16:00:00	NQ	Futures	10189.94	10207.37	10174.52	10206.23	9189.0
2020-05-05 18:00:00	NQ	Futures	10201.37	10245.07	10185.95	10242.5	4910.0
2020-05-05 19:00:00	NQ	Futures	10242.79	10243.07	10226.22	10233.08	2255.0
2020-05-05 20:00:00	NQ	Futures	10232.79	10237.36	10150.81	10164.52	8434.0
2020-05-05 21:00:00	NQ	Futures	10164.52	10184.8	10143.38	10174.23	8520.0
2020-05-05 22:00:00	NQ	Futures	10174.81	10187.37	10154.81	10183.95	4396.0
2020-05-05 23:00:00	NQ	Futures	10183.09	10214.79	10181.95	10202.23	4555.0
2020-05-05 00:00:00	YM	Futures	26008.3	26100.3	26003.9	26079.5	1725.0
2020-05-05 01:00:00	YM	Futures	26079.5	26089.4	26051.0	26057.6	1112.0
2020-05-05 02:00:00	YM	Futures	26056.5	26111.3	26036.8	26100.3	3271.0
2020-05-05 03:00:00	YM	Futures	26101.4	26205.5	26049.9	26170.4	7558.0

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

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