PREVIEW / futures_1hour / 2014-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-19.parquet
  size:    44 KB
  rows:    1,265

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-19 00:00:00	ES	Futures	2169.42	2180.21	2169.42	2179.42	16139.0
2014-12-19 01:00:00	ES	Futures	2179.69	2182.84	2176.79	2177.32	11137.0
2014-12-19 02:00:00	ES	Futures	2177.32	2178.11	2175.48	2177.06	16356.0
2014-12-19 03:00:00	ES	Futures	2177.06	2177.32	2173.63	2174.42	29437.0
2014-12-19 04:00:00	ES	Futures	2174.69	2178.11	2173.9	2177.84	21117.0
2014-12-19 05:00:00	ES	Futures	2177.58	2177.58	2172.06	2173.11	25914.0
2014-12-19 06:00:00	ES	Futures	2173.11	2175.21	2170.21	2173.37	24800.0
2014-12-19 07:00:00	ES	Futures	2173.11	2176.53	2172.32	2175.21	26107.0
2014-12-19 08:00:00	ES	Futures	2175.21	2175.74	2167.32	2169.69	60737.0
2014-12-19 09:00:00	ES	Futures	2169.42	2174.95	2164.69	2171.0	340497.0
2014-12-19 10:00:00	ES	Futures	2171.27	2176.0	2168.63	2172.58	225027.0
2014-12-19 11:00:00	ES	Futures	2172.58	2173.9	2169.95	2170.48	137392.0
2014-12-19 12:00:00	ES	Futures	2170.48	2171.79	2166.53	2169.69	113604.0
2014-12-19 13:00:00	ES	Futures	2169.42	2173.11	2168.63	2172.58	80683.0
2014-12-19 14:00:00	ES	Futures	2172.58	2183.11	2172.06	2182.58	131069.0
2014-12-19 15:00:00	ES	Futures	2182.58	2185.48	2176.0	2176.0	292603.0
2014-12-19 16:00:00	ES	Futures	2176.27	2177.32	2172.58	2174.16	130225.0
2014-12-19 17:00:00	ES	Futures	2174.16	2174.16	2171.53	2172.32	3765.0
2014-12-19 00:00:00	NQ	Futures	5019.13	5044.69	5019.13	5043.8	4087.0
2014-12-19 01:00:00	NQ	Futures	5044.1	5050.56	5036.76	5038.22	2559.0
2014-12-19 02:00:00	NQ	Futures	5037.93	5040.28	5033.82	5039.69	2679.0
2014-12-19 03:00:00	NQ	Futures	5039.99	5040.57	5031.18	5033.53	4343.0
2014-12-19 04:00:00	NQ	Futures	5033.53	5039.4	5032.64	5039.11	3228.0
2014-12-19 05:00:00	NQ	Futures	5039.69	5039.69	5025.6	5028.53	2944.0
2014-12-19 06:00:00	NQ	Futures	5028.24	5031.47	5020.9	5027.06	4067.0
2014-12-19 07:00:00	NQ	Futures	5026.77	5030.88	5023.83	5030.29	3698.0
2014-12-19 08:00:00	NQ	Futures	5030.29	5031.47	5015.61	5018.55	8450.0
2014-12-19 09:00:00	NQ	Futures	5017.96	5024.71	4999.16	5018.84	61190.0
2014-12-19 10:00:00	NQ	Futures	5018.84	5034.41	5012.97	5030.29	43231.0
2014-12-19 11:00:00	NQ	Futures	5030.29	5038.22	5025.6	5027.95	22930.0
2014-12-19 12:00:00	NQ	Futures	5027.65	5033.23	5016.49	5026.48	18605.0
2014-12-19 13:00:00	NQ	Futures	5026.48	5033.23	5022.95	5028.53	10950.0
2014-12-19 14:00:00	NQ	Futures	5028.83	5050.56	5028.53	5050.27	19036.0
2014-12-19 15:00:00	NQ	Futures	5049.97	5056.73	5033.82	5034.11	55468.0
2014-12-19 16:00:00	NQ	Futures	5034.11	5036.76	5027.65	5030.88	13695.0
2014-12-19 17:00:00	NQ	Futures	5030.29	5030.29	5025.89	5026.77	197.0
2014-12-19 00:00:00	YM	Futures	18514.2	18612.3	18514.2	18607.1	4190.0
2014-12-19 01:00:00	YM	Futures	18608.2	18628.0	18596.7	18602.9	2841.0
2014-12-19 02:00:00	YM	Futures	18601.9	18607.1	18587.3	18593.5	2237.0
2014-12-19 03:00:00	YM	Futures	18594.6	18594.6	18561.2	18567.4	4256.0
2014-12-19 04:00:00	YM	Futures	18567.4	18599.8	18561.2	18592.5	3062.0
2014-12-19 05:00:00	YM	Futures	18593.5	18594.6	18536.1	18548.7	4120.0
2014-12-19 06:00:00	YM	Futures	18548.7	18560.1	18522.6	18547.6	4658.0
2014-12-19 07:00:00	YM	Futures	18546.6	18566.4	18537.2	18560.1	3259.0
2014-12-19 08:00:00	YM	Futures	18559.1	18565.4	18512.1	18521.5	6019.0
2014-12-19 09:00:00	YM	Futures	18521.5	18546.6	18462.0	18509.0	27904.0
2014-12-19 10:00:00	YM	Futures	18510.0	18549.7	18496.5	18528.8	23700.0
2014-12-19 11:00:00	YM	Futures	18527.8	18533.0	18500.6	18502.7	11867.0
2014-12-19 12:00:00	YM	Futures	18501.7	18515.3	18469.3	18497.5	10084.0
2014-12-19 13:00:00	YM	Futures	18497.5	18532.0	18492.3	18518.4	6230.0

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

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