PREVIEW / futures_1hour / 2018-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-10.parquet
  size:    54 KB
  rows:    1,678

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-07-10 00:00:00	ES	Futures	3043.18	3043.99	3042.9	3043.72	2954.0
2018-07-10 01:00:00	ES	Futures	3043.72	3044.81	3041.0	3041.27	5700.0
2018-07-10 02:00:00	ES	Futures	3041.54	3041.54	3038.82	3041.54	10434.0
2018-07-10 03:00:00	ES	Futures	3041.54	3042.36	3038.27	3039.36	10398.0
2018-07-10 04:00:00	ES	Futures	3039.36	3041.54	3038.82	3039.63	10308.0
2018-07-10 05:00:00	ES	Futures	3039.91	3043.18	3039.63	3042.63	7664.0
2018-07-10 06:00:00	ES	Futures	3042.36	3045.08	3041.81	3041.81	9795.0
2018-07-10 07:00:00	ES	Futures	3041.81	3045.63	3041.54	3043.18	12722.0
2018-07-10 08:00:00	ES	Futures	3042.9	3043.18	3038.82	3042.36	22249.0
2018-07-10 09:00:00	ES	Futures	3042.09	3044.81	3039.63	3044.27	142731.0
2018-07-10 10:00:00	ES	Futures	3043.99	3049.17	3042.09	3047.81	149161.0
2018-07-10 11:00:00	ES	Futures	3047.81	3049.17	3042.36	3047.81	90587.0
2018-07-10 12:00:00	ES	Futures	3047.54	3047.81	3043.45	3044.81	52512.0
2018-07-10 13:00:00	ES	Futures	3044.54	3045.9	3039.09	3042.36	78640.0
2018-07-10 14:00:00	ES	Futures	3042.36	3046.72	3042.09	3046.45	51531.0
2018-07-10 15:00:00	ES	Futures	3046.45	3048.9	3044.81	3046.99	125357.0
2018-07-10 16:00:00	ES	Futures	3046.72	3049.17	3030.37	3036.36	76057.0
2018-07-10 18:00:00	ES	Futures	3030.64	3037.45	3021.65	3022.2	50065.0
2018-07-10 19:00:00	ES	Futures	3022.2	3028.46	3021.65	3024.38	15995.0
2018-07-10 20:00:00	ES	Futures	3024.65	3025.47	3019.47	3020.29	18216.0
2018-07-10 21:00:00	ES	Futures	3020.29	3024.38	3014.29	3024.1	31345.0
2018-07-10 22:00:00	ES	Futures	3024.1	3029.28	3022.74	3027.65	19534.0
2018-07-10 23:00:00	ES	Futures	3027.92	3030.92	3026.28	3029.28	8703.0
2018-07-10 00:00:00	NQ	Futures	8626.45	8628.81	8624.69	8627.63	961.0
2018-07-10 01:00:00	NQ	Futures	8627.34	8629.98	8614.68	8617.91	2129.0
2018-07-10 02:00:00	NQ	Futures	8617.91	8618.8	8609.96	8617.91	3070.0
2018-07-10 03:00:00	NQ	Futures	8618.21	8621.45	8603.78	8607.9	3950.0
2018-07-10 04:00:00	NQ	Futures	8607.61	8613.5	8604.08	8610.26	3340.0
2018-07-10 05:00:00	NQ	Futures	8610.26	8624.69	8608.79	8622.04	3346.0
2018-07-10 06:00:00	NQ	Futures	8622.04	8627.92	8614.68	8616.44	3295.0
2018-07-10 07:00:00	NQ	Futures	8616.44	8626.75	8612.91	8612.91	4330.0
2018-07-10 08:00:00	NQ	Futures	8612.91	8617.03	8602.02	8604.66	10885.0
2018-07-10 09:00:00	NQ	Futures	8604.66	8611.14	8583.17	8590.24	53681.0
2018-07-10 10:00:00	NQ	Futures	8590.24	8616.74	8585.82	8609.08	50392.0
2018-07-10 11:00:00	NQ	Futures	8608.79	8617.62	8593.77	8612.61	28659.0
2018-07-10 12:00:00	NQ	Futures	8612.91	8613.5	8602.9	8605.55	13718.0
2018-07-10 13:00:00	NQ	Futures	8605.55	8609.38	8568.75	8581.11	28928.0
2018-07-10 14:00:00	NQ	Futures	8581.41	8602.6	8581.11	8601.13	23310.0
2018-07-10 15:00:00	NQ	Futures	8601.43	8603.78	8587.88	8598.19	26245.0
2018-07-10 16:00:00	NQ	Futures	8597.89	8602.9	8549.31	8565.21	9404.0
2018-07-10 18:00:00	NQ	Futures	8554.02	8564.92	8529.29	8530.47	8224.0
2018-07-10 19:00:00	NQ	Futures	8529.88	8546.08	8527.53	8530.77	4537.0
2018-07-10 20:00:00	NQ	Futures	8531.06	8535.48	8515.46	8517.81	6545.0
2018-07-10 21:00:00	NQ	Futures	8517.81	8518.11	8484.54	8513.4	15764.0
2018-07-10 22:00:00	NQ	Futures	8513.1	8527.82	8507.51	8523.99	9645.0
2018-07-10 23:00:00	NQ	Futures	8524.29	8531.65	8520.46	8529.59	2938.0
2018-07-10 00:00:00	YM	Futures	27011.1	27017.6	27006.7	27014.3	637.0
2018-07-10 01:00:00	YM	Futures	27013.2	27023.0	26980.6	26983.9	1447.0
2018-07-10 02:00:00	YM	Futures	26982.8	26992.6	26961.1	26989.3	2258.0
2018-07-10 03:00:00	YM	Futures	26990.4	26998.0	26950.2	26961.1	2761.0

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

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