PREVIEW / futures_1hour / 2015-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-12.parquet
  size:    49 KB
  rows:    1,526

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
2015-10-12 00:00:00	ES	Futures	2145.16	2146.5	2144.89	2146.23	1211.0
2015-10-12 01:00:00	ES	Futures	2146.23	2148.91	2145.7	2148.11	3673.0
2015-10-12 02:00:00	ES	Futures	2148.11	2150.25	2146.5	2149.18	6366.0
2015-10-12 03:00:00	ES	Futures	2149.44	2153.99	2146.77	2151.32	14864.0
2015-10-12 04:00:00	ES	Futures	2151.32	2151.58	2146.23	2147.57	7588.0
2015-10-12 05:00:00	ES	Futures	2147.3	2148.64	2145.16	2148.11	10701.0
2015-10-12 06:00:00	ES	Futures	2148.11	2149.98	2147.3	2149.44	7391.0
2015-10-12 07:00:00	ES	Futures	2149.18	2150.25	2147.03	2149.44	7086.0
2015-10-12 08:00:00	ES	Futures	2149.18	2149.44	2146.23	2147.3	14212.0
2015-10-12 09:00:00	ES	Futures	2147.3	2149.98	2143.82	2145.7	128869.0
2015-10-12 10:00:00	ES	Futures	2145.7	2148.64	2143.02	2144.63	152943.0
2015-10-12 11:00:00	ES	Futures	2144.36	2152.12	2144.09	2149.44	113584.0
2015-10-12 12:00:00	ES	Futures	2149.18	2151.05	2147.3	2148.37	56019.0
2015-10-12 13:00:00	ES	Futures	2148.64	2148.91	2145.43	2147.3	52947.0
2015-10-12 14:00:00	ES	Futures	2147.03	2148.91	2146.5	2147.84	49251.0
2015-10-12 15:00:00	ES	Futures	2147.84	2151.32	2147.3	2149.71	98337.0
2015-10-12 16:00:00	ES	Futures	2150.25	2155.6	2148.64	2153.99	39901.0
2015-10-12 18:00:00	ES	Futures	2153.46	2153.72	2151.58	2151.58	2530.0
2015-10-12 19:00:00	ES	Futures	2151.58	2152.39	2151.05	2151.85	3012.0
2015-10-12 20:00:00	ES	Futures	2151.85	2154.26	2151.85	2152.92	4193.0
2015-10-12 21:00:00	ES	Futures	2152.65	2152.65	2149.18	2150.78	5802.0
2015-10-12 22:00:00	ES	Futures	2150.78	2152.92	2147.03	2147.57	9037.0
2015-10-12 23:00:00	ES	Futures	2147.84	2151.05	2147.3	2151.05	4185.0
2015-10-12 00:00:00	NQ	Futures	5164.28	5167.54	5162.8	5165.76	247.0
2015-10-12 01:00:00	NQ	Futures	5165.76	5172.29	5164.87	5169.02	636.0
2015-10-12 02:00:00	NQ	Futures	5169.62	5175.25	5166.36	5172.58	641.0
2015-10-12 03:00:00	NQ	Futures	5173.18	5184.74	5167.54	5179.99	2510.0
2015-10-12 04:00:00	NQ	Futures	5179.99	5180.29	5167.54	5169.91	1203.0
2015-10-12 05:00:00	NQ	Futures	5169.91	5171.69	5160.43	5167.54	1796.0
2015-10-12 06:00:00	NQ	Futures	5167.84	5173.77	5164.58	5171.99	1533.0
2015-10-12 07:00:00	NQ	Futures	5171.69	5174.66	5166.95	5174.66	1572.0
2015-10-12 08:00:00	NQ	Futures	5174.36	5180.29	5170.8	5179.11	4225.0
2015-10-12 09:00:00	NQ	Futures	5178.81	5188.3	5165.17	5172.29	26665.0
2015-10-12 10:00:00	NQ	Futures	5171.99	5181.48	5162.8	5174.36	24899.0
2015-10-12 11:00:00	NQ	Futures	5174.36	5194.23	5173.47	5184.44	18718.0
2015-10-12 12:00:00	NQ	Futures	5184.74	5192.45	5179.11	5180.59	9520.0
2015-10-12 13:00:00	NQ	Futures	5180.59	5185.63	5173.18	5181.48	8011.0
2015-10-12 14:00:00	NQ	Futures	5181.48	5187.7	5180.29	5181.77	6643.0
2015-10-12 15:00:00	NQ	Futures	5182.07	5190.08	5179.4	5184.44	15319.0
2015-10-12 16:00:00	NQ	Futures	5184.74	5196.3	5181.48	5193.04	4152.0
2015-10-12 18:00:00	NQ	Futures	5190.96	5191.26	5185.92	5186.22	524.0
2015-10-12 19:00:00	NQ	Futures	5186.22	5188.59	5184.74	5187.11	508.0
2015-10-12 20:00:00	NQ	Futures	5187.11	5193.04	5186.22	5188.0	918.0
2015-10-12 21:00:00	NQ	Futures	5187.7	5187.7	5178.81	5183.26	1123.0
2015-10-12 22:00:00	NQ	Futures	5183.85	5190.08	5174.36	5175.84	1708.0
2015-10-12 23:00:00	NQ	Futures	5175.55	5182.66	5174.66	5182.37	842.0
2015-10-12 00:00:00	YM	Futures	17976.6	17988.2	17972.4	17982.9	190.0
2015-10-12 01:00:00	YM	Futures	17984.0	18004.1	17979.8	17996.7	462.0
2015-10-12 02:00:00	YM	Futures	17996.7	18016.8	17987.2	18009.4	667.0
2015-10-12 03:00:00	YM	Futures	18011.5	18044.4	17990.4	18023.2	1824.0

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

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