PREVIEW / futures_1hour / 2017-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-30.parquet
  size:    54 KB
  rows:    1,639

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-01-30 00:00:00	ES	Futures	2490.93	2492.29	2490.65	2491.74	4150.0
2017-01-30 01:00:00	ES	Futures	2492.02	2493.11	2490.65	2491.2	4486.0
2017-01-30 02:00:00	ES	Futures	2491.47	2491.74	2490.38	2491.74	3946.0
2017-01-30 03:00:00	ES	Futures	2491.47	2493.93	2490.11	2491.2	20503.0
2017-01-30 04:00:00	ES	Futures	2491.47	2492.56	2490.38	2490.65	10635.0
2017-01-30 05:00:00	ES	Futures	2490.65	2491.47	2490.11	2490.38	6674.0
2017-01-30 06:00:00	ES	Futures	2490.65	2491.47	2490.11	2490.38	4458.0
2017-01-30 07:00:00	ES	Futures	2490.65	2491.47	2489.29	2490.38	14176.0
2017-01-30 08:00:00	ES	Futures	2490.11	2490.38	2486.83	2489.02	35195.0
2017-01-30 09:00:00	ES	Futures	2488.74	2489.56	2476.2	2479.2	387106.0
2017-01-30 10:00:00	ES	Futures	2479.2	2480.29	2469.38	2471.56	346240.0
2017-01-30 11:00:00	ES	Futures	2471.56	2477.83	2470.74	2477.29	227998.0
2017-01-30 12:00:00	ES	Futures	2477.29	2477.83	2473.74	2475.11	101536.0
2017-01-30 13:00:00	ES	Futures	2475.11	2477.29	2472.65	2474.29	95931.0
2017-01-30 14:00:00	ES	Futures	2474.29	2480.29	2474.29	2479.2	140404.0
2017-01-30 15:00:00	ES	Futures	2479.2	2484.38	2475.65	2482.47	308472.0
2017-01-30 16:00:00	ES	Futures	2482.47	2483.56	2481.65	2483.56	85475.0
2017-01-30 18:00:00	ES	Futures	2483.02	2483.56	2481.65	2483.29	4576.0
2017-01-30 19:00:00	ES	Futures	2483.29	2483.56	2482.2	2483.02	3603.0
2017-01-30 20:00:00	ES	Futures	2483.02	2484.11	2482.74	2483.02	2824.0
2017-01-30 21:00:00	ES	Futures	2483.02	2483.29	2478.38	2478.65	8419.0
2017-01-30 22:00:00	ES	Futures	2478.65	2478.65	2474.83	2477.01	15577.0
2017-01-30 23:00:00	ES	Futures	2477.01	2477.29	2476.2	2476.47	3748.0
2017-01-30 00:00:00	NQ	Futures	6142.41	6147.18	6141.81	6146.58	701.0
2017-01-30 01:00:00	NQ	Futures	6146.58	6149.27	6144.79	6145.69	1092.0
2017-01-30 02:00:00	NQ	Futures	6145.99	6147.18	6144.49	6145.69	820.0
2017-01-30 03:00:00	NQ	Futures	6145.69	6150.76	6139.12	6142.7	3543.0
2017-01-30 04:00:00	NQ	Futures	6142.41	6144.49	6138.53	6139.72	1972.0
2017-01-30 05:00:00	NQ	Futures	6140.02	6140.62	6138.23	6138.53	1357.0
2017-01-30 06:00:00	NQ	Futures	6138.53	6142.41	6137.93	6139.42	1468.0
2017-01-30 07:00:00	NQ	Futures	6139.72	6143.0	6137.63	6140.02	1895.0
2017-01-30 08:00:00	NQ	Futures	6139.72	6142.11	6133.75	6140.62	5123.0
2017-01-30 09:00:00	NQ	Futures	6140.32	6141.21	6094.38	6100.34	56989.0
2017-01-30 10:00:00	NQ	Futures	6100.04	6102.43	6079.16	6086.62	53193.0
2017-01-30 11:00:00	NQ	Futures	6086.32	6105.41	6081.85	6104.82	31614.0
2017-01-30 12:00:00	NQ	Futures	6104.82	6106.91	6093.78	6097.96	15908.0
2017-01-30 13:00:00	NQ	Futures	6097.66	6103.62	6094.08	6097.36	10798.0
2017-01-30 14:00:00	NQ	Futures	6097.66	6110.78	6096.76	6109.29	16878.0
2017-01-30 15:00:00	NQ	Futures	6108.99	6117.64	6100.34	6113.77	29394.0
2017-01-30 16:00:00	NQ	Futures	6114.06	6116.45	6111.68	6116.45	5180.0
2017-01-30 18:00:00	NQ	Futures	6113.77	6114.06	6110.19	6112.87	941.0
2017-01-30 19:00:00	NQ	Futures	6112.87	6113.77	6110.49	6112.87	714.0
2017-01-30 20:00:00	NQ	Futures	6113.17	6114.66	6111.68	6112.27	520.0
2017-01-30 21:00:00	NQ	Futures	6112.57	6112.87	6102.43	6102.73	1627.0
2017-01-30 22:00:00	NQ	Futures	6102.73	6103.33	6094.97	6100.64	2689.0
2017-01-30 23:00:00	NQ	Futures	6100.64	6100.94	6097.36	6099.75	726.0
2017-01-30 00:00:00	YM	Futures	21660.6	21670.4	21659.5	21668.2	703.0
2017-01-30 01:00:00	YM	Futures	21669.3	21675.8	21663.9	21667.1	919.0
2017-01-30 02:00:00	YM	Futures	21668.2	21672.5	21661.7	21670.4	863.0
2017-01-30 03:00:00	YM	Futures	21671.5	21687.7	21655.2	21666.0	3824.0

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

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