PREVIEW / futures_1hour / 2019-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-27.parquet
  size:    39 KB
  rows:    1,242

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
2019-05-27 00:00:00	ES	Futures	3068.61	3068.88	3066.44	3066.71	1985.0
2019-05-27 01:00:00	ES	Futures	3066.44	3070.23	3066.44	3069.69	4014.0
2019-05-27 02:00:00	ES	Futures	3069.69	3074.03	3069.15	3073.76	7189.0
2019-05-27 03:00:00	ES	Futures	3073.76	3078.91	3072.67	3075.11	12551.0
2019-05-27 04:00:00	ES	Futures	3075.38	3075.93	3070.78	3071.59	10638.0
2019-05-27 05:00:00	ES	Futures	3071.86	3072.94	3068.34	3069.96	8952.0
2019-05-27 06:00:00	ES	Futures	3069.96	3069.96	3066.98	3069.15	7494.0
2019-05-27 07:00:00	ES	Futures	3069.15	3070.5	3068.06	3068.88	3425.0
2019-05-27 08:00:00	ES	Futures	3069.15	3071.05	3068.06	3069.42	5675.0
2019-05-27 09:00:00	ES	Futures	3069.42	3070.78	3067.52	3067.79	10001.0
2019-05-27 10:00:00	ES	Futures	3068.06	3069.69	3066.71	3069.15	12831.0
2019-05-27 11:00:00	ES	Futures	3069.42	3069.69	3066.17	3067.25	15094.0
2019-05-27 12:00:00	ES	Futures	3067.25	3071.32	3066.98	3070.78	6333.0
2019-05-27 18:00:00	ES	Futures	3068.88	3075.66	3068.88	3073.49	7131.0
2019-05-27 19:00:00	ES	Futures	3073.49	3073.76	3071.86	3072.4	7035.0
2019-05-27 20:00:00	ES	Futures	3072.67	3077.01	3071.05	3076.47	9694.0
2019-05-27 21:00:00	ES	Futures	3076.47	3078.37	3073.22	3078.1	9116.0
2019-05-27 22:00:00	ES	Futures	3077.82	3078.91	3075.93	3078.64	6245.0
2019-05-27 23:00:00	ES	Futures	3078.37	3078.64	3076.74	3077.55	3722.0
2019-05-27 00:00:00	NQ	Futures	8505.25	8506.71	8495.06	8495.06	1582.0
2019-05-27 01:00:00	NQ	Futures	8495.06	8509.33	8495.06	8507.0	2582.0
2019-05-27 02:00:00	NQ	Futures	8507.29	8529.42	8506.12	8528.54	4478.0
2019-05-27 03:00:00	NQ	Futures	8528.54	8546.59	8525.63	8538.15	6519.0
2019-05-27 04:00:00	NQ	Futures	8538.44	8540.19	8522.43	8526.21	4321.0
2019-05-27 05:00:00	NQ	Futures	8526.8	8530.0	8516.9	8522.14	3590.0
2019-05-27 06:00:00	NQ	Futures	8521.85	8522.14	8510.49	8517.19	2974.0
2019-05-27 07:00:00	NQ	Futures	8517.48	8523.59	8513.99	8517.77	2053.0
2019-05-27 08:00:00	NQ	Futures	8518.06	8527.67	8514.57	8521.26	2824.0
2019-05-27 09:00:00	NQ	Futures	8521.85	8527.67	8516.02	8518.06	4699.0
2019-05-27 10:00:00	NQ	Futures	8518.06	8521.85	8513.69	8516.61	4882.0
2019-05-27 11:00:00	NQ	Futures	8516.9	8521.56	8513.69	8515.44	4132.0
2019-05-27 12:00:00	NQ	Futures	8515.44	8523.3	8514.57	8523.01	2046.0
2019-05-27 18:00:00	NQ	Futures	8516.61	8536.4	8515.15	8531.75	2509.0
2019-05-27 19:00:00	NQ	Futures	8531.75	8534.37	8527.67	8529.13	1665.0
2019-05-27 20:00:00	NQ	Futures	8529.42	8545.43	8524.18	8543.68	4964.0
2019-05-27 21:00:00	NQ	Futures	8543.97	8552.42	8534.07	8551.54	4347.0
2019-05-27 22:00:00	NQ	Futures	8551.84	8556.79	8546.01	8555.91	3028.0
2019-05-27 23:00:00	NQ	Futures	8555.62	8556.49	8550.09	8553.87	1476.0
2019-05-27 00:00:00	YM	Futures	27864.9	27868.2	27850.8	27854.1	709.0
2019-05-27 01:00:00	YM	Futures	27853.0	27885.6	27853.0	27881.3	1779.0
2019-05-27 02:00:00	YM	Futures	27881.3	27912.8	27876.9	27909.5	2366.0
2019-05-27 03:00:00	YM	Futures	27909.5	27949.8	27901.9	27921.5	4054.0
2019-05-27 04:00:00	YM	Futures	27921.5	27925.9	27885.6	27896.5	2578.0
2019-05-27 05:00:00	YM	Futures	27896.5	27899.8	27866.0	27871.5	2371.0
2019-05-27 06:00:00	YM	Futures	27873.6	27880.2	27853.0	27878.0	1721.0
2019-05-27 07:00:00	YM	Futures	27876.9	27882.3	27868.2	27870.4	1246.0
2019-05-27 08:00:00	YM	Futures	27871.5	27891.0	27863.9	27872.6	1504.0
2019-05-27 09:00:00	YM	Futures	27873.6	27887.8	27858.4	27872.6	3436.0
2019-05-27 10:00:00	YM	Futures	27873.6	27891.0	27867.1	27890.0	2738.0
2019-05-27 11:00:00	YM	Futures	27890.0	27897.6	27873.6	27878.0	2859.0

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

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