PREVIEW / futures_1hour / 2019-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-14.parquet
  size:    56 KB
  rows:    1,771

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-14 00:00:00	ES	Futures	2797.86	2799.77	2795.42	2796.23	4603.0
2019-01-14 01:00:00	ES	Futures	2796.51	2797.86	2793.79	2795.69	4248.0
2019-01-14 02:00:00	ES	Futures	2795.69	2797.59	2794.06	2794.61	12715.0
2019-01-14 03:00:00	ES	Futures	2794.61	2800.85	2792.7	2797.05	16271.0
2019-01-14 04:00:00	ES	Futures	2797.32	2800.58	2794.61	2795.15	12653.0
2019-01-14 05:00:00	ES	Futures	2794.88	2795.69	2788.9	2792.16	22360.0
2019-01-14 06:00:00	ES	Futures	2792.16	2795.96	2790.26	2795.96	17285.0
2019-01-14 07:00:00	ES	Futures	2795.96	2799.77	2794.06	2795.15	20898.0
2019-01-14 08:00:00	ES	Futures	2795.42	2800.04	2794.61	2798.41	31967.0
2019-01-14 09:00:00	ES	Futures	2798.41	2804.93	2792.7	2800.85	163356.0
2019-01-14 10:00:00	ES	Futures	2801.12	2811.44	2799.22	2808.46	199241.0
2019-01-14 11:00:00	ES	Futures	2808.46	2810.09	2800.85	2805.74	132568.0
2019-01-14 12:00:00	ES	Futures	2805.74	2811.72	2803.84	2808.46	76343.0
2019-01-14 13:00:00	ES	Futures	2808.18	2813.34	2806.55	2809.81	65153.0
2019-01-14 14:00:00	ES	Futures	2809.81	2812.53	2804.38	2811.72	77947.0
2019-01-14 15:00:00	ES	Futures	2811.72	2813.07	2802.75	2804.11	157883.0
2019-01-14 16:00:00	ES	Futures	2804.11	2805.74	2799.49	2804.38	84143.0
2019-01-14 18:00:00	ES	Futures	2804.38	2806.55	2802.75	2806.01	5940.0
2019-01-14 19:00:00	ES	Futures	2806.28	2812.53	2806.01	2810.9	12272.0
2019-01-14 20:00:00	ES	Futures	2810.9	2820.68	2810.36	2817.69	21234.0
2019-01-14 21:00:00	ES	Futures	2817.42	2821.76	2817.42	2818.5	11990.0
2019-01-14 22:00:00	ES	Futures	2818.23	2822.31	2818.23	2820.41	12711.0
2019-01-14 23:00:00	ES	Futures	2820.68	2821.76	2819.86	2820.13	4229.0
2019-01-14 00:00:00	NQ	Futures	7655.94	7660.91	7646.01	7648.93	2188.0
2019-01-14 01:00:00	NQ	Futures	7648.06	7653.9	7636.37	7645.72	2990.0
2019-01-14 02:00:00	NQ	Futures	7645.43	7652.44	7642.5	7644.55	3978.0
2019-01-14 03:00:00	NQ	Futures	7644.55	7668.51	7638.41	7655.07	6239.0
2019-01-14 04:00:00	NQ	Futures	7654.78	7667.92	7649.52	7651.56	4558.0
2019-01-14 05:00:00	NQ	Futures	7650.98	7654.19	7627.02	7634.32	7790.0
2019-01-14 06:00:00	NQ	Futures	7634.62	7645.43	7628.48	7645.43	5295.0
2019-01-14 07:00:00	NQ	Futures	7645.72	7657.41	7640.46	7643.97	6466.0
2019-01-14 08:00:00	NQ	Futures	7644.26	7665.0	7643.38	7658.87	11626.0
2019-01-14 09:00:00	NQ	Futures	7659.16	7660.04	7622.05	7635.49	59297.0
2019-01-14 10:00:00	NQ	Futures	7635.49	7686.92	7629.06	7679.61	66580.0
2019-01-14 11:00:00	NQ	Futures	7679.61	7687.79	7659.45	7674.35	49627.0
2019-01-14 12:00:00	NQ	Futures	7674.35	7686.62	7665.88	7675.52	23604.0
2019-01-14 13:00:00	NQ	Futures	7675.23	7689.55	7668.22	7677.57	20775.0
2019-01-14 14:00:00	NQ	Futures	7677.57	7682.24	7660.62	7679.9	22403.0
2019-01-14 15:00:00	NQ	Futures	7680.2	7685.16	7648.06	7657.99	34545.0
2019-01-14 16:00:00	NQ	Futures	7657.7	7658.87	7643.67	7650.69	11420.0
2019-01-14 18:00:00	NQ	Futures	7647.18	7659.16	7646.3	7657.11	2440.0
2019-01-14 19:00:00	NQ	Futures	7657.41	7678.74	7656.82	7675.23	5406.0
2019-01-14 20:00:00	NQ	Futures	7675.23	7709.71	7672.02	7698.31	8979.0
2019-01-14 21:00:00	NQ	Futures	7698.31	7712.92	7697.73	7700.07	5590.0
2019-01-14 22:00:00	NQ	Futures	7700.07	7711.17	7699.77	7706.2	4784.0
2019-01-14 23:00:00	NQ	Futures	7707.08	7710.88	7705.32	7706.2	2069.0
2019-01-14 00:00:00	YM	Futures	25808.3	25822.4	25782.3	25795.3	1278.0
2019-01-14 01:00:00	YM	Futures	25796.4	25809.4	25763.8	25786.6	1387.0
2019-01-14 02:00:00	YM	Futures	25785.5	25810.5	25776.9	25782.3	2913.0
2019-01-14 03:00:00	YM	Futures	25783.4	25837.6	25768.2	25805.1	4364.0

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

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