PREVIEW / futures_1hour / 2019-01-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	2757.94	2759.57	2754.14	2754.95	6696.0
2019-01-07 01:00:00	ES	Futures	2754.95	2757.67	2751.15	2757.13	6967.0
2019-01-07 02:00:00	ES	Futures	2757.13	2761.2	2755.23	2759.3	11904.0
2019-01-07 03:00:00	ES	Futures	2759.3	2759.57	2750.07	2750.34	25103.0
2019-01-07 04:00:00	ES	Futures	2750.61	2753.87	2744.36	2745.18	23466.0
2019-01-07 05:00:00	ES	Futures	2745.45	2750.34	2743.55	2747.89	14872.0
2019-01-07 06:00:00	ES	Futures	2747.89	2748.98	2741.1	2746.53	15944.0
2019-01-07 07:00:00	ES	Futures	2746.26	2752.24	2744.91	2751.15	20307.0
2019-01-07 08:00:00	ES	Futures	2750.88	2753.32	2745.72	2747.08	28154.0
2019-01-07 09:00:00	ES	Futures	2747.08	2756.04	2742.46	2751.69	189039.0
2019-01-07 10:00:00	ES	Futures	2751.42	2769.89	2746.81	2766.9	282949.0
2019-01-07 11:00:00	ES	Futures	2766.9	2783.2	2765.0	2782.93	196336.0
2019-01-07 12:00:00	ES	Futures	2782.93	2786.19	2776.14	2783.74	128570.0
2019-01-07 13:00:00	ES	Futures	2784.01	2789.17	2775.87	2776.95	128765.0
2019-01-07 14:00:00	ES	Futures	2776.95	2780.48	2767.18	2768.8	113069.0
2019-01-07 15:00:00	ES	Futures	2768.8	2780.48	2768.26	2770.71	224553.0
2019-01-07 16:00:00	ES	Futures	2770.71	2774.78	2768.53	2774.24	63592.0
2019-01-07 18:00:00	ES	Futures	2773.69	2775.32	2769.35	2770.98	7457.0
2019-01-07 19:00:00	ES	Futures	2771.25	2779.12	2771.25	2778.58	9598.0
2019-01-07 20:00:00	ES	Futures	2778.58	2780.21	2773.96	2777.22	13178.0
2019-01-07 21:00:00	ES	Futures	2777.5	2783.2	2776.68	2780.75	8657.0
2019-01-07 22:00:00	ES	Futures	2780.75	2783.2	2780.21	2780.21	5442.0
2019-01-07 23:00:00	ES	Futures	2780.21	2784.56	2778.58	2784.28	5314.0
2019-01-07 00:00:00	NQ	Futures	7544.04	7555.14	7539.07	7541.7	3584.0
2019-01-07 01:00:00	NQ	Futures	7541.41	7544.91	7520.95	7541.41	3966.0
2019-01-07 02:00:00	NQ	Futures	7541.7	7558.65	7534.1	7550.76	5461.0
2019-01-07 03:00:00	NQ	Futures	7551.34	7551.34	7509.56	7511.6	10498.0
2019-01-07 04:00:00	NQ	Futures	7511.6	7525.63	7496.41	7503.71	8438.0
2019-01-07 05:00:00	NQ	Futures	7504.3	7518.03	7497.58	7509.85	6744.0
2019-01-07 06:00:00	NQ	Futures	7509.56	7512.19	7482.97	7498.16	7850.0
2019-01-07 07:00:00	NQ	Futures	7497.87	7522.12	7492.03	7517.74	8938.0
2019-01-07 08:00:00	NQ	Futures	7518.03	7523.58	7497.58	7503.13	11953.0
2019-01-07 09:00:00	NQ	Futures	7503.42	7552.51	7502.55	7531.18	65972.0
2019-01-07 10:00:00	NQ	Futures	7530.89	7578.51	7510.43	7570.33	80796.0
2019-01-07 11:00:00	NQ	Futures	7570.04	7620.88	7553.39	7619.13	71144.0
2019-01-07 12:00:00	NQ	Futures	7619.13	7631.4	7601.6	7624.68	41030.0
2019-01-07 13:00:00	NQ	Futures	7625.27	7638.71	7601.89	7607.73	40084.0
2019-01-07 14:00:00	NQ	Futures	7607.15	7618.54	7575.89	7580.56	44923.0
2019-01-07 15:00:00	NQ	Futures	7580.56	7620.59	7579.1	7597.51	48798.0
2019-01-07 16:00:00	NQ	Futures	7597.51	7606.27	7589.62	7602.77	9213.0
2019-01-07 18:00:00	NQ	Futures	7603.94	7605.98	7586.4	7592.25	3542.0
2019-01-07 19:00:00	NQ	Futures	7592.54	7615.62	7592.25	7613.87	4319.0
2019-01-07 20:00:00	NQ	Futures	7613.87	7617.96	7598.38	7609.49	6284.0
2019-01-07 21:00:00	NQ	Futures	7609.78	7630.82	7606.27	7622.93	4528.0
2019-01-07 22:00:00	NQ	Futures	7623.51	7628.48	7618.25	7619.42	2599.0
2019-01-07 23:00:00	NQ	Futures	7619.13	7632.57	7614.45	7630.52	2232.0
2019-01-07 00:00:00	YM	Futures	25506.5	25523.9	25463.1	25468.5	2595.0
2019-01-07 01:00:00	YM	Futures	25468.5	25503.3	25431.6	25492.4	2784.0
2019-01-07 02:00:00	YM	Futures	25493.5	25532.6	25472.9	25509.8	4256.0
2019-01-07 03:00:00	YM	Futures	25510.9	25513.0	25427.3	25431.6	6235.0

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

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