PREVIEW / futures_1hour / 2009-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-17.parquet
  size:    35 KB
  rows:    1,005

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-07-17 00:00:00	ES	Futures	900.03	900.03	898.83	899.31	1090.0
2009-07-17 01:00:00	ES	Futures	899.55	901.0	898.83	900.27	1974.0
2009-07-17 02:00:00	ES	Futures	900.27	901.48	899.07	900.27	6952.0
2009-07-17 03:00:00	ES	Futures	900.27	901.72	898.34	901.24	20294.0
2009-07-17 04:00:00	ES	Futures	901.48	903.65	900.75	902.44	12415.0
2009-07-17 05:00:00	ES	Futures	902.68	902.92	900.51	902.2	10579.0
2009-07-17 06:00:00	ES	Futures	901.96	903.65	901.24	901.96	13032.0
2009-07-17 07:00:00	ES	Futures	901.96	902.92	895.93	897.62	34532.0
2009-07-17 08:00:00	ES	Futures	897.62	901.0	895.21	900.75	62943.0
2009-07-17 09:00:00	ES	Futures	900.75	903.41	898.1	900.75	228405.0
2009-07-17 10:00:00	ES	Futures	901.0	903.89	899.31	900.27	264930.0
2009-07-17 11:00:00	ES	Futures	900.27	901.48	898.83	899.55	127771.0
2009-07-17 12:00:00	ES	Futures	899.55	902.92	899.31	901.48	131738.0
2009-07-17 13:00:00	ES	Futures	901.48	905.58	900.75	903.89	125781.0
2009-07-17 14:00:00	ES	Futures	903.65	904.13	902.2	902.92	128838.0
2009-07-17 15:00:00	ES	Futures	903.17	904.13	899.79	903.89	245107.0
2009-07-17 16:00:00	ES	Futures	903.65	904.37	902.92	904.37	80263.0
2009-07-17 00:00:00	NQ	Futures	1717.69	1718.83	1716.55	1717.12	133.0
2009-07-17 01:00:00	NQ	Futures	1717.69	1721.96	1716.55	1720.82	282.0
2009-07-17 02:00:00	NQ	Futures	1721.11	1723.39	1720.25	1721.39	585.0
2009-07-17 03:00:00	NQ	Futures	1721.11	1724.24	1717.98	1723.39	1149.0
2009-07-17 04:00:00	NQ	Futures	1723.67	1728.51	1723.1	1727.09	1486.0
2009-07-17 05:00:00	NQ	Futures	1727.09	1728.23	1724.24	1726.81	1515.0
2009-07-17 06:00:00	NQ	Futures	1726.52	1729.08	1725.1	1725.38	1022.0
2009-07-17 07:00:00	NQ	Futures	1725.38	1726.81	1715.41	1718.83	3108.0
2009-07-17 08:00:00	NQ	Futures	1718.55	1724.81	1715.7	1723.96	6314.0
2009-07-17 09:00:00	NQ	Futures	1724.24	1731.65	1719.97	1723.96	36390.0
2009-07-17 10:00:00	NQ	Futures	1724.24	1732.22	1719.97	1725.95	43017.0
2009-07-17 11:00:00	NQ	Futures	1725.67	1729.37	1723.39	1727.66	21498.0
2009-07-17 12:00:00	NQ	Futures	1727.66	1731.93	1727.38	1730.22	20958.0
2009-07-17 13:00:00	NQ	Futures	1730.22	1738.2	1729.94	1734.78	22930.0
2009-07-17 14:00:00	NQ	Futures	1735.07	1737.63	1733.64	1736.2	19622.0
2009-07-17 15:00:00	NQ	Futures	1736.49	1737.91	1730.22	1737.06	34616.0
2009-07-17 16:00:00	NQ	Futures	1737.06	1741.9	1737.06	1741.9	10854.0
2009-07-17 00:00:00	YM	Futures	7996.3	7996.3	7989.8	7990.7	72.0
2009-07-17 01:00:00	YM	Futures	7991.7	8004.6	7987.0	7997.2	148.0
2009-07-17 02:00:00	YM	Futures	8001.8	8004.6	7988.0	7995.3	354.0
2009-07-17 03:00:00	YM	Futures	7995.3	8002.7	7982.4	8000.9	989.0
2009-07-17 04:00:00	YM	Futures	8000.9	8016.6	7996.3	8008.3	957.0
2009-07-17 05:00:00	YM	Futures	8007.4	8011.1	7995.3	8008.3	1034.0
2009-07-17 06:00:00	YM	Futures	8007.4	8020.3	8003.7	8010.1	777.0
2009-07-17 07:00:00	YM	Futures	8011.1	8016.6	7965.8	7977.8	1542.0
2009-07-17 08:00:00	YM	Futures	7977.8	8009.2	7962.1	8006.4	3290.0
2009-07-17 09:00:00	YM	Futures	8005.5	8027.7	7973.2	7999.0	14017.0
2009-07-17 10:00:00	YM	Futures	7997.2	8026.8	7983.3	8002.7	18028.0
2009-07-17 11:00:00	YM	Futures	8002.7	8017.5	7994.4	7999.0	9660.0
2009-07-17 12:00:00	YM	Futures	7998.1	8025.9	7996.3	8014.8	11543.0
2009-07-17 13:00:00	YM	Futures	8014.8	8051.8	8008.3	8033.3	12912.0
2009-07-17 14:00:00	YM	Futures	8034.2	8039.7	8021.2	8032.3	7782.0
2009-07-17 15:00:00	YM	Futures	8032.3	8046.2	8005.5	8041.6	15099.0

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

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