PREVIEW / futures_1hour / 2018-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-09.parquet
  size:    54 KB
  rows:    1,680

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-04-09 00:00:00	ES	Futures	2863.9	2864.72	2861.71	2862.53	2814.0
2018-04-09 01:00:00	ES	Futures	2862.53	2863.62	2859.53	2859.8	4906.0
2018-04-09 02:00:00	ES	Futures	2859.53	2866.35	2859.53	2865.53	11586.0
2018-04-09 03:00:00	ES	Futures	2865.26	2866.08	2854.89	2863.35	29535.0
2018-04-09 04:00:00	ES	Futures	2863.35	2868.26	2861.99	2865.26	14604.0
2018-04-09 05:00:00	ES	Futures	2865.26	2869.08	2862.81	2862.81	13639.0
2018-04-09 06:00:00	ES	Futures	2863.08	2867.44	2860.08	2860.35	14500.0
2018-04-09 07:00:00	ES	Futures	2860.35	2863.35	2858.17	2861.44	17069.0
2018-04-09 08:00:00	ES	Futures	2861.44	2863.08	2855.44	2856.8	33868.0
2018-04-09 09:00:00	ES	Futures	2857.07	2870.17	2852.71	2866.08	197242.0
2018-04-09 10:00:00	ES	Futures	2866.35	2877.54	2860.62	2874.81	212079.0
2018-04-09 11:00:00	ES	Futures	2874.81	2888.46	2871.81	2887.37	166387.0
2018-04-09 12:00:00	ES	Futures	2887.37	2891.19	2883.27	2888.73	139170.0
2018-04-09 13:00:00	ES	Futures	2889.0	2896.92	2889.0	2896.37	119641.0
2018-04-09 14:00:00	ES	Futures	2896.1	2896.65	2878.91	2886.28	186537.0
2018-04-09 15:00:00	ES	Futures	2886.28	2886.82	2849.71	2853.25	376094.0
2018-04-09 16:00:00	ES	Futures	2853.25	2860.62	2849.16	2857.89	101511.0
2018-04-09 18:00:00	ES	Futures	2857.62	2860.62	2851.62	2853.53	13434.0
2018-04-09 19:00:00	ES	Futures	2853.25	2858.71	2851.89	2855.44	6566.0
2018-04-09 20:00:00	ES	Futures	2855.44	2858.98	2852.16	2857.35	14647.0
2018-04-09 21:00:00	ES	Futures	2857.07	2881.64	2857.07	2880.54	32671.0
2018-04-09 22:00:00	ES	Futures	2880.54	2901.56	2873.72	2892.28	57540.0
2018-04-09 23:00:00	ES	Futures	2892.01	2892.83	2879.73	2886.55	23013.0
2018-04-09 00:00:00	NQ	Futures	7700.39	7702.75	7693.59	7695.36	1276.0
2018-04-09 01:00:00	NQ	Futures	7694.47	7698.02	7685.31	7686.5	2300.0
2018-04-09 02:00:00	NQ	Futures	7686.5	7705.71	7685.61	7699.2	3714.0
2018-04-09 03:00:00	NQ	Futures	7699.2	7700.68	7666.4	7693.88	7995.0
2018-04-09 04:00:00	NQ	Futures	7694.18	7710.73	7689.45	7700.09	5037.0
2018-04-09 05:00:00	NQ	Futures	7700.09	7716.05	7695.07	7697.43	4611.0
2018-04-09 06:00:00	NQ	Futures	7697.73	7708.96	7685.61	7685.61	3932.0
2018-04-09 07:00:00	NQ	Futures	7686.5	7696.84	7677.93	7687.97	6467.0
2018-04-09 08:00:00	NQ	Futures	7687.09	7693.0	7669.95	7676.45	10408.0
2018-04-09 09:00:00	NQ	Futures	7676.15	7739.1	7663.15	7728.76	58552.0
2018-04-09 10:00:00	NQ	Futures	7728.17	7766.58	7717.53	7755.35	64361.0
2018-04-09 11:00:00	NQ	Futures	7755.35	7799.39	7738.51	7798.21	54471.0
2018-04-09 12:00:00	NQ	Futures	7798.5	7823.33	7784.02	7799.68	49045.0
2018-04-09 13:00:00	NQ	Futures	7799.68	7815.64	7781.95	7801.75	35724.0
2018-04-09 14:00:00	NQ	Futures	7801.75	7804.12	7744.72	7765.99	49929.0
2018-04-09 15:00:00	NQ	Futures	7765.7	7766.29	7655.17	7664.04	81438.0
2018-04-09 16:00:00	NQ	Futures	7664.04	7686.5	7647.19	7676.15	15997.0
2018-04-09 18:00:00	NQ	Futures	7672.61	7684.72	7655.46	7666.4	3144.0
2018-04-09 19:00:00	NQ	Futures	7666.1	7677.63	7660.19	7664.33	1841.0
2018-04-09 20:00:00	NQ	Futures	7663.74	7679.99	7650.44	7674.08	5895.0
2018-04-09 21:00:00	NQ	Futures	7674.38	7756.83	7673.49	7750.03	9591.0
2018-04-09 22:00:00	NQ	Futures	7750.63	7829.83	7732.01	7797.91	20517.0
2018-04-09 23:00:00	NQ	Futures	7798.5	7801.75	7764.81	7788.16	6850.0
2018-04-09 00:00:00	YM	Futures	26168.8	26175.3	26152.5	26160.1	1139.0
2018-04-09 01:00:00	YM	Futures	26159.0	26171.0	26118.9	26126.5	2974.0
2018-04-09 02:00:00	YM	Futures	26127.5	26227.5	26126.5	26205.7	4531.0
2018-04-09 03:00:00	YM	Futures	26206.8	26213.3	26110.2	26184.0	6353.0

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

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