PREVIEW / futures_1hour / 2017-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-29.parquet
  size:    54 KB
  rows:    1,655

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
2017-11-29 00:00:00	ES	Futures	2871.54	2872.91	2871.27	2872.64	3952.0
2017-11-29 01:00:00	ES	Futures	2872.91	2873.46	2871.82	2873.19	3734.0
2017-11-29 02:00:00	ES	Futures	2873.19	2874.28	2872.64	2873.46	9323.0
2017-11-29 03:00:00	ES	Futures	2873.73	2874.83	2872.37	2872.91	25933.0
2017-11-29 04:00:00	ES	Futures	2873.19	2874.83	2872.37	2874.01	18917.0
2017-11-29 05:00:00	ES	Futures	2874.01	2875.65	2873.19	2875.65	16087.0
2017-11-29 06:00:00	ES	Futures	2875.37	2877.56	2874.83	2876.74	19766.0
2017-11-29 07:00:00	ES	Futures	2876.74	2877.29	2875.65	2875.92	18256.0
2017-11-29 08:00:00	ES	Futures	2875.92	2876.74	2874.01	2876.2	30063.0
2017-11-29 09:00:00	ES	Futures	2876.2	2882.49	2875.1	2881.39	176230.0
2017-11-29 10:00:00	ES	Futures	2881.39	2881.39	2872.37	2874.01	353440.0
2017-11-29 11:00:00	ES	Futures	2873.73	2875.1	2867.71	2867.99	257104.0
2017-11-29 12:00:00	ES	Futures	2867.99	2874.01	2866.62	2872.64	174829.0
2017-11-29 13:00:00	ES	Futures	2872.64	2873.73	2869.08	2869.9	98238.0
2017-11-29 14:00:00	ES	Futures	2870.18	2873.46	2869.9	2871.0	130494.0
2017-11-29 15:00:00	ES	Futures	2871.27	2874.55	2868.54	2872.91	184355.0
2017-11-29 16:00:00	ES	Futures	2872.64	2873.19	2871.54	2872.91	60653.0
2017-11-29 18:00:00	ES	Futures	2872.37	2874.01	2871.27	2871.27	6588.0
2017-11-29 19:00:00	ES	Futures	2871.54	2872.37	2870.18	2870.72	11660.0
2017-11-29 20:00:00	ES	Futures	2870.72	2872.91	2868.81	2870.72	11925.0
2017-11-29 21:00:00	ES	Futures	2871.0	2871.54	2869.9	2871.27	3739.0
2017-11-29 22:00:00	ES	Futures	2871.27	2871.54	2869.36	2870.72	4568.0
2017-11-29 23:00:00	ES	Futures	2870.45	2872.64	2870.45	2872.37	4715.0
2017-11-29 00:00:00	NQ	Futures	7635.27	7640.63	7635.27	7640.33	687.0
2017-11-29 01:00:00	NQ	Futures	7640.33	7644.49	7637.36	7642.71	1181.0
2017-11-29 02:00:00	NQ	Futures	7642.41	7644.79	7640.03	7640.03	1519.0
2017-11-29 03:00:00	NQ	Futures	7640.33	7643.31	7629.03	7629.62	4009.0
2017-11-29 04:00:00	NQ	Futures	7630.22	7639.14	7626.95	7636.17	2864.0
2017-11-29 05:00:00	NQ	Futures	7636.46	7640.93	7632.9	7640.63	1364.0
2017-11-29 06:00:00	NQ	Futures	7640.33	7647.77	7638.55	7643.6	2530.0
2017-11-29 07:00:00	NQ	Futures	7643.6	7645.98	7640.33	7641.52	2291.0
2017-11-29 08:00:00	NQ	Futures	7641.82	7644.2	7629.92	7637.36	7405.0
2017-11-29 09:00:00	NQ	Futures	7637.06	7640.03	7591.55	7592.74	77560.0
2017-11-29 10:00:00	NQ	Futures	7592.45	7598.99	7515.12	7520.17	164606.0
2017-11-29 11:00:00	NQ	Futures	7520.17	7534.75	7483.59	7485.08	112789.0
2017-11-29 12:00:00	NQ	Futures	7485.08	7527.02	7474.67	7513.04	80851.0
2017-11-29 13:00:00	NQ	Futures	7513.33	7537.42	7504.71	7512.14	45041.0
2017-11-29 14:00:00	NQ	Futures	7511.85	7520.17	7494.89	7504.11	43101.0
2017-11-29 15:00:00	NQ	Futures	7504.41	7520.47	7487.46	7512.14	53661.0
2017-11-29 16:00:00	NQ	Futures	7512.14	7512.44	7497.87	7500.25	10289.0
2017-11-29 18:00:00	NQ	Futures	7502.63	7508.28	7502.63	7503.52	2043.0
2017-11-29 19:00:00	NQ	Futures	7503.82	7506.49	7501.44	7504.11	2105.0
2017-11-29 20:00:00	NQ	Futures	7504.41	7508.28	7495.49	7507.09	2920.0
2017-11-29 21:00:00	NQ	Futures	7507.09	7507.98	7502.63	7503.52	1484.0
2017-11-29 22:00:00	NQ	Futures	7503.22	7503.52	7481.81	7487.76	3782.0
2017-11-29 23:00:00	NQ	Futures	7487.46	7494.89	7486.57	7494.3	1802.0
2017-11-29 00:00:00	YM	Futures	25894.5	25910.8	25893.4	25909.7	953.0
2017-11-29 01:00:00	YM	Futures	25909.7	25922.8	25902.1	25920.6	2010.0
2017-11-29 02:00:00	YM	Futures	25920.6	25940.2	25917.3	25936.9	2621.0
2017-11-29 03:00:00	YM	Futures	25936.9	25947.8	25930.4	25934.7	3363.0

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

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