PREVIEW / futures_1hour / 2017-11-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	2872.37	2873.73	2871.54	2871.82	5993.0
2017-11-30 01:00:00	ES	Futures	2871.82	2872.64	2871.0	2872.37	2982.0
2017-11-30 02:00:00	ES	Futures	2872.64	2875.65	2872.64	2874.28	11050.0
2017-11-30 03:00:00	ES	Futures	2874.28	2876.2	2873.19	2875.65	21697.0
2017-11-30 04:00:00	ES	Futures	2875.65	2878.11	2875.37	2875.92	22476.0
2017-11-30 05:00:00	ES	Futures	2876.2	2881.12	2875.65	2880.3	21704.0
2017-11-30 06:00:00	ES	Futures	2880.02	2882.21	2880.02	2881.39	16235.0
2017-11-30 07:00:00	ES	Futures	2881.39	2881.39	2878.66	2881.12	22141.0
2017-11-30 08:00:00	ES	Futures	2880.85	2881.94	2880.02	2881.67	22114.0
2017-11-30 09:00:00	ES	Futures	2881.39	2888.51	2881.12	2885.77	249162.0
2017-11-30 10:00:00	ES	Futures	2885.77	2890.97	2883.85	2890.69	230524.0
2017-11-30 11:00:00	ES	Futures	2890.69	2895.89	2889.87	2892.61	235478.0
2017-11-30 12:00:00	ES	Futures	2892.61	2909.02	2892.61	2903.55	312105.0
2017-11-30 13:00:00	ES	Futures	2903.82	2907.38	2895.34	2898.35	198913.0
2017-11-30 14:00:00	ES	Futures	2898.35	2900.54	2895.34	2896.16	121410.0
2017-11-30 15:00:00	ES	Futures	2896.16	2901.36	2890.42	2896.16	490879.0
2017-11-30 16:00:00	ES	Futures	2896.16	2896.44	2888.78	2891.51	230725.0
2017-11-30 18:00:00	ES	Futures	2889.6	2892.06	2887.68	2890.69	16528.0
2017-11-30 19:00:00	ES	Futures	2890.97	2892.06	2886.86	2888.23	18074.0
2017-11-30 20:00:00	ES	Futures	2888.23	2889.33	2885.77	2886.86	11679.0
2017-11-30 21:00:00	ES	Futures	2887.14	2889.87	2885.77	2888.78	10704.0
2017-11-30 22:00:00	ES	Futures	2888.78	2890.97	2888.78	2889.33	6143.0
2017-11-30 23:00:00	ES	Futures	2889.33	2891.79	2888.78	2890.42	4884.0
2017-11-30 00:00:00	NQ	Futures	7494.0	7500.55	7490.14	7496.68	2437.0
2017-11-30 01:00:00	NQ	Futures	7496.38	7498.46	7489.54	7498.17	1071.0
2017-11-30 02:00:00	NQ	Futures	7498.46	7507.09	7498.17	7502.92	2779.0
2017-11-30 03:00:00	NQ	Futures	7503.22	7507.98	7497.27	7503.52	3754.0
2017-11-30 04:00:00	NQ	Futures	7503.52	7516.9	7503.52	7509.47	4172.0
2017-11-30 05:00:00	NQ	Futures	7510.06	7523.74	7509.77	7521.07	3072.0
2017-11-30 06:00:00	NQ	Futures	7520.77	7528.21	7520.17	7525.23	3782.0
2017-11-30 07:00:00	NQ	Futures	7524.93	7528.8	7518.09	7527.61	6072.0
2017-11-30 08:00:00	NQ	Futures	7527.61	7530.58	7522.55	7529.1	5839.0
2017-11-30 09:00:00	NQ	Futures	7529.1	7556.76	7523.74	7535.94	83601.0
2017-11-30 10:00:00	NQ	Futures	7535.94	7565.08	7531.48	7554.68	81394.0
2017-11-30 11:00:00	NQ	Futures	7554.97	7578.77	7552.0	7563.3	59409.0
2017-11-30 12:00:00	NQ	Futures	7563.6	7587.09	7559.43	7571.33	54062.0
2017-11-30 13:00:00	NQ	Futures	7571.33	7581.44	7563.3	7576.09	36781.0
2017-11-30 14:00:00	NQ	Futures	7576.09	7579.36	7563.0	7565.98	22477.0
2017-11-30 15:00:00	NQ	Futures	7566.27	7582.63	7549.62	7573.71	53489.0
2017-11-30 16:00:00	NQ	Futures	7573.71	7574.9	7555.86	7561.22	15387.0
2017-11-30 18:00:00	NQ	Futures	7558.84	7568.06	7553.78	7563.89	2383.0
2017-11-30 19:00:00	NQ	Futures	7564.49	7565.98	7549.62	7553.78	4813.0
2017-11-30 20:00:00	NQ	Futures	7554.08	7556.46	7542.78	7544.86	4822.0
2017-11-30 21:00:00	NQ	Futures	7544.56	7554.97	7539.8	7552.89	3284.0
2017-11-30 22:00:00	NQ	Futures	7553.19	7560.33	7552.3	7555.86	1475.0
2017-11-30 23:00:00	NQ	Futures	7555.57	7567.76	7554.68	7562.41	2032.0
2017-11-30 00:00:00	YM	Futures	26042.4	26055.5	26033.7	26037.0	1586.0
2017-11-30 01:00:00	YM	Futures	26037.0	26051.1	26033.7	26049.0	908.0
2017-11-30 02:00:00	YM	Futures	26049.0	26079.4	26047.9	26070.7	2218.0
2017-11-30 03:00:00	YM	Futures	26068.5	26088.1	26058.7	26079.4	2794.0

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

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