PREVIEW / futures_1hour / 2017-12-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-13.parquet
  size:    53 KB
  rows:    1,617

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-12-13 00:00:00	ES	Futures	2911.76	2914.22	2910.94	2912.3	2303.0
2017-12-13 01:00:00	ES	Futures	2912.3	2913.67	2912.03	2913.13	1070.0
2017-12-13 02:00:00	ES	Futures	2913.13	2914.49	2912.58	2913.13	1318.0
2017-12-13 03:00:00	ES	Futures	2913.13	2915.59	2912.85	2914.77	3098.0
2017-12-13 04:00:00	ES	Futures	2914.77	2916.41	2914.22	2915.04	2886.0
2017-12-13 05:00:00	ES	Futures	2915.04	2917.23	2914.77	2916.96	2618.0
2017-12-13 06:00:00	ES	Futures	2916.96	2917.5	2915.31	2915.31	3311.0
2017-12-13 07:00:00	ES	Futures	2915.31	2915.86	2913.13	2914.49	4542.0
2017-12-13 08:00:00	ES	Futures	2914.22	2919.14	2913.95	2918.32	9350.0
2017-12-13 09:00:00	ES	Futures	2918.32	2923.52	2918.05	2922.43	27057.0
2017-12-13 10:00:00	ES	Futures	2922.7	2924.07	2920.51	2922.97	35022.0
2017-12-13 11:00:00	ES	Futures	2923.25	2924.34	2921.61	2923.52	25073.0
2017-12-13 12:00:00	ES	Futures	2923.52	2923.52	2917.78	2918.87	20005.0
2017-12-13 13:00:00	ES	Futures	2919.14	2919.14	2915.86	2917.5	13136.0
2017-12-13 14:00:00	ES	Futures	2918.05	2924.07	2917.5	2923.52	23677.0
2017-12-13 15:00:00	ES	Futures	2923.52	2923.52	2914.49	2915.31	41543.0
2017-12-13 16:00:00	ES	Futures	2915.31	2918.6	2915.04	2917.5	10397.0
2017-12-13 18:00:00	ES	Futures	2916.68	2918.32	2916.41	2918.05	1446.0
2017-12-13 19:00:00	ES	Futures	2918.05	2921.06	2917.78	2920.79	1414.0
2017-12-13 20:00:00	ES	Futures	2920.51	2921.33	2918.87	2919.42	1082.0
2017-12-13 21:00:00	ES	Futures	2919.69	2920.51	2919.42	2919.69	1597.0
2017-12-13 22:00:00	ES	Futures	2919.69	2920.24	2918.87	2919.42	928.0
2017-12-13 23:00:00	ES	Futures	2919.14	2919.42	2916.68	2918.6	937.0
2017-12-13 00:00:00	NQ	Futures	7585.9	7595.42	7584.42	7591.85	294.0
2017-12-13 01:00:00	NQ	Futures	7591.55	7598.99	7590.66	7594.23	263.0
2017-12-13 02:00:00	NQ	Futures	7595.12	7601.96	7595.12	7597.8	353.0
2017-12-13 03:00:00	NQ	Futures	7598.1	7605.24	7597.8	7599.88	533.0
2017-12-13 04:00:00	NQ	Futures	7599.88	7604.64	7599.58	7601.07	579.0
2017-12-13 05:00:00	NQ	Futures	7600.77	7606.43	7599.29	7606.13	404.0
2017-12-13 06:00:00	NQ	Futures	7606.13	7607.91	7601.67	7602.26	605.0
2017-12-13 07:00:00	NQ	Futures	7602.56	7603.15	7593.34	7595.72	1086.0
2017-12-13 08:00:00	NQ	Futures	7594.83	7624.87	7594.83	7619.81	2200.0
2017-12-13 09:00:00	NQ	Futures	7619.51	7636.17	7619.21	7628.14	10174.0
2017-12-13 10:00:00	NQ	Futures	7628.14	7630.52	7613.27	7629.92	9912.0
2017-12-13 11:00:00	NQ	Futures	7630.22	7635.27	7618.92	7621.0	5361.0
2017-12-13 12:00:00	NQ	Futures	7620.4	7620.7	7601.37	7612.97	4725.0
2017-12-13 13:00:00	NQ	Futures	7612.67	7614.46	7600.48	7605.53	4337.0
2017-12-13 14:00:00	NQ	Futures	7605.83	7632.0	7605.83	7628.73	5806.0
2017-12-13 15:00:00	NQ	Futures	7629.03	7631.41	7607.91	7611.18	7787.0
2017-12-13 16:00:00	NQ	Futures	7610.89	7616.84	7607.02	7613.86	1702.0
2017-12-13 18:00:00	NQ	Futures	7609.99	7618.02	7609.99	7616.24	149.0
2017-12-13 19:00:00	NQ	Futures	7615.94	7625.16	7615.65	7624.57	172.0
2017-12-13 20:00:00	NQ	Futures	7624.27	7626.65	7619.21	7620.11	118.0
2017-12-13 21:00:00	NQ	Futures	7619.81	7624.27	7619.81	7621.0	86.0
2017-12-13 22:00:00	NQ	Futures	7621.0	7623.38	7619.21	7619.51	49.0
2017-12-13 23:00:00	NQ	Futures	7619.21	7621.59	7613.27	7617.43	311.0
2017-12-13 00:00:00	YM	Futures	26644.9	26669.9	26640.5	26655.7	1331.0
2017-12-13 01:00:00	YM	Futures	26655.7	26666.6	26649.2	26659.0	830.0
2017-12-13 02:00:00	YM	Futures	26659.0	26672.0	26655.7	26661.2	895.0
2017-12-13 03:00:00	YM	Futures	26659.0	26684.0	26659.0	26674.2	1393.0

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

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