PREVIEW / futures_1hour / 2009-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-30.parquet
  size:    44 KB
  rows:    1,276

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-07-30 00:00:00	ES	Futures	942.72	943.44	942.23	942.96	3007.0
2009-07-30 01:00:00	ES	Futures	942.72	945.13	942.48	944.65	4703.0
2009-07-30 02:00:00	ES	Futures	944.89	948.02	943.68	946.09	18209.0
2009-07-30 03:00:00	ES	Futures	945.85	945.85	941.51	943.2	27287.0
2009-07-30 04:00:00	ES	Futures	942.96	946.33	941.99	945.61	16823.0
2009-07-30 05:00:00	ES	Futures	945.85	948.51	945.61	946.82	18889.0
2009-07-30 06:00:00	ES	Futures	946.82	949.95	946.82	948.02	16211.0
2009-07-30 07:00:00	ES	Futures	948.02	948.51	946.58	947.3	15972.0
2009-07-30 08:00:00	ES	Futures	947.3	951.88	945.85	950.43	101143.0
2009-07-30 09:00:00	ES	Futures	950.43	955.5	946.82	954.78	324055.0
2009-07-30 10:00:00	ES	Futures	954.78	958.88	953.81	957.91	373215.0
2009-07-30 11:00:00	ES	Futures	957.91	958.63	952.12	952.85	240317.0
2009-07-30 12:00:00	ES	Futures	953.09	955.02	952.12	953.57	137057.0
2009-07-30 13:00:00	ES	Futures	953.81	957.19	953.33	954.53	196839.0
2009-07-30 14:00:00	ES	Futures	954.78	955.98	952.85	954.78	149506.0
2009-07-30 15:00:00	ES	Futures	954.78	957.19	947.54	948.02	418507.0
2009-07-30 16:00:00	ES	Futures	948.02	949.71	946.33	947.06	104756.0
2009-07-30 17:00:00	ES	Futures	946.82	947.3	946.33	946.58	1678.0
2009-07-30 18:00:00	ES	Futures	946.58	948.26	946.58	947.54	1780.0
2009-07-30 19:00:00	ES	Futures	947.54	948.75	947.54	947.78	2062.0
2009-07-30 20:00:00	ES	Futures	947.54	947.78	946.33	947.54	3203.0
2009-07-30 21:00:00	ES	Futures	947.54	948.75	947.3	947.54	3094.0
2009-07-30 22:00:00	ES	Futures	947.54	948.99	946.82	948.99	2366.0
2009-07-30 23:00:00	ES	Futures	948.99	951.16	948.75	950.92	3819.0
2009-07-30 00:00:00	NQ	Futures	1828.2	1828.48	1825.63	1827.06	87.0
2009-07-30 01:00:00	NQ	Futures	1827.34	1831.62	1826.77	1830.48	273.0
2009-07-30 02:00:00	NQ	Futures	1830.76	1837.31	1829.62	1835.03	1999.0
2009-07-30 03:00:00	NQ	Futures	1835.32	1835.32	1828.77	1831.9	1947.0
2009-07-30 04:00:00	NQ	Futures	1831.9	1836.46	1830.19	1834.75	1775.0
2009-07-30 05:00:00	NQ	Futures	1834.75	1837.6	1833.89	1835.03	1605.0
2009-07-30 06:00:00	NQ	Futures	1835.32	1840.73	1835.32	1835.6	1968.0
2009-07-30 07:00:00	NQ	Futures	1835.6	1836.74	1833.04	1835.89	2713.0
2009-07-30 08:00:00	NQ	Futures	1835.6	1843.01	1832.47	1841.3	10378.0
2009-07-30 09:00:00	NQ	Futures	1841.01	1852.98	1834.75	1852.69	53565.0
2009-07-30 10:00:00	NQ	Futures	1852.69	1859.24	1848.7	1854.4	56411.0
2009-07-30 11:00:00	NQ	Futures	1854.69	1856.11	1842.15	1842.44	35550.0
2009-07-30 12:00:00	NQ	Futures	1842.72	1845.29	1839.88	1841.01	22735.0
2009-07-30 13:00:00	NQ	Futures	1841.01	1847.85	1840.73	1842.44	27784.0
2009-07-30 14:00:00	NQ	Futures	1842.44	1846.71	1838.17	1844.43	29486.0
2009-07-30 15:00:00	NQ	Futures	1844.72	1848.7	1827.91	1830.76	59881.0
2009-07-30 16:00:00	NQ	Futures	1830.76	1833.61	1826.77	1831.05	11948.0
2009-07-30 17:00:00	NQ	Futures	1830.76	1830.76	1829.34	1829.62	166.0
2009-07-30 18:00:00	NQ	Futures	1829.91	1832.47	1829.62	1831.33	233.0
2009-07-30 19:00:00	NQ	Futures	1831.62	1833.04	1830.19	1831.05	251.0
2009-07-30 20:00:00	NQ	Futures	1830.48	1830.48	1829.05	1829.91	191.0
2009-07-30 21:00:00	NQ	Futures	1829.91	1832.76	1829.34	1830.48	670.0
2009-07-30 22:00:00	NQ	Futures	1830.76	1833.32	1829.62	1833.04	205.0
2009-07-30 23:00:00	NQ	Futures	1833.32	1836.46	1832.76	1835.32	336.0
2009-07-30 00:00:00	YM	Futures	8380.0	8387.4	8377.2	8378.2	285.0
2009-07-30 01:00:00	YM	Futures	8380.0	8399.4	8379.1	8394.8	443.0

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

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