PREVIEW / futures_1hour / 2013-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-08.parquet
  size:    44 KB
  rows:    1,273

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
2013-11-08 00:00:00	ES	Futures	1803.92	1804.69	1803.4	1803.92	3728.0
2013-11-08 01:00:00	ES	Futures	1803.66	1803.92	1802.37	1803.4	3070.0
2013-11-08 02:00:00	ES	Futures	1803.14	1803.92	1802.11	1803.66	7580.0
2013-11-08 03:00:00	ES	Futures	1803.66	1805.72	1803.4	1805.72	25016.0
2013-11-08 04:00:00	ES	Futures	1805.46	1806.75	1804.95	1805.46	18474.0
2013-11-08 05:00:00	ES	Futures	1805.46	1805.72	1804.69	1805.21	11182.0
2013-11-08 06:00:00	ES	Futures	1805.21	1805.46	1803.14	1803.92	23323.0
2013-11-08 07:00:00	ES	Futures	1803.92	1805.21	1801.08	1801.85	43010.0
2013-11-08 08:00:00	ES	Futures	1801.85	1805.46	1791.79	1797.73	226131.0
2013-11-08 09:00:00	ES	Futures	1797.73	1805.98	1796.95	1800.31	348780.0
2013-11-08 10:00:00	ES	Futures	1800.56	1813.72	1800.31	1812.69	384470.0
2013-11-08 11:00:00	ES	Futures	1812.69	1814.75	1810.37	1813.2	169139.0
2013-11-08 12:00:00	ES	Futures	1812.95	1816.3	1812.95	1815.78	116602.0
2013-11-08 13:00:00	ES	Futures	1815.53	1818.88	1813.98	1816.82	116440.0
2013-11-08 14:00:00	ES	Futures	1816.56	1818.62	1816.3	1817.85	111262.0
2013-11-08 15:00:00	ES	Futures	1817.85	1823.78	1815.01	1823.52	314475.0
2013-11-08 16:00:00	ES	Futures	1823.78	1824.3	1821.46	1821.72	105434.0
2013-11-08 17:00:00	ES	Futures	1821.46	1823.01	1821.46	1823.01	1722.0
2013-11-08 00:00:00	NQ	Futures	3863.91	3865.66	3863.33	3863.91	569.0
2013-11-08 01:00:00	NQ	Futures	3863.62	3863.91	3861.3	3861.88	466.0
2013-11-08 02:00:00	NQ	Futures	3861.88	3864.49	3859.85	3863.91	1132.0
2013-11-08 03:00:00	NQ	Futures	3863.91	3869.43	3862.75	3869.43	3274.0
2013-11-08 04:00:00	NQ	Futures	3869.14	3872.05	3867.98	3869.72	2477.0
2013-11-08 05:00:00	NQ	Futures	3870.01	3871.17	3868.85	3870.01	1859.0
2013-11-08 06:00:00	NQ	Futures	3870.01	3870.3	3866.24	3869.14	2302.0
2013-11-08 07:00:00	NQ	Futures	3869.14	3870.88	3862.17	3863.04	4487.0
2013-11-08 08:00:00	NQ	Futures	3863.04	3876.11	3845.33	3859.85	28547.0
2013-11-08 09:00:00	NQ	Futures	3859.85	3877.27	3857.23	3861.88	51093.0
2013-11-08 10:00:00	NQ	Futures	3861.59	3892.38	3861.01	3886.57	61492.0
2013-11-08 11:00:00	NQ	Futures	3886.57	3896.15	3881.34	3893.83	26794.0
2013-11-08 12:00:00	NQ	Futures	3893.83	3899.35	3893.25	3897.02	18416.0
2013-11-08 13:00:00	NQ	Futures	3896.73	3904.57	3894.12	3899.93	17029.0
2013-11-08 14:00:00	NQ	Futures	3899.64	3901.96	3897.6	3898.77	11507.0
2013-11-08 15:00:00	NQ	Futures	3899.06	3906.61	3892.67	3906.03	45016.0
2013-11-08 16:00:00	NQ	Futures	3906.03	3906.9	3902.83	3903.41	7983.0
2013-11-08 17:00:00	NQ	Futures	3903.7	3905.45	3902.83	3905.45	249.0
2013-11-08 00:00:00	YM	Futures	15906.9	15913.1	15901.8	15903.9	604.0
2013-11-08 01:00:00	YM	Futures	15902.9	15903.9	15893.7	15899.8	592.0
2013-11-08 02:00:00	YM	Futures	15898.8	15906.9	15891.6	15903.9	793.0
2013-11-08 03:00:00	YM	Futures	15905.9	15921.2	15899.8	15920.2	2993.0
2013-11-08 04:00:00	YM	Futures	15920.2	15926.3	15913.1	15914.1	1686.0
2013-11-08 05:00:00	YM	Futures	15915.1	15917.2	15911.0	15913.1	1249.0
2013-11-08 06:00:00	YM	Futures	15913.1	15915.1	15901.8	15906.9	2031.0
2013-11-08 07:00:00	YM	Futures	15909.0	15915.1	15883.5	15887.5	2633.0
2013-11-08 08:00:00	YM	Futures	15887.5	15915.1	15824.2	15864.1	17131.0
2013-11-08 09:00:00	YM	Futures	15863.0	15916.1	15853.8	15871.2	29116.0
2013-11-08 10:00:00	YM	Futures	15871.2	15980.5	15869.2	15969.2	35333.0
2013-11-08 11:00:00	YM	Futures	15969.2	15974.3	15945.8	15951.9	14213.0
2013-11-08 12:00:00	YM	Futures	15951.9	15976.4	15951.9	15967.2	9238.0
2013-11-08 13:00:00	YM	Futures	15967.2	15996.8	15953.9	15975.4	10579.0

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

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