PREVIEW / futures_1hour / 2009-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-20.parquet
  size:    37 KB
  rows:    1,016

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-02-20 00:00:00	ES	Futures	733.38	733.61	731.48	733.14	4781.0
2009-02-20 01:00:00	ES	Futures	733.14	733.61	731.48	732.19	2608.0
2009-02-20 02:00:00	ES	Futures	732.43	734.09	731.48	732.43	6599.0
2009-02-20 03:00:00	ES	Futures	732.43	734.33	726.97	730.06	40871.0
2009-02-20 04:00:00	ES	Futures	730.06	730.29	725.08	727.21	24816.0
2009-02-20 05:00:00	ES	Futures	727.21	729.58	725.79	727.21	13701.0
2009-02-20 06:00:00	ES	Futures	727.21	730.06	727.21	728.16	11432.0
2009-02-20 07:00:00	ES	Futures	728.16	728.87	724.13	726.74	25445.0
2009-02-20 08:00:00	ES	Futures	726.5	729.58	725.08	725.79	47556.0
2009-02-20 09:00:00	ES	Futures	725.55	731.01	722.23	729.82	344531.0
2009-02-20 10:00:00	ES	Futures	729.82	734.56	725.79	726.97	410758.0
2009-02-20 11:00:00	ES	Futures	726.74	728.16	721.04	723.42	324396.0
2009-02-20 12:00:00	ES	Futures	723.65	728.63	717.72	719.38	264416.0
2009-02-20 13:00:00	ES	Futures	719.38	722.47	713.93	720.81	336819.0
2009-02-20 14:00:00	ES	Futures	720.81	738.83	718.2	732.9	637967.0
2009-02-20 15:00:00	ES	Futures	732.67	732.9	724.13	730.06	495221.0
2009-02-20 16:00:00	ES	Futures	730.06	730.77	726.97	730.53	110800.0
2009-02-20 00:00:00	NQ	Futures	1314.2	1314.48	1310.53	1313.35	178.0
2009-02-20 01:00:00	NQ	Futures	1311.66	1312.79	1311.09	1312.51	114.0
2009-02-20 02:00:00	NQ	Futures	1311.94	1315.05	1311.09	1312.22	191.0
2009-02-20 03:00:00	NQ	Futures	1313.07	1315.05	1304.03	1308.83	2366.0
2009-02-20 04:00:00	NQ	Futures	1308.83	1308.83	1299.23	1302.06	1531.0
2009-02-20 05:00:00	NQ	Futures	1302.06	1307.14	1299.23	1303.19	1494.0
2009-02-20 06:00:00	NQ	Futures	1303.47	1306.58	1302.9	1303.75	1007.0
2009-02-20 07:00:00	NQ	Futures	1303.75	1305.73	1300.08	1304.03	2257.0
2009-02-20 08:00:00	NQ	Futures	1304.03	1309.4	1301.21	1303.47	4946.0
2009-02-20 09:00:00	NQ	Futures	1303.19	1318.15	1298.95	1314.48	52727.0
2009-02-20 10:00:00	NQ	Futures	1314.76	1323.8	1311.09	1314.2	58676.0
2009-02-20 11:00:00	NQ	Futures	1314.2	1317.59	1310.25	1314.76	57720.0
2009-02-20 12:00:00	NQ	Futures	1314.48	1322.11	1307.14	1309.4	37384.0
2009-02-20 13:00:00	NQ	Futures	1309.12	1311.09	1301.49	1307.99	41803.0
2009-02-20 14:00:00	NQ	Futures	1307.7	1336.79	1304.88	1326.62	103252.0
2009-02-20 15:00:00	NQ	Futures	1326.91	1328.88	1314.76	1323.52	63344.0
2009-02-20 16:00:00	NQ	Futures	1323.8	1325.78	1320.13	1324.65	10848.0
2009-02-20 00:00:00	YM	Futures	6746.2	6748.9	6732.5	6744.3	202.0
2009-02-20 01:00:00	YM	Futures	6744.3	6749.8	6735.2	6738.9	230.0
2009-02-20 02:00:00	YM	Futures	6739.8	6756.2	6735.2	6745.2	398.0
2009-02-20 03:00:00	YM	Futures	6746.2	6756.2	6697.9	6717.0	3186.0
2009-02-20 04:00:00	YM	Futures	6720.6	6722.5	6677.8	6695.1	1449.0
2009-02-20 05:00:00	YM	Futures	6693.3	6709.7	6680.5	6690.6	1465.0
2009-02-20 06:00:00	YM	Futures	6691.5	6715.2	6690.6	6701.5	898.0
2009-02-20 07:00:00	YM	Futures	6703.3	6705.2	6655.0	6687.8	2213.0
2009-02-20 08:00:00	YM	Futures	6688.8	6714.3	6676.0	6684.2	3107.0
2009-02-20 09:00:00	YM	Futures	6683.3	6717.9	6656.9	6709.7	25993.0
2009-02-20 10:00:00	YM	Futures	6709.7	6754.4	6685.1	6692.4	38889.0
2009-02-20 11:00:00	YM	Futures	6692.4	6702.4	6646.8	6662.3	26333.0
2009-02-20 12:00:00	YM	Futures	6662.3	6702.4	6619.5	6635.0	24972.0
2009-02-20 13:00:00	YM	Futures	6634.1	6660.5	6586.7	6645.9	29060.0
2009-02-20 14:00:00	YM	Futures	6646.8	6795.4	6624.0	6742.5	64093.0
2009-02-20 15:00:00	YM	Futures	6743.4	6743.4	6663.2	6707.0	44179.0

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

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