PREVIEW / futures_1hour / 2017-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-09.parquet
  size:    54 KB
  rows:    1,654

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-09 00:00:00	ES	Futures	2499.11	2499.93	2497.75	2498.29	3047.0
2017-02-09 01:00:00	ES	Futures	2498.29	2499.11	2498.02	2498.84	1230.0
2017-02-09 02:00:00	ES	Futures	2498.84	2499.65	2498.56	2499.38	3829.0
2017-02-09 03:00:00	ES	Futures	2499.11	2501.02	2497.47	2499.11	17223.0
2017-02-09 04:00:00	ES	Futures	2498.84	2500.2	2498.56	2499.11	7527.0
2017-02-09 05:00:00	ES	Futures	2499.11	2500.2	2498.56	2499.38	6144.0
2017-02-09 06:00:00	ES	Futures	2499.11	2505.38	2499.11	2504.02	31115.0
2017-02-09 07:00:00	ES	Futures	2504.02	2504.29	2501.84	2503.2	17261.0
2017-02-09 08:00:00	ES	Futures	2502.93	2503.2	2500.2	2501.56	25280.0
2017-02-09 09:00:00	ES	Futures	2501.56	2505.11	2501.29	2504.84	147285.0
2017-02-09 10:00:00	ES	Futures	2504.84	2513.02	2504.02	2512.47	306940.0
2017-02-09 11:00:00	ES	Futures	2512.47	2516.02	2511.38	2514.38	189346.0
2017-02-09 12:00:00	ES	Futures	2514.11	2516.02	2511.93	2513.29	121902.0
2017-02-09 13:00:00	ES	Futures	2513.57	2515.75	2513.02	2515.48	79518.0
2017-02-09 14:00:00	ES	Futures	2515.48	2517.93	2514.93	2517.11	91912.0
2017-02-09 15:00:00	ES	Futures	2517.38	2517.93	2513.02	2513.84	193425.0
2017-02-09 16:00:00	ES	Futures	2513.57	2514.38	2512.75	2514.11	79794.0
2017-02-09 18:00:00	ES	Futures	2514.11	2514.66	2513.02	2513.57	5712.0
2017-02-09 19:00:00	ES	Futures	2513.57	2514.38	2512.75	2513.84	3870.0
2017-02-09 20:00:00	ES	Futures	2513.84	2516.84	2513.57	2516.02	6196.0
2017-02-09 21:00:00	ES	Futures	2516.02	2517.11	2515.48	2516.84	2469.0
2017-02-09 22:00:00	ES	Futures	2517.11	2517.66	2516.57	2516.84	3097.0
2017-02-09 23:00:00	ES	Futures	2517.11	2517.38	2516.29	2517.11	2327.0
2017-02-09 00:00:00	NQ	Futures	6194.31	6196.7	6191.93	6193.12	841.0
2017-02-09 01:00:00	NQ	Futures	6193.42	6195.51	6192.82	6195.21	372.0
2017-02-09 02:00:00	NQ	Futures	6195.51	6196.4	6194.91	6195.51	785.0
2017-02-09 03:00:00	NQ	Futures	6195.8	6199.98	6193.12	6197.0	2725.0
2017-02-09 04:00:00	NQ	Futures	6197.3	6198.19	6194.91	6195.8	914.0
2017-02-09 05:00:00	NQ	Futures	6195.51	6198.49	6194.61	6196.7	981.0
2017-02-09 06:00:00	NQ	Futures	6197.0	6207.14	6196.4	6203.26	3696.0
2017-02-09 07:00:00	NQ	Futures	6203.26	6204.16	6197.89	6201.47	2433.0
2017-02-09 08:00:00	NQ	Futures	6201.77	6201.77	6195.21	6197.89	2707.0
2017-02-09 09:00:00	NQ	Futures	6197.89	6208.04	6195.21	6202.67	24002.0
2017-02-09 10:00:00	NQ	Futures	6202.67	6213.11	6199.68	6211.91	29299.0
2017-02-09 11:00:00	NQ	Futures	6211.62	6227.13	6209.83	6223.85	23212.0
2017-02-09 12:00:00	NQ	Futures	6223.55	6224.14	6213.41	6217.58	14452.0
2017-02-09 13:00:00	NQ	Futures	6217.28	6223.25	6216.09	6223.25	9928.0
2017-02-09 14:00:00	NQ	Futures	6223.25	6228.02	6221.76	6225.34	11554.0
2017-02-09 15:00:00	NQ	Futures	6225.64	6227.72	6213.7	6215.2	19549.0
2017-02-09 16:00:00	NQ	Futures	6215.2	6220.57	6214.0	6219.67	4935.0
2017-02-09 18:00:00	NQ	Futures	6218.48	6221.46	6216.69	6219.37	890.0
2017-02-09 19:00:00	NQ	Futures	6219.67	6221.16	6216.99	6220.86	878.0
2017-02-09 20:00:00	NQ	Futures	6220.57	6227.72	6219.97	6225.93	1691.0
2017-02-09 21:00:00	NQ	Futures	6225.64	6228.02	6225.34	6227.72	615.0
2017-02-09 22:00:00	NQ	Futures	6228.02	6230.71	6227.72	6229.22	927.0
2017-02-09 23:00:00	NQ	Futures	6229.22	6230.41	6228.02	6230.11	631.0
2017-02-09 00:00:00	YM	Futures	21695.3	21702.9	21688.8	21692.1	714.0
2017-02-09 01:00:00	YM	Futures	21693.1	21697.5	21689.9	21697.5	311.0
2017-02-09 02:00:00	YM	Futures	21697.5	21701.8	21692.1	21700.7	845.0
2017-02-09 03:00:00	YM	Futures	21699.7	21710.5	21685.6	21697.5	2678.0

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

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