PREVIEW / futures_1hour / 2009-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-17.parquet
  size:    44 KB
  rows:    1,273

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-06-17 00:00:00	ES	Futures	878.08	878.81	877.36	877.84	1780.0
2009-06-17 01:00:00	ES	Futures	877.84	880.26	877.6	879.53	3762.0
2009-06-17 02:00:00	ES	Futures	879.53	880.5	878.81	880.26	10511.0
2009-06-17 03:00:00	ES	Futures	880.26	880.5	877.84	879.05	16540.0
2009-06-17 04:00:00	ES	Futures	879.05	879.29	875.67	876.4	15294.0
2009-06-17 05:00:00	ES	Futures	876.4	876.4	874.23	875.67	19815.0
2009-06-17 06:00:00	ES	Futures	875.67	876.64	873.74	875.19	14549.0
2009-06-17 07:00:00	ES	Futures	875.19	879.29	871.09	872.54	49813.0
2009-06-17 08:00:00	ES	Futures	872.3	876.88	872.06	876.16	55132.0
2009-06-17 09:00:00	ES	Futures	875.91	877.12	870.85	871.33	315690.0
2009-06-17 10:00:00	ES	Futures	871.33	875.43	867.47	870.13	429400.0
2009-06-17 11:00:00	ES	Futures	870.13	874.95	870.13	874.47	275406.0
2009-06-17 12:00:00	ES	Futures	874.71	879.05	874.47	875.91	197735.0
2009-06-17 13:00:00	ES	Futures	875.91	881.7	874.95	879.77	165398.0
2009-06-17 14:00:00	ES	Futures	879.77	881.94	876.4	877.84	154556.0
2009-06-17 15:00:00	ES	Futures	877.6	879.29	873.02	874.47	316491.0
2009-06-17 16:00:00	ES	Futures	874.47	874.71	873.02	874.23	73425.0
2009-06-17 17:00:00	ES	Futures	874.23	874.47	873.5	873.5	1852.0
2009-06-17 18:00:00	ES	Futures	873.74	874.47	873.5	874.47	2218.0
2009-06-17 19:00:00	ES	Futures	874.47	877.6	874.23	877.12	5077.0
2009-06-17 20:00:00	ES	Futures	877.12	877.36	874.71	875.91	3158.0
2009-06-17 21:00:00	ES	Futures	875.91	878.33	875.43	876.64	5800.0
2009-06-17 22:00:00	ES	Futures	876.64	877.6	876.16	876.4	3410.0
2009-06-17 23:00:00	ES	Futures	876.4	877.12	874.47	875.19	3031.0
2009-06-17 00:00:00	NQ	Futures	1650.19	1651.9	1649.91	1649.91	294.0
2009-06-17 01:00:00	NQ	Futures	1651.05	1655.03	1650.76	1654.46	416.0
2009-06-17 02:00:00	NQ	Futures	1653.61	1656.46	1651.9	1655.32	923.0
2009-06-17 03:00:00	NQ	Futures	1655.32	1655.6	1652.19	1653.04	1456.0
2009-06-17 04:00:00	NQ	Futures	1653.04	1653.04	1647.06	1648.2	1522.0
2009-06-17 05:00:00	NQ	Futures	1647.63	1647.91	1644.5	1646.77	1801.0
2009-06-17 06:00:00	NQ	Futures	1646.49	1648.48	1644.5	1647.06	1431.0
2009-06-17 07:00:00	NQ	Futures	1646.77	1655.32	1644.5	1645.35	5634.0
2009-06-17 08:00:00	NQ	Futures	1645.63	1651.9	1644.78	1650.48	5360.0
2009-06-17 09:00:00	NQ	Futures	1650.48	1654.18	1640.22	1640.79	53931.0
2009-06-17 10:00:00	NQ	Futures	1640.79	1652.75	1637.94	1645.92	67310.0
2009-06-17 11:00:00	NQ	Futures	1645.63	1658.17	1645.35	1657.03	54217.0
2009-06-17 12:00:00	NQ	Futures	1657.03	1665.86	1656.74	1659.59	36451.0
2009-06-17 13:00:00	NQ	Futures	1659.31	1674.12	1658.17	1670.41	41378.0
2009-06-17 14:00:00	NQ	Futures	1670.41	1672.98	1661.87	1664.72	29279.0
2009-06-17 15:00:00	NQ	Futures	1664.43	1667.0	1655.32	1658.45	49457.0
2009-06-17 16:00:00	NQ	Futures	1658.17	1659.59	1654.46	1655.6	10402.0
2009-06-17 17:00:00	NQ	Futures	1656.17	1656.17	1655.32	1655.32	134.0
2009-06-17 18:00:00	NQ	Futures	1655.6	1656.46	1653.89	1655.32	258.0
2009-06-17 19:00:00	NQ	Futures	1655.32	1659.88	1655.32	1659.31	378.0
2009-06-17 20:00:00	NQ	Futures	1659.59	1659.59	1655.89	1657.88	393.0
2009-06-17 21:00:00	NQ	Futures	1658.17	1661.3	1656.17	1658.17	562.0
2009-06-17 22:00:00	NQ	Futures	1658.45	1661.01	1658.17	1659.02	196.0
2009-06-17 23:00:00	NQ	Futures	1657.6	1658.45	1653.89	1655.32	191.0
2009-06-17 00:00:00	YM	Futures	7835.4	7841.9	7829.8	7834.5	150.0
2009-06-17 01:00:00	YM	Futures	7832.6	7851.1	7830.8	7844.6	251.0

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

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