PREVIEW / futures_1hour / 2009-04-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	824.58	825.06	823.14	824.1	1605.0
2009-04-20 01:00:00	ES	Futures	824.34	826.02	824.1	825.3	2718.0
2009-04-20 02:00:00	ES	Futures	825.06	826.74	824.82	826.5	5730.0
2009-04-20 03:00:00	ES	Futures	826.5	827.7	824.34	824.58	12293.0
2009-04-20 04:00:00	ES	Futures	824.82	825.06	821.7	822.18	26337.0
2009-04-20 05:00:00	ES	Futures	822.18	822.42	818.11	818.35	23959.0
2009-04-20 06:00:00	ES	Futures	818.59	821.7	818.11	821.23	14022.0
2009-04-20 07:00:00	ES	Futures	820.99	822.18	816.67	817.39	39121.0
2009-04-20 08:00:00	ES	Futures	817.39	818.83	813.56	815.47	66444.0
2009-04-20 09:00:00	ES	Futures	815.47	817.63	808.52	809.72	273724.0
2009-04-20 10:00:00	ES	Futures	809.72	809.96	802.29	803.25	371444.0
2009-04-20 11:00:00	ES	Futures	803.01	804.69	801.34	802.29	234139.0
2009-04-20 12:00:00	ES	Futures	802.05	803.01	800.14	802.53	165403.0
2009-04-20 13:00:00	ES	Futures	802.53	802.77	797.74	800.14	166668.0
2009-04-20 14:00:00	ES	Futures	800.14	800.14	795.82	796.54	183498.0
2009-04-20 15:00:00	ES	Futures	796.3	799.9	794.39	795.1	441585.0
2009-04-20 16:00:00	ES	Futures	795.34	799.42	795.1	799.18	171919.0
2009-04-20 17:00:00	ES	Futures	798.94	799.42	798.46	799.18	2195.0
2009-04-20 18:00:00	ES	Futures	798.94	798.94	798.22	798.22	1455.0
2009-04-20 19:00:00	ES	Futures	798.46	799.18	797.98	798.94	1652.0
2009-04-20 20:00:00	ES	Futures	798.7	799.18	796.54	798.7	6253.0
2009-04-20 21:00:00	ES	Futures	798.94	799.18	797.5	797.98	3441.0
2009-04-20 22:00:00	ES	Futures	798.22	799.18	797.02	798.46	2898.0
2009-04-20 23:00:00	ES	Futures	798.46	800.38	797.98	799.66	5018.0
2009-04-20 00:00:00	NQ	Futures	1524.41	1525.83	1522.99	1524.13	88.0
2009-04-20 01:00:00	NQ	Futures	1526.12	1529.24	1524.98	1526.4	96.0
2009-04-20 02:00:00	NQ	Futures	1527.54	1530.09	1526.97	1529.52	187.0
2009-04-20 03:00:00	NQ	Futures	1529.52	1532.37	1526.4	1526.4	726.0
2009-04-20 04:00:00	NQ	Futures	1526.4	1526.97	1519.86	1521.57	1313.0
2009-04-20 05:00:00	NQ	Futures	1521.57	1521.57	1511.34	1511.34	1893.0
2009-04-20 06:00:00	NQ	Futures	1511.62	1514.75	1510.2	1512.76	2720.0
2009-04-20 07:00:00	NQ	Futures	1512.48	1516.74	1507.36	1508.21	3715.0
2009-04-20 08:00:00	NQ	Futures	1508.5	1511.34	1504.52	1507.08	7081.0
2009-04-20 09:00:00	NQ	Futures	1507.36	1515.03	1502.53	1503.67	38458.0
2009-04-20 10:00:00	NQ	Futures	1503.67	1504.24	1485.2	1487.76	56192.0
2009-04-20 11:00:00	NQ	Futures	1487.76	1494.01	1484.63	1486.9	33693.0
2009-04-20 12:00:00	NQ	Futures	1486.9	1492.87	1483.78	1492.02	24226.0
2009-04-20 13:00:00	NQ	Futures	1491.73	1492.02	1485.77	1490.31	19470.0
2009-04-20 14:00:00	NQ	Futures	1490.6	1491.45	1480.94	1482.36	25545.0
2009-04-20 15:00:00	NQ	Futures	1482.64	1492.3	1479.23	1487.19	50901.0
2009-04-20 16:00:00	NQ	Futures	1486.9	1496.56	1486.62	1493.72	14496.0
2009-04-20 17:00:00	NQ	Futures	1493.15	1494.86	1492.3	1494.01	212.0
2009-04-20 18:00:00	NQ	Futures	1492.87	1493.44	1490.88	1492.3	234.0
2009-04-20 19:00:00	NQ	Futures	1492.3	1493.15	1491.45	1491.73	107.0
2009-04-20 20:00:00	NQ	Futures	1492.3	1495.71	1490.03	1495.71	383.0
2009-04-20 21:00:00	NQ	Futures	1496.0	1496.28	1493.44	1495.14	246.0
2009-04-20 22:00:00	NQ	Futures	1495.14	1496.28	1493.15	1495.43	145.0
2009-04-20 23:00:00	NQ	Futures	1496.0	1498.27	1495.14	1498.27	217.0
2009-04-20 00:00:00	YM	Futures	7378.2	7381.9	7367.2	7376.4	167.0
2009-04-20 01:00:00	YM	Futures	7378.2	7392.9	7378.2	7382.8	170.0

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

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