PREVIEW / futures_1hour / 2018-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-18.parquet
  size:    56 KB
  rows:    1,749

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
2018-12-18 00:00:00	ES	Futures	2777.22	2778.31	2772.61	2774.51	12460.0
2018-12-18 01:00:00	ES	Futures	2774.51	2781.3	2773.69	2781.03	6956.0
2018-12-18 02:00:00	ES	Futures	2780.75	2785.64	2775.05	2784.01	18258.0
2018-12-18 03:00:00	ES	Futures	2784.01	2785.37	2777.5	2784.56	26419.0
2018-12-18 04:00:00	ES	Futures	2784.28	2787.82	2778.04	2787.0	26638.0
2018-12-18 05:00:00	ES	Futures	2786.73	2790.26	2783.74	2784.56	15845.0
2018-12-18 06:00:00	ES	Futures	2784.56	2789.99	2783.74	2787.0	16667.0
2018-12-18 07:00:00	ES	Futures	2787.0	2797.86	2784.83	2796.78	33633.0
2018-12-18 08:00:00	ES	Futures	2796.78	2798.68	2790.8	2791.35	38986.0
2018-12-18 09:00:00	ES	Futures	2791.35	2800.31	2787.82	2798.68	233222.0
2018-12-18 10:00:00	ES	Futures	2798.68	2799.22	2782.38	2785.64	291867.0
2018-12-18 11:00:00	ES	Futures	2785.91	2789.99	2775.32	2783.47	206298.0
2018-12-18 12:00:00	ES	Futures	2783.2	2798.68	2782.93	2793.52	148778.0
2018-12-18 13:00:00	ES	Futures	2793.52	2795.69	2774.51	2777.77	127992.0
2018-12-18 14:00:00	ES	Futures	2777.77	2786.19	2754.41	2754.95	235821.0
2018-12-18 15:00:00	ES	Futures	2754.95	2783.74	2749.52	2768.8	394156.0
2018-12-18 16:00:00	ES	Futures	2768.8	2770.16	2748.44	2750.61	94109.0
2018-12-18 18:00:00	ES	Futures	2750.61	2762.83	2749.52	2762.56	11032.0
2018-12-18 19:00:00	ES	Futures	2762.56	2766.9	2756.58	2764.19	16258.0
2018-12-18 20:00:00	ES	Futures	2764.46	2770.98	2763.1	2770.16	12805.0
2018-12-18 21:00:00	ES	Futures	2769.89	2770.16	2765.27	2767.45	8017.0
2018-12-18 22:00:00	ES	Futures	2767.45	2772.06	2766.9	2771.79	8737.0
2018-12-18 23:00:00	ES	Futures	2771.52	2775.05	2770.43	2775.05	6817.0
2018-12-18 00:00:00	NQ	Futures	7594.29	7599.55	7579.98	7585.24	5029.0
2018-12-18 01:00:00	NQ	Futures	7585.82	7605.1	7582.9	7603.35	3108.0
2018-12-18 02:00:00	NQ	Futures	7603.94	7617.38	7583.77	7607.44	5846.0
2018-12-18 03:00:00	NQ	Futures	7607.44	7613.58	7586.7	7609.19	7736.0
2018-12-18 04:00:00	NQ	Futures	7608.9	7624.1	7591.37	7621.47	8431.0
2018-12-18 05:00:00	NQ	Futures	7621.17	7630.82	7607.73	7611.82	4869.0
2018-12-18 06:00:00	NQ	Futures	7611.24	7634.91	7609.78	7624.68	5852.0
2018-12-18 07:00:00	NQ	Futures	7625.27	7650.1	7619.42	7645.72	8282.0
2018-12-18 08:00:00	NQ	Futures	7646.01	7653.02	7624.68	7626.14	15009.0
2018-12-18 09:00:00	NQ	Futures	7625.85	7654.78	7605.98	7647.47	69433.0
2018-12-18 10:00:00	NQ	Futures	7647.47	7655.65	7609.49	7636.66	83354.0
2018-12-18 11:00:00	NQ	Futures	7636.95	7650.39	7594.59	7622.05	53251.0
2018-12-18 12:00:00	NQ	Futures	7622.64	7687.5	7621.17	7679.61	48932.0
2018-12-18 13:00:00	NQ	Futures	7679.9	7683.12	7624.68	7635.49	39065.0
2018-12-18 14:00:00	NQ	Futures	7635.78	7666.76	7569.16	7570.33	65251.0
2018-12-18 15:00:00	NQ	Futures	7570.04	7659.74	7546.67	7612.7	104632.0
2018-12-18 16:00:00	NQ	Futures	7611.82	7618.25	7551.05	7552.22	16699.0
2018-12-18 18:00:00	NQ	Futures	7555.72	7588.45	7548.42	7588.16	4241.0
2018-12-18 19:00:00	NQ	Futures	7587.57	7601.31	7570.04	7593.42	6933.0
2018-12-18 20:00:00	NQ	Futures	7593.42	7616.79	7589.33	7613.87	5191.0
2018-12-18 21:00:00	NQ	Futures	7613.29	7613.29	7597.8	7603.35	3005.0
2018-12-18 22:00:00	NQ	Futures	7603.94	7616.5	7602.77	7615.04	2785.0
2018-12-18 23:00:00	NQ	Futures	7614.75	7622.05	7610.07	7621.76	2542.0
2018-12-18 00:00:00	YM	Futures	25736.7	25746.5	25697.6	25719.3	1880.0
2018-12-18 01:00:00	YM	Futures	25717.1	25777.9	25709.5	25774.7	1151.0
2018-12-18 02:00:00	YM	Futures	25775.8	25809.4	25708.5	25791.0	3146.0
2018-12-18 03:00:00	YM	Futures	25789.9	25808.3	25739.9	25798.6	3354.0

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

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