PREVIEW / futures_1hour / 2018-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-21.parquet
  size:    54 KB
  rows:    1,684

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-11-21 00:00:00	ES	Futures	2884.54	2884.81	2881.28	2883.45	5600.0
2018-11-21 01:00:00	ES	Futures	2883.45	2888.08	2881.01	2888.08	7734.0
2018-11-21 02:00:00	ES	Futures	2888.08	2891.34	2884.0	2889.44	17600.0
2018-11-21 03:00:00	ES	Futures	2889.17	2893.52	2883.73	2892.97	26839.0
2018-11-21 04:00:00	ES	Futures	2892.7	2893.52	2885.36	2887.53	17147.0
2018-11-21 05:00:00	ES	Futures	2887.26	2893.52	2881.28	2884.0	25639.0
2018-11-21 06:00:00	ES	Futures	2884.0	2891.61	2881.82	2887.26	33906.0
2018-11-21 07:00:00	ES	Futures	2887.26	2900.59	2886.72	2898.68	46649.0
2018-11-21 08:00:00	ES	Futures	2898.41	2901.68	2892.16	2892.97	37969.0
2018-11-21 09:00:00	ES	Futures	2893.25	2897.32	2884.27	2894.88	220040.0
2018-11-21 10:00:00	ES	Futures	2894.88	2900.86	2889.98	2895.97	232000.0
2018-11-21 11:00:00	ES	Futures	2895.69	2906.3	2892.7	2902.49	152123.0
2018-11-21 12:00:00	ES	Futures	2902.49	2903.58	2896.51	2903.04	79962.0
2018-11-21 13:00:00	ES	Futures	2903.04	2903.85	2897.6	2900.04	64612.0
2018-11-21 14:00:00	ES	Futures	2900.32	2901.4	2895.69	2896.51	70063.0
2018-11-21 15:00:00	ES	Futures	2896.78	2901.68	2882.91	2883.73	213493.0
2018-11-21 16:00:00	ES	Futures	2883.73	2884.54	2880.73	2882.09	69765.0
2018-11-21 18:00:00	ES	Futures	2883.18	2887.53	2882.37	2884.81	4022.0
2018-11-21 19:00:00	ES	Futures	2884.54	2889.71	2881.01	2887.81	6277.0
2018-11-21 20:00:00	ES	Futures	2887.81	2889.98	2880.46	2881.28	7154.0
2018-11-21 21:00:00	ES	Futures	2881.55	2884.0	2878.01	2881.55	4144.0
2018-11-21 22:00:00	ES	Futures	2881.55	2882.64	2879.1	2882.09	2463.0
2018-11-21 23:00:00	ES	Futures	2882.37	2886.17	2882.09	2885.9	2488.0
2018-11-21 00:00:00	NQ	Futures	7704.48	7708.3	7696.56	7705.95	3453.0
2018-11-21 01:00:00	NQ	Futures	7705.36	7737.04	7697.15	7733.81	5436.0
2018-11-21 02:00:00	NQ	Futures	7734.11	7742.91	7712.99	7730.0	9253.0
2018-11-21 03:00:00	NQ	Futures	7730.0	7749.95	7703.02	7745.55	14539.0
2018-11-21 04:00:00	NQ	Futures	7744.96	7750.83	7714.75	7727.36	9445.0
2018-11-21 05:00:00	NQ	Futures	7726.19	7745.84	7700.67	7711.23	12406.0
2018-11-21 06:00:00	NQ	Futures	7711.52	7739.68	7703.6	7713.87	12808.0
2018-11-21 07:00:00	NQ	Futures	7713.28	7771.06	7711.52	7760.21	25011.0
2018-11-21 08:00:00	NQ	Futures	7759.92	7770.48	7741.15	7752.59	21383.0
2018-11-21 09:00:00	NQ	Futures	7752.59	7796.0	7709.47	7761.39	105948.0
2018-11-21 10:00:00	NQ	Futures	7761.39	7790.13	7732.35	7758.16	106926.0
2018-11-21 11:00:00	NQ	Futures	7758.16	7799.52	7745.25	7770.19	58714.0
2018-11-21 12:00:00	NQ	Futures	7770.48	7786.32	7755.52	7783.97	32023.0
2018-11-21 13:00:00	NQ	Futures	7783.97	7787.78	7759.63	7777.52	24467.0
2018-11-21 14:00:00	NQ	Futures	7777.52	7786.32	7758.75	7761.68	23875.0
2018-11-21 15:00:00	NQ	Futures	7761.97	7780.16	7723.25	7724.13	51416.0
2018-11-21 16:00:00	NQ	Futures	7723.84	7725.6	7713.58	7719.15	12220.0
2018-11-21 18:00:00	NQ	Futures	7725.01	7735.28	7720.32	7727.36	1448.0
2018-11-21 19:00:00	NQ	Futures	7726.19	7738.51	7715.63	7734.99	2799.0
2018-11-21 20:00:00	NQ	Futures	7735.57	7741.15	7713.28	7715.92	3723.0
2018-11-21 21:00:00	NQ	Futures	7714.46	7724.13	7700.38	7712.99	2551.0
2018-11-21 22:00:00	NQ	Futures	7713.28	7713.28	7698.03	7709.47	1788.0
2018-11-21 23:00:00	NQ	Futures	7709.47	7723.84	7708.59	7722.67	1580.0
2018-11-21 00:00:00	YM	Futures	26655.4	26656.5	26627.2	26643.5	1736.0
2018-11-21 01:00:00	YM	Futures	26642.4	26681.5	26618.5	26678.2	2412.0
2018-11-21 02:00:00	YM	Futures	26680.4	26707.6	26641.3	26685.8	5391.0
2018-11-21 03:00:00	YM	Futures	26685.8	26721.7	26646.7	26711.9	6823.0

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

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