PREVIEW / futures_1hour / 2008-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-28.parquet
  size:    40 KB
  rows:    1,198

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-07-28 00:00:00	ES	Futures	1164.17	1166.26	1163.94	1165.33	747.0
2008-07-28 01:00:00	ES	Futures	1165.56	1166.96	1165.33	1166.49	1445.0
2008-07-28 02:00:00	ES	Futures	1166.49	1168.82	1166.26	1167.42	4079.0
2008-07-28 03:00:00	ES	Futures	1167.42	1167.65	1163.01	1164.4	10985.0
2008-07-28 04:00:00	ES	Futures	1164.4	1166.26	1163.24	1165.56	5497.0
2008-07-28 05:00:00	ES	Futures	1165.33	1165.56	1162.08	1162.77	8222.0
2008-07-28 06:00:00	ES	Futures	1162.77	1164.4	1162.08	1163.47	5672.0
2008-07-28 07:00:00	ES	Futures	1163.47	1166.96	1162.54	1166.96	13952.0
2008-07-28 08:00:00	ES	Futures	1166.96	1167.42	1163.94	1165.56	22340.0
2008-07-28 09:00:00	ES	Futures	1165.56	1170.68	1164.87	1167.89	189401.0
2008-07-28 10:00:00	ES	Futures	1167.89	1171.37	1165.33	1166.03	236626.0
2008-07-28 11:00:00	ES	Futures	1166.26	1166.26	1159.06	1161.15	226710.0
2008-07-28 12:00:00	ES	Futures	1160.91	1162.54	1154.17	1155.34	190891.0
2008-07-28 13:00:00	ES	Futures	1155.1	1156.5	1153.01	1154.41	156819.0
2008-07-28 14:00:00	ES	Futures	1154.41	1157.2	1150.69	1151.15	211979.0
2008-07-28 15:00:00	ES	Futures	1151.15	1154.64	1146.27	1147.9	249765.0
2008-07-28 16:00:00	ES	Futures	1147.67	1149.06	1146.74	1147.67	78753.0
2008-07-28 17:00:00	ES	Futures	1147.67	1148.13	1146.74	1146.74	2943.0
2008-07-28 18:00:00	ES	Futures	1147.43	1150.22	1147.2	1149.99	7563.0
2008-07-28 19:00:00	ES	Futures	1149.99	1150.22	1148.13	1148.83	2422.0
2008-07-28 20:00:00	ES	Futures	1149.06	1149.06	1147.9	1147.9	1766.0
2008-07-28 21:00:00	ES	Futures	1148.13	1148.36	1146.5	1146.97	3141.0
2008-07-28 22:00:00	ES	Futures	1147.2	1147.9	1146.5	1146.97	1433.0
2008-07-28 23:00:00	ES	Futures	1147.2	1149.76	1146.97	1149.76	1787.0
2008-07-28 00:00:00	NQ	Futures	2071.41	2075.07	2069.72	2073.38	61.0
2008-07-28 01:00:00	NQ	Futures	2073.94	2075.07	2073.1	2075.07	51.0
2008-07-28 02:00:00	NQ	Futures	2075.07	2078.72	2075.07	2076.47	372.0
2008-07-28 03:00:00	NQ	Futures	2076.19	2076.19	2067.19	2070.57	1481.0
2008-07-28 04:00:00	NQ	Futures	2070.0	2074.5	2069.16	2073.38	1084.0
2008-07-28 05:00:00	NQ	Futures	2073.1	2073.1	2065.5	2066.91	996.0
2008-07-28 06:00:00	NQ	Futures	2066.07	2069.44	2065.22	2069.16	330.0
2008-07-28 07:00:00	NQ	Futures	2068.6	2077.32	2066.91	2077.32	1252.0
2008-07-28 08:00:00	NQ	Futures	2077.32	2078.16	2071.97	2073.94	2335.0
2008-07-28 09:00:00	NQ	Futures	2073.66	2086.6	2069.16	2071.41	40570.0
2008-07-28 10:00:00	NQ	Futures	2071.41	2079.85	2069.16	2071.13	49782.0
2008-07-28 11:00:00	NQ	Futures	2070.85	2071.69	2052.85	2059.03	56978.0
2008-07-28 12:00:00	NQ	Futures	2059.03	2060.72	2043.84	2046.09	36231.0
2008-07-28 13:00:00	NQ	Futures	2046.09	2052.28	2042.72	2048.06	31924.0
2008-07-28 14:00:00	NQ	Futures	2048.06	2050.31	2031.47	2032.87	49414.0
2008-07-28 15:00:00	NQ	Futures	2033.16	2043.0	2025.28	2034.56	63400.0
2008-07-28 16:00:00	NQ	Futures	2034.56	2041.59	2033.16	2038.78	14549.0
2008-07-28 17:00:00	NQ	Futures	2039.06	2039.63	2037.09	2037.09	168.0
2008-07-28 18:00:00	NQ	Futures	2038.5	2042.44	2038.5	2042.16	443.0
2008-07-28 19:00:00	NQ	Futures	2041.88	2042.16	2039.34	2041.03	149.0
2008-07-28 20:00:00	NQ	Futures	2040.19	2040.75	2038.5	2039.06	52.0
2008-07-28 21:00:00	NQ	Futures	2039.06	2039.63	2035.41	2036.25	387.0
2008-07-28 22:00:00	NQ	Futures	2036.25	2037.37	2035.41	2036.81	183.0
2008-07-28 23:00:00	NQ	Futures	2036.81	2041.03	2036.53	2041.03	190.0
2008-07-28 00:00:00	YM	Futures	10276.6	10287.5	10276.6	10284.8	52.0
2008-07-28 01:00:00	YM	Futures	10283.9	10299.4	10283.9	10295.7	179.0

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

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