PREVIEW / futures_1hour / 2018-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-22.parquet
  size:    55 KB
  rows:    1,699

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-22 00:00:00	ES	Futures	3015.1	3016.73	3011.84	3015.1	10248.0
2018-10-22 01:00:00	ES	Futures	3015.1	3018.36	3013.47	3017.28	10276.0
2018-10-22 02:00:00	ES	Futures	3017.55	3022.44	3016.46	3020.54	21232.0
2018-10-22 03:00:00	ES	Futures	3020.27	3023.8	3019.45	3020.54	25363.0
2018-10-22 04:00:00	ES	Futures	3020.27	3020.81	3013.2	3015.1	21017.0
2018-10-22 05:00:00	ES	Futures	3015.1	3018.91	3013.2	3015.1	17464.0
2018-10-22 06:00:00	ES	Futures	3014.83	3021.63	3012.38	3020.54	17666.0
2018-10-22 07:00:00	ES	Futures	3020.54	3026.8	3020.0	3024.08	22390.0
2018-10-22 08:00:00	ES	Futures	3023.8	3025.44	3021.08	3021.36	24947.0
2018-10-22 09:00:00	ES	Futures	3021.36	3025.16	3000.14	3003.4	202865.0
2018-10-22 10:00:00	ES	Futures	3003.4	3018.91	2993.07	3014.83	284538.0
2018-10-22 11:00:00	ES	Futures	3014.56	3016.73	2998.51	3001.5	186649.0
2018-10-22 12:00:00	ES	Futures	3001.5	3008.57	2994.97	3003.4	140395.0
2018-10-22 13:00:00	ES	Futures	3003.4	3009.93	3000.14	3000.41	113987.0
2018-10-22 14:00:00	ES	Futures	3000.14	3008.3	2998.78	3005.31	120853.0
2018-10-22 15:00:00	ES	Futures	3005.31	3011.84	2999.6	3000.14	230752.0
2018-10-22 16:00:00	ES	Futures	3000.14	3001.23	2997.69	2999.32	58068.0
2018-10-22 18:00:00	ES	Futures	2998.24	3000.14	2996.33	2999.32	5142.0
2018-10-22 19:00:00	ES	Futures	2999.32	3000.14	2992.52	2994.16	8428.0
2018-10-22 20:00:00	ES	Futures	2994.43	2995.52	2979.2	2983.0	30280.0
2018-10-22 21:00:00	ES	Futures	2983.0	2987.9	2981.1	2983.28	19160.0
2018-10-22 22:00:00	ES	Futures	2983.28	2984.91	2975.93	2978.38	21969.0
2018-10-22 23:00:00	ES	Futures	2978.38	2978.92	2971.85	2975.39	22083.0
2018-10-22 00:00:00	NQ	Futures	8369.13	8372.95	8360.92	8367.96	5016.0
2018-10-22 01:00:00	NQ	Futures	8368.25	8375.29	8358.57	8370.31	6156.0
2018-10-22 02:00:00	NQ	Futures	8370.6	8385.56	8365.61	8381.45	8308.0
2018-10-22 03:00:00	NQ	Futures	8382.04	8397.58	8378.52	8391.42	10969.0
2018-10-22 04:00:00	NQ	Futures	8391.72	8394.06	8367.96	8371.77	9516.0
2018-10-22 05:00:00	NQ	Futures	8372.36	8387.9	8367.96	8374.41	6935.0
2018-10-22 06:00:00	NQ	Futures	8374.12	8399.05	8367.37	8394.65	7058.0
2018-10-22 07:00:00	NQ	Futures	8394.06	8420.17	8389.08	8411.08	7726.0
2018-10-22 08:00:00	NQ	Futures	8410.78	8416.36	8398.76	8401.98	14308.0
2018-10-22 09:00:00	NQ	Futures	8401.98	8427.5	8331.59	8345.96	89411.0
2018-10-22 10:00:00	NQ	Futures	8346.25	8459.77	8330.71	8441.58	130615.0
2018-10-22 11:00:00	NQ	Futures	8441.29	8457.13	8389.08	8402.86	88162.0
2018-10-22 12:00:00	NQ	Futures	8403.45	8427.8	8375.88	8411.96	58500.0
2018-10-22 13:00:00	NQ	Futures	8411.66	8433.37	8389.66	8389.66	42452.0
2018-10-22 14:00:00	NQ	Futures	8389.96	8421.34	8384.68	8413.13	40991.0
2018-10-22 15:00:00	NQ	Futures	8412.84	8445.69	8394.65	8395.53	56646.0
2018-10-22 16:00:00	NQ	Futures	8395.82	8400.81	8388.78	8399.34	9036.0
2018-10-22 18:00:00	NQ	Futures	8394.65	8400.22	8388.49	8397.0	2062.0
2018-10-22 19:00:00	NQ	Futures	8397.58	8399.93	8371.48	8377.05	4157.0
2018-10-22 20:00:00	NQ	Futures	8377.35	8381.45	8332.76	8355.35	12856.0
2018-10-22 21:00:00	NQ	Futures	8355.05	8369.13	8341.85	8346.55	9517.0
2018-10-22 22:00:00	NQ	Futures	8346.25	8353.59	8324.84	8336.28	7374.0
2018-10-22 23:00:00	NQ	Futures	8336.28	8339.21	8307.83	8321.91	7144.0
2018-10-22 00:00:00	YM	Futures	27663.7	27676.7	27627.8	27657.2	2291.0
2018-10-22 01:00:00	YM	Futures	27656.1	27686.5	27645.2	27673.5	2462.0
2018-10-22 02:00:00	YM	Futures	27674.6	27723.4	27667.0	27709.3	3822.0
2018-10-22 03:00:00	YM	Futures	27709.3	27748.4	27698.5	27710.4	5229.0

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

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