PREVIEW / futures_1hour / 2017-11-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	2835.16	2835.16	2828.05	2831.61	33954.0
2017-11-09 01:00:00	ES	Futures	2831.61	2832.97	2831.33	2832.43	4345.0
2017-11-09 02:00:00	ES	Futures	2832.7	2834.61	2831.61	2832.15	12520.0
2017-11-09 03:00:00	ES	Futures	2832.43	2834.07	2829.42	2831.06	36176.0
2017-11-09 04:00:00	ES	Futures	2831.06	2832.7	2830.51	2831.61	21586.0
2017-11-09 05:00:00	ES	Futures	2831.88	2831.88	2828.87	2830.24	21758.0
2017-11-09 06:00:00	ES	Futures	2830.24	2830.78	2825.04	2826.95	43146.0
2017-11-09 07:00:00	ES	Futures	2826.68	2826.95	2821.21	2822.03	67717.0
2017-11-09 08:00:00	ES	Futures	2822.03	2823.4	2818.2	2821.48	74131.0
2017-11-09 09:00:00	ES	Futures	2821.48	2823.67	2816.83	2820.12	246055.0
2017-11-09 10:00:00	ES	Futures	2820.39	2827.23	2820.12	2826.95	282547.0
2017-11-09 11:00:00	ES	Futures	2826.68	2827.23	2812.46	2816.01	267242.0
2017-11-09 12:00:00	ES	Futures	2815.74	2816.01	2804.8	2812.18	360371.0
2017-11-09 13:00:00	ES	Futures	2812.18	2819.02	2809.17	2817.65	183972.0
2017-11-09 14:00:00	ES	Futures	2817.65	2821.76	2817.65	2819.02	145675.0
2017-11-09 15:00:00	ES	Futures	2819.02	2827.23	2818.2	2825.31	250568.0
2017-11-09 16:00:00	ES	Futures	2825.31	2827.78	2825.04	2826.68	90940.0
2017-11-09 18:00:00	ES	Futures	2825.31	2826.41	2823.4	2825.04	10012.0
2017-11-09 19:00:00	ES	Futures	2825.04	2827.23	2824.22	2825.59	10093.0
2017-11-09 20:00:00	ES	Futures	2825.31	2828.05	2825.04	2826.41	9436.0
2017-11-09 21:00:00	ES	Futures	2826.41	2827.23	2824.49	2826.68	5277.0
2017-11-09 22:00:00	ES	Futures	2826.95	2828.05	2826.68	2826.95	3649.0
2017-11-09 23:00:00	ES	Futures	2826.95	2828.6	2826.68	2828.32	3798.0
2017-11-09 00:00:00	NQ	Futures	7542.18	7542.48	7524.93	7535.64	7795.0
2017-11-09 01:00:00	NQ	Futures	7535.64	7538.32	7532.96	7538.32	1247.0
2017-11-09 02:00:00	NQ	Futures	7538.32	7543.08	7533.86	7534.75	2370.0
2017-11-09 03:00:00	NQ	Futures	7535.05	7541.59	7528.5	7534.15	2863.0
2017-11-09 04:00:00	NQ	Futures	7535.05	7539.21	7533.26	7537.72	2045.0
2017-11-09 05:00:00	NQ	Futures	7537.72	7538.02	7527.31	7530.58	2364.0
2017-11-09 06:00:00	NQ	Futures	7530.58	7531.48	7512.74	7521.07	6162.0
2017-11-09 07:00:00	NQ	Futures	7521.07	7521.36	7496.68	7497.87	11431.0
2017-11-09 08:00:00	NQ	Futures	7498.17	7501.73	7478.54	7486.27	21568.0
2017-11-09 09:00:00	NQ	Futures	7486.57	7496.68	7461.88	7478.54	75342.0
2017-11-09 10:00:00	NQ	Futures	7478.83	7510.66	7477.64	7509.17	84216.0
2017-11-09 11:00:00	NQ	Futures	7509.17	7509.47	7458.01	7466.64	64859.0
2017-11-09 12:00:00	NQ	Futures	7466.94	7469.91	7429.17	7451.17	94259.0
2017-11-09 13:00:00	NQ	Futures	7451.17	7475.26	7436.6	7472.29	50137.0
2017-11-09 14:00:00	NQ	Futures	7472.29	7489.54	7471.99	7484.19	45851.0
2017-11-09 15:00:00	NQ	Futures	7484.48	7510.36	7480.02	7506.2	55712.0
2017-11-09 16:00:00	NQ	Futures	7505.9	7514.23	7505.9	7510.36	10450.0
2017-11-09 18:00:00	NQ	Futures	7510.06	7511.25	7502.03	7506.49	2249.0
2017-11-09 19:00:00	NQ	Futures	7506.2	7512.44	7504.11	7508.87	2020.0
2017-11-09 20:00:00	NQ	Futures	7508.87	7516.61	7507.98	7511.55	2087.0
2017-11-09 21:00:00	NQ	Futures	7511.85	7513.63	7505.3	7512.44	1509.0
2017-11-09 22:00:00	NQ	Futures	7512.74	7517.2	7511.85	7511.85	1002.0
2017-11-09 23:00:00	NQ	Futures	7511.85	7517.5	7511.25	7516.61	913.0
2017-11-09 00:00:00	YM	Futures	25562.8	25563.8	25477.9	25533.4	12499.0
2017-11-09 01:00:00	YM	Futures	25533.4	25549.7	25529.0	25539.9	2245.0
2017-11-09 02:00:00	YM	Futures	25541.0	25556.2	25533.4	25541.0	2683.0
2017-11-09 03:00:00	YM	Futures	25542.1	25550.8	25509.5	25524.7	3461.0

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

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