PREVIEW / futures_1hour / 2009-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-04.parquet
  size:    44 KB
  rows:    1,263

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
2009-06-04 00:00:00	ES	Futures	892.4	892.88	891.2	891.68	2602.0
2009-06-04 01:00:00	ES	Futures	891.68	892.88	891.2	892.16	1789.0
2009-06-04 02:00:00	ES	Futures	891.92	894.79	891.44	894.31	5758.0
2009-06-04 03:00:00	ES	Futures	894.55	899.82	894.55	899.11	38581.0
2009-06-04 04:00:00	ES	Futures	899.35	899.82	896.47	896.95	11740.0
2009-06-04 05:00:00	ES	Futures	896.95	899.59	896.71	899.11	8955.0
2009-06-04 06:00:00	ES	Futures	899.11	899.59	896.47	897.67	11639.0
2009-06-04 07:00:00	ES	Futures	897.91	897.91	892.16	892.16	24455.0
2009-06-04 08:00:00	ES	Futures	892.4	897.67	890.96	896.47	49962.0
2009-06-04 09:00:00	ES	Futures	896.71	897.91	891.68	893.83	206783.0
2009-06-04 10:00:00	ES	Futures	894.07	899.11	889.52	898.15	313199.0
2009-06-04 11:00:00	ES	Futures	898.15	899.11	895.75	895.99	175551.0
2009-06-04 12:00:00	ES	Futures	895.99	899.11	894.07	897.67	122913.0
2009-06-04 13:00:00	ES	Futures	897.91	902.22	897.19	901.5	176923.0
2009-06-04 14:00:00	ES	Futures	901.5	902.7	900.06	900.54	179967.0
2009-06-04 15:00:00	ES	Futures	900.78	902.94	899.11	901.74	308182.0
2009-06-04 16:00:00	ES	Futures	901.98	902.7	900.78	902.7	107007.0
2009-06-04 17:00:00	ES	Futures	902.7	902.94	901.5	901.98	1627.0
2009-06-04 18:00:00	ES	Futures	901.98	902.94	901.5	902.7	1841.0
2009-06-04 19:00:00	ES	Futures	902.46	902.94	902.22	902.46	1128.0
2009-06-04 20:00:00	ES	Futures	902.46	904.38	902.22	903.18	3989.0
2009-06-04 21:00:00	ES	Futures	903.42	903.66	901.74	901.98	1891.0
2009-06-04 22:00:00	ES	Futures	901.98	902.94	901.74	902.22	1826.0
2009-06-04 23:00:00	ES	Futures	901.98	903.18	901.98	902.7	1403.0
2009-06-04 00:00:00	NQ	Futures	1676.99	1677.28	1675.86	1675.86	159.0
2009-06-04 01:00:00	NQ	Futures	1676.43	1678.41	1675.57	1677.28	151.0
2009-06-04 02:00:00	NQ	Futures	1676.43	1682.96	1676.14	1680.97	651.0
2009-06-04 03:00:00	NQ	Futures	1680.97	1690.35	1680.69	1687.79	1865.0
2009-06-04 04:00:00	NQ	Futures	1687.79	1689.21	1684.1	1684.67	1366.0
2009-06-04 05:00:00	NQ	Futures	1684.67	1688.64	1684.38	1687.79	586.0
2009-06-04 06:00:00	NQ	Futures	1687.51	1687.79	1681.26	1683.24	1543.0
2009-06-04 07:00:00	NQ	Futures	1682.68	1682.68	1675.86	1676.43	2352.0
2009-06-04 08:00:00	NQ	Futures	1676.43	1683.24	1675.0	1681.54	4522.0
2009-06-04 09:00:00	NQ	Futures	1681.82	1692.34	1677.28	1689.5	34901.0
2009-06-04 10:00:00	NQ	Futures	1689.5	1690.06	1678.7	1687.79	38584.0
2009-06-04 11:00:00	NQ	Futures	1687.79	1688.64	1683.53	1683.53	19089.0
2009-06-04 12:00:00	NQ	Futures	1683.53	1689.78	1680.4	1687.22	13350.0
2009-06-04 13:00:00	NQ	Futures	1687.51	1695.75	1686.09	1692.05	19438.0
2009-06-04 14:00:00	NQ	Futures	1692.62	1695.18	1689.21	1691.77	19582.0
2009-06-04 15:00:00	NQ	Futures	1691.48	1697.74	1688.07	1694.89	35420.0
2009-06-04 16:00:00	NQ	Futures	1695.46	1697.45	1694.04	1696.88	8697.0
2009-06-04 17:00:00	NQ	Futures	1696.6	1697.17	1695.46	1696.31	94.0
2009-06-04 18:00:00	NQ	Futures	1696.6	1697.17	1695.46	1697.17	201.0
2009-06-04 19:00:00	NQ	Futures	1697.17	1698.59	1696.03	1698.3	379.0
2009-06-04 20:00:00	NQ	Futures	1698.02	1701.15	1698.02	1699.44	376.0
2009-06-04 21:00:00	NQ	Futures	1699.16	1699.44	1696.31	1697.17	110.0
2009-06-04 22:00:00	NQ	Futures	1697.17	1698.87	1696.31	1696.6	53.0
2009-06-04 23:00:00	NQ	Futures	1696.88	1698.87	1696.88	1698.02	73.0
2009-06-04 00:00:00	YM	Futures	7957.2	7960.9	7944.3	7950.7	324.0
2009-06-04 01:00:00	YM	Futures	7949.8	7959.0	7947.1	7955.3	99.0

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

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