PREVIEW / futures_1hour / 2019-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-21.parquet
  size:    55 KB
  rows:    1,779

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
2019-02-21 00:00:00	ES	Futures	3037.67	3038.76	3034.41	3034.41	11203.0
2019-02-21 01:00:00	ES	Futures	3034.69	3034.69	3031.97	3033.6	9705.0
2019-02-21 02:00:00	ES	Futures	3033.6	3034.96	3030.88	3031.7	11384.0
2019-02-21 03:00:00	ES	Futures	3031.97	3033.87	3030.07	3030.88	19193.0
2019-02-21 04:00:00	ES	Futures	3030.88	3031.16	3028.17	3029.8	13429.0
2019-02-21 05:00:00	ES	Futures	3030.07	3031.7	3028.44	3030.61	11994.0
2019-02-21 06:00:00	ES	Futures	3030.34	3031.97	3027.9	3028.98	13046.0
2019-02-21 07:00:00	ES	Futures	3028.98	3030.34	3020.02	3023.01	38717.0
2019-02-21 08:00:00	ES	Futures	3023.01	3024.91	3018.12	3021.92	38070.0
2019-02-21 09:00:00	ES	Futures	3021.92	3023.28	3009.16	3012.96	242664.0
2019-02-21 10:00:00	ES	Futures	3013.23	3015.4	3008.07	3011.6	240443.0
2019-02-21 11:00:00	ES	Futures	3011.6	3020.02	3009.7	3017.58	139027.0
2019-02-21 12:00:00	ES	Futures	3017.85	3021.11	3015.95	3021.11	81948.0
2019-02-21 13:00:00	ES	Futures	3021.11	3021.92	3016.22	3018.12	54599.0
2019-02-21 14:00:00	ES	Futures	3018.12	3018.66	3002.91	3005.9	140034.0
2019-02-21 15:00:00	ES	Futures	3005.63	3015.4	3002.91	3014.86	192641.0
2019-02-21 16:00:00	ES	Futures	3014.86	3016.22	3012.96	3013.5	53621.0
2019-02-21 18:00:00	ES	Futures	3012.96	3014.32	3010.79	3014.05	7672.0
2019-02-21 19:00:00	ES	Futures	3014.05	3014.86	3011.33	3014.86	7357.0
2019-02-21 20:00:00	ES	Futures	3014.59	3015.68	3009.7	3011.06	9758.0
2019-02-21 21:00:00	ES	Futures	3011.06	3013.23	3010.51	3011.33	5896.0
2019-02-21 22:00:00	ES	Futures	3011.33	3013.23	3010.24	3011.87	5576.0
2019-02-21 23:00:00	ES	Futures	3011.87	3012.96	3010.79	3011.33	4329.0
2019-02-21 00:00:00	NQ	Futures	8302.56	8307.53	8293.79	8294.09	4249.0
2019-02-21 01:00:00	NQ	Futures	8294.38	8295.26	8284.44	8291.16	3181.0
2019-02-21 02:00:00	NQ	Futures	8291.16	8294.38	8278.31	8284.44	4792.0
2019-02-21 03:00:00	NQ	Futures	8285.03	8290.29	8276.56	8281.23	6241.0
2019-02-21 04:00:00	NQ	Futures	8281.52	8283.57	8271.0	8281.52	4235.0
2019-02-21 05:00:00	NQ	Futures	8281.23	8288.24	8278.02	8285.91	3351.0
2019-02-21 06:00:00	NQ	Futures	8286.2	8291.75	8278.89	8281.23	3316.0
2019-02-21 07:00:00	NQ	Futures	8280.94	8285.03	8249.67	8259.9	14100.0
2019-02-21 08:00:00	NQ	Futures	8259.9	8265.45	8241.2	8252.89	12225.0
2019-02-21 09:00:00	NQ	Futures	8252.3	8258.73	8196.5	8208.47	70091.0
2019-02-21 10:00:00	NQ	Futures	8208.77	8216.07	8187.15	8209.06	75751.0
2019-02-21 11:00:00	NQ	Futures	8209.06	8249.67	8202.05	8243.54	50930.0
2019-02-21 12:00:00	NQ	Futures	8243.83	8262.53	8241.49	8260.78	32223.0
2019-02-21 13:00:00	NQ	Futures	8260.48	8262.24	8243.25	8248.8	22067.0
2019-02-21 14:00:00	NQ	Futures	8248.8	8252.01	8199.12	8206.14	39222.0
2019-02-21 15:00:00	NQ	Futures	8205.26	8231.56	8196.79	8230.97	46485.0
2019-02-21 16:00:00	NQ	Futures	8230.97	8233.9	8220.45	8225.13	8512.0
2019-02-21 18:00:00	NQ	Futures	8217.83	8220.45	8209.64	8218.99	2558.0
2019-02-21 19:00:00	NQ	Futures	8218.99	8222.21	8211.1	8222.21	4496.0
2019-02-21 20:00:00	NQ	Futures	8222.21	8225.42	8208.18	8210.23	5008.0
2019-02-21 21:00:00	NQ	Futures	8210.52	8215.78	8206.14	8207.31	3686.0
2019-02-21 22:00:00	NQ	Futures	8207.31	8214.32	8203.8	8210.81	2757.0
2019-02-21 23:00:00	NQ	Futures	8210.81	8215.78	8209.64	8211.69	1919.0
2019-02-21 00:00:00	YM	Futures	28297.9	28308.7	28267.5	28269.6	2929.0
2019-02-21 01:00:00	YM	Futures	28269.6	28271.8	28250.1	28268.5	1931.0
2019-02-21 02:00:00	YM	Futures	28268.5	28280.5	28242.5	28251.2	2466.0
2019-02-21 03:00:00	YM	Futures	28251.2	28274.0	28237.1	28247.9	4350.0

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

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