PREVIEW / futures_1hour / 2018-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-18.parquet
  size:    54 KB
  rows:    1,664

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-07-18 00:00:00	ES	Futures	3066.34	3066.34	3064.43	3066.06	2853.0
2018-07-18 01:00:00	ES	Futures	3066.34	3066.61	3064.43	3064.43	3459.0
2018-07-18 02:00:00	ES	Futures	3064.43	3066.88	3064.16	3066.61	7271.0
2018-07-18 03:00:00	ES	Futures	3066.61	3067.7	3064.43	3066.61	13119.0
2018-07-18 04:00:00	ES	Futures	3066.61	3066.61	3062.79	3064.7	13435.0
2018-07-18 05:00:00	ES	Futures	3064.97	3066.61	3064.43	3065.79	7452.0
2018-07-18 06:00:00	ES	Futures	3065.79	3066.06	3063.07	3064.43	5982.0
2018-07-18 07:00:00	ES	Futures	3064.16	3064.7	3062.52	3062.79	10728.0
2018-07-18 08:00:00	ES	Futures	3063.07	3063.07	3059.8	3062.52	24051.0
2018-07-18 09:00:00	ES	Futures	3062.25	3066.88	3061.43	3062.79	142666.0
2018-07-18 10:00:00	ES	Futures	3063.07	3063.88	3058.98	3063.07	135366.0
2018-07-18 11:00:00	ES	Futures	3063.34	3070.7	3062.25	3070.15	98372.0
2018-07-18 12:00:00	ES	Futures	3069.88	3071.24	3068.24	3069.33	59103.0
2018-07-18 13:00:00	ES	Futures	3069.33	3069.88	3065.52	3067.7	37309.0
2018-07-18 14:00:00	ES	Futures	3067.43	3070.42	3067.15	3069.33	62968.0
2018-07-18 15:00:00	ES	Futures	3069.61	3071.51	3068.79	3069.88	136820.0
2018-07-18 16:00:00	ES	Futures	3070.15	3070.42	3067.43	3067.7	47361.0
2018-07-18 18:00:00	ES	Futures	3067.43	3069.06	3067.15	3068.79	2944.0
2018-07-18 19:00:00	ES	Futures	3068.79	3069.88	3068.79	3069.06	1328.0
2018-07-18 20:00:00	ES	Futures	3069.06	3070.15	3067.7	3069.33	5007.0
2018-07-18 21:00:00	ES	Futures	3069.33	3071.24	3068.79	3070.7	6704.0
2018-07-18 22:00:00	ES	Futures	3070.7	3070.97	3069.06	3070.15	3463.0
2018-07-18 23:00:00	ES	Futures	3070.15	3070.7	3067.97	3068.52	3288.0
2018-07-18 00:00:00	NQ	Futures	8747.75	8749.22	8742.45	8748.34	1250.0
2018-07-18 01:00:00	NQ	Futures	8748.34	8749.81	8738.63	8739.21	1681.0
2018-07-18 02:00:00	NQ	Futures	8739.21	8746.87	8738.04	8745.99	2322.0
2018-07-18 03:00:00	NQ	Futures	8745.99	8747.75	8736.86	8742.16	4515.0
2018-07-18 04:00:00	NQ	Futures	8741.57	8743.04	8731.26	8738.92	4373.0
2018-07-18 05:00:00	NQ	Futures	8739.21	8742.75	8736.86	8740.39	1895.0
2018-07-18 06:00:00	NQ	Futures	8740.39	8740.69	8730.38	8734.21	2403.0
2018-07-18 07:00:00	NQ	Futures	8733.91	8735.39	8727.14	8729.79	3153.0
2018-07-18 08:00:00	NQ	Futures	8729.79	8730.97	8720.96	8729.79	6016.0
2018-07-18 09:00:00	NQ	Futures	8729.5	8746.28	8705.06	8717.43	54218.0
2018-07-18 10:00:00	NQ	Futures	8717.13	8724.79	8692.99	8710.66	53112.0
2018-07-18 11:00:00	NQ	Futures	8710.95	8730.09	8704.47	8726.55	30382.0
2018-07-18 12:00:00	NQ	Futures	8726.55	8731.85	8710.66	8725.67	23722.0
2018-07-18 13:00:00	NQ	Futures	8724.79	8731.26	8715.95	8726.55	15952.0
2018-07-18 14:00:00	NQ	Futures	8726.55	8735.39	8717.72	8724.49	21719.0
2018-07-18 15:00:00	NQ	Futures	8724.49	8731.26	8719.49	8720.67	22929.0
2018-07-18 16:00:00	NQ	Futures	8720.67	8722.73	8711.54	8712.72	5434.0
2018-07-18 18:00:00	NQ	Futures	8714.78	8721.84	8712.72	8720.67	892.0
2018-07-18 19:00:00	NQ	Futures	8720.37	8725.97	8720.08	8723.02	1018.0
2018-07-18 20:00:00	NQ	Futures	8722.73	8729.5	8718.6	8725.67	1821.0
2018-07-18 21:00:00	NQ	Futures	8725.97	8733.62	8724.49	8732.15	2244.0
2018-07-18 22:00:00	NQ	Futures	8732.15	8733.62	8726.55	8730.38	1481.0
2018-07-18 23:00:00	NQ	Futures	8731.26	8733.33	8723.32	8724.49	1389.0
2018-07-18 00:00:00	YM	Futures	27311.1	27313.3	27285.0	27312.2	1265.0
2018-07-18 01:00:00	YM	Futures	27312.2	27314.4	27291.5	27292.6	865.0
2018-07-18 02:00:00	YM	Futures	27291.5	27318.7	27289.4	27314.4	1818.0
2018-07-18 03:00:00	YM	Futures	27315.5	27330.7	27298.1	27314.4	2351.0

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

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