PREVIEW / futures_1hour / 2008-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-30.parquet
  size:    30 KB
  rows:    813

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-30 00:00:00	ES	Futures	1265.8	1266.27	1264.64	1265.34	2230.0
2008-01-30 01:00:00	ES	Futures	1265.34	1266.97	1263.94	1264.17	3437.0
2008-01-30 02:00:00	ES	Futures	1264.17	1264.87	1262.07	1263.47	9385.0
2008-01-30 03:00:00	ES	Futures	1263.71	1266.27	1262.31	1264.17	15165.0
2008-01-30 04:00:00	ES	Futures	1264.17	1266.04	1261.84	1265.8	14399.0
2008-01-30 05:00:00	ES	Futures	1265.8	1268.84	1265.11	1267.9	12990.0
2008-01-30 06:00:00	ES	Futures	1267.9	1270.23	1267.44	1267.44	11884.0
2008-01-30 07:00:00	ES	Futures	1267.44	1267.9	1263.71	1265.11	22799.0
2008-01-30 08:00:00	ES	Futures	1265.11	1272.33	1264.87	1266.27	71694.0
2008-01-30 09:00:00	ES	Futures	1266.27	1268.37	1262.77	1267.67	165609.0
2008-01-30 10:00:00	ES	Futures	1267.67	1271.87	1267.2	1270.7	201895.0
2008-01-30 11:00:00	ES	Futures	1270.47	1271.17	1264.64	1266.97	154461.0
2008-01-30 12:00:00	ES	Futures	1266.74	1269.07	1265.8	1267.44	80896.0
2008-01-30 13:00:00	ES	Futures	1267.67	1270.23	1266.04	1266.74	77056.0
2008-01-30 14:00:00	ES	Futures	1266.74	1289.82	1265.8	1289.59	806492.0
2008-01-30 15:00:00	ES	Futures	1289.59	1294.02	1261.84	1263.94	799274.0
2008-01-30 16:00:00	ES	Futures	1263.71	1263.94	1253.68	1255.55	142400.0
2008-01-30 17:00:00	ES	Futures	1255.31	1255.55	1247.39	1247.85	21301.0
2008-01-30 18:00:00	ES	Futures	1248.78	1248.78	1243.19	1246.45	20299.0
2008-01-30 19:00:00	ES	Futures	1246.69	1249.48	1245.52	1249.25	8448.0
2008-01-30 20:00:00	ES	Futures	1249.48	1252.05	1248.55	1252.05	10870.0
2008-01-30 21:00:00	ES	Futures	1251.82	1252.51	1246.45	1246.69	4822.0
2008-01-30 22:00:00	ES	Futures	1246.92	1251.35	1245.99	1251.12	3116.0
2008-01-30 23:00:00	ES	Futures	1251.12	1256.01	1250.65	1252.98	7334.0
2008-01-30 00:00:00	NQ	Futures	2047.08	2049.64	2046.23	2046.8	273.0
2008-01-30 01:00:00	NQ	Futures	2047.65	2047.65	2044.81	2045.09	149.0
2008-01-30 02:00:00	NQ	Futures	2045.09	2045.95	2043.67	2044.53	293.0
2008-01-30 03:00:00	NQ	Futures	2044.81	2047.08	2041.69	2045.38	743.0
2008-01-30 04:00:00	NQ	Futures	2043.11	2046.23	2039.42	2046.23	557.0
2008-01-30 05:00:00	NQ	Futures	2045.95	2050.49	2044.53	2050.49	475.0
2008-01-30 06:00:00	NQ	Futures	2048.78	2050.49	2046.51	2046.51	782.0
2008-01-30 07:00:00	NQ	Futures	2046.51	2048.22	2043.67	2045.09	1115.0
2008-01-30 08:00:00	NQ	Futures	2045.66	2052.47	2043.96	2047.93	10003.0
2008-01-30 09:00:00	NQ	Futures	2047.93	2062.12	2046.51	2058.72	37806.0
2008-01-30 10:00:00	NQ	Futures	2058.72	2069.5	2055.03	2068.37	47899.0
2008-01-30 11:00:00	NQ	Futures	2068.08	2069.79	2057.58	2060.14	36878.0
2008-01-30 12:00:00	NQ	Futures	2059.85	2060.99	2055.03	2056.16	18794.0
2008-01-30 13:00:00	NQ	Futures	2055.88	2060.14	2051.62	2054.18	22620.0
2008-01-30 14:00:00	NQ	Futures	2054.18	2091.93	2052.76	2090.51	163798.0
2008-01-30 15:00:00	NQ	Futures	2090.79	2100.44	2056.45	2057.58	151126.0
2008-01-30 16:00:00	NQ	Futures	2057.58	2066.1	2045.38	2045.95	34818.0
2008-01-30 17:00:00	NQ	Futures	2045.95	2046.51	2036.01	2036.86	2057.0
2008-01-30 18:00:00	NQ	Futures	2036.01	2036.86	2025.51	2028.91	3010.0
2008-01-30 19:00:00	NQ	Futures	2029.2	2032.6	2028.91	2032.32	364.0
2008-01-30 20:00:00	NQ	Futures	2031.19	2037.43	2030.62	2036.86	410.0
2008-01-30 21:00:00	NQ	Futures	2036.86	2038.28	2030.05	2030.33	285.0
2008-01-30 22:00:00	NQ	Futures	2030.05	2036.86	2029.2	2034.31	251.0
2008-01-30 23:00:00	NQ	Futures	2034.88	2039.7	2034.59	2037.71	273.0
2008-01-30 00:00:00	YM	Futures	11297.2	11302.6	11294.4	11299.9	71.0
2008-01-30 01:00:00	YM	Futures	11299.9	11305.4	11283.5	11286.3	209.0

> showing 50 of 813 rows — these rows as CSV

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