PREVIEW / futures_1hour / 2009-04-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	800.38	801.1	797.98	798.94	4181.0
2009-04-03 01:00:00	ES	Futures	798.94	799.66	797.5	799.42	4321.0
2009-04-03 02:00:00	ES	Futures	799.18	799.9	796.06	796.54	7595.0
2009-04-03 03:00:00	ES	Futures	796.54	799.18	795.58	797.26	22531.0
2009-04-03 04:00:00	ES	Futures	797.26	801.1	795.82	800.38	17529.0
2009-04-03 05:00:00	ES	Futures	800.38	804.21	800.38	803.01	24386.0
2009-04-03 06:00:00	ES	Futures	803.01	803.97	800.38	803.49	14281.0
2009-04-03 07:00:00	ES	Futures	803.49	803.97	800.62	803.25	13192.0
2009-04-03 08:00:00	ES	Futures	803.25	809.48	796.06	797.5	139808.0
2009-04-03 09:00:00	ES	Futures	797.74	798.46	792.71	795.1	279931.0
2009-04-03 10:00:00	ES	Futures	795.34	795.58	788.63	791.27	339551.0
2009-04-03 11:00:00	ES	Futures	791.03	795.34	788.87	794.87	207129.0
2009-04-03 12:00:00	ES	Futures	794.87	798.94	794.63	795.82	203396.0
2009-04-03 13:00:00	ES	Futures	795.82	799.18	794.15	798.94	156751.0
2009-04-03 14:00:00	ES	Futures	798.94	803.25	797.26	801.34	219159.0
2009-04-03 15:00:00	ES	Futures	801.34	803.97	794.87	803.49	368386.0
2009-04-03 16:00:00	ES	Futures	803.73	807.57	803.25	805.89	113362.0
2009-04-03 00:00:00	NQ	Futures	1478.1	1480.37	1474.97	1475.25	190.0
2009-04-03 01:00:00	NQ	Futures	1475.25	1477.24	1474.4	1476.11	368.0
2009-04-03 02:00:00	NQ	Futures	1476.39	1476.39	1470.99	1471.28	329.0
2009-04-03 03:00:00	NQ	Futures	1471.28	1475.82	1470.14	1474.12	1347.0
2009-04-03 04:00:00	NQ	Futures	1474.4	1480.94	1472.98	1479.8	1070.0
2009-04-03 05:00:00	NQ	Futures	1480.37	1488.04	1480.37	1488.04	2268.0
2009-04-03 06:00:00	NQ	Futures	1488.04	1490.88	1482.07	1488.89	2328.0
2009-04-03 07:00:00	NQ	Futures	1488.61	1490.88	1483.49	1487.76	1813.0
2009-04-03 08:00:00	NQ	Futures	1487.76	1494.58	1477.81	1480.65	12606.0
2009-04-03 09:00:00	NQ	Futures	1480.65	1488.04	1473.55	1478.1	42176.0
2009-04-03 10:00:00	NQ	Futures	1478.1	1479.23	1469.86	1475.82	43277.0
2009-04-03 11:00:00	NQ	Futures	1475.54	1483.78	1472.7	1483.21	24763.0
2009-04-03 12:00:00	NQ	Futures	1483.21	1489.75	1481.51	1484.06	26601.0
2009-04-03 13:00:00	NQ	Futures	1484.06	1491.73	1482.64	1490.31	22044.0
2009-04-03 14:00:00	NQ	Futures	1490.03	1496.28	1486.05	1492.87	29037.0
2009-04-03 15:00:00	NQ	Futures	1492.87	1494.29	1480.37	1494.01	47597.0
2009-04-03 16:00:00	NQ	Futures	1494.01	1497.99	1493.15	1497.13	12838.0
2009-04-03 00:00:00	YM	Futures	7301.1	7309.3	7280.8	7290.0	390.0
2009-04-03 01:00:00	YM	Futures	7287.3	7294.6	7276.2	7291.9	343.0
2009-04-03 02:00:00	YM	Futures	7291.9	7292.8	7264.3	7268.0	404.0
2009-04-03 03:00:00	YM	Futures	7267.1	7290.0	7259.7	7277.2	1752.0
2009-04-03 04:00:00	YM	Futures	7276.2	7304.7	7264.3	7299.2	1264.0
2009-04-03 05:00:00	YM	Futures	7300.1	7334.1	7300.1	7324.0	1559.0
2009-04-03 06:00:00	YM	Futures	7324.0	7329.5	7300.1	7328.6	859.0
2009-04-03 07:00:00	YM	Futures	7328.6	7330.5	7302.9	7316.7	1017.0
2009-04-03 08:00:00	YM	Futures	7320.3	7383.8	7264.3	7275.3	8234.0
2009-04-03 09:00:00	YM	Futures	7272.6	7298.3	7244.1	7264.3	21302.0
2009-04-03 10:00:00	YM	Futures	7264.3	7267.1	7204.6	7226.6	27343.0
2009-04-03 11:00:00	YM	Futures	7226.6	7265.2	7211.0	7256.9	15601.0
2009-04-03 12:00:00	YM	Futures	7256.9	7287.3	7252.3	7257.9	14839.0
2009-04-03 13:00:00	YM	Futures	7256.9	7275.3	7233.0	7274.4	17842.0
2009-04-03 14:00:00	YM	Futures	7274.4	7317.6	7259.7	7294.6	17769.0
2009-04-03 15:00:00	YM	Futures	7294.6	7319.4	7243.2	7317.6	27079.0

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

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