PREVIEW / futures_1hour / 2019-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-13.parquet
  size:    56 KB
  rows:    1,774

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-13 00:00:00	ES	Futures	2990.96	2993.13	2990.69	2992.32	4433.0
2019-02-13 01:00:00	ES	Futures	2992.32	2995.03	2991.78	2992.86	6910.0
2019-02-13 02:00:00	ES	Futures	2993.13	2993.41	2989.87	2990.96	9015.0
2019-02-13 03:00:00	ES	Futures	2990.69	2991.23	2988.24	2988.24	17113.0
2019-02-13 04:00:00	ES	Futures	2988.24	2989.33	2984.17	2985.53	14637.0
2019-02-13 05:00:00	ES	Futures	2985.53	2987.16	2983.9	2986.89	11010.0
2019-02-13 06:00:00	ES	Futures	2986.62	2989.87	2984.99	2989.6	21510.0
2019-02-13 07:00:00	ES	Futures	2989.6	2990.69	2988.52	2989.06	15123.0
2019-02-13 08:00:00	ES	Futures	2989.06	2992.32	2985.26	2991.5	27882.0
2019-02-13 09:00:00	ES	Futures	2991.78	3000.47	2988.79	2995.85	196868.0
2019-02-13 10:00:00	ES	Futures	2995.85	2999.38	2991.23	2996.66	195790.0
2019-02-13 11:00:00	ES	Futures	2996.66	2999.38	2985.26	2990.42	165724.0
2019-02-13 12:00:00	ES	Futures	2990.42	2990.96	2985.8	2988.52	79135.0
2019-02-13 13:00:00	ES	Futures	2988.52	2991.23	2987.7	2989.87	44752.0
2019-02-13 14:00:00	ES	Futures	2989.87	2995.58	2989.6	2994.76	61895.0
2019-02-13 15:00:00	ES	Futures	2994.49	2998.02	2988.52	2989.6	183093.0
2019-02-13 16:00:00	ES	Futures	2989.6	2989.87	2986.34	2986.62	55802.0
2019-02-13 18:00:00	ES	Futures	2986.62	2988.24	2984.17	2987.97	8821.0
2019-02-13 19:00:00	ES	Futures	2987.97	2990.42	2982.54	2984.17	12700.0
2019-02-13 20:00:00	ES	Futures	2984.17	2989.87	2983.08	2986.62	9379.0
2019-02-13 21:00:00	ES	Futures	2986.89	2988.52	2984.71	2985.26	6833.0
2019-02-13 22:00:00	ES	Futures	2984.99	2993.41	2984.99	2992.86	9822.0
2019-02-13 23:00:00	ES	Futures	2993.13	2993.13	2989.87	2990.42	4473.0
2019-02-13 00:00:00	NQ	Futures	8239.74	8248.5	8238.86	8246.17	2120.0
2019-02-13 01:00:00	NQ	Futures	8246.17	8256.98	8245.0	8250.26	3030.0
2019-02-13 02:00:00	NQ	Futures	8250.55	8252.01	8242.37	8245.0	3125.0
2019-02-13 03:00:00	NQ	Futures	8245.0	8245.58	8235.06	8235.06	6015.0
2019-02-13 04:00:00	NQ	Futures	8235.36	8237.99	8221.62	8227.18	5297.0
2019-02-13 05:00:00	NQ	Futures	8226.88	8233.31	8223.96	8232.14	4776.0
2019-02-13 06:00:00	NQ	Futures	8232.43	8242.66	8226.59	8240.91	6279.0
2019-02-13 07:00:00	NQ	Futures	8241.2	8247.04	8237.69	8240.62	6127.0
2019-02-13 08:00:00	NQ	Futures	8240.91	8248.8	8227.18	8245.0	9702.0
2019-02-13 09:00:00	NQ	Futures	8245.0	8262.82	8230.1	8243.54	60704.0
2019-02-13 10:00:00	NQ	Futures	8243.54	8253.47	8214.61	8234.48	64417.0
2019-02-13 11:00:00	NQ	Futures	8234.77	8242.95	8204.97	8223.08	47251.0
2019-02-13 12:00:00	NQ	Futures	8223.08	8228.34	8213.44	8220.45	25229.0
2019-02-13 13:00:00	NQ	Futures	8220.16	8232.43	8218.12	8227.18	15342.0
2019-02-13 14:00:00	NQ	Futures	8226.88	8242.08	8226.88	8237.11	21123.0
2019-02-13 15:00:00	NQ	Futures	8237.11	8239.15	8198.25	8205.85	43483.0
2019-02-13 16:00:00	NQ	Futures	8205.85	8210.81	8195.33	8200.88	11094.0
2019-02-13 18:00:00	NQ	Futures	8201.46	8208.47	8194.45	8205.26	3368.0
2019-02-13 19:00:00	NQ	Futures	8205.55	8212.86	8184.22	8190.94	6810.0
2019-02-13 20:00:00	NQ	Futures	8191.24	8209.35	8185.68	8197.66	4083.0
2019-02-13 21:00:00	NQ	Futures	8197.66	8204.68	8192.11	8193.87	2495.0
2019-02-13 22:00:00	NQ	Futures	8193.87	8226.3	8193.28	8225.13	4248.0
2019-02-13 23:00:00	NQ	Futures	8224.84	8225.71	8209.94	8211.69	2024.0
2019-02-13 00:00:00	YM	Futures	27681.2	27700.7	27680.1	27692.0	987.0
2019-02-13 01:00:00	YM	Futures	27693.1	27721.4	27688.8	27705.1	1882.0
2019-02-13 02:00:00	YM	Futures	27705.1	27710.5	27671.4	27679.0	2347.0
2019-02-13 03:00:00	YM	Futures	27679.0	27688.8	27655.1	27664.9	3735.0

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

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