PREVIEW / futures_1hour / 2019-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-17.parquet
  size:    57 KB
  rows:    1,773

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-01-17 00:00:00	ES	Futures	2831.0	2831.54	2828.55	2829.64	7012.0
2019-01-17 01:00:00	ES	Futures	2829.37	2831.0	2825.29	2826.38	8839.0
2019-01-17 02:00:00	ES	Futures	2826.38	2829.91	2822.58	2824.21	17578.0
2019-01-17 03:00:00	ES	Futures	2823.94	2829.1	2820.68	2828.28	23682.0
2019-01-17 04:00:00	ES	Futures	2828.28	2830.18	2822.85	2825.57	16466.0
2019-01-17 05:00:00	ES	Futures	2825.57	2831.27	2825.57	2830.73	11722.0
2019-01-17 06:00:00	ES	Futures	2830.45	2832.36	2828.01	2830.18	9708.0
2019-01-17 07:00:00	ES	Futures	2830.18	2830.73	2824.75	2827.2	19839.0
2019-01-17 08:00:00	ES	Futures	2827.2	2834.26	2826.92	2831.54	30977.0
2019-01-17 09:00:00	ES	Futures	2831.81	2843.76	2829.64	2842.13	168094.0
2019-01-17 10:00:00	ES	Futures	2842.4	2844.85	2836.7	2843.22	154393.0
2019-01-17 11:00:00	ES	Futures	2843.22	2849.47	2842.68	2847.29	121612.0
2019-01-17 12:00:00	ES	Futures	2847.56	2849.47	2843.76	2844.85	69516.0
2019-01-17 13:00:00	ES	Futures	2845.12	2852.45	2844.85	2851.37	75566.0
2019-01-17 14:00:00	ES	Futures	2851.37	2873.91	2847.29	2859.51	324162.0
2019-01-17 15:00:00	ES	Futures	2859.79	2864.67	2851.91	2863.59	265312.0
2019-01-17 16:00:00	ES	Futures	2863.32	2867.66	2859.79	2866.03	81121.0
2019-01-17 18:00:00	ES	Futures	2864.4	2864.95	2860.06	2861.14	8828.0
2019-01-17 19:00:00	ES	Futures	2861.14	2872.28	2860.06	2867.12	20220.0
2019-01-17 20:00:00	ES	Futures	2867.12	2873.09	2866.85	2871.19	14788.0
2019-01-17 21:00:00	ES	Futures	2871.46	2873.09	2869.56	2871.46	7475.0
2019-01-17 22:00:00	ES	Futures	2871.46	2872.28	2870.11	2870.38	4667.0
2019-01-17 23:00:00	ES	Futures	2870.38	2870.38	2868.48	2869.02	4316.0
2019-01-17 00:00:00	NQ	Futures	7773.41	7776.91	7766.1	7771.36	2733.0
2019-01-17 01:00:00	NQ	Futures	7771.65	7776.91	7746.23	7747.69	4521.0
2019-01-17 02:00:00	NQ	Futures	7747.98	7758.8	7736.59	7743.02	6570.0
2019-01-17 03:00:00	NQ	Futures	7743.02	7759.09	7728.12	7755.87	7807.0
2019-01-17 04:00:00	NQ	Futures	7755.87	7762.89	7741.26	7749.15	4758.0
2019-01-17 05:00:00	NQ	Futures	7748.86	7764.05	7748.86	7761.72	3152.0
2019-01-17 06:00:00	NQ	Futures	7761.43	7768.15	7756.75	7763.76	3265.0
2019-01-17 07:00:00	NQ	Futures	7764.05	7767.85	7751.49	7763.18	5868.0
2019-01-17 08:00:00	NQ	Futures	7763.47	7790.94	7762.3	7780.13	12227.0
2019-01-17 09:00:00	NQ	Futures	7780.71	7823.37	7765.52	7817.53	61888.0
2019-01-17 10:00:00	NQ	Futures	7817.53	7826.0	7797.36	7813.43	65233.0
2019-01-17 11:00:00	NQ	Futures	7813.43	7828.34	7811.68	7818.11	33097.0
2019-01-17 12:00:00	NQ	Futures	7818.4	7826.58	7808.76	7811.1	24408.0
2019-01-17 13:00:00	NQ	Futures	7811.1	7830.09	7810.51	7820.74	26336.0
2019-01-17 14:00:00	NQ	Futures	7821.03	7900.8	7812.27	7850.84	81070.0
2019-01-17 15:00:00	NQ	Futures	7851.13	7868.07	7831.26	7866.03	75972.0
2019-01-17 16:00:00	NQ	Futures	7865.74	7885.02	7842.36	7866.61	20779.0
2019-01-17 18:00:00	NQ	Futures	7857.26	7862.81	7844.7	7848.79	3331.0
2019-01-17 19:00:00	NQ	Futures	7848.79	7882.1	7845.87	7870.12	8717.0
2019-01-17 20:00:00	NQ	Futures	7869.83	7887.94	7867.49	7882.68	5992.0
2019-01-17 21:00:00	NQ	Futures	7882.98	7887.36	7874.21	7880.05	3016.0
2019-01-17 22:00:00	NQ	Futures	7879.76	7884.73	7875.38	7878.59	1916.0
2019-01-17 23:00:00	NQ	Futures	7878.3	7878.59	7868.95	7871.0	2260.0
2019-01-17 00:00:00	YM	Futures	26159.0	26161.2	26126.4	26139.5	1956.0
2019-01-17 01:00:00	YM	Futures	26138.4	26152.5	26104.7	26112.3	2101.0
2019-01-17 02:00:00	YM	Futures	26112.3	26150.3	26084.1	26101.5	4019.0
2019-01-17 03:00:00	YM	Futures	26102.6	26148.2	26067.8	26140.6	7270.0

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

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