PREVIEW / futures_1hour / 2009-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-24.parquet
  size:    37 KB
  rows:    1,024

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-24 00:00:00	ES	Futures	810.92	811.4	807.09	807.33	5455.0
2009-04-24 01:00:00	ES	Futures	807.09	809.0	806.61	808.52	3029.0
2009-04-24 02:00:00	ES	Futures	808.28	810.44	808.28	809.72	5866.0
2009-04-24 03:00:00	ES	Futures	809.72	813.8	808.52	813.56	15261.0
2009-04-24 04:00:00	ES	Futures	813.32	814.99	811.88	812.12	15487.0
2009-04-24 05:00:00	ES	Futures	811.88	813.08	810.68	811.4	8079.0
2009-04-24 06:00:00	ES	Futures	811.64	815.23	811.4	814.99	9819.0
2009-04-24 07:00:00	ES	Futures	814.99	820.03	814.52	818.35	29774.0
2009-04-24 08:00:00	ES	Futures	818.35	820.27	815.71	816.91	33548.0
2009-04-24 09:00:00	ES	Futures	816.91	822.9	816.91	822.42	238480.0
2009-04-24 10:00:00	ES	Futures	822.66	824.58	817.63	823.38	395848.0
2009-04-24 11:00:00	ES	Futures	823.14	827.93	821.94	826.98	286220.0
2009-04-24 12:00:00	ES	Futures	826.74	828.65	825.3	828.17	148784.0
2009-04-24 13:00:00	ES	Futures	828.41	829.37	824.58	825.3	130413.0
2009-04-24 14:00:00	ES	Futures	825.3	830.81	817.15	830.09	471646.0
2009-04-24 15:00:00	ES	Futures	830.33	832.73	821.23	825.78	457064.0
2009-04-24 16:00:00	ES	Futures	826.02	831.05	825.54	830.57	104660.0
2009-04-24 00:00:00	NQ	Futures	1525.26	1525.26	1518.73	1519.01	215.0
2009-04-24 01:00:00	NQ	Futures	1519.01	1520.43	1517.88	1519.3	189.0
2009-04-24 02:00:00	NQ	Futures	1520.15	1523.56	1519.01	1521.85	345.0
2009-04-24 03:00:00	NQ	Futures	1521.85	1528.67	1519.58	1527.54	1159.0
2009-04-24 04:00:00	NQ	Futures	1527.54	1529.52	1523.56	1523.56	1145.0
2009-04-24 05:00:00	NQ	Futures	1523.56	1525.83	1521.85	1523.27	623.0
2009-04-24 06:00:00	NQ	Futures	1523.84	1530.95	1522.99	1530.95	1203.0
2009-04-24 07:00:00	NQ	Futures	1530.66	1540.04	1530.09	1538.9	3608.0
2009-04-24 08:00:00	NQ	Futures	1538.9	1542.6	1535.49	1536.63	4258.0
2009-04-24 09:00:00	NQ	Futures	1536.63	1541.17	1526.4	1538.33	38197.0
2009-04-24 10:00:00	NQ	Futures	1538.33	1549.7	1535.78	1546.86	51239.0
2009-04-24 11:00:00	NQ	Futures	1547.14	1561.06	1544.3	1558.79	43882.0
2009-04-24 12:00:00	NQ	Futures	1558.51	1561.06	1553.39	1559.64	25106.0
2009-04-24 13:00:00	NQ	Futures	1559.64	1560.5	1552.54	1553.39	17541.0
2009-04-24 14:00:00	NQ	Futures	1553.39	1563.91	1541.74	1562.48	57396.0
2009-04-24 15:00:00	NQ	Futures	1562.48	1566.75	1549.13	1556.8	54539.0
2009-04-24 16:00:00	NQ	Futures	1556.52	1563.05	1554.24	1562.2	11885.0
2009-04-24 00:00:00	YM	Futures	7252.3	7252.3	7221.1	7222.9	304.0
2009-04-24 01:00:00	YM	Futures	7223.9	7235.8	7217.4	7230.3	186.0
2009-04-24 02:00:00	YM	Futures	7230.3	7245.9	7230.3	7244.1	370.0
2009-04-24 03:00:00	YM	Futures	7240.4	7272.6	7233.0	7272.6	1081.0
2009-04-24 04:00:00	YM	Futures	7270.7	7282.7	7256.9	7256.9	998.0
2009-04-24 05:00:00	YM	Futures	7256.0	7268.9	7248.7	7254.2	497.0
2009-04-24 06:00:00	YM	Futures	7255.1	7287.3	7251.4	7283.6	675.0
2009-04-24 07:00:00	YM	Futures	7283.6	7320.3	7280.8	7305.6	2174.0
2009-04-24 08:00:00	YM	Futures	7304.7	7319.4	7285.4	7294.6	1992.0
2009-04-24 09:00:00	YM	Futures	7294.6	7357.1	7294.6	7356.2	15576.0
2009-04-24 10:00:00	YM	Futures	7356.2	7371.8	7313.0	7356.2	30056.0
2009-04-24 11:00:00	YM	Futures	7356.2	7396.6	7345.2	7389.3	19800.0
2009-04-24 12:00:00	YM	Futures	7389.3	7398.5	7377.3	7393.9	12238.0
2009-04-24 13:00:00	YM	Futures	7393.9	7415.9	7370.9	7378.2	10788.0
2009-04-24 14:00:00	YM	Futures	7377.3	7415.9	7315.8	7410.4	37249.0
2009-04-24 15:00:00	YM	Futures	7411.3	7426.9	7328.6	7373.6	29002.0

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

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