PREVIEW / futures_1hour / 2017-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-04.parquet
  size:    53 KB
  rows:    1,639

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-04 00:00:00	ES	Futures	2911.48	2911.76	2908.48	2909.84	5163.0
2017-12-04 01:00:00	ES	Futures	2909.84	2910.39	2908.48	2909.84	5600.0
2017-12-04 02:00:00	ES	Futures	2909.57	2912.3	2908.75	2909.57	18515.0
2017-12-04 03:00:00	ES	Futures	2909.57	2910.12	2907.11	2908.75	37000.0
2017-12-04 04:00:00	ES	Futures	2908.48	2909.57	2906.56	2906.83	16568.0
2017-12-04 05:00:00	ES	Futures	2907.11	2910.66	2906.56	2910.12	15535.0
2017-12-04 06:00:00	ES	Futures	2909.84	2911.48	2909.3	2910.94	15060.0
2017-12-04 07:00:00	ES	Futures	2910.66	2911.76	2909.3	2909.84	18456.0
2017-12-04 08:00:00	ES	Futures	2909.84	2910.12	2906.83	2908.48	40234.0
2017-12-04 09:00:00	ES	Futures	2908.48	2916.41	2907.93	2911.76	228228.0
2017-12-04 10:00:00	ES	Futures	2912.03	2913.13	2900.54	2903.82	316433.0
2017-12-04 11:00:00	ES	Futures	2903.55	2907.65	2900.82	2905.74	181610.0
2017-12-04 12:00:00	ES	Futures	2905.74	2908.2	2901.91	2905.74	100809.0
2017-12-04 13:00:00	ES	Futures	2905.74	2907.93	2904.92	2907.11	83232.0
2017-12-04 14:00:00	ES	Futures	2906.83	2907.11	2895.07	2897.26	181859.0
2017-12-04 15:00:00	ES	Futures	2897.26	2897.53	2886.86	2887.14	248501.0
2017-12-04 16:00:00	ES	Futures	2886.86	2888.23	2881.94	2885.22	91231.0
2017-12-04 18:00:00	ES	Futures	2884.4	2887.41	2884.13	2886.59	10452.0
2017-12-04 19:00:00	ES	Futures	2886.59	2888.78	2885.22	2887.14	11360.0
2017-12-04 20:00:00	ES	Futures	2887.14	2890.42	2886.86	2889.6	7557.0
2017-12-04 21:00:00	ES	Futures	2889.6	2891.24	2889.33	2890.15	4659.0
2017-12-04 22:00:00	ES	Futures	2890.15	2892.61	2889.87	2891.51	6535.0
2017-12-04 23:00:00	ES	Futures	2891.51	2893.7	2891.24	2893.43	5145.0
2017-12-04 00:00:00	NQ	Futures	7590.37	7590.96	7581.44	7585.9	1562.0
2017-12-04 01:00:00	NQ	Futures	7586.5	7588.88	7582.33	7585.9	1124.0
2017-12-04 02:00:00	NQ	Futures	7585.9	7587.69	7580.85	7583.23	2226.0
2017-12-04 03:00:00	NQ	Futures	7583.23	7585.31	7570.74	7578.17	4949.0
2017-12-04 04:00:00	NQ	Futures	7576.98	7579.06	7570.74	7571.03	2245.0
2017-12-04 05:00:00	NQ	Futures	7571.63	7584.71	7570.14	7582.93	2006.0
2017-12-04 06:00:00	NQ	Futures	7582.93	7588.88	7581.44	7585.31	2331.0
2017-12-04 07:00:00	NQ	Futures	7585.01	7590.37	7580.25	7580.85	5014.0
2017-12-04 08:00:00	NQ	Futures	7580.85	7587.69	7576.09	7585.9	7127.0
2017-12-04 09:00:00	NQ	Futures	7585.9	7596.02	7554.97	7558.54	57853.0
2017-12-04 10:00:00	NQ	Futures	7558.24	7558.54	7466.34	7479.13	123549.0
2017-12-04 11:00:00	NQ	Futures	7478.83	7505.9	7465.45	7495.19	76454.0
2017-12-04 12:00:00	NQ	Futures	7495.49	7518.39	7488.35	7516.31	43431.0
2017-12-04 13:00:00	NQ	Futures	7516.31	7529.39	7514.82	7526.42	35270.0
2017-12-04 14:00:00	NQ	Futures	7526.42	7527.02	7477.35	7480.62	50050.0
2017-12-04 15:00:00	NQ	Futures	7480.62	7484.48	7444.63	7453.55	71422.0
2017-12-04 16:00:00	NQ	Futures	7453.26	7457.42	7436.3	7449.09	13334.0
2017-12-04 18:00:00	NQ	Futures	7441.95	7458.31	7441.95	7456.53	2654.0
2017-12-04 19:00:00	NQ	Futures	7455.93	7461.29	7449.09	7454.45	2405.0
2017-12-04 20:00:00	NQ	Futures	7454.45	7463.67	7453.26	7458.91	2155.0
2017-12-04 21:00:00	NQ	Futures	7458.91	7461.58	7456.23	7458.91	1363.0
2017-12-04 22:00:00	NQ	Futures	7458.91	7467.83	7457.12	7463.96	1252.0
2017-12-04 23:00:00	NQ	Futures	7464.56	7470.21	7462.48	7468.42	876.0
2017-12-04 00:00:00	YM	Futures	26615.6	26621.1	26580.8	26589.5	1358.0
2017-12-04 01:00:00	YM	Futures	26590.6	26604.8	26579.7	26596.1	2043.0
2017-12-04 02:00:00	YM	Futures	26595.0	26615.6	26574.3	26600.4	3230.0
2017-12-04 03:00:00	YM	Futures	26598.2	26599.3	26575.4	26585.2	3156.0

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

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