PREVIEW / futures_1hour / 2017-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-11.parquet
  size:    48 KB
  rows:    1,552

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-12-11 00:00:00	ES	Futures	2904.37	2904.37	2902.73	2904.1	2038.0
2017-12-11 01:00:00	ES	Futures	2904.37	2904.65	2902.46	2903.28	1714.0
2017-12-11 02:00:00	ES	Futures	2903.28	2905.74	2903.28	2904.37	4255.0
2017-12-11 03:00:00	ES	Futures	2904.37	2906.01	2903.0	2903.28	6763.0
2017-12-11 04:00:00	ES	Futures	2903.55	2904.65	2901.64	2902.18	3854.0
2017-12-11 05:00:00	ES	Futures	2902.18	2904.65	2902.18	2903.28	4199.0
2017-12-11 06:00:00	ES	Futures	2903.55	2904.65	2902.46	2902.46	3680.0
2017-12-11 07:00:00	ES	Futures	2902.46	2904.65	2900.54	2900.82	8213.0
2017-12-11 08:00:00	ES	Futures	2900.54	2903.55	2898.9	2903.0	14880.0
2017-12-11 09:00:00	ES	Futures	2903.0	2906.83	2901.64	2906.83	42579.0
2017-12-11 10:00:00	ES	Futures	2906.83	2908.2	2903.55	2903.82	46357.0
2017-12-11 11:00:00	ES	Futures	2903.82	2907.11	2902.73	2905.74	24154.0
2017-12-11 12:00:00	ES	Futures	2905.47	2909.02	2905.47	2908.75	16750.0
2017-12-11 13:00:00	ES	Futures	2909.02	2910.39	2907.38	2908.75	17098.0
2017-12-11 14:00:00	ES	Futures	2908.75	2909.57	2907.65	2908.75	15248.0
2017-12-11 15:00:00	ES	Futures	2908.48	2911.76	2906.29	2911.21	53912.0
2017-12-11 16:00:00	ES	Futures	2910.94	2915.86	2910.39	2914.49	29227.0
2017-12-11 18:00:00	ES	Futures	2913.67	2914.49	2911.76	2913.4	2794.0
2017-12-11 19:00:00	ES	Futures	2913.13	2915.31	2912.85	2913.13	2351.0
2017-12-11 20:00:00	ES	Futures	2912.85	2914.77	2912.58	2914.22	2948.0
2017-12-11 21:00:00	ES	Futures	2913.95	2916.13	2913.95	2914.49	2110.0
2017-12-11 22:00:00	ES	Futures	2914.49	2915.04	2913.95	2914.22	1142.0
2017-12-11 23:00:00	ES	Futures	2914.22	2914.77	2913.4	2913.67	934.0
2017-12-11 00:00:00	NQ	Futures	7562.11	7562.11	7557.35	7561.22	434.0
2017-12-11 01:00:00	NQ	Futures	7561.52	7562.41	7558.24	7559.14	182.0
2017-12-11 02:00:00	NQ	Futures	7560.33	7566.27	7558.54	7558.54	602.0
2017-12-11 03:00:00	NQ	Futures	7558.84	7563.6	7555.57	7555.57	867.0
2017-12-11 04:00:00	NQ	Futures	7556.16	7558.54	7549.02	7550.51	942.0
2017-12-11 05:00:00	NQ	Futures	7550.51	7557.05	7550.21	7552.3	391.0
2017-12-11 06:00:00	NQ	Futures	7552.0	7557.65	7548.73	7548.73	461.0
2017-12-11 07:00:00	NQ	Futures	7549.02	7562.41	7548.73	7555.57	1490.0
2017-12-11 08:00:00	NQ	Futures	7553.49	7557.35	7542.18	7550.51	1748.0
2017-12-11 09:00:00	NQ	Futures	7550.21	7575.79	7548.73	7569.55	14473.0
2017-12-11 10:00:00	NQ	Futures	7569.84	7578.17	7563.6	7570.44	11880.0
2017-12-11 11:00:00	NQ	Futures	7570.74	7587.99	7563.3	7585.01	8675.0
2017-12-11 12:00:00	NQ	Futures	7585.31	7607.91	7584.71	7606.72	7373.0
2017-12-11 13:00:00	NQ	Futures	7607.02	7609.7	7596.61	7602.56	5840.0
2017-12-11 14:00:00	NQ	Futures	7602.26	7605.83	7596.02	7600.18	4380.0
2017-12-11 15:00:00	NQ	Futures	7600.48	7607.62	7593.93	7607.02	8230.0
2017-12-11 16:00:00	NQ	Futures	7607.02	7625.46	7605.53	7621.0	3808.0
2017-12-11 18:00:00	NQ	Futures	7618.92	7620.4	7611.78	7616.54	539.0
2017-12-11 19:00:00	NQ	Futures	7616.84	7622.49	7615.05	7618.32	521.0
2017-12-11 20:00:00	NQ	Futures	7617.43	7619.81	7614.16	7617.43	378.0
2017-12-11 21:00:00	NQ	Futures	7617.43	7623.08	7617.13	7618.92	312.0
2017-12-11 22:00:00	NQ	Futures	7618.92	7621.59	7615.35	7617.73	247.0
2017-12-11 23:00:00	NQ	Futures	7617.43	7619.51	7616.54	7617.13	138.0
2017-12-11 00:00:00	YM	Futures	26491.6	26494.9	26466.6	26493.8	1150.0
2017-12-11 01:00:00	YM	Futures	26494.9	26498.1	26473.1	26479.7	573.0
2017-12-11 02:00:00	YM	Futures	26482.9	26509.0	26482.9	26499.2	1245.0
2017-12-11 03:00:00	YM	Futures	26498.1	26510.1	26490.5	26492.7	1345.0

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

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