PREVIEW / futures_1hour / 2017-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-07.parquet
  size:    55 KB
  rows:    1,659

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
2017-02-07 00:00:00	ES	Futures	2494.74	2495.29	2494.2	2494.74	2452.0
2017-02-07 01:00:00	ES	Futures	2494.74	2495.02	2494.2	2494.2	1425.0
2017-02-07 02:00:00	ES	Futures	2494.2	2495.02	2493.38	2493.93	7558.0
2017-02-07 03:00:00	ES	Futures	2494.2	2496.38	2493.38	2495.84	15966.0
2017-02-07 04:00:00	ES	Futures	2496.11	2499.38	2495.56	2499.11	13877.0
2017-02-07 05:00:00	ES	Futures	2499.11	2499.93	2498.02	2499.11	9512.0
2017-02-07 06:00:00	ES	Futures	2499.11	2502.93	2498.84	2502.38	20869.0
2017-02-07 07:00:00	ES	Futures	2502.38	2502.93	2500.47	2500.75	18171.0
2017-02-07 08:00:00	ES	Futures	2501.02	2501.56	2500.2	2500.47	20734.0
2017-02-07 09:00:00	ES	Futures	2500.2	2504.02	2498.84	2501.84	172523.0
2017-02-07 10:00:00	ES	Futures	2501.84	2503.47	2500.47	2501.84	106539.0
2017-02-07 11:00:00	ES	Futures	2501.84	2503.47	2497.2	2499.38	158526.0
2017-02-07 12:00:00	ES	Futures	2499.38	2501.02	2493.38	2494.47	170109.0
2017-02-07 13:00:00	ES	Futures	2494.47	2498.02	2493.65	2496.38	119780.0
2017-02-07 14:00:00	ES	Futures	2496.38	2497.47	2495.02	2496.38	82666.0
2017-02-07 15:00:00	ES	Futures	2496.65	2498.56	2494.2	2496.11	180466.0
2017-02-07 16:00:00	ES	Futures	2496.38	2497.2	2493.93	2493.93	67927.0
2017-02-07 18:00:00	ES	Futures	2493.93	2494.74	2492.29	2493.93	7757.0
2017-02-07 19:00:00	ES	Futures	2493.93	2495.29	2493.65	2494.74	3193.0
2017-02-07 20:00:00	ES	Futures	2494.74	2496.11	2493.11	2493.38	4712.0
2017-02-07 21:00:00	ES	Futures	2493.11	2494.74	2492.84	2493.65	2722.0
2017-02-07 22:00:00	ES	Futures	2493.93	2494.74	2493.65	2494.47	1469.0
2017-02-07 23:00:00	ES	Futures	2494.47	2495.56	2494.2	2495.29	1598.0
2017-02-07 00:00:00	NQ	Futures	6156.43	6158.22	6156.13	6157.02	736.0
2017-02-07 01:00:00	NQ	Futures	6157.02	6157.62	6156.43	6157.02	440.0
2017-02-07 02:00:00	NQ	Futures	6156.43	6157.92	6154.04	6156.43	1379.0
2017-02-07 03:00:00	NQ	Futures	6155.83	6159.71	6154.04	6159.41	2757.0
2017-02-07 04:00:00	NQ	Futures	6159.41	6165.97	6158.81	6165.08	2410.0
2017-02-07 05:00:00	NQ	Futures	6165.08	6167.76	6163.59	6166.27	2001.0
2017-02-07 06:00:00	NQ	Futures	6166.27	6172.54	6166.27	6170.45	3458.0
2017-02-07 07:00:00	NQ	Futures	6170.15	6171.94	6167.17	6168.96	2277.0
2017-02-07 08:00:00	NQ	Futures	6168.96	6169.55	6166.87	6168.36	2096.0
2017-02-07 09:00:00	NQ	Futures	6168.36	6182.08	6166.87	6179.7	26239.0
2017-02-07 10:00:00	NQ	Futures	6179.4	6193.42	6178.2	6191.63	21627.0
2017-02-07 11:00:00	NQ	Futures	6191.33	6195.51	6181.78	6187.75	17680.0
2017-02-07 12:00:00	NQ	Futures	6187.75	6191.03	6171.64	6175.82	19339.0
2017-02-07 13:00:00	NQ	Futures	6175.52	6186.56	6173.13	6182.98	14135.0
2017-02-07 14:00:00	NQ	Futures	6183.28	6185.66	6175.82	6178.5	10723.0
2017-02-07 15:00:00	NQ	Futures	6178.5	6183.28	6174.03	6181.49	21372.0
2017-02-07 16:00:00	NQ	Futures	6181.19	6182.08	6174.03	6175.52	5901.0
2017-02-07 18:00:00	NQ	Futures	6175.22	6176.41	6170.75	6175.22	1379.0
2017-02-07 19:00:00	NQ	Futures	6175.22	6179.1	6175.22	6177.01	978.0
2017-02-07 20:00:00	NQ	Futures	6177.31	6181.19	6173.43	6173.43	1198.0
2017-02-07 21:00:00	NQ	Futures	6173.43	6177.91	6173.43	6175.22	665.0
2017-02-07 22:00:00	NQ	Futures	6175.22	6177.91	6174.62	6176.71	285.0
2017-02-07 23:00:00	NQ	Futures	6176.71	6179.7	6176.71	6179.1	573.0
2017-02-07 00:00:00	YM	Futures	21670.4	21674.7	21666.0	21668.2	566.0
2017-02-07 01:00:00	YM	Futures	21668.2	21670.4	21664.9	21664.9	363.0
2017-02-07 02:00:00	YM	Futures	21664.9	21676.9	21659.5	21669.3	1637.0
2017-02-07 03:00:00	YM	Futures	21669.3	21683.4	21663.9	21681.2	2691.0

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

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