PREVIEW / futures_1hour / 2009-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-10.parquet
  size:    41 KB
  rows:    1,199

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-10 00:00:00	ES	Futures	904.14	904.62	902.7	904.62	2404.0
2009-06-10 01:00:00	ES	Futures	904.38	906.53	904.38	905.58	5277.0
2009-06-10 02:00:00	ES	Futures	905.34	909.41	905.1	908.69	15368.0
2009-06-10 03:00:00	ES	Futures	908.69	912.29	908.69	910.85	34100.0
2009-06-10 04:00:00	ES	Futures	910.85	911.57	909.17	911.09	17259.0
2009-06-10 05:00:00	ES	Futures	911.09	913.24	910.61	910.61	14738.0
2009-06-10 06:00:00	ES	Futures	910.85	914.68	910.61	913.48	17061.0
2009-06-10 07:00:00	ES	Futures	913.48	915.4	911.57	911.81	31260.0
2009-06-10 08:00:00	ES	Futures	911.57	912.77	909.17	909.41	30671.0
2009-06-10 09:00:00	ES	Futures	909.41	911.57	905.1	907.25	226447.0
2009-06-10 10:00:00	ES	Futures	907.49	907.73	899.11	900.78	373358.0
2009-06-10 11:00:00	ES	Futures	901.02	901.02	897.19	899.59	202572.0
2009-06-10 12:00:00	ES	Futures	899.59	901.98	897.91	899.11	152334.0
2009-06-10 13:00:00	ES	Futures	898.87	899.35	889.28	891.68	344282.0
2009-06-10 14:00:00	ES	Futures	891.68	896.71	888.56	895.51	303365.0
2009-06-10 15:00:00	ES	Futures	895.51	900.3	892.16	899.82	401361.0
2009-06-10 16:00:00	ES	Futures	899.82	901.98	899.59	901.5	108344.0
2009-06-10 17:00:00	ES	Futures	901.5	902.7	901.02	901.26	3018.0
2009-06-10 18:00:00	ES	Futures	901.5	902.7	901.5	901.98	2205.0
2009-06-10 19:00:00	ES	Futures	901.98	902.22	901.5	902.22	1093.0
2009-06-10 20:00:00	ES	Futures	902.22	906.06	901.98	905.1	6956.0
2009-06-10 21:00:00	ES	Futures	905.1	906.77	903.18	903.42	4560.0
2009-06-10 22:00:00	ES	Futures	903.18	905.82	903.18	905.58	3401.0
2009-06-10 23:00:00	ES	Futures	905.58	906.06	904.86	905.1	2238.0
2009-06-10 00:00:00	NQ	Futures	1711.09	1712.79	1709.1	1712.79	161.0
2009-06-10 01:00:00	NQ	Futures	1712.51	1715.35	1711.94	1713.93	329.0
2009-06-10 02:00:00	NQ	Futures	1715.07	1720.47	1714.5	1718.76	1599.0
2009-06-10 03:00:00	NQ	Futures	1719.05	1723.02	1719.05	1722.46	2377.0
2009-06-10 04:00:00	NQ	Futures	1722.74	1723.59	1719.33	1721.89	1278.0
2009-06-10 05:00:00	NQ	Futures	1721.89	1724.73	1718.48	1718.76	1986.0
2009-06-10 06:00:00	NQ	Futures	1718.76	1725.01	1718.76	1722.74	1791.0
2009-06-10 07:00:00	NQ	Futures	1722.46	1725.01	1719.05	1719.05	3131.0
2009-06-10 08:00:00	NQ	Futures	1719.05	1720.75	1715.64	1716.49	4310.0
2009-06-10 09:00:00	NQ	Futures	1716.2	1718.76	1698.59	1703.13	36520.0
2009-06-10 10:00:00	NQ	Futures	1703.13	1704.27	1686.65	1688.93	50922.0
2009-06-10 11:00:00	NQ	Futures	1688.93	1688.93	1680.4	1685.23	37415.0
2009-06-10 12:00:00	NQ	Futures	1685.23	1695.18	1684.38	1690.35	25817.0
2009-06-10 13:00:00	NQ	Futures	1690.06	1690.92	1675.57	1679.55	33980.0
2009-06-10 14:00:00	NQ	Futures	1679.27	1690.63	1674.44	1688.36	35130.0
2009-06-10 15:00:00	NQ	Futures	1688.07	1700.58	1680.97	1698.87	65534.0
2009-06-10 16:00:00	NQ	Futures	1698.59	1700.86	1698.59	1700.86	9746.0
2009-06-10 17:00:00	NQ	Futures	1700.86	1702.0	1699.16	1699.72	280.0
2009-06-10 18:00:00	NQ	Futures	1700.01	1702.85	1700.01	1700.86	98.0
2009-06-10 19:00:00	NQ	Futures	1700.86	1702.0	1699.72	1700.58	105.0
2009-06-10 20:00:00	NQ	Futures	1701.43	1708.25	1700.86	1706.83	753.0
2009-06-10 21:00:00	NQ	Futures	1706.83	1709.39	1702.85	1703.13	431.0
2009-06-10 22:00:00	NQ	Futures	1703.13	1707.11	1703.13	1706.54	315.0
2009-06-10 23:00:00	NQ	Futures	1706.83	1707.4	1705.41	1706.54	211.0
2009-06-10 00:00:00	YM	Futures	8064.7	8065.6	8063.8	8063.8	4.0
2009-06-10 01:00:00	YM	Futures	8068.4	8075.8	8068.4	8075.8	16.0

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

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