PREVIEW / futures_1hour / 2017-12-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2893.7	2893.7	2891.51	2891.79	2796.0
2017-12-05 01:00:00	ES	Futures	2892.06	2893.16	2890.97	2892.34	4712.0
2017-12-05 02:00:00	ES	Futures	2892.61	2893.7	2890.15	2890.15	10515.0
2017-12-05 03:00:00	ES	Futures	2889.87	2892.61	2888.23	2888.51	20561.0
2017-12-05 04:00:00	ES	Futures	2888.78	2890.69	2887.14	2890.15	13761.0
2017-12-05 05:00:00	ES	Futures	2890.15	2890.69	2883.58	2884.95	25386.0
2017-12-05 06:00:00	ES	Futures	2884.95	2889.05	2884.13	2889.05	16530.0
2017-12-05 07:00:00	ES	Futures	2889.05	2893.16	2887.96	2892.34	30289.0
2017-12-05 08:00:00	ES	Futures	2892.61	2893.98	2889.05	2889.33	35609.0
2017-12-05 09:00:00	ES	Futures	2889.6	2892.88	2886.86	2887.68	155207.0
2017-12-05 10:00:00	ES	Futures	2887.96	2895.89	2887.41	2894.8	189522.0
2017-12-05 11:00:00	ES	Futures	2894.8	2898.35	2891.79	2892.61	119881.0
2017-12-05 12:00:00	ES	Futures	2892.61	2892.88	2887.41	2888.51	93959.0
2017-12-05 13:00:00	ES	Futures	2888.51	2891.51	2886.86	2889.6	65186.0
2017-12-05 14:00:00	ES	Futures	2889.6	2890.42	2878.38	2880.3	143265.0
2017-12-05 15:00:00	ES	Futures	2880.02	2882.21	2875.1	2876.74	200772.0
2017-12-05 16:00:00	ES	Futures	2876.74	2878.38	2874.83	2875.1	51763.0
2017-12-05 18:00:00	ES	Futures	2874.28	2877.84	2874.28	2877.56	6208.0
2017-12-05 19:00:00	ES	Futures	2877.29	2879.48	2876.47	2878.66	7467.0
2017-12-05 20:00:00	ES	Futures	2878.93	2879.2	2877.29	2878.38	4766.0
2017-12-05 21:00:00	ES	Futures	2878.11	2878.38	2871.82	2872.64	14128.0
2017-12-05 22:00:00	ES	Futures	2872.91	2875.65	2871.82	2873.19	11600.0
2017-12-05 23:00:00	ES	Futures	2872.91	2873.19	2869.9	2871.27	10275.0
2017-12-05 00:00:00	NQ	Futures	7467.83	7468.13	7456.53	7458.91	1184.0
2017-12-05 01:00:00	NQ	Futures	7458.61	7460.39	7450.28	7459.2	1422.0
2017-12-05 02:00:00	NQ	Futures	7459.2	7469.32	7451.17	7451.47	2829.0
2017-12-05 03:00:00	NQ	Futures	7450.88	7456.23	7442.85	7445.23	4520.0
2017-12-05 04:00:00	NQ	Futures	7444.63	7447.9	7436.6	7443.74	4128.0
2017-12-05 05:00:00	NQ	Futures	7444.04	7445.23	7415.78	7420.24	6507.0
2017-12-05 06:00:00	NQ	Futures	7420.54	7430.95	7413.7	7429.46	5141.0
2017-12-05 07:00:00	NQ	Futures	7429.76	7461.58	7426.49	7455.93	8700.0
2017-12-05 08:00:00	NQ	Futures	7455.93	7464.56	7449.39	7454.74	10419.0
2017-12-05 09:00:00	NQ	Futures	7454.45	7512.14	7422.03	7500.25	85764.0
2017-12-05 10:00:00	NQ	Futures	7499.95	7520.17	7494.0	7518.39	71322.0
2017-12-05 11:00:00	NQ	Futures	7518.39	7542.18	7510.06	7513.93	51502.0
2017-12-05 12:00:00	NQ	Futures	7513.63	7517.8	7489.54	7494.89	43943.0
2017-12-05 13:00:00	NQ	Futures	7494.89	7510.66	7484.19	7501.44	34429.0
2017-12-05 14:00:00	NQ	Futures	7501.73	7502.92	7453.85	7460.99	38311.0
2017-12-05 15:00:00	NQ	Futures	7460.99	7477.35	7450.28	7455.93	51953.0
2017-12-05 16:00:00	NQ	Futures	7455.93	7466.94	7455.93	7458.01	6361.0
2017-12-05 18:00:00	NQ	Futures	7458.01	7466.34	7456.83	7465.45	1466.0
2017-12-05 19:00:00	NQ	Futures	7465.75	7469.91	7463.37	7467.23	1580.0
2017-12-05 20:00:00	NQ	Futures	7467.23	7469.02	7463.37	7466.64	1249.0
2017-12-05 21:00:00	NQ	Futures	7466.34	7466.94	7442.85	7445.52	3447.0
2017-12-05 22:00:00	NQ	Futures	7446.12	7456.23	7439.57	7444.93	3972.0
2017-12-05 23:00:00	NQ	Futures	7444.93	7444.93	7426.49	7430.35	4002.0
2017-12-05 00:00:00	YM	Futures	26521.0	26522.1	26500.3	26502.5	775.0
2017-12-05 01:00:00	YM	Futures	26502.5	26508.0	26487.3	26500.3	1122.0
2017-12-05 02:00:00	YM	Futures	26501.4	26512.3	26479.7	26481.8	1874.0
2017-12-05 03:00:00	YM	Futures	26481.8	26508.0	26481.8	26487.3	2468.0

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

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