PREVIEW / futures_1hour / 2018-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-12.parquet
  size:    49 KB
  rows:    1,407

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-10-12 00:00:00	ES	Futures	3011.56	3017.28	3008.84	3017.28	13266.0
2018-10-12 01:00:00	ES	Futures	3017.0	3025.16	3016.19	3020.54	24005.0
2018-10-12 02:00:00	ES	Futures	3020.54	3030.06	3016.46	3029.24	33174.0
2018-10-12 03:00:00	ES	Futures	3029.24	3029.52	3021.36	3024.08	37974.0
2018-10-12 04:00:00	ES	Futures	3024.35	3024.35	3009.93	3011.29	40168.0
2018-10-12 05:00:00	ES	Futures	3011.02	3016.19	3007.21	3013.47	37397.0
2018-10-12 06:00:00	ES	Futures	3013.47	3019.45	3008.57	3018.36	34471.0
2018-10-12 07:00:00	ES	Futures	3018.36	3021.9	3013.74	3015.64	38605.0
2018-10-12 08:00:00	ES	Futures	3015.64	3022.99	3013.74	3016.73	50935.0
2018-10-12 09:00:00	ES	Futures	3016.73	3023.8	3008.57	3019.18	311257.0
2018-10-12 10:00:00	ES	Futures	3019.18	3022.44	3002.04	3013.74	334614.0
2018-10-12 11:00:00	ES	Futures	3014.01	3018.09	2993.07	3000.14	232946.0
2018-10-12 12:00:00	ES	Futures	3000.14	3000.41	2972.67	2985.45	289992.0
2018-10-12 13:00:00	ES	Futures	2985.45	2998.51	2978.11	2988.44	269527.0
2018-10-12 14:00:00	ES	Futures	2988.44	2996.88	2975.39	2995.24	257650.0
2018-10-12 15:00:00	ES	Futures	2994.97	3023.53	2988.99	3012.38	484207.0
2018-10-12 16:00:00	ES	Futures	3012.38	3017.0	3007.76	3016.19	113491.0
2018-10-12 00:00:00	NQ	Futures	8330.42	8356.81	8318.68	8356.23	5928.0
2018-10-12 01:00:00	NQ	Futures	8356.52	8381.16	8350.95	8365.03	8627.0
2018-10-12 02:00:00	NQ	Futures	8365.32	8407.85	8351.83	8405.21	11959.0
2018-10-12 03:00:00	NQ	Futures	8404.92	8411.08	8380.57	8392.89	13636.0
2018-10-12 04:00:00	NQ	Futures	8392.89	8393.18	8344.2	8349.77	13899.0
2018-10-12 05:00:00	NQ	Futures	8349.48	8385.56	8341.85	8372.07	12544.0
2018-10-12 06:00:00	NQ	Futures	8372.36	8391.13	8350.65	8384.38	10166.0
2018-10-12 07:00:00	NQ	Futures	8384.38	8390.54	8362.39	8369.43	13234.0
2018-10-12 08:00:00	NQ	Futures	8370.01	8392.01	8358.28	8369.13	19019.0
2018-10-12 09:00:00	NQ	Futures	8370.01	8416.06	8350.95	8387.61	97006.0
2018-10-12 10:00:00	NQ	Futures	8387.32	8418.12	8352.41	8379.99	97639.0
2018-10-12 11:00:00	NQ	Futures	8380.28	8398.17	8313.11	8334.81	67959.0
2018-10-12 12:00:00	NQ	Futures	8334.23	8338.04	8253.86	8311.64	92833.0
2018-10-12 13:00:00	NQ	Futures	8312.23	8352.12	8293.75	8331.59	86081.0
2018-10-12 14:00:00	NQ	Futures	8331.0	8363.85	8284.95	8355.93	63567.0
2018-10-12 15:00:00	NQ	Futures	8355.05	8444.81	8340.97	8420.17	92993.0
2018-10-12 16:00:00	NQ	Futures	8420.76	8430.14	8399.64	8429.56	16597.0
2018-10-12 00:00:00	YM	Futures	27608.3	27648.5	27575.7	27647.4	3765.0
2018-10-12 01:00:00	YM	Futures	27647.4	27726.7	27638.7	27673.5	5882.0
2018-10-12 02:00:00	YM	Futures	27674.6	27755.0	27634.4	27736.5	8285.0
2018-10-12 03:00:00	YM	Futures	27736.5	27736.5	27644.1	27670.2	9536.0
2018-10-12 04:00:00	YM	Futures	27669.1	27670.2	27549.6	27563.7	11095.0
2018-10-12 05:00:00	YM	Futures	27562.6	27601.8	27521.4	27568.1	9955.0
2018-10-12 06:00:00	YM	Futures	27568.1	27634.4	27518.1	27622.4	8388.0
2018-10-12 07:00:00	YM	Futures	27622.4	27665.9	27594.2	27610.5	8745.0
2018-10-12 08:00:00	YM	Futures	27611.5	27665.9	27573.5	27603.9	14389.0
2018-10-12 09:00:00	YM	Futures	27605.0	27670.2	27522.4	27590.9	49527.0
2018-10-12 10:00:00	YM	Futures	27590.9	27596.3	27406.2	27515.9	48217.0
2018-10-12 11:00:00	YM	Futures	27515.9	27573.5	27319.3	27389.9	34689.0
2018-10-12 12:00:00	YM	Futures	27391.0	27394.2	27151.9	27286.7	46155.0
2018-10-12 13:00:00	YM	Futures	27285.6	27412.7	27208.4	27328.0	41500.0
2018-10-12 14:00:00	YM	Futures	27324.7	27377.9	27187.8	27355.1	44644.0
2018-10-12 15:00:00	YM	Futures	27357.3	27602.8	27294.3	27513.8	55389.0

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

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