PREVIEW / futures_1hour / 2013-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-23.parquet
  size:    50 KB
  rows:    1,549

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-10-23 00:00:00	ES	Futures	1800.82	1801.34	1798.76	1799.53	11759.0
2013-10-23 01:00:00	ES	Futures	1799.27	1799.79	1797.73	1797.73	8168.0
2013-10-23 02:00:00	ES	Futures	1797.73	1799.02	1795.66	1796.44	14150.0
2013-10-23 03:00:00	ES	Futures	1796.44	1797.98	1793.34	1794.37	30677.0
2013-10-23 04:00:00	ES	Futures	1794.11	1796.18	1792.57	1795.92	23389.0
2013-10-23 05:00:00	ES	Futures	1795.92	1796.95	1794.37	1794.37	15968.0
2013-10-23 06:00:00	ES	Futures	1794.37	1796.69	1793.34	1795.92	23107.0
2013-10-23 07:00:00	ES	Futures	1795.92	1796.95	1794.37	1795.92	29230.0
2013-10-23 08:00:00	ES	Futures	1795.92	1798.76	1795.4	1798.5	41107.0
2013-10-23 09:00:00	ES	Futures	1798.5	1799.53	1792.31	1792.82	243373.0
2013-10-23 10:00:00	ES	Futures	1792.82	1797.73	1789.73	1792.82	301101.0
2013-10-23 11:00:00	ES	Futures	1792.82	1797.21	1792.31	1795.66	156239.0
2013-10-23 12:00:00	ES	Futures	1795.4	1796.18	1792.05	1795.92	115180.0
2013-10-23 13:00:00	ES	Futures	1795.92	1796.95	1793.86	1795.15	99593.0
2013-10-23 14:00:00	ES	Futures	1795.15	1799.02	1794.63	1797.47	115828.0
2013-10-23 15:00:00	ES	Futures	1797.73	1798.76	1794.37	1796.69	185843.0
2013-10-23 16:00:00	ES	Futures	1796.69	1798.76	1796.44	1798.24	73470.0
2013-10-23 17:00:00	ES	Futures	1797.98	1799.02	1797.98	1797.98	3208.0
2013-10-23 18:00:00	ES	Futures	1798.24	1798.76	1796.18	1797.47	4057.0
2013-10-23 19:00:00	ES	Futures	1797.73	1798.5	1796.95	1797.98	1663.0
2013-10-23 20:00:00	ES	Futures	1797.98	1800.82	1797.98	1799.02	8834.0
2013-10-23 21:00:00	ES	Futures	1799.02	1802.37	1798.5	1801.6	13076.0
2013-10-23 22:00:00	ES	Futures	1801.34	1802.89	1800.05	1801.6	10712.0
2013-10-23 23:00:00	ES	Futures	1801.34	1802.11	1801.08	1801.85	2448.0
2013-10-23 00:00:00	NQ	Futures	3890.34	3891.21	3883.95	3885.7	1967.0
2013-10-23 01:00:00	NQ	Futures	3885.7	3886.57	3882.79	3883.08	1242.0
2013-10-23 02:00:00	NQ	Futures	3883.08	3885.7	3879.31	3880.47	1302.0
2013-10-23 03:00:00	NQ	Futures	3880.47	3883.95	3873.5	3874.95	3287.0
2013-10-23 04:00:00	NQ	Futures	3874.95	3880.47	3872.92	3880.18	2548.0
2013-10-23 05:00:00	NQ	Futures	3880.18	3880.76	3875.82	3876.11	1437.0
2013-10-23 06:00:00	NQ	Futures	3876.11	3879.31	3872.63	3877.56	2327.0
2013-10-23 07:00:00	NQ	Futures	3877.56	3879.31	3873.79	3877.27	3305.0
2013-10-23 08:00:00	NQ	Futures	3877.56	3885.41	3876.4	3884.83	5433.0
2013-10-23 09:00:00	NQ	Futures	3884.83	3890.63	3870.3	3870.88	46777.0
2013-10-23 10:00:00	NQ	Futures	3870.88	3881.05	3859.56	3864.79	51513.0
2013-10-23 11:00:00	NQ	Futures	3864.79	3874.66	3860.72	3871.76	27991.0
2013-10-23 12:00:00	NQ	Futures	3871.76	3876.69	3863.62	3875.24	18244.0
2013-10-23 13:00:00	NQ	Futures	3875.24	3877.56	3870.3	3873.21	16859.0
2013-10-23 14:00:00	NQ	Futures	3873.21	3881.05	3870.59	3878.73	17002.0
2013-10-23 15:00:00	NQ	Futures	3878.44	3879.89	3871.47	3879.02	32321.0
2013-10-23 16:00:00	NQ	Futures	3879.31	3883.95	3878.15	3883.37	5726.0
2013-10-23 17:00:00	NQ	Futures	3883.37	3884.83	3883.08	3883.08	294.0
2013-10-23 18:00:00	NQ	Futures	3882.79	3883.95	3878.73	3881.92	528.0
2013-10-23 19:00:00	NQ	Futures	3882.21	3883.37	3881.05	3882.79	278.0
2013-10-23 20:00:00	NQ	Futures	3882.79	3887.44	3882.79	3883.08	968.0
2013-10-23 21:00:00	NQ	Futures	3883.08	3891.51	3882.21	3889.18	1709.0
2013-10-23 22:00:00	NQ	Futures	3889.18	3891.51	3886.57	3888.89	1401.0
2013-10-23 23:00:00	NQ	Futures	3889.18	3890.92	3888.31	3890.34	436.0
2013-10-23 00:00:00	YM	Futures	15698.6	15699.6	15680.2	15683.3	1374.0
2013-10-23 01:00:00	YM	Futures	15683.3	15685.3	15672.1	15672.1	1332.0

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

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