PREVIEW / futures_1hour / 2019-02-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	3032.24	3033.06	3027.08	3027.08	10076.0
2019-02-28 01:00:00	ES	Futures	3027.08	3029.25	3024.09	3025.45	10952.0
2019-02-28 02:00:00	ES	Futures	3025.45	3027.08	3021.92	3023.01	15608.0
2019-02-28 03:00:00	ES	Futures	3023.01	3027.62	3021.92	3027.08	17827.0
2019-02-28 04:00:00	ES	Futures	3027.35	3028.98	3026.54	3028.17	10309.0
2019-02-28 05:00:00	ES	Futures	3028.17	3028.44	3026.0	3027.35	9281.0
2019-02-28 06:00:00	ES	Futures	3027.35	3029.53	3026.27	3028.71	12660.0
2019-02-28 07:00:00	ES	Futures	3028.98	3032.24	3027.35	3030.88	19418.0
2019-02-28 08:00:00	ES	Futures	3030.88	3033.6	3027.9	3031.16	30016.0
2019-02-28 09:00:00	ES	Futures	3031.16	3034.41	3027.35	3031.43	137044.0
2019-02-28 10:00:00	ES	Futures	3031.43	3031.43	3023.82	3027.35	217403.0
2019-02-28 11:00:00	ES	Futures	3027.08	3033.6	3024.09	3031.16	118800.0
2019-02-28 12:00:00	ES	Futures	3031.43	3035.5	3030.34	3034.96	71158.0
2019-02-28 13:00:00	ES	Futures	3034.96	3035.23	3030.61	3031.97	56066.0
2019-02-28 14:00:00	ES	Futures	3032.24	3033.6	3026.81	3028.71	86276.0
2019-02-28 15:00:00	ES	Futures	3028.71	3032.78	3023.01	3025.45	311481.0
2019-02-28 16:00:00	ES	Futures	3025.45	3030.61	3024.91	3027.62	109123.0
2019-02-28 18:00:00	ES	Futures	3025.72	3027.08	3023.28	3025.72	7458.0
2019-02-28 19:00:00	ES	Futures	3025.72	3028.98	3025.45	3028.17	5600.0
2019-02-28 20:00:00	ES	Futures	3028.17	3036.86	3028.17	3033.06	17674.0
2019-02-28 21:00:00	ES	Futures	3033.33	3036.04	3032.24	3036.04	7657.0
2019-02-28 22:00:00	ES	Futures	3035.77	3040.12	3035.5	3038.22	10189.0
2019-02-28 23:00:00	ES	Futures	3038.22	3038.49	3036.32	3036.86	4183.0
2019-02-28 00:00:00	NQ	Futures	8308.99	8313.08	8294.09	8294.38	2950.0
2019-02-28 01:00:00	NQ	Futures	8294.38	8298.76	8284.44	8287.37	3945.0
2019-02-28 02:00:00	NQ	Futures	8287.37	8291.75	8271.59	8273.63	6755.0
2019-02-28 03:00:00	NQ	Futures	8273.63	8286.49	8266.04	8285.32	6808.0
2019-02-28 04:00:00	NQ	Futures	8285.61	8290.87	8282.11	8288.24	3739.0
2019-02-28 05:00:00	NQ	Futures	8288.53	8289.7	8280.06	8286.49	2853.0
2019-02-28 06:00:00	NQ	Futures	8286.49	8293.79	8281.81	8291.46	3442.0
2019-02-28 07:00:00	NQ	Futures	8291.46	8299.93	8286.49	8298.47	5128.0
2019-02-28 08:00:00	NQ	Futures	8298.47	8309.28	8289.12	8299.05	9049.0
2019-02-28 09:00:00	NQ	Futures	8299.35	8323.89	8290.87	8311.33	51703.0
2019-02-28 10:00:00	NQ	Futures	8311.33	8311.33	8280.06	8299.05	70521.0
2019-02-28 11:00:00	NQ	Futures	8298.47	8327.69	8288.83	8319.8	44516.0
2019-02-28 12:00:00	NQ	Futures	8319.8	8334.12	8315.12	8331.49	24335.0
2019-02-28 13:00:00	NQ	Futures	8331.49	8333.82	8318.63	8323.31	19332.0
2019-02-28 14:00:00	NQ	Futures	8323.31	8327.1	8307.82	8313.66	25611.0
2019-02-28 15:00:00	NQ	Futures	8313.37	8320.09	8291.16	8303.44	52056.0
2019-02-28 16:00:00	NQ	Futures	8303.73	8317.46	8302.27	8310.16	11889.0
2019-02-28 18:00:00	NQ	Futures	8305.77	8308.4	8296.13	8304.61	2357.0
2019-02-28 19:00:00	NQ	Futures	8304.61	8315.71	8304.61	8313.08	2746.0
2019-02-28 20:00:00	NQ	Futures	8313.08	8340.84	8313.08	8328.56	7574.0
2019-02-28 21:00:00	NQ	Futures	8328.86	8338.79	8325.64	8338.21	2694.0
2019-02-28 22:00:00	NQ	Futures	8337.62	8352.23	8337.04	8344.93	4283.0
2019-02-28 23:00:00	NQ	Futures	8344.93	8347.85	8341.13	8342.3	1605.0
2019-02-28 00:00:00	YM	Futures	28204.5	28215.3	28158.9	28161.1	2228.0
2019-02-28 01:00:00	YM	Futures	28161.1	28180.6	28127.4	28140.4	2582.0
2019-02-28 02:00:00	YM	Futures	28141.5	28152.4	28095.9	28118.7	5297.0
2019-02-28 03:00:00	YM	Futures	28118.7	28164.3	28105.7	28161.1	4339.0

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

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