PREVIEW / futures_1hour / 2019-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-14.parquet
  size:    57 KB
  rows:    1,785

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-02-14 00:00:00	ES	Futures	2990.42	2992.32	2989.6	2991.23	4431.0
2019-02-14 01:00:00	ES	Futures	2991.23	2995.58	2991.23	2995.03	6121.0
2019-02-14 02:00:00	ES	Futures	2995.31	3001.55	2995.03	2999.92	14440.0
2019-02-14 03:00:00	ES	Futures	2999.92	3000.19	2994.22	2995.31	22281.0
2019-02-14 04:00:00	ES	Futures	2995.03	2997.75	2993.68	2994.22	15902.0
2019-02-14 05:00:00	ES	Futures	2994.22	2996.12	2992.05	2994.76	12096.0
2019-02-14 06:00:00	ES	Futures	2994.49	2997.21	2994.49	2995.58	10771.0
2019-02-14 07:00:00	ES	Futures	2995.31	2998.57	2994.22	2997.48	12546.0
2019-02-14 08:00:00	ES	Futures	2997.48	2998.84	2977.92	2978.74	82954.0
2019-02-14 09:00:00	ES	Futures	2978.47	2979.01	2965.98	2975.75	312663.0
2019-02-14 10:00:00	ES	Futures	2975.75	2985.53	2971.68	2978.47	363693.0
2019-02-14 11:00:00	ES	Futures	2978.2	2982.81	2972.49	2982.0	169325.0
2019-02-14 12:00:00	ES	Futures	2982.0	2993.13	2980.37	2990.42	140267.0
2019-02-14 13:00:00	ES	Futures	2990.42	2991.5	2987.16	2988.79	69829.0
2019-02-14 14:00:00	ES	Futures	2988.79	2992.32	2985.53	2987.16	87700.0
2019-02-14 15:00:00	ES	Futures	2987.43	2996.39	2981.18	2982.54	207800.0
2019-02-14 16:00:00	ES	Futures	2982.54	2983.9	2977.92	2977.92	57355.0
2019-02-14 18:00:00	ES	Futures	2977.92	2981.46	2975.48	2979.83	13269.0
2019-02-14 19:00:00	ES	Futures	2979.83	2980.1	2972.22	2974.12	19439.0
2019-02-14 20:00:00	ES	Futures	2973.85	2977.38	2973.04	2975.48	11244.0
2019-02-14 21:00:00	ES	Futures	2975.21	2975.48	2968.96	2969.78	10945.0
2019-02-14 22:00:00	ES	Futures	2969.78	2971.14	2968.96	2970.59	5340.0
2019-02-14 23:00:00	ES	Futures	2970.59	2971.14	2969.23	2969.51	3045.0
2019-02-14 00:00:00	NQ	Futures	8211.98	8221.62	8210.52	8215.78	1538.0
2019-02-14 01:00:00	NQ	Futures	8216.07	8231.56	8215.49	8227.47	2673.0
2019-02-14 02:00:00	NQ	Futures	8228.34	8248.5	8226.3	8245.0	5409.0
2019-02-14 03:00:00	NQ	Futures	8245.29	8246.17	8229.8	8231.85	6499.0
2019-02-14 04:00:00	NQ	Futures	8232.14	8240.03	8227.47	8231.27	3915.0
2019-02-14 05:00:00	NQ	Futures	8230.97	8236.53	8221.62	8228.34	4999.0
2019-02-14 06:00:00	NQ	Futures	8228.64	8236.82	8228.64	8230.68	3515.0
2019-02-14 07:00:00	NQ	Futures	8230.39	8239.74	8227.76	8236.53	5279.0
2019-02-14 08:00:00	NQ	Futures	8236.23	8246.46	8178.67	8182.47	25383.0
2019-02-14 09:00:00	NQ	Futures	8182.47	8194.16	8148.58	8191.53	91061.0
2019-02-14 10:00:00	NQ	Futures	8191.53	8216.36	8169.03	8192.7	97947.0
2019-02-14 11:00:00	NQ	Futures	8192.7	8209.94	8174.29	8204.38	53117.0
2019-02-14 12:00:00	NQ	Futures	8204.68	8240.32	8198.83	8233.9	45195.0
2019-02-14 13:00:00	NQ	Futures	8234.19	8238.28	8221.04	8223.96	24116.0
2019-02-14 14:00:00	NQ	Futures	8224.25	8237.11	8216.36	8221.33	28301.0
2019-02-14 15:00:00	NQ	Futures	8221.62	8245.58	8211.1	8214.03	53988.0
2019-02-14 16:00:00	NQ	Futures	8214.03	8218.99	8199.12	8201.46	13052.0
2019-02-14 18:00:00	NQ	Futures	8201.75	8210.23	8195.03	8204.68	3162.0
2019-02-14 19:00:00	NQ	Futures	8204.68	8205.85	8180.42	8187.15	6287.0
2019-02-14 20:00:00	NQ	Futures	8187.15	8196.79	8183.35	8189.77	4375.0
2019-02-14 21:00:00	NQ	Futures	8190.07	8190.07	8170.78	8172.54	4493.0
2019-02-14 22:00:00	NQ	Futures	8172.54	8175.17	8166.11	8173.12	2608.0
2019-02-14 23:00:00	NQ	Futures	8173.12	8176.33	8170.2	8170.49	1490.0
2019-02-14 00:00:00	YM	Futures	27710.5	27733.3	27702.9	27725.7	1432.0
2019-02-14 01:00:00	YM	Futures	27725.7	27761.5	27723.5	27753.9	1706.0
2019-02-14 02:00:00	YM	Futures	27755.0	27818.0	27755.0	27800.6	3619.0
2019-02-14 03:00:00	YM	Futures	27801.7	27803.9	27751.8	27762.6	5077.0

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

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