PREVIEW / futures_1hour / 2019-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-19.parquet
  size:    56 KB
  rows:    1,782

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-19 00:00:00	ES	Futures	3016.22	3016.49	3014.32	3015.68	4321.0
2019-02-19 01:00:00	ES	Futures	3015.68	3016.22	3014.59	3015.95	2056.0
2019-02-19 02:00:00	ES	Futures	3016.22	3016.76	3014.59	3015.13	4684.0
2019-02-19 03:00:00	ES	Futures	3015.13	3017.03	3013.77	3016.49	18460.0
2019-02-19 04:00:00	ES	Futures	3016.76	3017.85	3010.24	3011.87	25112.0
2019-02-19 05:00:00	ES	Futures	3011.87	3013.5	3010.79	3012.42	12827.0
2019-02-19 06:00:00	ES	Futures	3012.42	3012.96	3005.9	3006.98	25348.0
2019-02-19 07:00:00	ES	Futures	3007.26	3010.51	3005.63	3008.61	20718.0
2019-02-19 08:00:00	ES	Futures	3008.61	3010.24	3005.9	3007.53	26240.0
2019-02-19 09:00:00	ES	Futures	3007.53	3014.86	3004.81	3014.05	165524.0
2019-02-19 10:00:00	ES	Futures	3014.32	3017.3	3011.06	3012.69	143511.0
2019-02-19 11:00:00	ES	Futures	3012.69	3024.37	3012.69	3023.82	137620.0
2019-02-19 12:00:00	ES	Futures	3024.09	3024.37	3020.29	3021.65	65021.0
2019-02-19 13:00:00	ES	Futures	3021.38	3021.92	3018.66	3021.11	46707.0
2019-02-19 14:00:00	ES	Futures	3020.84	3028.17	3020.56	3027.35	81110.0
2019-02-19 15:00:00	ES	Futures	3027.35	3027.9	3018.66	3020.29	158872.0
2019-02-19 16:00:00	ES	Futures	3020.29	3020.84	3015.68	3017.58	48754.0
2019-02-19 18:00:00	ES	Futures	3017.58	3019.21	3015.68	3018.39	7033.0
2019-02-19 19:00:00	ES	Futures	3018.66	3019.21	3016.49	3018.66	8360.0
2019-02-19 20:00:00	ES	Futures	3018.66	3022.46	3017.58	3021.38	10569.0
2019-02-19 21:00:00	ES	Futures	3021.38	3021.65	3019.21	3019.48	7338.0
2019-02-19 22:00:00	ES	Futures	3019.48	3020.02	3013.77	3015.4	8683.0
2019-02-19 23:00:00	ES	Futures	3015.4	3016.49	3014.86	3015.68	3388.0
2019-02-19 00:00:00	NQ	Futures	8271.0	8271.3	8260.78	8265.74	2385.0
2019-02-19 01:00:00	NQ	Futures	8265.45	8267.21	8261.07	8266.62	1145.0
2019-02-19 02:00:00	NQ	Futures	8266.33	8268.37	8260.78	8262.82	2771.0
2019-02-19 03:00:00	NQ	Futures	8263.11	8268.67	8256.39	8267.5	6729.0
2019-02-19 04:00:00	NQ	Futures	8267.5	8271.3	8245.29	8249.97	8527.0
2019-02-19 05:00:00	NQ	Futures	8250.26	8253.76	8246.75	8249.97	4038.0
2019-02-19 06:00:00	NQ	Futures	8250.26	8251.13	8227.47	8233.31	7946.0
2019-02-19 07:00:00	NQ	Futures	8233.31	8241.49	8228.05	8236.23	7547.0
2019-02-19 08:00:00	NQ	Futures	8236.23	8239.45	8226.3	8231.27	7086.0
2019-02-19 09:00:00	NQ	Futures	8231.27	8263.99	8222.5	8259.9	53096.0
2019-02-19 10:00:00	NQ	Futures	8259.9	8272.46	8254.35	8260.48	44512.0
2019-02-19 11:00:00	NQ	Futures	8260.19	8287.07	8256.1	8286.2	43435.0
2019-02-19 12:00:00	NQ	Futures	8286.49	8287.07	8273.05	8274.8	23194.0
2019-02-19 13:00:00	NQ	Futures	8274.22	8275.39	8266.91	8270.42	19642.0
2019-02-19 14:00:00	NQ	Futures	8270.71	8292.04	8269.54	8290.58	26345.0
2019-02-19 15:00:00	NQ	Futures	8290.29	8290.87	8260.48	8265.74	36027.0
2019-02-19 16:00:00	NQ	Futures	8266.04	8266.62	8252.3	8261.36	6972.0
2019-02-19 18:00:00	NQ	Futures	8261.65	8266.04	8253.47	8262.24	1918.0
2019-02-19 19:00:00	NQ	Futures	8261.95	8268.37	8257.56	8264.58	3203.0
2019-02-19 20:00:00	NQ	Futures	8264.28	8280.65	8260.48	8277.43	4443.0
2019-02-19 21:00:00	NQ	Futures	8277.72	8277.72	8269.25	8270.42	3118.0
2019-02-19 22:00:00	NQ	Futures	8270.42	8272.76	8251.43	8257.27	4075.0
2019-02-19 23:00:00	NQ	Futures	8257.27	8262.24	8254.35	8259.32	2517.0
2019-02-19 00:00:00	YM	Futures	28106.8	28106.8	28085.1	28103.5	1300.0
2019-02-19 01:00:00	YM	Futures	28103.5	28110.0	28093.7	28106.8	778.0
2019-02-19 02:00:00	YM	Futures	28106.8	28112.2	28092.7	28095.9	1439.0
2019-02-19 03:00:00	YM	Futures	28095.9	28110.0	28075.3	28107.9	4632.0

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

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