PREVIEW / futures_1hour / 2019-05-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-10.parquet
  size:    50 KB
  rows:    1,490

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-10 00:00:00	ES	Futures	3101.41	3112.25	3094.9	3099.51	39690.0
2019-05-10 01:00:00	ES	Futures	3099.51	3111.17	3093.28	3110.36	24225.0
2019-05-10 02:00:00	ES	Futures	3110.36	3115.24	3107.1	3110.36	19928.0
2019-05-10 03:00:00	ES	Futures	3110.09	3117.41	3106.29	3107.1	33591.0
2019-05-10 04:00:00	ES	Futures	3106.83	3111.17	3103.04	3107.65	28861.0
2019-05-10 05:00:00	ES	Futures	3107.65	3111.98	3105.48	3106.56	15810.0
2019-05-10 06:00:00	ES	Futures	3106.29	3118.22	3105.21	3107.1	29322.0
2019-05-10 07:00:00	ES	Futures	3107.1	3108.19	3096.53	3098.43	56963.0
2019-05-10 08:00:00	ES	Futures	3098.43	3098.43	3089.48	3096.8	73289.0
2019-05-10 09:00:00	ES	Futures	3096.8	3109.0	3095.72	3100.33	277539.0
2019-05-10 10:00:00	ES	Futures	3100.33	3101.14	3067.52	3071.05	369659.0
2019-05-10 11:00:00	ES	Futures	3071.32	3079.99	3064.54	3073.76	386848.0
2019-05-10 12:00:00	ES	Futures	3073.76	3100.87	3073.22	3098.16	294983.0
2019-05-10 13:00:00	ES	Futures	3098.16	3114.69	3095.99	3111.71	284852.0
2019-05-10 14:00:00	ES	Futures	3111.71	3120.39	3105.21	3116.86	176239.0
2019-05-10 15:00:00	ES	Futures	3116.86	3137.2	3116.86	3127.44	357490.0
2019-05-10 16:00:00	ES	Futures	3127.16	3133.4	3124.45	3130.96	77570.0
2019-05-10 00:00:00	NQ	Futures	8792.04	8828.43	8772.53	8790.0	17667.0
2019-05-10 01:00:00	NQ	Futures	8790.29	8836.0	8772.53	8832.51	14322.0
2019-05-10 02:00:00	NQ	Futures	8831.64	8845.9	8821.15	8830.76	8607.0
2019-05-10 03:00:00	NQ	Futures	8830.18	8861.92	8824.65	8826.98	10628.0
2019-05-10 04:00:00	NQ	Futures	8826.69	8842.12	8813.29	8831.64	9965.0
2019-05-10 05:00:00	NQ	Futures	8831.64	8849.98	8828.14	8831.35	6209.0
2019-05-10 06:00:00	NQ	Futures	8831.05	8868.03	8820.57	8828.72	9517.0
2019-05-10 07:00:00	NQ	Futures	8829.31	8835.13	8794.08	8797.86	17372.0
2019-05-10 08:00:00	NQ	Futures	8797.86	8798.15	8763.8	8789.13	20589.0
2019-05-10 09:00:00	NQ	Futures	8788.55	8837.46	8786.51	8793.5	71542.0
2019-05-10 10:00:00	NQ	Futures	8793.2	8794.95	8669.75	8687.81	124043.0
2019-05-10 11:00:00	NQ	Futures	8688.1	8713.72	8659.85	8686.35	108261.0
2019-05-10 12:00:00	NQ	Futures	8685.77	8777.19	8685.18	8765.84	83773.0
2019-05-10 13:00:00	NQ	Futures	8766.42	8820.57	8758.85	8815.62	66026.0
2019-05-10 14:00:00	NQ	Futures	8815.62	8833.67	8787.09	8825.23	49419.0
2019-05-10 15:00:00	NQ	Futures	8825.81	8894.24	8825.52	8851.73	88072.0
2019-05-10 16:00:00	NQ	Futures	8851.44	8872.11	8845.03	8864.25	14204.0
2019-05-10 00:00:00	YM	Futures	27980.2	28073.8	27913.9	27954.1	11773.0
2019-05-10 01:00:00	YM	Futures	27954.1	28055.3	27895.4	28048.8	6344.0
2019-05-10 02:00:00	YM	Futures	28045.5	28097.7	28020.5	28055.3	3806.0
2019-05-10 03:00:00	YM	Futures	28054.2	28121.6	28025.9	28031.4	6058.0
2019-05-10 04:00:00	YM	Futures	28032.4	28066.2	27988.9	28035.7	6198.0
2019-05-10 05:00:00	YM	Futures	28035.7	28076.0	28022.7	28031.4	3763.0
2019-05-10 06:00:00	YM	Futures	28030.3	28132.5	28021.6	28040.1	8930.0
2019-05-10 07:00:00	YM	Futures	28040.1	28049.8	27945.4	27962.8	8882.0
2019-05-10 08:00:00	YM	Futures	27963.9	27991.1	27890.0	27949.8	9873.0
2019-05-10 09:00:00	YM	Futures	27948.7	28025.9	27926.9	27936.7	30888.0
2019-05-10 10:00:00	YM	Futures	27937.8	27946.5	27739.9	27755.1	45199.0
2019-05-10 11:00:00	YM	Futures	27752.9	27824.7	27696.4	27757.3	50890.0
2019-05-10 12:00:00	YM	Futures	27756.2	27975.9	27754.0	27952.0	34648.0
2019-05-10 13:00:00	YM	Futures	27950.9	28096.6	27938.9	28072.7	32336.0
2019-05-10 14:00:00	YM	Futures	28072.7	28170.6	28035.7	28140.1	23174.0
2019-05-10 15:00:00	YM	Futures	28140.1	28296.7	28140.1	28220.6	35336.0

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

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