PREVIEW / futures_1hour / 2020-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-19.parquet
  size:    61 KB
  rows:    1,866

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
2020-05-19 00:00:00	ES	Futures	3227.11	3239.19	3227.11	3238.09	10177.0
2020-05-19 01:00:00	ES	Futures	3237.81	3239.19	3230.41	3233.15	7904.0
2020-05-19 02:00:00	ES	Futures	3232.87	3266.9	3230.41	3262.51	34742.0
2020-05-19 03:00:00	ES	Futures	3262.51	3263.06	3236.99	3239.19	54682.0
2020-05-19 04:00:00	ES	Futures	3239.19	3241.93	3218.61	3230.41	47832.0
2020-05-19 05:00:00	ES	Futures	3230.13	3232.33	3221.35	3225.47	20941.0
2020-05-19 06:00:00	ES	Futures	3225.47	3227.11	3216.96	3222.72	26146.0
2020-05-19 07:00:00	ES	Futures	3223.0	3235.89	3222.17	3228.21	25190.0
2020-05-19 08:00:00	ES	Futures	3228.21	3231.78	3221.62	3229.86	40724.0
2020-05-19 09:00:00	ES	Futures	3229.58	3231.5	3218.06	3230.41	168961.0
2020-05-19 10:00:00	ES	Futures	3230.41	3243.58	3225.19	3237.27	214816.0
2020-05-19 11:00:00	ES	Futures	3237.27	3245.22	3233.7	3238.91	133122.0
2020-05-19 12:00:00	ES	Futures	3239.19	3241.66	3230.95	3236.44	77350.0
2020-05-19 13:00:00	ES	Futures	3236.72	3241.66	3233.42	3240.01	52843.0
2020-05-19 14:00:00	ES	Futures	3239.74	3247.42	3219.98	3223.54	122546.0
2020-05-19 15:00:00	ES	Futures	3223.54	3243.3	3200.49	3201.32	339833.0
2020-05-19 16:00:00	ES	Futures	3201.32	3205.71	3198.85	3201.87	76022.0
2020-05-19 18:00:00	ES	Futures	3198.02	3204.34	3192.54	3203.79	18731.0
2020-05-19 19:00:00	ES	Futures	3203.51	3211.2	3203.51	3208.73	11924.0
2020-05-19 20:00:00	ES	Futures	3208.45	3215.86	3208.18	3213.94	14764.0
2020-05-19 21:00:00	ES	Futures	3213.94	3224.37	3213.94	3223.82	15245.0
2020-05-19 22:00:00	ES	Futures	3223.82	3223.82	3219.43	3220.25	8964.0
2020-05-19 23:00:00	ES	Futures	3220.53	3223.54	3215.04	3222.17	7618.0
2020-05-19 00:00:00	NQ	Futures	10642.68	10678.96	10641.54	10675.53	4669.0
2020-05-19 01:00:00	NQ	Futures	10674.39	10678.96	10646.11	10660.68	4272.0
2020-05-19 02:00:00	NQ	Futures	10660.39	10759.8	10650.11	10746.94	11497.0
2020-05-19 03:00:00	NQ	Futures	10746.37	10748.09	10668.96	10676.1	16886.0
2020-05-19 04:00:00	NQ	Futures	10676.1	10687.82	10626.97	10665.82	13560.0
2020-05-19 05:00:00	NQ	Futures	10665.54	10674.39	10637.54	10644.11	7728.0
2020-05-19 06:00:00	NQ	Futures	10644.4	10654.68	10615.55	10641.26	8606.0
2020-05-19 07:00:00	NQ	Futures	10641.54	10682.39	10639.83	10656.97	8973.0
2020-05-19 08:00:00	NQ	Futures	10657.25	10674.68	10647.54	10667.25	13051.0
2020-05-19 09:00:00	NQ	Futures	10666.96	10716.67	10641.83	10707.81	50201.0
2020-05-19 10:00:00	NQ	Futures	10707.53	10738.37	10696.1	10732.38	49985.0
2020-05-19 11:00:00	NQ	Futures	10732.09	10746.66	10709.24	10726.66	31969.0
2020-05-19 12:00:00	NQ	Futures	10726.95	10736.09	10701.81	10732.95	20443.0
2020-05-19 13:00:00	NQ	Futures	10732.66	10750.09	10718.38	10743.23	14716.0
2020-05-19 14:00:00	NQ	Futures	10743.8	10758.94	10677.82	10685.25	28813.0
2020-05-19 15:00:00	NQ	Futures	10685.53	10748.66	10612.12	10615.83	70120.0
2020-05-19 16:00:00	NQ	Futures	10615.83	10631.54	10607.27	10622.4	11629.0
2020-05-19 18:00:00	NQ	Futures	10614.12	10634.12	10594.98	10628.97	5557.0
2020-05-19 19:00:00	NQ	Futures	10630.12	10652.68	10630.12	10645.54	3306.0
2020-05-19 20:00:00	NQ	Futures	10646.97	10662.97	10637.54	10655.82	4152.0
2020-05-19 21:00:00	NQ	Futures	10656.68	10684.1	10651.54	10681.53	4627.0
2020-05-19 22:00:00	NQ	Futures	10681.53	10682.1	10668.11	10673.53	3097.0
2020-05-19 23:00:00	NQ	Futures	10673.53	10678.39	10660.39	10675.25	2766.0
2020-05-19 00:00:00	YM	Futures	26789.3	26898.8	26788.2	26890.0	2646.0
2020-05-19 01:00:00	YM	Futures	26890.0	26898.8	26818.8	26837.5	2118.0
2020-05-19 02:00:00	YM	Futures	26835.3	27125.5	26813.4	27092.7	8391.0
2020-05-19 03:00:00	YM	Futures	27092.7	27094.9	26880.2	26899.9	11727.0

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

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