PREVIEW / futures_1hour / 2019-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-13.parquet
  size:    62 KB
  rows:    1,869

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-08-13 00:00:00	ES	Futures	3123.67	3126.64	3122.85	3125.29	5507.0
2019-08-13 01:00:00	ES	Futures	3125.29	3126.64	3122.31	3123.67	9560.0
2019-08-13 02:00:00	ES	Futures	3123.67	3125.29	3109.05	3112.57	34793.0
2019-08-13 03:00:00	ES	Futures	3112.57	3119.61	3108.51	3111.48	41212.0
2019-08-13 04:00:00	ES	Futures	3111.75	3122.04	3110.67	3119.33	39653.0
2019-08-13 05:00:00	ES	Futures	3119.33	3119.61	3104.18	3107.96	48114.0
2019-08-13 06:00:00	ES	Futures	3107.96	3117.71	3105.53	3117.17	35427.0
2019-08-13 07:00:00	ES	Futures	3117.17	3119.33	3109.86	3111.48	29808.0
2019-08-13 08:00:00	ES	Futures	3111.48	3114.73	3104.99	3112.03	61319.0
2019-08-13 09:00:00	ES	Futures	3112.3	3178.89	3109.86	3174.83	492437.0
2019-08-13 10:00:00	ES	Futures	3174.83	3188.09	3164.54	3168.33	391091.0
2019-08-13 11:00:00	ES	Futures	3168.6	3175.64	3159.13	3174.56	270271.0
2019-08-13 12:00:00	ES	Futures	3174.83	3180.51	3168.87	3172.39	129289.0
2019-08-13 13:00:00	ES	Futures	3172.39	3177.54	3164.81	3172.39	133704.0
2019-08-13 14:00:00	ES	Futures	3172.39	3179.43	3171.04	3174.29	83004.0
2019-08-13 15:00:00	ES	Futures	3174.29	3176.18	3165.9	3169.69	193934.0
2019-08-13 16:00:00	ES	Futures	3169.69	3177.27	3168.06	3174.56	61993.0
2019-08-13 18:00:00	ES	Futures	3173.75	3176.45	3170.77	3175.1	7621.0
2019-08-13 19:00:00	ES	Futures	3175.37	3177.54	3172.66	3175.37	6802.0
2019-08-13 20:00:00	ES	Futures	3175.64	3176.72	3170.23	3172.12	16582.0
2019-08-13 21:00:00	ES	Futures	3172.39	3179.7	3168.33	3170.77	17393.0
2019-08-13 22:00:00	ES	Futures	3170.5	3171.04	3165.35	3168.06	13897.0
2019-08-13 23:00:00	ES	Futures	3168.06	3170.23	3166.44	3169.41	14017.0
2019-08-13 00:00:00	NQ	Futures	8792.48	8805.53	8790.16	8799.73	3077.0
2019-08-13 01:00:00	NQ	Futures	8799.73	8804.37	8790.45	8798.28	4826.0
2019-08-13 02:00:00	NQ	Futures	8798.28	8802.34	8742.28	8755.92	15724.0
2019-08-13 03:00:00	NQ	Futures	8755.92	8779.71	8741.12	8750.99	15257.0
2019-08-13 04:00:00	NQ	Futures	8750.99	8781.74	8750.12	8773.04	12234.0
2019-08-13 05:00:00	NQ	Futures	8773.04	8773.33	8720.52	8733.87	18604.0
2019-08-13 06:00:00	NQ	Futures	8732.71	8773.62	8725.16	8772.75	15328.0
2019-08-13 07:00:00	NQ	Futures	8772.46	8781.45	8748.66	8757.08	12463.0
2019-08-13 08:00:00	NQ	Futures	8756.5	8768.68	8739.09	8759.4	21296.0
2019-08-13 09:00:00	NQ	Futures	8759.69	9022.56	8749.54	9009.5	151069.0
2019-08-13 10:00:00	NQ	Futures	9008.63	9040.26	8968.01	8970.33	108397.0
2019-08-13 11:00:00	NQ	Futures	8970.04	8992.38	8929.42	8984.55	80385.0
2019-08-13 12:00:00	NQ	Futures	8984.84	8996.74	8961.05	8971.2	40107.0
2019-08-13 13:00:00	NQ	Futures	8971.78	8990.64	8953.22	8981.65	41738.0
2019-08-13 14:00:00	NQ	Futures	8981.65	9011.82	8977.01	8995.29	27899.0
2019-08-13 15:00:00	NQ	Futures	8995.0	8999.64	8969.17	8980.49	49077.0
2019-08-13 16:00:00	NQ	Futures	8980.78	9001.38	8975.27	8995.87	13643.0
2019-08-13 18:00:00	NQ	Futures	8990.35	9002.54	8983.68	8999.06	4151.0
2019-08-13 19:00:00	NQ	Futures	8999.35	9005.44	8991.22	9000.22	4364.0
2019-08-13 20:00:00	NQ	Futures	9000.8	9003.99	8979.33	8985.42	9676.0
2019-08-13 21:00:00	NQ	Futures	8985.42	9014.73	8973.24	8982.52	10458.0
2019-08-13 22:00:00	NQ	Futures	8982.52	8982.52	8963.37	8974.98	7312.0
2019-08-13 23:00:00	NQ	Futures	8974.98	8979.91	8966.85	8976.14	6366.0
2019-08-13 00:00:00	YM	Futures	28177.1	28197.8	28172.8	28185.8	1149.0
2019-08-13 01:00:00	YM	Futures	28186.9	28200.0	28164.1	28175.0	2139.0
2019-08-13 02:00:00	YM	Futures	28175.0	28186.9	28041.2	28069.5	7385.0
2019-08-13 03:00:00	YM	Futures	28070.6	28127.1	28031.4	28058.6	8821.0

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

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