PREVIEW / futures_1hour / 2009-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-14.parquet
  size:    41 KB
  rows:    1,215

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-14 00:00:00	ES	Futures	845.91	847.11	845.67	846.39	1514.0
2009-05-14 01:00:00	ES	Futures	846.39	846.87	845.67	846.63	1738.0
2009-05-14 02:00:00	ES	Futures	846.39	849.74	846.15	847.58	7248.0
2009-05-14 03:00:00	ES	Futures	847.82	850.22	843.75	847.35	33349.0
2009-05-14 04:00:00	ES	Futures	847.35	851.66	846.15	849.26	20945.0
2009-05-14 05:00:00	ES	Futures	849.26	850.22	847.11	847.58	12768.0
2009-05-14 06:00:00	ES	Futures	847.58	848.78	844.47	845.67	19593.0
2009-05-14 07:00:00	ES	Futures	845.91	849.26	843.99	848.06	26560.0
2009-05-14 08:00:00	ES	Futures	848.06	849.74	842.31	846.15	90666.0
2009-05-14 09:00:00	ES	Futures	845.91	850.7	843.99	846.39	294885.0
2009-05-14 10:00:00	ES	Futures	846.39	851.9	846.15	849.74	351308.0
2009-05-14 11:00:00	ES	Futures	849.74	853.82	849.26	852.62	230981.0
2009-05-14 12:00:00	ES	Futures	852.86	856.93	852.38	854.53	239615.0
2009-05-14 13:00:00	ES	Futures	854.77	855.73	851.66	853.1	138894.0
2009-05-14 14:00:00	ES	Futures	853.34	859.57	853.1	857.41	208708.0
2009-05-14 15:00:00	ES	Futures	857.65	858.37	851.66	853.1	396091.0
2009-05-14 16:00:00	ES	Futures	852.62	853.82	851.66	852.86	83668.0
2009-05-14 17:00:00	ES	Futures	853.1	853.58	852.38	852.38	1418.0
2009-05-14 18:00:00	ES	Futures	851.66	853.34	851.66	852.62	2462.0
2009-05-14 19:00:00	ES	Futures	852.86	854.53	852.14	853.82	2881.0
2009-05-14 20:00:00	ES	Futures	853.82	854.77	852.38	852.86	3979.0
2009-05-14 21:00:00	ES	Futures	852.62	853.82	851.18	853.34	3600.0
2009-05-14 22:00:00	ES	Futures	853.34	853.82	852.86	853.34	2611.0
2009-05-14 23:00:00	ES	Futures	853.34	854.53	853.1	854.05	1858.0
2009-05-14 00:00:00	NQ	Futures	1525.26	1527.25	1524.69	1526.68	81.0
2009-05-14 01:00:00	NQ	Futures	1526.12	1527.54	1524.98	1527.54	405.0
2009-05-14 02:00:00	NQ	Futures	1527.25	1531.51	1525.83	1528.96	417.0
2009-05-14 03:00:00	NQ	Futures	1528.96	1532.65	1519.01	1526.4	2711.0
2009-05-14 04:00:00	NQ	Futures	1526.68	1532.37	1524.69	1529.52	1580.0
2009-05-14 05:00:00	NQ	Futures	1530.66	1531.23	1526.12	1528.1	1132.0
2009-05-14 06:00:00	NQ	Futures	1528.39	1529.81	1523.27	1524.41	1473.0
2009-05-14 07:00:00	NQ	Futures	1524.13	1534.07	1522.71	1533.22	3410.0
2009-05-14 08:00:00	NQ	Futures	1532.93	1534.36	1522.71	1529.24	10465.0
2009-05-14 09:00:00	NQ	Futures	1529.24	1538.62	1526.68	1533.22	42110.0
2009-05-14 10:00:00	NQ	Futures	1533.22	1543.16	1532.93	1538.9	51730.0
2009-05-14 11:00:00	NQ	Futures	1538.9	1545.72	1538.62	1545.44	34840.0
2009-05-14 12:00:00	NQ	Futures	1545.15	1550.84	1544.58	1547.99	31581.0
2009-05-14 13:00:00	NQ	Futures	1547.71	1549.7	1543.16	1545.44	20603.0
2009-05-14 14:00:00	NQ	Futures	1545.44	1555.67	1545.44	1552.54	32193.0
2009-05-14 15:00:00	NQ	Futures	1552.26	1553.68	1539.19	1540.32	59994.0
2009-05-14 16:00:00	NQ	Futures	1540.32	1542.6	1537.48	1540.89	9757.0
2009-05-14 17:00:00	NQ	Futures	1540.04	1541.17	1538.9	1539.19	68.0
2009-05-14 18:00:00	NQ	Futures	1538.9	1541.17	1538.05	1540.89	231.0
2009-05-14 19:00:00	NQ	Futures	1540.89	1542.31	1538.62	1541.74	182.0
2009-05-14 20:00:00	NQ	Futures	1541.74	1543.45	1539.19	1539.47	130.0
2009-05-14 21:00:00	NQ	Futures	1539.47	1541.17	1537.2	1540.32	197.0
2009-05-14 22:00:00	NQ	Futures	1540.61	1541.46	1539.47	1540.32	69.0
2009-05-14 23:00:00	NQ	Futures	1539.47	1542.88	1539.47	1541.74	64.0
2009-05-14 00:00:00	YM	Futures	7599.7	7608.9	7597.0	7602.5	244.0
2009-05-14 01:00:00	YM	Futures	7602.5	7607.1	7597.0	7607.1	119.0

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

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