PREVIEW / futures_1hour / 2018-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-28.parquet
  size:    56 KB
  rows:    1,698

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-03-28 00:00:00	ES	Futures	2855.71	2858.44	2850.8	2854.35	9708.0
2018-03-28 01:00:00	ES	Futures	2854.35	2855.16	2841.25	2851.89	18451.0
2018-03-28 02:00:00	ES	Futures	2852.16	2860.35	2851.07	2857.35	23111.0
2018-03-28 03:00:00	ES	Futures	2857.62	2861.44	2840.15	2841.25	48852.0
2018-03-28 04:00:00	ES	Futures	2841.52	2852.71	2838.24	2844.25	37393.0
2018-03-28 05:00:00	ES	Futures	2843.97	2850.52	2839.88	2848.07	23333.0
2018-03-28 06:00:00	ES	Futures	2848.34	2857.62	2846.7	2857.62	23693.0
2018-03-28 07:00:00	ES	Futures	2857.62	2864.99	2856.26	2860.62	39552.0
2018-03-28 08:00:00	ES	Futures	2860.62	2867.72	2851.89	2852.43	60906.0
2018-03-28 09:00:00	ES	Futures	2852.71	2863.35	2841.52	2859.26	330154.0
2018-03-28 10:00:00	ES	Futures	2859.53	2866.9	2830.6	2843.43	460848.0
2018-03-28 11:00:00	ES	Futures	2843.43	2857.07	2834.7	2849.71	372503.0
2018-03-28 12:00:00	ES	Futures	2849.71	2875.09	2846.98	2848.61	327236.0
2018-03-28 13:00:00	ES	Futures	2848.61	2865.26	2841.79	2857.89	238652.0
2018-03-28 14:00:00	ES	Futures	2857.62	2861.99	2846.43	2849.43	200001.0
2018-03-28 15:00:00	ES	Futures	2849.16	2859.53	2834.97	2843.7	372142.0
2018-03-28 16:00:00	ES	Futures	2843.7	2850.25	2842.34	2846.98	68667.0
2018-03-28 18:00:00	ES	Futures	2848.89	2855.16	2847.52	2852.43	10232.0
2018-03-28 19:00:00	ES	Futures	2852.43	2855.44	2848.61	2850.8	6487.0
2018-03-28 20:00:00	ES	Futures	2850.52	2851.89	2841.79	2849.43	12237.0
2018-03-28 21:00:00	ES	Futures	2849.71	2851.89	2842.88	2845.07	9201.0
2018-03-28 22:00:00	ES	Futures	2845.07	2848.61	2842.34	2847.25	6195.0
2018-03-28 23:00:00	ES	Futures	2846.98	2848.07	2839.34	2844.25	8205.0
2018-03-28 00:00:00	NQ	Futures	7747.97	7761.56	7716.64	7728.17	5966.0
2018-03-28 01:00:00	NQ	Futures	7728.17	7732.01	7685.9	7724.62	8105.0
2018-03-28 02:00:00	NQ	Futures	7724.91	7757.72	7724.32	7743.24	8960.0
2018-03-28 03:00:00	NQ	Futures	7742.65	7761.56	7672.9	7677.33	18562.0
2018-03-28 04:00:00	NQ	Futures	7677.93	7712.21	7666.4	7684.72	13191.0
2018-03-28 05:00:00	NQ	Futures	7684.13	7715.16	7668.47	7704.82	9483.0
2018-03-28 06:00:00	NQ	Futures	7704.23	7742.35	7694.47	7740.58	8750.0
2018-03-28 07:00:00	NQ	Futures	7740.58	7779.0	7738.21	7763.04	15414.0
2018-03-28 08:00:00	NQ	Futures	7762.74	7778.11	7697.13	7698.91	24324.0
2018-03-28 09:00:00	NQ	Futures	7698.32	7732.3	7617.93	7714.57	141074.0
2018-03-28 10:00:00	NQ	Futures	7714.57	7754.17	7590.45	7649.85	159125.0
2018-03-28 11:00:00	NQ	Futures	7649.85	7698.91	7603.45	7671.13	112205.0
2018-03-28 12:00:00	NQ	Futures	7670.83	7771.9	7659.9	7669.95	100795.0
2018-03-28 13:00:00	NQ	Futures	7669.65	7738.51	7643.64	7704.82	81701.0
2018-03-28 14:00:00	NQ	Futures	7704.82	7723.44	7655.76	7665.51	80331.0
2018-03-28 15:00:00	NQ	Futures	7664.33	7705.11	7618.23	7649.55	105821.0
2018-03-28 16:00:00	NQ	Futures	7649.26	7677.93	7644.53	7670.24	15478.0
2018-03-28 18:00:00	NQ	Futures	7672.9	7693.59	7667.88	7683.84	3071.0
2018-03-28 19:00:00	NQ	Futures	7683.24	7687.09	7668.17	7674.38	2766.0
2018-03-28 20:00:00	NQ	Futures	7674.38	7684.43	7647.19	7679.11	5407.0
2018-03-28 21:00:00	NQ	Futures	7679.4	7685.9	7655.46	7665.81	4609.0
2018-03-28 22:00:00	NQ	Futures	7664.92	7669.06	7650.74	7666.69	3822.0
2018-03-28 23:00:00	NQ	Futures	7666.69	7670.54	7648.96	7664.92	3543.0
2018-03-28 00:00:00	YM	Futures	25912.5	25963.6	25888.6	25941.8	5687.0
2018-03-28 01:00:00	YM	Futures	25942.9	25946.2	25816.9	25903.8	7450.0
2018-03-28 02:00:00	YM	Futures	25904.9	25972.2	25886.4	25933.1	6932.0
2018-03-28 03:00:00	YM	Futures	25936.4	25974.4	25805.0	25813.7	11314.0

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

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