PREVIEW / futures_1hour / 2009-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-18.parquet
  size:    43 KB
  rows:    1,224

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-05-18 00:00:00	ES	Futures	840.16	842.79	839.92	842.07	3496.0
2009-05-18 01:00:00	ES	Futures	842.07	843.27	841.59	841.83	2235.0
2009-05-18 02:00:00	ES	Futures	841.59	843.99	841.59	843.51	7054.0
2009-05-18 03:00:00	ES	Futures	843.51	847.11	841.11	845.91	22910.0
2009-05-18 04:00:00	ES	Futures	845.91	847.82	843.75	847.82	10662.0
2009-05-18 05:00:00	ES	Futures	847.58	852.38	847.35	850.46	22923.0
2009-05-18 06:00:00	ES	Futures	850.46	851.42	848.3	849.74	12521.0
2009-05-18 07:00:00	ES	Futures	849.98	854.77	849.5	852.86	30167.0
2009-05-18 08:00:00	ES	Futures	853.1	854.53	851.66	853.1	34622.0
2009-05-18 09:00:00	ES	Futures	853.1	857.17	852.62	854.53	254180.0
2009-05-18 10:00:00	ES	Futures	854.53	860.29	852.14	859.57	354140.0
2009-05-18 11:00:00	ES	Futures	859.81	861.24	858.37	859.09	164256.0
2009-05-18 12:00:00	ES	Futures	859.33	864.36	858.85	863.64	168794.0
2009-05-18 13:00:00	ES	Futures	863.88	864.12	861.0	861.48	128345.0
2009-05-18 14:00:00	ES	Futures	861.72	866.52	860.05	866.04	229366.0
2009-05-18 15:00:00	ES	Futures	866.28	871.07	863.64	870.11	357720.0
2009-05-18 16:00:00	ES	Futures	870.35	871.07	869.15	870.11	94084.0
2009-05-18 17:00:00	ES	Futures	870.11	870.35	869.39	869.87	1419.0
2009-05-18 18:00:00	ES	Futures	870.11	870.59	869.63	869.87	2270.0
2009-05-18 19:00:00	ES	Futures	870.11	870.59	869.39	870.11	2012.0
2009-05-18 20:00:00	ES	Futures	870.11	870.11	868.19	868.19	5087.0
2009-05-18 21:00:00	ES	Futures	867.95	868.91	867.47	868.67	4192.0
2009-05-18 22:00:00	ES	Futures	868.67	870.35	868.19	869.87	4459.0
2009-05-18 23:00:00	ES	Futures	869.87	871.07	869.39	870.59	3466.0
2009-05-18 00:00:00	NQ	Futures	1528.39	1532.65	1528.39	1531.51	102.0
2009-05-18 01:00:00	NQ	Futures	1532.08	1533.22	1529.81	1530.95	113.0
2009-05-18 02:00:00	NQ	Futures	1530.09	1534.07	1530.09	1533.22	376.0
2009-05-18 03:00:00	NQ	Futures	1533.22	1538.9	1528.96	1537.48	1481.0
2009-05-18 04:00:00	NQ	Futures	1537.2	1540.32	1533.22	1540.32	1008.0
2009-05-18 05:00:00	NQ	Futures	1540.04	1547.99	1539.47	1545.44	1800.0
2009-05-18 06:00:00	NQ	Futures	1545.44	1547.43	1541.74	1544.3	847.0
2009-05-18 07:00:00	NQ	Futures	1544.3	1553.96	1544.02	1551.69	4139.0
2009-05-18 08:00:00	NQ	Futures	1551.12	1552.82	1546.57	1548.56	3471.0
2009-05-18 09:00:00	NQ	Futures	1548.28	1556.23	1546.57	1549.98	33656.0
2009-05-18 10:00:00	NQ	Futures	1549.98	1558.51	1540.89	1557.09	47461.0
2009-05-18 11:00:00	NQ	Futures	1556.8	1558.51	1550.55	1554.81	20728.0
2009-05-18 12:00:00	NQ	Futures	1555.1	1570.44	1554.24	1567.88	38873.0
2009-05-18 13:00:00	NQ	Futures	1567.6	1568.17	1563.62	1565.89	16389.0
2009-05-18 14:00:00	NQ	Futures	1565.89	1579.53	1563.62	1577.54	35001.0
2009-05-18 15:00:00	NQ	Futures	1577.54	1582.09	1571.86	1580.39	51594.0
2009-05-18 16:00:00	NQ	Futures	1580.39	1582.66	1576.98	1578.97	13659.0
2009-05-18 17:00:00	NQ	Futures	1578.68	1578.68	1578.11	1578.4	44.0
2009-05-18 18:00:00	NQ	Futures	1579.25	1579.53	1578.11	1579.25	312.0
2009-05-18 19:00:00	NQ	Futures	1578.97	1579.53	1577.26	1579.25	119.0
2009-05-18 20:00:00	NQ	Futures	1579.25	1579.25	1575.56	1575.56	104.0
2009-05-18 21:00:00	NQ	Futures	1575.27	1576.41	1573.85	1575.84	316.0
2009-05-18 22:00:00	NQ	Futures	1575.56	1578.11	1574.7	1577.83	139.0
2009-05-18 23:00:00	NQ	Futures	1577.83	1579.53	1576.69	1579.25	189.0
2009-05-18 00:00:00	YM	Futures	7521.6	7551.9	7521.6	7548.2	1221.0
2009-05-18 01:00:00	YM	Futures	7547.3	7560.2	7543.7	7545.5	403.0

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

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