PREVIEW / futures_1hour / 2008-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-04.parquet
  size:    42 KB
  rows:    1,218

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-08-04 00:00:00	ES	Futures	1170.68	1171.84	1170.68	1171.37	1105.0
2008-08-04 01:00:00	ES	Futures	1171.61	1171.84	1170.68	1170.91	548.0
2008-08-04 02:00:00	ES	Futures	1171.14	1171.37	1169.51	1170.21	3061.0
2008-08-04 03:00:00	ES	Futures	1170.21	1171.37	1168.82	1171.37	8674.0
2008-08-04 04:00:00	ES	Futures	1171.37	1174.16	1170.91	1172.77	9518.0
2008-08-04 05:00:00	ES	Futures	1172.77	1173.47	1168.35	1169.28	8936.0
2008-08-04 06:00:00	ES	Futures	1169.05	1169.51	1167.65	1169.05	5726.0
2008-08-04 07:00:00	ES	Futures	1169.05	1170.21	1167.89	1169.51	9398.0
2008-08-04 08:00:00	ES	Futures	1169.51	1170.68	1167.19	1168.35	27283.0
2008-08-04 09:00:00	ES	Futures	1168.35	1171.14	1163.01	1165.56	168513.0
2008-08-04 10:00:00	ES	Futures	1165.56	1166.26	1159.75	1161.38	236300.0
2008-08-04 11:00:00	ES	Futures	1161.15	1167.42	1159.29	1166.26	280501.0
2008-08-04 12:00:00	ES	Futures	1166.03	1168.35	1163.24	1163.7	114610.0
2008-08-04 13:00:00	ES	Futures	1163.7	1165.56	1162.54	1164.4	107977.0
2008-08-04 14:00:00	ES	Futures	1164.4	1171.37	1163.7	1169.75	177323.0
2008-08-04 15:00:00	ES	Futures	1169.75	1170.21	1158.59	1159.99	285573.0
2008-08-04 16:00:00	ES	Futures	1159.75	1162.31	1159.75	1161.61	67784.0
2008-08-04 17:00:00	ES	Futures	1161.38	1161.84	1161.38	1161.84	654.0
2008-08-04 18:00:00	ES	Futures	1161.61	1162.31	1160.68	1161.38	1910.0
2008-08-04 19:00:00	ES	Futures	1161.38	1162.31	1160.91	1161.84	1499.0
2008-08-04 20:00:00	ES	Futures	1161.84	1163.47	1161.84	1163.24	2111.0
2008-08-04 21:00:00	ES	Futures	1163.47	1163.47	1161.61	1162.08	1584.0
2008-08-04 22:00:00	ES	Futures	1162.08	1162.54	1161.38	1161.61	1573.0
2008-08-04 23:00:00	ES	Futures	1161.84	1163.01	1161.61	1162.31	818.0
2008-08-04 00:00:00	NQ	Futures	2060.16	2061.85	2060.16	2061.28	83.0
2008-08-04 01:00:00	NQ	Futures	2061.28	2061.28	2059.88	2059.88	69.0
2008-08-04 02:00:00	NQ	Futures	2060.44	2060.72	2057.35	2058.75	421.0
2008-08-04 03:00:00	NQ	Futures	2059.03	2060.72	2055.94	2060.44	792.0
2008-08-04 04:00:00	NQ	Futures	2060.72	2066.07	2060.72	2063.53	571.0
2008-08-04 05:00:00	NQ	Futures	2063.53	2065.22	2055.1	2055.94	671.0
2008-08-04 06:00:00	NQ	Futures	2056.78	2057.91	2054.25	2056.22	556.0
2008-08-04 07:00:00	NQ	Futures	2055.94	2056.5	2052.28	2053.69	1985.0
2008-08-04 08:00:00	NQ	Futures	2053.69	2055.94	2050.03	2054.81	3755.0
2008-08-04 09:00:00	NQ	Futures	2054.81	2058.75	2039.06	2047.22	38968.0
2008-08-04 10:00:00	NQ	Futures	2047.5	2048.91	2032.87	2037.94	43184.0
2008-08-04 11:00:00	NQ	Futures	2037.66	2054.53	2034.28	2050.31	50451.0
2008-08-04 12:00:00	NQ	Futures	2050.6	2053.13	2042.72	2043.0	18030.0
2008-08-04 13:00:00	NQ	Futures	2043.56	2047.5	2039.06	2043.84	21887.0
2008-08-04 14:00:00	NQ	Futures	2043.84	2053.69	2041.88	2047.5	27627.0
2008-08-04 15:00:00	NQ	Futures	2047.78	2049.19	2027.25	2034.28	61591.0
2008-08-04 16:00:00	NQ	Futures	2034.28	2040.75	2034.0	2039.34	11773.0
2008-08-04 17:00:00	NQ	Futures	2039.34	2041.31	2039.34	2041.31	154.0
2008-08-04 18:00:00	NQ	Futures	2040.47	2046.66	2039.34	2040.75	498.0
2008-08-04 19:00:00	NQ	Futures	2040.75	2041.88	2040.19	2040.75	104.0
2008-08-04 20:00:00	NQ	Futures	2041.88	2044.13	2041.88	2043.28	39.0
2008-08-04 21:00:00	NQ	Futures	2043.28	2043.84	2040.75	2040.75	70.0
2008-08-04 22:00:00	NQ	Futures	2040.75	2041.88	2040.47	2040.75	92.0
2008-08-04 23:00:00	NQ	Futures	2041.03	2042.16	2040.47	2041.88	53.0
2008-08-04 00:00:00	YM	Futures	10265.7	10274.8	10265.7	10273.9	93.0
2008-08-04 01:00:00	YM	Futures	10273.9	10274.8	10263.9	10270.3	93.0

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

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