PREVIEW / futures_1hour / 2009-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-13.parquet
  size:    45 KB
  rows:    1,281

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-13 00:00:00	ES	Futures	872.27	873.47	871.55	871.79	3430.0
2009-05-13 01:00:00	ES	Futures	871.79	872.51	871.07	872.51	2828.0
2009-05-13 02:00:00	ES	Futures	872.51	873.23	869.87	869.87	5753.0
2009-05-13 03:00:00	ES	Futures	870.11	870.59	866.52	868.67	19590.0
2009-05-13 04:00:00	ES	Futures	868.43	871.79	868.43	870.35	10015.0
2009-05-13 05:00:00	ES	Futures	870.11	871.79	867.23	867.71	13709.0
2009-05-13 06:00:00	ES	Futures	867.71	869.15	864.36	865.32	25057.0
2009-05-13 07:00:00	ES	Futures	865.32	867.0	859.81	860.52	46836.0
2009-05-13 08:00:00	ES	Futures	860.76	862.2	852.38	854.53	119687.0
2009-05-13 09:00:00	ES	Futures	854.53	855.73	849.98	853.82	266801.0
2009-05-13 10:00:00	ES	Futures	853.82	858.37	850.7	851.42	381817.0
2009-05-13 11:00:00	ES	Futures	851.18	853.1	848.54	849.98	268381.0
2009-05-13 12:00:00	ES	Futures	849.98	853.58	846.39	846.63	196597.0
2009-05-13 13:00:00	ES	Futures	846.63	849.5	843.51	849.5	272083.0
2009-05-13 14:00:00	ES	Futures	849.26	849.98	844.47	849.26	245184.0
2009-05-13 15:00:00	ES	Futures	849.26	849.98	844.23	845.91	430229.0
2009-05-13 16:00:00	ES	Futures	845.43	849.26	845.43	848.3	116389.0
2009-05-13 17:00:00	ES	Futures	848.3	848.54	847.82	847.82	1438.0
2009-05-13 18:00:00	ES	Futures	847.58	847.82	844.95	845.91	4740.0
2009-05-13 19:00:00	ES	Futures	845.91	848.06	845.43	847.58	3840.0
2009-05-13 20:00:00	ES	Futures	847.58	850.22	847.58	849.26	7911.0
2009-05-13 21:00:00	ES	Futures	849.5	849.98	848.78	848.78	2272.0
2009-05-13 22:00:00	ES	Futures	849.02	849.74	847.58	847.58	3003.0
2009-05-13 23:00:00	ES	Futures	847.82	848.54	845.67	846.15	2758.0
2009-05-13 00:00:00	NQ	Futures	1577.83	1579.25	1576.12	1576.12	226.0
2009-05-13 01:00:00	NQ	Futures	1576.69	1577.83	1575.56	1577.54	165.0
2009-05-13 02:00:00	NQ	Futures	1577.54	1578.11	1572.43	1573.28	373.0
2009-05-13 03:00:00	NQ	Futures	1573.0	1573.57	1564.76	1570.16	2271.0
2009-05-13 04:00:00	NQ	Futures	1569.3	1575.84	1568.74	1573.28	1273.0
2009-05-13 05:00:00	NQ	Futures	1573.28	1575.56	1567.32	1567.32	813.0
2009-05-13 06:00:00	NQ	Futures	1567.6	1568.74	1560.21	1561.63	2356.0
2009-05-13 07:00:00	NQ	Futures	1561.06	1563.91	1550.84	1555.1	5360.0
2009-05-13 08:00:00	NQ	Futures	1555.38	1558.79	1547.43	1550.55	11321.0
2009-05-13 09:00:00	NQ	Futures	1550.55	1553.11	1541.17	1544.87	46121.0
2009-05-13 10:00:00	NQ	Futures	1544.58	1544.87	1529.24	1529.24	70216.0
2009-05-13 11:00:00	NQ	Futures	1529.24	1535.49	1527.82	1529.52	45548.0
2009-05-13 12:00:00	NQ	Futures	1529.52	1535.49	1526.12	1526.4	30503.0
2009-05-13 13:00:00	NQ	Futures	1526.4	1533.22	1523.27	1533.22	39433.0
2009-05-13 14:00:00	NQ	Futures	1532.93	1534.07	1521.0	1531.23	41071.0
2009-05-13 15:00:00	NQ	Futures	1530.95	1531.23	1522.14	1522.99	52851.0
2009-05-13 16:00:00	NQ	Futures	1522.99	1529.24	1522.42	1527.25	11524.0
2009-05-13 17:00:00	NQ	Futures	1526.97	1527.25	1526.4	1526.68	96.0
2009-05-13 18:00:00	NQ	Futures	1526.4	1527.25	1523.56	1524.98	357.0
2009-05-13 19:00:00	NQ	Futures	1524.69	1527.82	1523.56	1527.82	261.0
2009-05-13 20:00:00	NQ	Futures	1527.54	1531.23	1527.54	1530.38	521.0
2009-05-13 21:00:00	NQ	Futures	1529.24	1530.66	1528.39	1528.67	109.0
2009-05-13 22:00:00	NQ	Futures	1528.67	1530.09	1526.97	1527.25	63.0
2009-05-13 23:00:00	NQ	Futures	1527.25	1529.52	1524.98	1524.98	343.0
2009-05-13 00:00:00	YM	Futures	7771.6	7780.7	7766.0	7767.0	226.0
2009-05-13 01:00:00	YM	Futures	7767.0	7776.1	7763.3	7773.4	213.0

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

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