PREVIEW / futures_1hour / 2009-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-28.parquet
  size:    44 KB
  rows:    1,284

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-28 00:00:00	ES	Futures	943.68	944.89	942.96	943.92	1806.0
2009-07-28 01:00:00	ES	Futures	944.16	945.13	943.92	945.13	1510.0
2009-07-28 02:00:00	ES	Futures	945.13	945.13	942.48	942.48	7019.0
2009-07-28 03:00:00	ES	Futures	942.48	946.82	942.48	945.13	20075.0
2009-07-28 04:00:00	ES	Futures	945.13	946.33	942.96	943.2	10193.0
2009-07-28 05:00:00	ES	Futures	943.2	944.41	941.75	942.72	12172.0
2009-07-28 06:00:00	ES	Futures	942.48	943.92	940.79	941.99	10051.0
2009-07-28 07:00:00	ES	Futures	941.99	941.99	937.89	938.14	27491.0
2009-07-28 08:00:00	ES	Futures	938.14	940.55	938.14	940.31	36199.0
2009-07-28 09:00:00	ES	Futures	940.55	944.65	937.17	943.44	249665.0
2009-07-28 10:00:00	ES	Futures	943.44	944.16	935.24	939.1	345733.0
2009-07-28 11:00:00	ES	Futures	939.34	939.34	931.86	934.52	292583.0
2009-07-28 12:00:00	ES	Futures	934.52	936.21	933.07	935.24	108623.0
2009-07-28 13:00:00	ES	Futures	935.0	939.82	933.31	939.1	165161.0
2009-07-28 14:00:00	ES	Futures	938.86	943.68	937.65	939.58	254846.0
2009-07-28 15:00:00	ES	Futures	939.34	942.48	936.93	941.75	287915.0
2009-07-28 16:00:00	ES	Futures	941.51	942.48	939.1	939.82	83817.0
2009-07-28 17:00:00	ES	Futures	940.06	940.55	939.34	940.31	889.0
2009-07-28 18:00:00	ES	Futures	940.06	940.06	938.86	939.34	1868.0
2009-07-28 19:00:00	ES	Futures	939.1	939.1	937.41	938.14	2862.0
2009-07-28 20:00:00	ES	Futures	938.14	941.51	937.89	940.79	3891.0
2009-07-28 21:00:00	ES	Futures	940.79	941.51	939.82	940.06	3480.0
2009-07-28 22:00:00	ES	Futures	940.31	940.55	939.58	939.82	1658.0
2009-07-28 23:00:00	ES	Futures	939.82	939.82	937.65	937.65	3218.0
2009-07-28 00:00:00	NQ	Futures	1819.08	1822.79	1818.23	1821.08	237.0
2009-07-28 01:00:00	NQ	Futures	1820.51	1820.51	1818.51	1820.51	205.0
2009-07-28 02:00:00	NQ	Futures	1820.79	1820.79	1817.94	1817.94	374.0
2009-07-28 03:00:00	NQ	Futures	1817.94	1827.06	1817.94	1823.93	1415.0
2009-07-28 04:00:00	NQ	Futures	1823.93	1825.63	1819.65	1819.94	675.0
2009-07-28 05:00:00	NQ	Futures	1819.94	1822.5	1817.66	1819.37	1401.0
2009-07-28 06:00:00	NQ	Futures	1819.37	1820.79	1815.95	1817.94	1285.0
2009-07-28 07:00:00	NQ	Futures	1818.23	1818.8	1811.39	1811.39	2514.0
2009-07-28 08:00:00	NQ	Futures	1811.68	1815.38	1810.26	1815.38	3960.0
2009-07-28 09:00:00	NQ	Futures	1815.67	1823.93	1809.97	1820.51	36352.0
2009-07-28 10:00:00	NQ	Futures	1821.65	1821.65	1804.27	1813.96	53318.0
2009-07-28 11:00:00	NQ	Futures	1813.67	1813.96	1801.71	1807.98	43794.0
2009-07-28 12:00:00	NQ	Futures	1808.26	1810.54	1805.41	1809.4	18362.0
2009-07-28 13:00:00	NQ	Futures	1809.12	1822.79	1806.27	1821.36	34946.0
2009-07-28 14:00:00	NQ	Futures	1821.36	1831.9	1818.23	1821.65	46060.0
2009-07-28 15:00:00	NQ	Futures	1821.65	1828.48	1816.24	1825.92	54110.0
2009-07-28 16:00:00	NQ	Futures	1826.2	1827.91	1821.93	1823.64	6803.0
2009-07-28 17:00:00	NQ	Futures	1823.36	1824.5	1821.65	1824.21	207.0
2009-07-28 18:00:00	NQ	Futures	1823.36	1824.21	1821.36	1822.5	175.0
2009-07-28 19:00:00	NQ	Futures	1822.5	1822.79	1818.51	1820.22	399.0
2009-07-28 20:00:00	NQ	Futures	1819.65	1826.2	1819.65	1825.35	326.0
2009-07-28 21:00:00	NQ	Futures	1825.63	1827.06	1825.35	1825.35	368.0
2009-07-28 22:00:00	NQ	Futures	1825.35	1826.2	1824.5	1824.78	308.0
2009-07-28 23:00:00	NQ	Futures	1825.07	1825.07	1820.51	1820.79	396.0
2009-07-28 00:00:00	YM	Futures	8376.3	8389.2	8373.5	8380.9	108.0
2009-07-28 01:00:00	YM	Futures	8382.8	8388.3	8376.3	8386.5	67.0

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

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