PREVIEW / futures_1hour / 2008-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-07.parquet
  size:    27 KB
  rows:    735

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-01-07 00:00:00	ES	Futures	1329.92	1331.79	1328.76	1328.99	2595.0
2008-01-07 01:00:00	ES	Futures	1328.99	1329.22	1327.59	1327.82	6206.0
2008-01-07 02:00:00	ES	Futures	1328.06	1331.55	1327.59	1330.62	12151.0
2008-01-07 03:00:00	ES	Futures	1330.62	1332.49	1325.96	1327.12	18725.0
2008-01-07 04:00:00	ES	Futures	1327.12	1333.42	1327.12	1332.49	14221.0
2008-01-07 05:00:00	ES	Futures	1332.49	1334.59	1332.02	1333.89	16907.0
2008-01-07 06:00:00	ES	Futures	1333.89	1334.82	1333.19	1334.35	9218.0
2008-01-07 07:00:00	ES	Futures	1334.35	1335.75	1331.09	1332.25	20016.0
2008-01-07 08:00:00	ES	Futures	1332.25	1333.65	1331.55	1332.49	28248.0
2008-01-07 09:00:00	ES	Futures	1332.25	1333.19	1326.43	1329.69	218958.0
2008-01-07 10:00:00	ES	Futures	1329.69	1329.92	1315.0	1319.9	475249.0
2008-01-07 11:00:00	ES	Futures	1320.13	1331.55	1319.9	1328.99	317817.0
2008-01-07 12:00:00	ES	Futures	1328.99	1335.05	1323.63	1333.19	241648.0
2008-01-07 13:00:00	ES	Futures	1333.19	1333.42	1324.56	1326.66	181714.0
2008-01-07 14:00:00	ES	Futures	1326.66	1328.06	1317.8	1322.46	306954.0
2008-01-07 15:00:00	ES	Futures	1322.69	1330.39	1315.93	1328.06	368310.0
2008-01-07 16:00:00	ES	Futures	1328.06	1329.69	1324.79	1325.96	88792.0
2008-01-07 17:00:00	ES	Futures	1325.96	1325.96	1324.56	1324.56	3549.0
2008-01-07 18:00:00	ES	Futures	1324.56	1326.19	1324.33	1326.19	2282.0
2008-01-07 19:00:00	ES	Futures	1326.19	1326.89	1325.26	1325.73	2534.0
2008-01-07 20:00:00	ES	Futures	1325.96	1328.29	1325.26	1327.59	2659.0
2008-01-07 21:00:00	ES	Futures	1327.59	1328.99	1327.59	1328.52	2055.0
2008-01-07 22:00:00	ES	Futures	1328.52	1330.62	1328.06	1329.46	3695.0
2008-01-07 23:00:00	ES	Futures	1329.46	1329.69	1327.82	1328.52	1371.0
2008-01-07 00:00:00	NQ	Futures	2255.42	2259.96	2255.42	2255.42	137.0
2008-01-07 01:00:00	NQ	Futures	2256.27	2256.27	2253.15	2254.0	241.0
2008-01-07 02:00:00	NQ	Futures	2254.57	2260.25	2254.0	2259.96	405.0
2008-01-07 03:00:00	NQ	Futures	2259.96	2264.5	2250.88	2253.43	1692.0
2008-01-07 04:00:00	NQ	Futures	2253.72	2263.37	2253.72	2262.8	966.0
2008-01-07 05:00:00	NQ	Futures	2262.52	2264.79	2261.38	2262.52	1629.0
2008-01-07 06:00:00	NQ	Futures	2262.8	2263.65	2259.96	2262.8	1007.0
2008-01-07 07:00:00	NQ	Futures	2262.23	2265.64	2255.42	2258.26	2470.0
2008-01-07 08:00:00	NQ	Futures	2257.98	2261.38	2256.84	2257.98	4339.0
2008-01-07 09:00:00	NQ	Futures	2258.26	2259.68	2243.78	2255.42	60667.0
2008-01-07 10:00:00	NQ	Futures	2255.14	2255.42	2206.88	2223.06	119512.0
2008-01-07 11:00:00	NQ	Futures	2223.35	2259.96	2223.06	2251.45	91952.0
2008-01-07 12:00:00	NQ	Futures	2251.16	2261.95	2236.4	2258.54	56584.0
2008-01-07 13:00:00	NQ	Futures	2258.83	2259.11	2235.84	2240.66	45726.0
2008-01-07 14:00:00	NQ	Futures	2240.38	2242.93	2221.08	2230.73	61781.0
2008-01-07 15:00:00	NQ	Futures	2230.73	2247.76	2209.72	2242.08	92039.0
2008-01-07 16:00:00	NQ	Futures	2242.08	2248.04	2241.23	2243.22	15795.0
2008-01-07 17:00:00	NQ	Futures	2242.65	2242.93	2240.95	2240.95	314.0
2008-01-07 18:00:00	NQ	Futures	2241.8	2243.22	2239.24	2242.93	656.0
2008-01-07 19:00:00	NQ	Futures	2242.65	2242.93	2240.38	2242.36	151.0
2008-01-07 20:00:00	NQ	Futures	2242.93	2245.49	2240.38	2245.49	117.0
2008-01-07 21:00:00	NQ	Futures	2245.49	2248.04	2245.2	2246.91	179.0
2008-01-07 22:00:00	NQ	Futures	2246.91	2250.88	2246.91	2250.31	179.0
2008-01-07 23:00:00	NQ	Futures	2250.31	2250.31	2245.49	2246.62	160.0
2008-01-07 00:00:00	YM	Futures	11723.3	11737.8	11713.3	11716.9	161.0
2008-01-07 01:00:00	YM	Futures	11715.1	11719.6	11708.7	11713.3	248.0

> showing 50 of 735 rows — these rows as CSV

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