PREVIEW / futures_1hour / 2009-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-15.parquet
  size:    36 KB
  rows:    1,007

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-15 00:00:00	ES	Futures	854.29	854.29	853.1	853.58	1334.0
2009-05-15 01:00:00	ES	Futures	853.34	854.53	853.1	854.29	1722.0
2009-05-15 02:00:00	ES	Futures	854.05	855.73	853.82	855.25	8338.0
2009-05-15 03:00:00	ES	Futures	855.25	855.73	851.18	851.9	20744.0
2009-05-15 04:00:00	ES	Futures	851.9	854.77	851.42	852.86	14151.0
2009-05-15 05:00:00	ES	Futures	852.62	854.77	852.14	853.1	15850.0
2009-05-15 06:00:00	ES	Futures	852.86	853.1	849.02	849.5	25116.0
2009-05-15 07:00:00	ES	Futures	849.5	849.5	845.91	846.87	29886.0
2009-05-15 08:00:00	ES	Futures	846.87	850.94	845.19	849.5	55160.0
2009-05-15 09:00:00	ES	Futures	849.74	856.69	848.78	852.62	327029.0
2009-05-15 10:00:00	ES	Futures	852.86	858.37	849.5	855.49	353054.0
2009-05-15 11:00:00	ES	Futures	855.49	856.45	846.15	846.15	257335.0
2009-05-15 12:00:00	ES	Futures	846.39	848.06	844.47	845.43	175480.0
2009-05-15 13:00:00	ES	Futures	845.43	847.35	843.75	845.19	141280.0
2009-05-15 14:00:00	ES	Futures	845.19	847.11	841.35	842.55	232608.0
2009-05-15 15:00:00	ES	Futures	842.79	846.39	840.4	845.67	397868.0
2009-05-15 16:00:00	ES	Futures	845.67	846.87	844.23	845.91	94122.0
2009-05-15 00:00:00	NQ	Futures	1542.03	1542.6	1540.32	1540.32	27.0
2009-05-15 01:00:00	NQ	Futures	1540.32	1542.88	1540.32	1542.88	97.0
2009-05-15 02:00:00	NQ	Futures	1541.74	1545.44	1541.74	1544.3	208.0
2009-05-15 03:00:00	NQ	Futures	1544.58	1544.87	1535.78	1536.91	1719.0
2009-05-15 04:00:00	NQ	Futures	1536.91	1542.6	1536.34	1538.05	862.0
2009-05-15 05:00:00	NQ	Futures	1538.05	1541.46	1536.63	1538.05	900.0
2009-05-15 06:00:00	NQ	Futures	1538.33	1538.62	1530.66	1531.23	1643.0
2009-05-15 07:00:00	NQ	Futures	1531.51	1531.51	1524.69	1526.4	2933.0
2009-05-15 08:00:00	NQ	Futures	1526.68	1534.36	1524.41	1532.37	6322.0
2009-05-15 09:00:00	NQ	Futures	1532.37	1554.24	1531.23	1550.55	48812.0
2009-05-15 10:00:00	NQ	Futures	1550.84	1560.5	1546.57	1557.65	45755.0
2009-05-15 11:00:00	NQ	Futures	1557.37	1559.36	1543.16	1543.16	31254.0
2009-05-15 12:00:00	NQ	Futures	1543.45	1547.99	1540.89	1543.73	20819.0
2009-05-15 13:00:00	NQ	Futures	1543.45	1547.14	1539.19	1542.31	21457.0
2009-05-15 14:00:00	NQ	Futures	1541.74	1546.29	1537.48	1540.04	28395.0
2009-05-15 15:00:00	NQ	Futures	1539.75	1545.72	1535.49	1540.04	43811.0
2009-05-15 16:00:00	NQ	Futures	1540.04	1541.17	1537.2	1538.62	9262.0
2009-05-15 00:00:00	YM	Futures	7634.6	7634.6	7627.3	7629.1	84.0
2009-05-15 01:00:00	YM	Futures	7629.1	7640.1	7627.3	7639.2	205.0
2009-05-15 02:00:00	YM	Futures	7638.3	7651.2	7633.7	7644.7	558.0
2009-05-15 03:00:00	YM	Futures	7644.7	7649.3	7613.5	7618.1	1660.0
2009-05-15 04:00:00	YM	Futures	7619.0	7641.1	7614.4	7626.4	1243.0
2009-05-15 05:00:00	YM	Futures	7627.3	7645.7	7619.9	7629.1	1460.0
2009-05-15 06:00:00	YM	Futures	7631.0	7632.8	7595.1	7601.5	1695.0
2009-05-15 07:00:00	YM	Futures	7602.5	7602.5	7569.4	7574.9	1785.0
2009-05-15 08:00:00	YM	Futures	7574.9	7608.0	7563.0	7599.7	3663.0
2009-05-15 09:00:00	YM	Futures	7599.7	7666.8	7593.3	7647.5	22806.0
2009-05-15 10:00:00	YM	Futures	7647.5	7695.3	7621.8	7674.1	29989.0
2009-05-15 11:00:00	YM	Futures	7675.1	7684.3	7598.8	7601.5	22942.0
2009-05-15 12:00:00	YM	Futures	7600.6	7606.1	7579.5	7585.9	15344.0
2009-05-15 13:00:00	YM	Futures	7587.8	7601.5	7574.0	7583.2	11874.0
2009-05-15 14:00:00	YM	Futures	7583.2	7594.2	7546.4	7554.7	18754.0
2009-05-15 15:00:00	YM	Futures	7554.7	7585.9	7540.9	7584.1	27159.0

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

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