PREVIEW / futures_1hour / 2019-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-04.parquet
  size:    59 KB
  rows:    1,837

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-12-04 00:00:00	ES	Futures	3361.43	3361.98	3360.08	3360.62	11772.0
2019-12-04 01:00:00	ES	Futures	3360.62	3362.25	3359.8	3361.43	8310.0
2019-12-04 02:00:00	ES	Futures	3361.43	3361.7	3348.94	3349.21	34378.0
2019-12-04 03:00:00	ES	Futures	3349.48	3357.36	3348.4	3356.82	46446.0
2019-12-04 04:00:00	ES	Futures	3356.54	3377.46	3356.54	3375.56	129173.0
2019-12-04 05:00:00	ES	Futures	3375.56	3375.83	3370.13	3370.4	33693.0
2019-12-04 06:00:00	ES	Futures	3370.4	3375.56	3370.13	3375.56	15648.0
2019-12-04 07:00:00	ES	Futures	3375.29	3376.37	3372.84	3374.2	20501.0
2019-12-04 08:00:00	ES	Futures	3374.2	3375.83	3369.31	3372.84	47761.0
2019-12-04 09:00:00	ES	Futures	3372.84	3386.15	3369.58	3384.25	228977.0
2019-12-04 10:00:00	ES	Futures	3383.98	3387.24	3380.99	3385.88	209715.0
2019-12-04 11:00:00	ES	Futures	3385.88	3387.78	3381.81	3383.71	107995.0
2019-12-04 12:00:00	ES	Futures	3383.71	3385.07	3380.72	3384.52	72409.0
2019-12-04 13:00:00	ES	Futures	3384.79	3385.07	3382.08	3384.79	49342.0
2019-12-04 14:00:00	ES	Futures	3384.79	3389.41	3384.25	3388.32	64250.0
2019-12-04 15:00:00	ES	Futures	3388.05	3388.6	3381.26	3382.35	169048.0
2019-12-04 16:00:00	ES	Futures	3382.35	3383.16	3377.19	3379.9	84264.0
2019-12-04 18:00:00	ES	Futures	3380.18	3382.08	3378.27	3378.55	7629.0
2019-12-04 19:00:00	ES	Futures	3378.27	3380.99	3377.46	3378.55	15052.0
2019-12-04 20:00:00	ES	Futures	3378.55	3384.79	3376.1	3379.09	22580.0
2019-12-04 21:00:00	ES	Futures	3379.36	3381.26	3378.27	3378.82	9708.0
2019-12-04 22:00:00	ES	Futures	3378.55	3379.36	3377.19	3379.09	5255.0
2019-12-04 23:00:00	ES	Futures	3379.09	3380.72	3378.82	3379.9	4595.0
2019-12-04 00:00:00	NQ	Futures	9601.93	9605.13	9596.7	9599.03	7900.0
2019-12-04 01:00:00	NQ	Futures	9599.32	9604.55	9594.96	9601.64	4173.0
2019-12-04 02:00:00	NQ	Futures	9601.93	9602.51	9554.29	9555.45	13251.0
2019-12-04 03:00:00	NQ	Futures	9555.45	9583.63	9551.97	9582.76	13707.0
2019-12-04 04:00:00	NQ	Futures	9581.89	9660.9	9581.89	9652.19	31545.0
2019-12-04 05:00:00	NQ	Futures	9651.9	9652.77	9635.92	9636.79	11890.0
2019-12-04 06:00:00	NQ	Futures	9636.79	9650.74	9636.5	9650.74	5431.0
2019-12-04 07:00:00	NQ	Futures	9650.74	9654.8	9640.28	9645.51	6922.0
2019-12-04 08:00:00	NQ	Futures	9645.8	9651.32	9623.43	9640.28	17701.0
2019-12-04 09:00:00	NQ	Futures	9640.57	9665.26	9629.82	9658.58	59074.0
2019-12-04 10:00:00	NQ	Futures	9658.29	9666.71	9642.89	9659.45	54096.0
2019-12-04 11:00:00	NQ	Futures	9659.16	9666.13	9645.8	9648.7	32447.0
2019-12-04 12:00:00	NQ	Futures	9648.7	9654.51	9637.66	9651.03	25626.0
2019-12-04 13:00:00	NQ	Futures	9651.32	9652.77	9640.28	9647.54	14835.0
2019-12-04 14:00:00	NQ	Futures	9647.25	9663.52	9646.38	9660.61	20353.0
2019-12-04 15:00:00	NQ	Futures	9660.9	9662.06	9639.99	9642.02	34085.0
2019-12-04 16:00:00	NQ	Futures	9642.02	9646.38	9628.08	9640.28	11875.0
2019-12-04 18:00:00	NQ	Futures	9639.99	9648.41	9633.31	9633.89	4282.0
2019-12-04 19:00:00	NQ	Futures	9633.6	9642.6	9631.56	9635.92	8351.0
2019-12-04 20:00:00	NQ	Futures	9635.92	9655.67	9627.21	9637.08	10320.0
2019-12-04 21:00:00	NQ	Futures	9637.66	9644.93	9634.76	9635.63	5759.0
2019-12-04 22:00:00	NQ	Futures	9635.34	9637.95	9630.11	9635.63	3043.0
2019-12-04 23:00:00	NQ	Futures	9635.92	9640.86	9635.34	9638.53	2145.0
2019-12-04 00:00:00	YM	Futures	29933.0	29937.3	29919.9	29926.4	1606.0
2019-12-04 01:00:00	YM	Futures	29927.5	29939.5	29913.4	29929.7	1268.0
2019-12-04 02:00:00	YM	Futures	29930.8	29930.8	29821.9	29826.3	6133.0
2019-12-04 03:00:00	YM	Futures	29826.3	29895.9	29817.6	29892.7	7287.0

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

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