PREVIEW / futures_1hour / 2009-04-27

all futures 1-hour files

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

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-04-27 00:00:00	ES	Futures	812.84	815.71	811.88	815.71	3519.0
2009-04-27 01:00:00	ES	Futures	815.71	816.67	814.52	815.95	2509.0
2009-04-27 02:00:00	ES	Futures	815.95	817.63	812.84	813.56	10541.0
2009-04-27 03:00:00	ES	Futures	813.56	815.71	812.84	814.75	19277.0
2009-04-27 04:00:00	ES	Futures	814.52	817.87	813.56	817.15	16048.0
2009-04-27 05:00:00	ES	Futures	817.39	817.63	813.8	815.71	10665.0
2009-04-27 06:00:00	ES	Futures	815.71	817.39	813.32	814.75	13835.0
2009-04-27 07:00:00	ES	Futures	814.75	818.11	814.28	816.19	19971.0
2009-04-27 08:00:00	ES	Futures	816.19	816.19	813.08	815.47	39132.0
2009-04-27 09:00:00	ES	Futures	815.47	822.9	814.28	821.46	301079.0
2009-04-27 10:00:00	ES	Futures	821.7	828.41	816.67	828.17	485742.0
2009-04-27 11:00:00	ES	Futures	828.17	829.37	825.78	827.93	217771.0
2009-04-27 12:00:00	ES	Futures	827.93	829.85	822.42	823.62	200308.0
2009-04-27 13:00:00	ES	Futures	823.62	824.1	815.23	817.39	267421.0
2009-04-27 14:00:00	ES	Futures	817.15	820.51	815.23	819.31	255659.0
2009-04-27 15:00:00	ES	Futures	819.55	823.62	815.71	818.59	457527.0
2009-04-27 16:00:00	ES	Futures	818.83	821.46	815.47	817.15	93875.0
2009-04-27 17:00:00	ES	Futures	817.15	817.39	816.19	816.91	1580.0
2009-04-27 18:00:00	ES	Futures	817.39	818.11	815.95	816.67	2248.0
2009-04-27 19:00:00	ES	Futures	816.67	817.63	816.43	816.67	1251.0
2009-04-27 20:00:00	ES	Futures	816.43	819.79	815.23	819.31	6888.0
2009-04-27 21:00:00	ES	Futures	819.55	820.51	817.15	818.35	4199.0
2009-04-27 22:00:00	ES	Futures	818.11	818.35	814.75	815.47	4855.0
2009-04-27 23:00:00	ES	Futures	815.71	815.95	812.84	814.75	6063.0
2009-04-27 00:00:00	NQ	Futures	1537.2	1541.17	1534.92	1541.17	237.0
2009-04-27 01:00:00	NQ	Futures	1541.46	1542.88	1538.9	1542.31	188.0
2009-04-27 02:00:00	NQ	Futures	1542.31	1543.45	1535.21	1536.63	769.0
2009-04-27 03:00:00	NQ	Futures	1536.63	1540.32	1534.92	1538.05	1393.0
2009-04-27 04:00:00	NQ	Futures	1538.05	1542.03	1536.91	1541.17	983.0
2009-04-27 05:00:00	NQ	Futures	1541.74	1542.03	1536.34	1539.75	1126.0
2009-04-27 06:00:00	NQ	Futures	1540.04	1541.74	1537.2	1539.19	1346.0
2009-04-27 07:00:00	NQ	Futures	1539.75	1543.16	1537.48	1540.61	1867.0
2009-04-27 08:00:00	NQ	Futures	1540.89	1541.46	1536.34	1539.75	5376.0
2009-04-27 09:00:00	NQ	Futures	1539.75	1561.35	1538.9	1557.37	46307.0
2009-04-27 10:00:00	NQ	Futures	1557.65	1571.29	1549.98	1570.44	66523.0
2009-04-27 11:00:00	NQ	Futures	1570.16	1572.43	1564.19	1568.45	29402.0
2009-04-27 12:00:00	NQ	Futures	1568.45	1571.86	1559.93	1561.63	19438.0
2009-04-27 13:00:00	NQ	Futures	1561.63	1562.2	1549.13	1553.11	27440.0
2009-04-27 14:00:00	NQ	Futures	1552.82	1557.65	1547.99	1555.38	25853.0
2009-04-27 15:00:00	NQ	Futures	1555.67	1562.77	1549.98	1555.67	43271.0
2009-04-27 16:00:00	NQ	Futures	1555.95	1560.5	1553.39	1555.95	8179.0
2009-04-27 17:00:00	NQ	Futures	1555.67	1557.37	1554.24	1555.38	271.0
2009-04-27 18:00:00	NQ	Futures	1556.23	1556.52	1553.39	1554.24	151.0
2009-04-27 19:00:00	NQ	Futures	1553.96	1556.8	1553.96	1555.1	151.0
2009-04-27 20:00:00	NQ	Futures	1554.81	1560.5	1552.26	1560.21	277.0
2009-04-27 21:00:00	NQ	Futures	1559.36	1561.06	1555.1	1557.94	228.0
2009-04-27 22:00:00	NQ	Futures	1557.65	1557.65	1551.12	1551.97	245.0
2009-04-27 23:00:00	NQ	Futures	1551.97	1553.11	1549.41	1553.11	429.0
2009-04-27 00:00:00	YM	Futures	7263.4	7290.0	7260.6	7286.3	564.0
2009-04-27 01:00:00	YM	Futures	7287.3	7292.8	7275.3	7290.0	234.0

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

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