PREVIEW / futures_1hour / 2018-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-08.parquet
  size:    47 KB
  rows:    1,388

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-06-08 00:00:00	ES	Futures	3023.55	3024.64	3021.91	3023.28	1721.0
2018-06-08 01:00:00	ES	Futures	3023.28	3023.55	3018.91	3019.18	4961.0
2018-06-08 02:00:00	ES	Futures	3019.18	3020.82	3016.18	3019.45	11058.0
2018-06-08 03:00:00	ES	Futures	3019.73	3020.55	3011.81	3013.72	28368.0
2018-06-08 04:00:00	ES	Futures	3013.45	3014.0	3004.17	3008.54	27186.0
2018-06-08 05:00:00	ES	Futures	3008.54	3011.81	3007.45	3008.54	14646.0
2018-06-08 06:00:00	ES	Futures	3008.54	3013.45	3007.45	3009.9	11863.0
2018-06-08 07:00:00	ES	Futures	3009.9	3017.82	3009.9	3015.91	17481.0
2018-06-08 08:00:00	ES	Futures	3015.91	3020.82	3015.36	3017.54	20516.0
2018-06-08 09:00:00	ES	Futures	3017.54	3023.55	3016.45	3023.28	109391.0
2018-06-08 10:00:00	ES	Futures	3023.28	3023.82	3016.45	3022.46	92653.0
2018-06-08 11:00:00	ES	Futures	3022.46	3024.91	3018.64	3022.73	77309.0
2018-06-08 12:00:00	ES	Futures	3022.73	3030.92	3022.46	3029.28	55873.0
2018-06-08 13:00:00	ES	Futures	3029.28	3030.37	3025.19	3027.64	47888.0
2018-06-08 14:00:00	ES	Futures	3027.64	3032.28	3027.37	3029.83	37170.0
2018-06-08 15:00:00	ES	Futures	3030.1	3033.92	3027.64	3033.37	96032.0
2018-06-08 16:00:00	ES	Futures	3033.1	3034.46	3032.01	3033.92	35796.0
2018-06-08 00:00:00	NQ	Futures	8445.13	8450.74	8440.99	8445.42	841.0
2018-06-08 01:00:00	NQ	Futures	8445.42	8446.01	8430.94	8432.12	1388.0
2018-06-08 02:00:00	NQ	Futures	8432.12	8438.92	8422.67	8436.85	2224.0
2018-06-08 03:00:00	NQ	Futures	8437.44	8441.28	8408.48	8411.44	5811.0
2018-06-08 04:00:00	NQ	Futures	8411.14	8411.73	8366.81	8384.54	9162.0
2018-06-08 05:00:00	NQ	Futures	8385.13	8393.11	8376.27	8382.18	3685.0
2018-06-08 06:00:00	NQ	Futures	8381.88	8399.91	8372.13	8380.4	4143.0
2018-06-08 07:00:00	NQ	Futures	8380.4	8406.71	8380.4	8398.73	4016.0
2018-06-08 08:00:00	NQ	Futures	8399.02	8418.82	8396.66	8408.18	6582.0
2018-06-08 09:00:00	NQ	Futures	8408.18	8434.49	8402.87	8433.9	27916.0
2018-06-08 10:00:00	NQ	Futures	8433.6	8437.74	8394.0	8424.73	30135.0
2018-06-08 11:00:00	NQ	Futures	8424.73	8445.42	8416.46	8431.83	21736.0
2018-06-08 12:00:00	NQ	Futures	8432.12	8456.95	8431.53	8452.51	11574.0
2018-06-08 13:00:00	NQ	Futures	8452.51	8455.77	8439.51	8446.31	7509.0
2018-06-08 14:00:00	NQ	Futures	8447.2	8463.15	8446.9	8456.06	6701.0
2018-06-08 15:00:00	NQ	Futures	8456.65	8467.59	8450.15	8455.47	13251.0
2018-06-08 16:00:00	NQ	Futures	8455.17	8458.13	8447.79	8453.7	4882.0
2018-06-08 00:00:00	YM	Futures	27419.9	27427.5	27404.7	27415.6	527.0
2018-06-08 01:00:00	YM	Futures	27414.5	27416.7	27370.0	27377.6	1584.0
2018-06-08 02:00:00	YM	Futures	27376.5	27380.8	27331.9	27350.4	3304.0
2018-06-08 03:00:00	YM	Futures	27350.4	27363.4	27284.2	27298.3	5877.0
2018-06-08 04:00:00	YM	Futures	27297.2	27305.9	27233.1	27272.2	5374.0
2018-06-08 05:00:00	YM	Futures	27271.1	27311.3	27262.4	27272.2	2540.0
2018-06-08 06:00:00	YM	Futures	27273.3	27311.3	27257.0	27280.9	1843.0
2018-06-08 07:00:00	YM	Futures	27279.8	27353.7	27279.8	27341.7	2916.0
2018-06-08 08:00:00	YM	Futures	27339.5	27380.8	27337.4	27350.4	3964.0
2018-06-08 09:00:00	YM	Futures	27350.4	27401.5	27326.5	27384.1	14435.0
2018-06-08 10:00:00	YM	Futures	27386.2	27437.3	27358.0	27415.6	11662.0
2018-06-08 11:00:00	YM	Futures	27413.4	27434.0	27364.5	27416.7	6783.0
2018-06-08 12:00:00	YM	Futures	27416.7	27500.3	27415.6	27473.1	5565.0
2018-06-08 13:00:00	YM	Futures	27472.0	27474.2	27423.2	27449.2	5612.0
2018-06-08 14:00:00	YM	Futures	27449.2	27484.0	27444.9	27462.3	3529.0
2018-06-08 15:00:00	YM	Futures	27462.3	27507.9	27440.5	27491.6	7486.0

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

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