PREVIEW / futures_1hour / 2014-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-02.parquet
  size:    50 KB
  rows:    1,541

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
2014-12-02 00:00:00	ES	Futures	2151.28	2152.59	2150.75	2151.01	5461.0
2014-12-02 01:00:00	ES	Futures	2151.01	2153.63	2150.75	2153.63	6491.0
2014-12-02 02:00:00	ES	Futures	2153.9	2155.99	2153.63	2154.16	12325.0
2014-12-02 03:00:00	ES	Futures	2154.42	2157.56	2152.59	2156.52	24458.0
2014-12-02 04:00:00	ES	Futures	2156.25	2157.56	2153.63	2154.16	15021.0
2014-12-02 05:00:00	ES	Futures	2154.16	2154.94	2149.7	2151.28	17044.0
2014-12-02 06:00:00	ES	Futures	2151.28	2153.63	2150.75	2153.11	16898.0
2014-12-02 07:00:00	ES	Futures	2153.11	2155.99	2152.06	2154.42	23923.0
2014-12-02 08:00:00	ES	Futures	2154.42	2154.94	2151.54	2153.37	30169.0
2014-12-02 09:00:00	ES	Futures	2153.37	2157.3	2150.75	2155.99	179903.0
2014-12-02 10:00:00	ES	Futures	2156.25	2160.97	2155.99	2160.97	200818.0
2014-12-02 11:00:00	ES	Futures	2160.97	2162.02	2159.14	2161.49	130612.0
2014-12-02 12:00:00	ES	Futures	2161.49	2161.75	2158.61	2160.18	78356.0
2014-12-02 13:00:00	ES	Futures	2160.44	2164.11	2159.92	2162.8	93697.0
2014-12-02 14:00:00	ES	Futures	2162.54	2166.99	2162.02	2166.47	86269.0
2014-12-02 15:00:00	ES	Futures	2166.47	2166.73	2162.8	2164.37	123874.0
2014-12-02 16:00:00	ES	Futures	2164.37	2165.68	2163.33	2165.16	70528.0
2014-12-02 17:00:00	ES	Futures	2165.42	2165.68	2165.16	2165.42	1347.0
2014-12-02 18:00:00	ES	Futures	2165.42	2165.95	2164.9	2165.95	4065.0
2014-12-02 19:00:00	ES	Futures	2165.68	2166.73	2165.42	2166.73	2888.0
2014-12-02 20:00:00	ES	Futures	2166.73	2166.73	2165.68	2165.95	2338.0
2014-12-02 21:00:00	ES	Futures	2165.95	2166.47	2165.95	2165.95	1314.0
2014-12-02 22:00:00	ES	Futures	2166.21	2166.21	2164.9	2165.16	3396.0
2014-12-02 23:00:00	ES	Futures	2165.16	2166.21	2164.64	2164.9	4587.0
2014-12-02 00:00:00	NQ	Futures	5029.44	5032.67	5026.22	5029.15	1388.0
2014-12-02 01:00:00	NQ	Futures	5028.86	5034.72	5028.27	5034.72	669.0
2014-12-02 02:00:00	NQ	Futures	5034.72	5039.99	5034.42	5035.6	1298.0
2014-12-02 03:00:00	NQ	Futures	5035.01	5044.97	5031.49	5042.92	3295.0
2014-12-02 04:00:00	NQ	Futures	5043.21	5047.02	5039.99	5041.16	2702.0
2014-12-02 05:00:00	NQ	Futures	5040.87	5042.63	5029.74	5033.55	2536.0
2014-12-02 06:00:00	NQ	Futures	5033.55	5039.41	5032.08	5038.82	2121.0
2014-12-02 07:00:00	NQ	Futures	5038.82	5043.8	5035.6	5038.23	4349.0
2014-12-02 08:00:00	NQ	Futures	5038.53	5038.53	5030.62	5036.48	6838.0
2014-12-02 09:00:00	NQ	Futures	5036.77	5041.46	5022.12	5036.18	47962.0
2014-12-02 10:00:00	NQ	Futures	5036.18	5046.44	5031.2	5036.18	40994.0
2014-12-02 11:00:00	NQ	Futures	5036.18	5048.49	5030.32	5046.44	28653.0
2014-12-02 12:00:00	NQ	Futures	5046.14	5046.73	5031.2	5037.94	18584.0
2014-12-02 13:00:00	NQ	Futures	5037.94	5046.44	5035.6	5043.21	13658.0
2014-12-02 14:00:00	NQ	Futures	5043.21	5056.99	5039.11	5054.35	17244.0
2014-12-02 15:00:00	NQ	Futures	5054.35	5056.11	5042.92	5048.49	25470.0
2014-12-02 16:00:00	NQ	Futures	5048.49	5050.54	5046.14	5049.95	4562.0
2014-12-02 17:00:00	NQ	Futures	5049.95	5051.42	5049.66	5051.42	152.0
2014-12-02 18:00:00	NQ	Futures	5049.07	5052.3	5048.2	5052.0	561.0
2014-12-02 19:00:00	NQ	Futures	5052.0	5053.47	5050.83	5053.47	424.0
2014-12-02 20:00:00	NQ	Futures	5053.18	5054.35	5050.83	5052.3	572.0
2014-12-02 21:00:00	NQ	Futures	5052.3	5054.06	5052.0	5052.59	175.0
2014-12-02 22:00:00	NQ	Futures	5052.3	5053.18	5049.95	5050.54	444.0
2014-12-02 23:00:00	NQ	Futures	5050.54	5052.3	5047.61	5047.9	626.0
2014-12-02 00:00:00	YM	Futures	18481.8	18496.3	18473.5	18473.5	2119.0
2014-12-02 01:00:00	YM	Futures	18473.5	18497.4	18470.4	18496.3	1458.0

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

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