PREVIEW / futures_1hour / 2008-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-16.parquet
  size:    44 KB
  rows:    1,259

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-16 00:00:00	ES	Futures	1129.77	1131.4	1129.77	1130.93	5524.0
2008-07-16 01:00:00	ES	Futures	1130.93	1131.4	1130.24	1131.4	5866.0
2008-07-16 02:00:00	ES	Futures	1131.17	1132.1	1129.77	1130.24	8209.0
2008-07-16 03:00:00	ES	Futures	1130.24	1132.33	1126.98	1130.24	19714.0
2008-07-16 04:00:00	ES	Futures	1130.47	1130.7	1126.75	1129.31	10648.0
2008-07-16 05:00:00	ES	Futures	1129.07	1129.31	1123.73	1124.19	17911.0
2008-07-16 06:00:00	ES	Futures	1123.96	1125.59	1117.92	1120.47	38003.0
2008-07-16 07:00:00	ES	Futures	1120.71	1124.19	1118.85	1121.87	31703.0
2008-07-16 08:00:00	ES	Futures	1121.87	1133.02	1121.64	1127.91	150156.0
2008-07-16 09:00:00	ES	Futures	1127.91	1138.37	1126.28	1137.67	407420.0
2008-07-16 10:00:00	ES	Futures	1137.67	1142.09	1128.84	1139.07	512325.0
2008-07-16 11:00:00	ES	Futures	1139.07	1142.79	1134.42	1137.91	302615.0
2008-07-16 12:00:00	ES	Futures	1137.91	1143.48	1136.51	1142.55	198374.0
2008-07-16 13:00:00	ES	Futures	1142.55	1146.97	1142.09	1145.34	234286.0
2008-07-16 14:00:00	ES	Futures	1145.34	1151.39	1140.93	1149.99	346987.0
2008-07-16 15:00:00	ES	Futures	1149.99	1158.59	1148.36	1157.43	431726.0
2008-07-16 16:00:00	ES	Futures	1157.43	1157.89	1151.62	1153.71	134609.0
2008-07-16 17:00:00	ES	Futures	1153.71	1154.41	1152.55	1153.71	2764.0
2008-07-16 18:00:00	ES	Futures	1153.25	1153.71	1152.32	1152.78	1752.0
2008-07-16 19:00:00	ES	Futures	1152.55	1153.48	1152.08	1153.25	2273.0
2008-07-16 20:00:00	ES	Futures	1153.01	1153.71	1152.08	1152.55	2414.0
2008-07-16 21:00:00	ES	Futures	1152.32	1153.71	1152.08	1152.55	2035.0
2008-07-16 22:00:00	ES	Futures	1152.55	1152.78	1151.15	1151.62	2860.0
2008-07-16 23:00:00	ES	Futures	1151.39	1151.62	1150.92	1151.39	1331.0
2008-07-16 00:00:00	NQ	Futures	2034.28	2036.81	2034.28	2036.53	171.0
2008-07-16 01:00:00	NQ	Futures	2036.53	2036.53	2035.12	2036.53	176.0
2008-07-16 02:00:00	NQ	Futures	2036.81	2038.22	2032.87	2033.72	716.0
2008-07-16 03:00:00	NQ	Futures	2033.72	2034.28	2024.44	2032.03	3182.0
2008-07-16 04:00:00	NQ	Futures	2032.03	2032.59	2025.28	2029.22	1125.0
2008-07-16 05:00:00	NQ	Futures	2028.94	2029.78	2019.65	2019.65	1339.0
2008-07-16 06:00:00	NQ	Futures	2019.09	2021.9	2009.25	2014.31	3621.0
2008-07-16 07:00:00	NQ	Futures	2014.31	2023.03	2011.78	2020.22	3881.0
2008-07-16 08:00:00	NQ	Futures	2020.5	2041.59	2020.22	2028.94	22397.0
2008-07-16 09:00:00	NQ	Futures	2028.65	2039.91	2014.59	2037.37	76025.0
2008-07-16 10:00:00	NQ	Futures	2037.37	2053.41	2021.34	2049.47	98960.0
2008-07-16 11:00:00	NQ	Futures	2049.47	2060.44	2041.88	2049.75	75925.0
2008-07-16 12:00:00	NQ	Futures	2049.75	2061.0	2044.13	2059.03	47074.0
2008-07-16 13:00:00	NQ	Futures	2059.6	2068.32	2057.63	2065.5	53728.0
2008-07-16 14:00:00	NQ	Futures	2065.22	2079.29	2056.5	2076.76	71315.0
2008-07-16 15:00:00	NQ	Futures	2076.76	2081.82	2072.54	2080.13	64584.0
2008-07-16 16:00:00	NQ	Futures	2080.13	2080.69	2069.16	2070.57	14979.0
2008-07-16 17:00:00	NQ	Futures	2070.85	2071.69	2070.0	2071.41	212.0
2008-07-16 18:00:00	NQ	Futures	2071.69	2071.69	2070.0	2070.29	146.0
2008-07-16 19:00:00	NQ	Futures	2070.29	2071.97	2069.72	2071.41	180.0
2008-07-16 20:00:00	NQ	Futures	2071.97	2073.38	2070.85	2072.54	181.0
2008-07-16 21:00:00	NQ	Futures	2072.25	2073.66	2071.41	2071.41	48.0
2008-07-16 22:00:00	NQ	Futures	2071.41	2071.97	2070.0	2070.29	37.0
2008-07-16 23:00:00	NQ	Futures	2070.29	2070.57	2068.6	2068.6	76.0
2008-07-16 00:00:00	YM	Futures	9951.3	9962.2	9946.7	9960.4	187.0
2008-07-16 01:00:00	YM	Futures	9960.4	9963.1	9954.9	9961.3	111.0

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

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