PREVIEW / futures_1hour / 2019-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-11.parquet
  size:    53 KB
  rows:    1,527

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-10-11 00:00:00	ES	Futures	3205.79	3209.86	3205.52	3209.05	6480.0
2019-10-11 01:00:00	ES	Futures	3209.05	3211.76	3207.96	3208.23	9627.0
2019-10-11 02:00:00	ES	Futures	3208.51	3209.32	3203.07	3208.51	12143.0
2019-10-11 03:00:00	ES	Futures	3208.78	3210.95	3204.97	3210.41	24861.0
2019-10-11 04:00:00	ES	Futures	3210.41	3222.63	3210.13	3222.63	34799.0
2019-10-11 05:00:00	ES	Futures	3222.63	3229.69	3222.09	3224.26	30207.0
2019-10-11 06:00:00	ES	Futures	3224.26	3227.25	3222.9	3224.8	18279.0
2019-10-11 07:00:00	ES	Futures	3224.8	3231.32	3222.36	3226.98	28923.0
2019-10-11 08:00:00	ES	Futures	3227.25	3229.42	3224.53	3225.07	33572.0
2019-10-11 09:00:00	ES	Futures	3225.35	3242.19	3222.63	3236.75	202149.0
2019-10-11 10:00:00	ES	Futures	3237.03	3244.09	3237.03	3241.37	186298.0
2019-10-11 11:00:00	ES	Futures	3241.37	3253.05	3240.56	3242.19	203596.0
2019-10-11 12:00:00	ES	Futures	3242.19	3243.27	3224.26	3240.83	158896.0
2019-10-11 13:00:00	ES	Futures	3241.1	3247.35	3234.85	3246.26	135698.0
2019-10-11 14:00:00	ES	Futures	3246.26	3250.34	3241.1	3248.43	74135.0
2019-10-11 15:00:00	ES	Futures	3248.43	3251.69	3224.26	3225.35	319622.0
2019-10-11 16:00:00	ES	Futures	3225.62	3233.77	3220.19	3227.25	115469.0
2019-10-11 00:00:00	NQ	Futures	9060.16	9073.53	9056.97	9068.59	2978.0
2019-10-11 01:00:00	NQ	Futures	9068.01	9078.47	9065.39	9066.56	3985.0
2019-10-11 02:00:00	NQ	Futures	9066.56	9070.04	9047.09	9067.72	5895.0
2019-10-11 03:00:00	NQ	Futures	9067.43	9077.01	9055.23	9071.49	11441.0
2019-10-11 04:00:00	NQ	Futures	9071.78	9115.07	9071.2	9113.32	14731.0
2019-10-11 05:00:00	NQ	Futures	9113.32	9132.5	9111.29	9115.36	9698.0
2019-10-11 06:00:00	NQ	Futures	9115.07	9124.07	9105.77	9111.87	8022.0
2019-10-11 07:00:00	NQ	Futures	9111.87	9135.98	9105.77	9116.81	13108.0
2019-10-11 08:00:00	NQ	Futures	9117.1	9122.04	9107.51	9108.97	12289.0
2019-10-11 09:00:00	NQ	Futures	9108.97	9166.78	9101.12	9148.18	63090.0
2019-10-11 10:00:00	NQ	Futures	9148.47	9176.65	9148.47	9166.78	59771.0
2019-10-11 11:00:00	NQ	Futures	9166.78	9193.21	9157.48	9162.42	58935.0
2019-10-11 12:00:00	NQ	Futures	9162.42	9171.13	9109.26	9166.78	48328.0
2019-10-11 13:00:00	NQ	Futures	9166.78	9187.98	9151.67	9183.62	37747.0
2019-10-11 14:00:00	NQ	Futures	9183.62	9191.18	9168.81	9187.69	19243.0
2019-10-11 15:00:00	NQ	Futures	9187.98	9201.05	9121.46	9122.91	72419.0
2019-10-11 16:00:00	NQ	Futures	9123.2	9150.22	9105.19	9131.34	20307.0
2019-10-11 00:00:00	YM	Futures	28916.4	28949.1	28912.1	28939.3	1516.0
2019-10-11 01:00:00	YM	Futures	28939.3	28965.4	28930.6	28931.7	2291.0
2019-10-11 02:00:00	YM	Futures	28931.7	28941.5	28894.7	28940.4	3944.0
2019-10-11 03:00:00	YM	Futures	28939.3	28950.2	28906.6	28944.7	7118.0
2019-10-11 04:00:00	YM	Futures	28944.7	29066.6	28940.4	29061.2	9598.0
2019-10-11 05:00:00	YM	Futures	29062.3	29121.0	29057.9	29077.5	7180.0
2019-10-11 06:00:00	YM	Futures	29077.5	29113.4	29072.1	29089.5	4321.0
2019-10-11 07:00:00	YM	Futures	29089.5	29142.8	29069.9	29105.8	6759.0
2019-10-11 08:00:00	YM	Futures	29106.9	29123.2	29084.0	29100.4	5818.0
2019-10-11 09:00:00	YM	Futures	29102.5	29247.3	29081.9	29197.2	31969.0
2019-10-11 10:00:00	YM	Futures	29194.0	29242.9	29190.7	29223.3	21084.0
2019-10-11 11:00:00	YM	Futures	29223.3	29351.8	29222.3	29257.1	27310.0
2019-10-11 12:00:00	YM	Futures	29258.2	29265.8	29080.8	29229.9	21909.0
2019-10-11 13:00:00	YM	Futures	29228.8	29283.2	29173.3	29273.4	15598.0
2019-10-11 14:00:00	YM	Futures	29273.4	29332.2	29234.2	29320.2	9412.0
2019-10-11 15:00:00	YM	Futures	29321.3	29358.3	29120.0	29135.2	33534.0

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

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