PREVIEW / futures_1hour / 2018-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-17.parquet
  size:    56 KB
  rows:    1,703

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
2018-01-17 00:00:00	ES	Futures	3042.96	3044.33	3042.41	3044.05	5075.0
2018-01-17 01:00:00	ES	Futures	3044.33	3044.6	3041.32	3041.87	4858.0
2018-01-17 02:00:00	ES	Futures	3042.14	3044.6	3041.87	3043.51	9641.0
2018-01-17 03:00:00	ES	Futures	3043.51	3049.52	3043.51	3048.97	26166.0
2018-01-17 04:00:00	ES	Futures	3048.97	3049.25	3047.61	3048.43	10970.0
2018-01-17 05:00:00	ES	Futures	3048.7	3050.07	3047.06	3049.52	13083.0
2018-01-17 06:00:00	ES	Futures	3049.79	3053.62	3049.52	3053.07	27677.0
2018-01-17 07:00:00	ES	Futures	3053.07	3053.62	3051.71	3052.53	19008.0
2018-01-17 08:00:00	ES	Futures	3052.8	3054.17	3051.16	3053.62	34029.0
2018-01-17 09:00:00	ES	Futures	3053.62	3054.99	3039.95	3041.32	272440.0
2018-01-17 10:00:00	ES	Futures	3041.05	3048.7	3041.05	3048.15	185944.0
2018-01-17 11:00:00	ES	Futures	3047.88	3054.17	3046.51	3053.35	128325.0
2018-01-17 12:00:00	ES	Futures	3053.35	3060.45	3053.07	3060.18	106179.0
2018-01-17 13:00:00	ES	Futures	3059.91	3063.46	3059.09	3061.55	94594.0
2018-01-17 14:00:00	ES	Futures	3061.82	3069.47	3061.55	3068.93	105932.0
2018-01-17 15:00:00	ES	Futures	3068.93	3071.66	3063.46	3066.19	251394.0
2018-01-17 16:00:00	ES	Futures	3066.19	3067.29	3063.46	3065.1	83325.0
2018-01-17 18:00:00	ES	Futures	3064.83	3068.93	3064.28	3068.11	10183.0
2018-01-17 19:00:00	ES	Futures	3067.83	3068.65	3067.01	3067.83	9565.0
2018-01-17 20:00:00	ES	Futures	3068.11	3069.75	3065.92	3066.47	7749.0
2018-01-17 21:00:00	ES	Futures	3066.74	3068.65	3066.19	3067.83	3374.0
2018-01-17 22:00:00	ES	Futures	3067.83	3069.75	3067.83	3069.47	5361.0
2018-01-17 23:00:00	ES	Futures	3069.2	3070.02	3067.83	3068.38	3604.0
2018-01-17 00:00:00	NQ	Futures	8021.39	8028.51	8018.72	8026.73	1612.0
2018-01-17 01:00:00	NQ	Futures	8027.32	8028.51	8017.83	8023.47	1704.0
2018-01-17 02:00:00	NQ	Futures	8023.17	8032.37	8023.17	8027.03	1738.0
2018-01-17 03:00:00	NQ	Futures	8027.32	8045.12	8027.03	8040.08	4883.0
2018-01-17 04:00:00	NQ	Futures	8039.78	8043.64	8036.81	8042.15	2234.0
2018-01-17 05:00:00	NQ	Futures	8042.15	8048.38	8037.7	8046.31	2721.0
2018-01-17 06:00:00	NQ	Futures	8046.31	8057.28	8046.31	8051.64	4615.0
2018-01-17 07:00:00	NQ	Futures	8051.64	8055.5	8045.42	8046.31	4203.0
2018-01-17 08:00:00	NQ	Futures	8046.31	8061.14	8044.23	8059.06	7040.0
2018-01-17 09:00:00	NQ	Futures	8059.06	8062.03	8009.82	8020.5	73876.0
2018-01-17 10:00:00	NQ	Futures	8020.21	8041.56	8016.05	8038.89	62443.0
2018-01-17 11:00:00	NQ	Futures	8038.89	8060.84	8031.77	8046.01	34044.0
2018-01-17 12:00:00	NQ	Futures	8046.31	8070.63	8045.12	8069.44	25874.0
2018-01-17 13:00:00	NQ	Futures	8069.74	8085.16	8066.47	8072.7	29685.0
2018-01-17 14:00:00	NQ	Futures	8072.7	8098.8	8072.41	8095.54	26983.0
2018-01-17 15:00:00	NQ	Futures	8095.54	8108.0	8088.13	8094.95	41855.0
2018-01-17 16:00:00	NQ	Futures	8094.95	8101.18	8090.5	8090.5	8718.0
2018-01-17 18:00:00	NQ	Futures	8088.72	8106.22	8088.72	8103.84	2159.0
2018-01-17 19:00:00	NQ	Futures	8104.14	8106.81	8094.35	8104.14	3124.0
2018-01-17 20:00:00	NQ	Futures	8104.44	8110.67	8091.09	8093.17	2969.0
2018-01-17 21:00:00	NQ	Futures	8092.87	8100.88	8091.68	8097.91	1511.0
2018-01-17 22:00:00	NQ	Futures	8097.62	8102.07	8093.76	8101.47	1366.0
2018-01-17 23:00:00	NQ	Futures	8101.47	8102.96	8093.46	8094.65	955.0
2018-01-17 00:00:00	YM	Futures	28125.2	28143.7	28121.9	28140.4	1414.0
2018-01-17 01:00:00	YM	Futures	28140.4	28143.7	28098.0	28115.4	2655.0
2018-01-17 02:00:00	YM	Futures	28115.4	28137.2	28114.3	28126.3	1554.0
2018-01-17 03:00:00	YM	Futures	28127.4	28194.8	28126.3	28190.4	5179.0

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

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