PREVIEW / futures_1hour / 2017-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-01.parquet
  size:    55 KB
  rows:    1,672

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-03-01 00:00:00	ES	Futures	2583.67	2584.49	2582.03	2583.12	4569.0
2017-03-01 01:00:00	ES	Futures	2583.12	2583.67	2581.49	2581.76	3338.0
2017-03-01 02:00:00	ES	Futures	2581.76	2584.21	2581.21	2583.94	7843.0
2017-03-01 03:00:00	ES	Futures	2583.94	2591.03	2583.67	2590.49	34832.0
2017-03-01 04:00:00	ES	Futures	2590.76	2591.03	2589.12	2589.94	21549.0
2017-03-01 05:00:00	ES	Futures	2589.94	2591.85	2588.58	2591.03	24245.0
2017-03-01 06:00:00	ES	Futures	2591.3	2591.85	2588.85	2590.76	20598.0
2017-03-01 07:00:00	ES	Futures	2590.76	2593.21	2590.21	2592.67	25694.0
2017-03-01 08:00:00	ES	Futures	2592.94	2597.85	2592.4	2597.03	64698.0
2017-03-01 09:00:00	ES	Futures	2597.03	2603.03	2596.21	2602.49	230057.0
2017-03-01 10:00:00	ES	Futures	2602.76	2606.85	2602.22	2606.03	245823.0
2017-03-01 11:00:00	ES	Futures	2606.03	2612.04	2605.22	2610.94	223023.0
2017-03-01 12:00:00	ES	Futures	2610.67	2617.22	2610.67	2613.94	222536.0
2017-03-01 13:00:00	ES	Futures	2613.94	2615.58	2613.13	2615.04	125031.0
2017-03-01 14:00:00	ES	Futures	2615.04	2619.67	2613.67	2619.13	202897.0
2017-03-01 15:00:00	ES	Futures	2618.85	2619.13	2612.31	2612.85	386003.0
2017-03-01 16:00:00	ES	Futures	2613.13	2613.4	2610.13	2610.4	157220.0
2017-03-01 18:00:00	ES	Futures	2610.13	2612.04	2609.85	2611.22	7561.0
2017-03-01 19:00:00	ES	Futures	2611.22	2612.04	2610.4	2611.22	6288.0
2017-03-01 20:00:00	ES	Futures	2610.94	2610.94	2609.03	2609.58	6994.0
2017-03-01 21:00:00	ES	Futures	2609.58	2610.4	2609.03	2609.31	3164.0
2017-03-01 22:00:00	ES	Futures	2609.31	2609.58	2608.76	2609.31	2501.0
2017-03-01 23:00:00	ES	Futures	2609.03	2609.58	2608.22	2608.49	3025.0
2017-03-01 00:00:00	NQ	Futures	6371.81	6375.09	6370.32	6371.51	919.0
2017-03-01 01:00:00	NQ	Futures	6371.51	6373.6	6367.64	6368.53	707.0
2017-03-01 02:00:00	NQ	Futures	6368.53	6375.69	6367.64	6375.09	1735.0
2017-03-01 03:00:00	NQ	Futures	6375.09	6399.56	6374.5	6396.87	6720.0
2017-03-01 04:00:00	NQ	Futures	6396.87	6397.47	6390.31	6391.8	3497.0
2017-03-01 05:00:00	NQ	Futures	6391.5	6403.73	6389.71	6401.35	3959.0
2017-03-01 06:00:00	NQ	Futures	6401.35	6404.33	6393.59	6395.98	3705.0
2017-03-01 07:00:00	NQ	Futures	6395.98	6399.56	6390.91	6398.36	3168.0
2017-03-01 08:00:00	NQ	Futures	6398.66	6407.31	6397.47	6401.35	7564.0
2017-03-01 09:00:00	NQ	Futures	6401.35	6407.31	6390.01	6398.36	35663.0
2017-03-01 10:00:00	NQ	Futures	6398.66	6412.68	6398.66	6410.3	29183.0
2017-03-01 11:00:00	NQ	Futures	6410.3	6425.81	6408.8	6423.42	25135.0
2017-03-01 12:00:00	NQ	Futures	6423.42	6437.44	6423.42	6428.49	23421.0
2017-03-01 13:00:00	NQ	Futures	6428.79	6432.07	6425.51	6431.48	12925.0
2017-03-01 14:00:00	NQ	Futures	6431.18	6441.32	6427.6	6440.13	18547.0
2017-03-01 15:00:00	NQ	Futures	6439.83	6443.71	6430.58	6432.07	31509.0
2017-03-01 16:00:00	NQ	Futures	6431.78	6432.67	6425.51	6426.41	7808.0
2017-03-01 18:00:00	NQ	Futures	6423.12	6429.69	6423.12	6428.79	1179.0
2017-03-01 19:00:00	NQ	Futures	6428.49	6430.58	6425.21	6426.41	1054.0
2017-03-01 20:00:00	NQ	Futures	6426.41	6426.41	6420.74	6423.42	1498.0
2017-03-01 21:00:00	NQ	Futures	6423.12	6424.91	6421.33	6422.23	717.0
2017-03-01 22:00:00	NQ	Futures	6422.23	6423.12	6420.74	6421.33	640.0
2017-03-01 23:00:00	NQ	Futures	6420.74	6421.63	6419.25	6420.74	544.0
2017-03-01 00:00:00	YM	Futures	22609.8	22614.1	22601.1	22607.6	1127.0
2017-03-01 01:00:00	YM	Futures	22607.6	22611.9	22595.7	22597.8	946.0
2017-03-01 02:00:00	YM	Futures	22597.8	22620.6	22592.4	22617.4	2188.0
2017-03-01 03:00:00	YM	Futures	22617.4	22667.3	22616.3	22666.2	6914.0

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

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