PREVIEW / futures_1hour / 2008-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-06.parquet
  size:    47 KB
  rows:    1,289

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
2008-10-06 00:00:00	ES	Futures	1033.45	1033.69	1029.9	1031.08	3329.0
2008-10-06 01:00:00	ES	Futures	1031.08	1032.27	1029.9	1030.14	2878.0
2008-10-06 02:00:00	ES	Futures	1030.14	1031.79	1024.46	1026.35	21196.0
2008-10-06 03:00:00	ES	Futures	1026.35	1032.74	1024.93	1030.61	35633.0
2008-10-06 04:00:00	ES	Futures	1030.61	1030.61	1020.43	1020.91	32076.0
2008-10-06 05:00:00	ES	Futures	1021.14	1023.51	1014.75	1017.36	40721.0
2008-10-06 06:00:00	ES	Futures	1017.36	1027.06	1015.23	1023.04	31791.0
2008-10-06 07:00:00	ES	Futures	1023.04	1026.59	1017.83	1024.46	53424.0
2008-10-06 08:00:00	ES	Futures	1024.69	1036.76	1017.12	1024.69	112342.0
2008-10-06 09:00:00	ES	Futures	1024.69	1026.11	1007.89	1011.68	365598.0
2008-10-06 10:00:00	ES	Futures	1011.91	1013.81	975.94	992.98	733911.0
2008-10-06 11:00:00	ES	Futures	992.98	1004.34	988.01	991.8	537053.0
2008-10-06 12:00:00	ES	Futures	991.56	996.53	980.68	982.33	308132.0
2008-10-06 13:00:00	ES	Futures	982.33	990.14	975.0	981.62	403330.0
2008-10-06 14:00:00	ES	Futures	981.62	981.86	955.12	967.42	642502.0
2008-10-06 15:00:00	ES	Futures	967.19	1011.68	961.27	1010.49	897254.0
2008-10-06 16:00:00	ES	Futures	1010.26	1012.15	993.22	994.64	180411.0
2008-10-06 17:00:00	ES	Futures	994.64	997.71	993.93	997.0	10758.0
2008-10-06 18:00:00	ES	Futures	997.24	997.71	992.98	997.71	8569.0
2008-10-06 19:00:00	ES	Futures	997.71	999.61	992.98	994.17	6965.0
2008-10-06 20:00:00	ES	Futures	993.93	997.48	992.51	995.82	4638.0
2008-10-06 21:00:00	ES	Futures	996.06	1001.5	993.93	1001.03	7715.0
2008-10-06 22:00:00	ES	Futures	1001.03	1001.97	999.37	1001.74	4517.0
2008-10-06 23:00:00	ES	Futures	1001.74	1010.26	1000.55	1010.26	10983.0
2008-10-06 00:00:00	NQ	Futures	1648.54	1648.54	1645.71	1645.71	557.0
2008-10-06 01:00:00	NQ	Futures	1645.43	1649.11	1644.3	1645.43	180.0
2008-10-06 02:00:00	NQ	Futures	1645.15	1646.85	1618.27	1624.78	2925.0
2008-10-06 03:00:00	NQ	Futures	1625.34	1640.62	1622.79	1640.34	3162.0
2008-10-06 04:00:00	NQ	Futures	1640.06	1640.06	1624.78	1630.43	2463.0
2008-10-06 05:00:00	NQ	Futures	1631.28	1637.23	1619.97	1621.66	1488.0
2008-10-06 06:00:00	NQ	Futures	1621.95	1642.04	1621.38	1632.98	2252.0
2008-10-06 07:00:00	NQ	Futures	1635.25	1646.0	1629.87	1642.04	2468.0
2008-10-06 08:00:00	NQ	Futures	1642.32	1652.51	1626.76	1640.34	10617.0
2008-10-06 09:00:00	NQ	Futures	1640.06	1652.22	1598.46	1606.38	66580.0
2008-10-06 10:00:00	NQ	Futures	1606.38	1612.89	1543.28	1586.29	124152.0
2008-10-06 11:00:00	NQ	Futures	1586.58	1601.01	1570.73	1573.56	81894.0
2008-10-06 12:00:00	NQ	Futures	1573.28	1581.77	1558.0	1559.98	45565.0
2008-10-06 13:00:00	NQ	Futures	1559.98	1573.84	1542.72	1555.73	58368.0
2008-10-06 14:00:00	NQ	Futures	1555.73	1556.86	1520.93	1540.74	93706.0
2008-10-06 15:00:00	NQ	Futures	1540.74	1616.0	1529.42	1612.61	146380.0
2008-10-06 16:00:00	NQ	Futures	1612.33	1614.31	1591.1	1593.08	17436.0
2008-10-06 17:00:00	NQ	Futures	1592.8	1597.05	1592.23	1594.22	623.0
2008-10-06 18:00:00	NQ	Futures	1597.05	1599.03	1591.39	1597.61	447.0
2008-10-06 19:00:00	NQ	Futures	1597.33	1600.16	1594.22	1595.91	425.0
2008-10-06 20:00:00	NQ	Futures	1596.76	1600.44	1593.08	1598.18	141.0
2008-10-06 21:00:00	NQ	Futures	1598.74	1608.08	1596.48	1608.08	400.0
2008-10-06 22:00:00	NQ	Futures	1606.67	1608.36	1605.53	1608.08	127.0
2008-10-06 23:00:00	NQ	Futures	1607.51	1613.74	1605.82	1613.74	836.0
2008-10-06 00:00:00	YM	Futures	9288.0	9290.7	9262.5	9270.7	313.0
2008-10-06 01:00:00	YM	Futures	9276.2	9283.5	9268.0	9275.3	240.0

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

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