PREVIEW / futures_1hour / 2008-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-06.parquet
  size:    43 KB
  rows:    1,233

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-05-06 00:00:00	ES	Futures	1314.64	1315.8	1314.4	1314.87	1621.0
2008-05-06 01:00:00	ES	Futures	1314.87	1315.1	1312.77	1315.1	2069.0
2008-05-06 02:00:00	ES	Futures	1315.1	1315.57	1313.7	1314.87	3404.0
2008-05-06 03:00:00	ES	Futures	1314.64	1315.8	1313.7	1313.94	7694.0
2008-05-06 04:00:00	ES	Futures	1313.7	1314.4	1311.38	1311.61	12367.0
2008-05-06 05:00:00	ES	Futures	1311.61	1312.31	1309.98	1310.21	10219.0
2008-05-06 06:00:00	ES	Futures	1310.21	1310.68	1308.58	1309.51	12011.0
2008-05-06 07:00:00	ES	Futures	1309.51	1309.98	1304.16	1304.86	39176.0
2008-05-06 08:00:00	ES	Futures	1304.86	1306.72	1302.99	1303.46	53004.0
2008-05-06 09:00:00	ES	Futures	1303.46	1305.09	1301.13	1303.69	222458.0
2008-05-06 10:00:00	ES	Futures	1303.46	1309.98	1302.99	1309.75	297261.0
2008-05-06 11:00:00	ES	Futures	1309.75	1312.07	1307.88	1312.07	209144.0
2008-05-06 12:00:00	ES	Futures	1311.84	1319.99	1311.61	1319.06	297701.0
2008-05-06 13:00:00	ES	Futures	1319.29	1320.46	1317.2	1318.83	176453.0
2008-05-06 14:00:00	ES	Futures	1319.06	1321.62	1315.33	1320.92	209696.0
2008-05-06 15:00:00	ES	Futures	1320.92	1324.65	1319.99	1321.39	249753.0
2008-05-06 16:00:00	ES	Futures	1321.39	1325.11	1320.92	1323.95	81654.0
2008-05-06 17:00:00	ES	Futures	1323.95	1323.95	1322.09	1322.32	3612.0
2008-05-06 18:00:00	ES	Futures	1322.55	1323.72	1321.85	1323.25	2036.0
2008-05-06 19:00:00	ES	Futures	1323.25	1324.41	1323.25	1323.95	1373.0
2008-05-06 20:00:00	ES	Futures	1324.18	1326.28	1323.95	1325.35	2920.0
2008-05-06 21:00:00	ES	Futures	1325.35	1325.35	1322.55	1322.55	2080.0
2008-05-06 22:00:00	ES	Futures	1322.55	1322.79	1320.92	1321.62	2904.0
2008-05-06 23:00:00	ES	Futures	1321.39	1321.62	1319.99	1320.22	2030.0
2008-05-06 00:00:00	NQ	Futures	2244.81	2245.38	2243.96	2245.09	105.0
2008-05-06 01:00:00	NQ	Futures	2245.09	2245.09	2241.42	2244.81	192.0
2008-05-06 02:00:00	NQ	Futures	2245.09	2245.38	2243.4	2244.81	278.0
2008-05-06 03:00:00	NQ	Futures	2244.53	2246.22	2243.4	2243.68	506.0
2008-05-06 04:00:00	NQ	Futures	2243.68	2243.96	2237.17	2237.46	804.0
2008-05-06 05:00:00	NQ	Futures	2237.74	2239.44	2236.04	2236.33	657.0
2008-05-06 06:00:00	NQ	Futures	2236.61	2237.74	2235.19	2235.76	709.0
2008-05-06 07:00:00	NQ	Futures	2235.76	2236.33	2229.82	2230.39	1687.0
2008-05-06 08:00:00	NQ	Futures	2230.67	2234.06	2227.84	2231.52	2978.0
2008-05-06 09:00:00	NQ	Futures	2231.52	2236.33	2219.64	2223.6	53536.0
2008-05-06 10:00:00	NQ	Futures	2223.32	2238.87	2219.92	2238.31	54422.0
2008-05-06 11:00:00	NQ	Futures	2238.31	2241.42	2231.8	2241.13	39286.0
2008-05-06 12:00:00	NQ	Futures	2241.13	2255.84	2240.85	2252.73	49892.0
2008-05-06 13:00:00	NQ	Futures	2253.01	2257.26	2249.05	2253.86	33987.0
2008-05-06 14:00:00	NQ	Futures	2253.86	2261.78	2248.2	2259.52	40769.0
2008-05-06 15:00:00	NQ	Futures	2259.8	2265.17	2254.71	2256.41	46652.0
2008-05-06 16:00:00	NQ	Futures	2256.41	2268.29	2255.28	2265.74	16674.0
2008-05-06 17:00:00	NQ	Futures	2265.74	2265.74	2254.99	2257.82	2064.0
2008-05-06 18:00:00	NQ	Futures	2259.52	2262.63	2259.52	2261.21	636.0
2008-05-06 19:00:00	NQ	Futures	2262.06	2262.63	2260.93	2262.06	116.0
2008-05-06 20:00:00	NQ	Futures	2262.06	2264.33	2261.21	2263.19	189.0
2008-05-06 21:00:00	NQ	Futures	2263.76	2263.76	2258.67	2259.52	70.0
2008-05-06 22:00:00	NQ	Futures	2259.52	2259.8	2255.28	2255.56	229.0
2008-05-06 23:00:00	NQ	Futures	2256.12	2256.69	2254.99	2254.99	77.0
2008-05-06 00:00:00	YM	Futures	11797.0	11801.6	11794.3	11797.0	193.0
2008-05-06 01:00:00	YM	Futures	11794.3	11807.0	11785.2	11807.0	176.0

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

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