PREVIEW / futures_1hour / 2019-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-20.parquet
  size:    59 KB
  rows:    1,886

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-11-20 00:00:00	ES	Futures	3383.71	3384.52	3382.08	3383.44	6284.0
2019-11-20 01:00:00	ES	Futures	3383.44	3383.71	3381.26	3382.08	5102.0
2019-11-20 02:00:00	ES	Futures	3381.81	3385.61	3378.27	3380.18	24721.0
2019-11-20 03:00:00	ES	Futures	3380.18	3380.72	3374.47	3375.56	38685.0
2019-11-20 04:00:00	ES	Futures	3375.29	3379.36	3373.11	3377.73	26584.0
2019-11-20 05:00:00	ES	Futures	3377.73	3378.27	3374.2	3376.37	16922.0
2019-11-20 06:00:00	ES	Futures	3376.37	3380.18	3373.11	3380.18	21871.0
2019-11-20 07:00:00	ES	Futures	3379.9	3381.53	3378.0	3378.82	23073.0
2019-11-20 08:00:00	ES	Futures	3378.55	3382.08	3377.46	3377.73	24533.0
2019-11-20 09:00:00	ES	Futures	3378.0	3386.42	3377.46	3384.79	140730.0
2019-11-20 10:00:00	ES	Futures	3385.07	3388.32	3380.18	3386.42	147372.0
2019-11-20 11:00:00	ES	Futures	3386.7	3388.05	3382.35	3383.16	99090.0
2019-11-20 12:00:00	ES	Futures	3383.16	3384.52	3363.33	3370.13	180940.0
2019-11-20 13:00:00	ES	Futures	3370.4	3371.48	3358.17	3368.5	305599.0
2019-11-20 14:00:00	ES	Futures	3368.5	3376.1	3364.42	3372.57	153412.0
2019-11-20 15:00:00	ES	Futures	3372.3	3378.55	3369.85	3377.19	242642.0
2019-11-20 16:00:00	ES	Futures	3377.19	3378.82	3373.93	3377.73	71132.0
2019-11-20 18:00:00	ES	Futures	3365.24	3372.3	3360.89	3370.13	21958.0
2019-11-20 19:00:00	ES	Futures	3370.4	3372.03	3361.43	3361.98	23887.0
2019-11-20 20:00:00	ES	Futures	3361.98	3364.42	3358.72	3360.62	36351.0
2019-11-20 21:00:00	ES	Futures	3360.62	3376.37	3360.35	3370.94	53206.0
2019-11-20 22:00:00	ES	Futures	3370.94	3372.03	3367.41	3370.94	12775.0
2019-11-20 23:00:00	ES	Futures	3370.94	3371.21	3368.5	3369.31	7822.0
2019-11-20 00:00:00	NQ	Futures	9664.39	9668.46	9660.03	9663.81	2698.0
2019-11-20 01:00:00	NQ	Futures	9664.1	9664.39	9659.45	9662.36	2390.0
2019-11-20 02:00:00	NQ	Futures	9662.06	9675.72	9646.96	9657.13	8854.0
2019-11-20 03:00:00	NQ	Futures	9657.71	9659.45	9640.57	9645.51	13804.0
2019-11-20 04:00:00	NQ	Futures	9645.22	9656.55	9635.63	9652.19	9485.0
2019-11-20 05:00:00	NQ	Futures	9652.19	9653.64	9639.99	9648.12	6519.0
2019-11-20 06:00:00	NQ	Futures	9648.12	9658.29	9634.47	9657.42	7568.0
2019-11-20 07:00:00	NQ	Futures	9657.42	9666.42	9653.93	9657.42	7441.0
2019-11-20 08:00:00	NQ	Futures	9657.42	9668.75	9652.19	9653.35	9765.0
2019-11-20 09:00:00	NQ	Futures	9653.06	9682.98	9651.32	9681.82	53750.0
2019-11-20 10:00:00	NQ	Futures	9681.82	9700.12	9669.91	9693.73	52689.0
2019-11-20 11:00:00	NQ	Futures	9693.73	9698.67	9667.58	9671.07	35368.0
2019-11-20 12:00:00	NQ	Futures	9671.36	9679.2	9594.38	9620.52	57086.0
2019-11-20 13:00:00	NQ	Futures	9620.81	9626.04	9564.17	9603.68	98464.0
2019-11-20 14:00:00	NQ	Futures	9603.39	9628.66	9587.99	9616.17	52912.0
2019-11-20 15:00:00	NQ	Futures	9616.17	9636.21	9601.64	9636.21	51422.0
2019-11-20 16:00:00	NQ	Futures	9635.92	9638.24	9625.17	9630.69	12855.0
2019-11-20 18:00:00	NQ	Futures	9599.61	9616.75	9577.24	9609.49	6001.0
2019-11-20 19:00:00	NQ	Futures	9609.2	9615.0	9582.18	9583.92	9426.0
2019-11-20 20:00:00	NQ	Futures	9584.21	9592.06	9574.63	9580.15	11339.0
2019-11-20 21:00:00	NQ	Futures	9580.15	9633.02	9578.98	9613.26	17467.0
2019-11-20 22:00:00	NQ	Futures	9613.55	9613.84	9597.28	9609.49	5756.0
2019-11-20 23:00:00	NQ	Futures	9609.49	9611.52	9603.97	9606.58	2933.0
2019-11-20 00:00:00	YM	Futures	30319.3	30326.9	30307.3	30320.4	977.0
2019-11-20 01:00:00	YM	Futures	30320.4	30321.5	30296.5	30304.1	904.0
2019-11-20 02:00:00	YM	Futures	30304.1	30336.7	30275.8	30288.8	4776.0
2019-11-20 03:00:00	YM	Futures	30289.9	30295.4	30221.4	30231.2	8018.0

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

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