PREVIEW / futures_1hour / 2009-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-29.parquet
  size:    42 KB
  rows:    1,262

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-29 00:00:00	ES	Futures	937.89	939.34	936.93	938.14	3670.0
2009-07-29 01:00:00	ES	Futures	938.14	938.62	937.17	937.89	2753.0
2009-07-29 02:00:00	ES	Futures	937.89	938.14	929.94	932.35	26994.0
2009-07-29 03:00:00	ES	Futures	932.11	937.65	932.11	936.45	27586.0
2009-07-29 04:00:00	ES	Futures	936.69	940.31	936.45	937.65	29427.0
2009-07-29 05:00:00	ES	Futures	937.89	939.58	935.0	935.0	15970.0
2009-07-29 06:00:00	ES	Futures	935.0	940.06	935.0	938.62	18536.0
2009-07-29 07:00:00	ES	Futures	938.62	939.1	935.48	935.48	21180.0
2009-07-29 08:00:00	ES	Futures	935.72	940.06	934.04	935.0	60002.0
2009-07-29 09:00:00	ES	Futures	935.0	937.65	932.35	937.17	256433.0
2009-07-29 10:00:00	ES	Futures	936.93	940.55	934.76	936.93	326965.0
2009-07-29 11:00:00	ES	Futures	936.69	938.38	932.11	935.72	210818.0
2009-07-29 12:00:00	ES	Futures	935.72	938.14	935.0	936.69	125909.0
2009-07-29 13:00:00	ES	Futures	936.69	936.69	931.14	933.79	192423.0
2009-07-29 14:00:00	ES	Futures	933.79	936.21	931.38	931.86	167354.0
2009-07-29 15:00:00	ES	Futures	931.62	939.34	931.62	937.89	279846.0
2009-07-29 16:00:00	ES	Futures	937.65	940.79	937.41	940.06	85136.0
2009-07-29 17:00:00	ES	Futures	940.31	942.48	940.06	941.51	3774.0
2009-07-29 18:00:00	ES	Futures	941.03	941.27	940.06	940.06	2419.0
2009-07-29 19:00:00	ES	Futures	940.06	940.79	939.34	940.79	2380.0
2009-07-29 20:00:00	ES	Futures	940.79	941.51	940.55	941.27	3930.0
2009-07-29 21:00:00	ES	Futures	941.51	942.48	939.34	942.23	7739.0
2009-07-29 22:00:00	ES	Futures	942.48	944.16	941.75	943.92	8927.0
2009-07-29 23:00:00	ES	Futures	944.16	944.16	941.51	942.72	6509.0
2009-07-29 00:00:00	NQ	Futures	1820.79	1822.79	1818.8	1821.36	214.0
2009-07-29 01:00:00	NQ	Futures	1821.36	1821.93	1819.37	1821.93	107.0
2009-07-29 02:00:00	NQ	Futures	1820.22	1821.65	1809.97	1811.11	4207.0
2009-07-29 03:00:00	NQ	Futures	1811.11	1819.94	1811.11	1818.8	1852.0
2009-07-29 04:00:00	NQ	Futures	1818.51	1824.78	1817.66	1821.36	2276.0
2009-07-29 05:00:00	NQ	Futures	1821.65	1823.93	1816.52	1816.52	977.0
2009-07-29 06:00:00	NQ	Futures	1816.81	1826.2	1816.81	1823.64	1086.0
2009-07-29 07:00:00	NQ	Futures	1823.93	1824.5	1815.95	1815.95	3313.0
2009-07-29 08:00:00	NQ	Futures	1815.95	1821.65	1813.67	1814.81	6123.0
2009-07-29 09:00:00	NQ	Futures	1815.1	1821.65	1809.12	1816.81	44289.0
2009-07-29 10:00:00	NQ	Futures	1816.81	1824.5	1814.53	1819.65	57981.0
2009-07-29 11:00:00	NQ	Futures	1819.37	1821.36	1809.4	1816.24	37055.0
2009-07-29 12:00:00	NQ	Futures	1816.24	1821.08	1815.1	1818.23	20870.0
2009-07-29 13:00:00	NQ	Futures	1817.94	1817.94	1804.27	1813.96	38531.0
2009-07-29 14:00:00	NQ	Futures	1813.67	1818.8	1810.54	1811.11	28286.0
2009-07-29 15:00:00	NQ	Futures	1811.11	1823.36	1811.11	1820.79	37892.0
2009-07-29 16:00:00	NQ	Futures	1820.79	1824.5	1819.37	1823.64	10708.0
2009-07-29 17:00:00	NQ	Futures	1823.64	1826.77	1822.5	1825.07	590.0
2009-07-29 18:00:00	NQ	Futures	1824.5	1826.2	1823.36	1824.78	505.0
2009-07-29 19:00:00	NQ	Futures	1824.5	1825.92	1822.79	1825.63	445.0
2009-07-29 20:00:00	NQ	Futures	1825.35	1826.77	1824.5	1826.2	408.0
2009-07-29 21:00:00	NQ	Futures	1826.2	1827.63	1821.65	1827.34	554.0
2009-07-29 22:00:00	NQ	Futures	1827.34	1830.48	1826.49	1829.62	741.0
2009-07-29 23:00:00	NQ	Futures	1829.62	1829.62	1825.07	1827.34	300.0
2009-07-29 00:00:00	YM	Futures	8343.0	8354.1	8338.4	8345.8	256.0
2009-07-29 01:00:00	YM	Futures	8346.7	8348.6	8339.3	8345.8	271.0

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

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