PREVIEW / futures_1hour / 2014-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-06.parquet
  size:    51 KB
  rows:    1,571

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-02-06 00:00:00	ES	Futures	1808.5	1809.28	1806.95	1807.21	3031.0
2014-02-06 01:00:00	ES	Futures	1807.21	1807.99	1805.66	1806.18	4533.0
2014-02-06 02:00:00	ES	Futures	1806.18	1810.06	1806.18	1809.8	7436.0
2014-02-06 03:00:00	ES	Futures	1809.54	1810.06	1805.66	1807.99	24728.0
2014-02-06 04:00:00	ES	Futures	1807.73	1815.75	1807.73	1813.94	33083.0
2014-02-06 05:00:00	ES	Futures	1813.94	1816.52	1813.42	1813.94	21243.0
2014-02-06 06:00:00	ES	Futures	1813.68	1814.97	1812.38	1812.9	13397.0
2014-02-06 07:00:00	ES	Futures	1813.16	1813.68	1804.62	1809.28	53548.0
2014-02-06 08:00:00	ES	Futures	1809.28	1815.49	1804.62	1808.76	127025.0
2014-02-06 09:00:00	ES	Futures	1809.02	1820.66	1807.47	1819.88	264084.0
2014-02-06 10:00:00	ES	Futures	1819.88	1827.39	1819.11	1825.06	318937.0
2014-02-06 11:00:00	ES	Futures	1825.06	1827.9	1823.51	1824.54	169924.0
2014-02-06 12:00:00	ES	Futures	1824.54	1827.64	1824.54	1825.32	89628.0
2014-02-06 13:00:00	ES	Futures	1825.57	1826.61	1822.47	1824.54	84328.0
2014-02-06 14:00:00	ES	Futures	1824.28	1830.23	1824.28	1828.94	148752.0
2014-02-06 15:00:00	ES	Futures	1828.94	1831.01	1827.64	1830.49	221305.0
2014-02-06 16:00:00	ES	Futures	1830.49	1830.75	1826.87	1828.94	104297.0
2014-02-06 17:00:00	ES	Futures	1829.2	1829.71	1828.94	1829.71	2228.0
2014-02-06 18:00:00	ES	Futures	1829.2	1829.45	1827.9	1829.45	4482.0
2014-02-06 19:00:00	ES	Futures	1829.45	1829.45	1828.16	1828.68	3751.0
2014-02-06 20:00:00	ES	Futures	1828.42	1829.2	1827.13	1828.68	5694.0
2014-02-06 21:00:00	ES	Futures	1828.68	1828.94	1827.39	1828.16	2755.0
2014-02-06 22:00:00	ES	Futures	1827.9	1829.2	1827.9	1828.94	2095.0
2014-02-06 23:00:00	ES	Futures	1828.94	1829.2	1828.16	1828.68	2511.0
2014-02-06 00:00:00	NQ	Futures	4016.39	4018.43	4012.9	4013.48	475.0
2014-02-06 01:00:00	NQ	Futures	4013.48	4015.52	4011.74	4012.9	393.0
2014-02-06 02:00:00	NQ	Futures	4012.03	4019.88	4012.03	4019.01	415.0
2014-02-06 03:00:00	NQ	Futures	4019.88	4020.46	4010.0	4014.94	2757.0
2014-02-06 04:00:00	NQ	Futures	4015.23	4030.05	4014.94	4028.02	3773.0
2014-02-06 05:00:00	NQ	Futures	4028.02	4033.83	4026.86	4027.44	2692.0
2014-02-06 06:00:00	NQ	Futures	4027.44	4029.47	4024.53	4025.98	1736.0
2014-02-06 07:00:00	NQ	Futures	4026.27	4027.73	4012.61	4019.88	5029.0
2014-02-06 08:00:00	NQ	Futures	4019.59	4032.96	4012.9	4021.91	15164.0
2014-02-06 09:00:00	NQ	Futures	4022.2	4050.4	4017.55	4048.66	40427.0
2014-02-06 10:00:00	NQ	Futures	4048.66	4068.71	4047.78	4062.9	46983.0
2014-02-06 11:00:00	NQ	Futures	4062.9	4065.81	4055.63	4055.92	27841.0
2014-02-06 12:00:00	NQ	Futures	4055.92	4062.9	4055.92	4059.41	16035.0
2014-02-06 13:00:00	NQ	Futures	4059.41	4061.45	4051.56	4056.51	17895.0
2014-02-06 14:00:00	NQ	Futures	4056.51	4068.13	4056.51	4064.64	25677.0
2014-02-06 15:00:00	NQ	Futures	4064.94	4066.39	4059.7	4062.32	45508.0
2014-02-06 16:00:00	NQ	Futures	4062.61	4063.19	4053.31	4059.41	9907.0
2014-02-06 17:00:00	NQ	Futures	4059.41	4059.7	4058.25	4059.41	199.0
2014-02-06 18:00:00	NQ	Futures	4058.83	4059.99	4056.21	4059.12	408.0
2014-02-06 19:00:00	NQ	Futures	4059.12	4059.12	4056.51	4057.38	274.0
2014-02-06 20:00:00	NQ	Futures	4057.67	4059.99	4054.76	4059.41	757.0
2014-02-06 21:00:00	NQ	Futures	4059.41	4059.41	4056.51	4057.38	405.0
2014-02-06 22:00:00	NQ	Futures	4057.67	4059.99	4057.67	4059.41	162.0
2014-02-06 23:00:00	NQ	Futures	4059.7	4059.99	4058.25	4059.12	193.0
2014-02-06 00:00:00	YM	Futures	15797.4	15801.5	15785.1	15786.1	620.0
2014-02-06 01:00:00	YM	Futures	15786.1	15792.2	15777.9	15782.0	572.0

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

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