PREVIEW / futures_1hour / 2008-01-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1263.24	1265.57	1262.54	1263.94	2058.0
2008-01-29 01:00:00	ES	Futures	1263.94	1264.64	1261.37	1263.01	1649.0
2008-01-29 02:00:00	ES	Futures	1263.01	1264.41	1261.14	1262.54	7736.0
2008-01-29 03:00:00	ES	Futures	1262.54	1263.47	1259.28	1263.47	14123.0
2008-01-29 04:00:00	ES	Futures	1263.47	1266.04	1263.01	1264.64	14298.0
2008-01-29 05:00:00	ES	Futures	1264.64	1269.77	1264.17	1269.3	16340.0
2008-01-29 06:00:00	ES	Futures	1269.3	1269.77	1265.34	1266.74	12521.0
2008-01-29 07:00:00	ES	Futures	1266.74	1268.6	1265.11	1266.5	20733.0
2008-01-29 08:00:00	ES	Futures	1266.5	1273.73	1266.04	1271.63	76389.0
2008-01-29 09:00:00	ES	Futures	1271.63	1273.97	1263.24	1263.71	215371.0
2008-01-29 10:00:00	ES	Futures	1263.71	1270.47	1259.98	1268.14	308334.0
2008-01-29 11:00:00	ES	Futures	1268.14	1273.03	1267.67	1270.7	156873.0
2008-01-29 12:00:00	ES	Futures	1270.7	1271.17	1264.17	1266.27	129082.0
2008-01-29 13:00:00	ES	Futures	1266.27	1270.23	1264.41	1266.27	108826.0
2008-01-29 14:00:00	ES	Futures	1266.27	1270.23	1264.41	1269.07	139115.0
2008-01-29 15:00:00	ES	Futures	1269.3	1274.9	1268.84	1271.17	259812.0
2008-01-29 16:00:00	ES	Futures	1270.93	1271.4	1268.84	1269.54	59684.0
2008-01-29 17:00:00	ES	Futures	1269.54	1270.0	1269.3	1269.77	1167.0
2008-01-29 18:00:00	ES	Futures	1270.0	1270.23	1268.37	1269.07	1939.0
2008-01-29 19:00:00	ES	Futures	1269.3	1269.3	1267.67	1267.67	2063.0
2008-01-29 20:00:00	ES	Futures	1267.67	1268.84	1267.44	1268.84	1593.0
2008-01-29 21:00:00	ES	Futures	1268.84	1270.23	1268.84	1268.84	1290.0
2008-01-29 22:00:00	ES	Futures	1268.84	1269.3	1266.04	1266.97	3538.0
2008-01-29 23:00:00	ES	Futures	1266.97	1267.2	1265.57	1265.8	2167.0
2008-01-29 00:00:00	NQ	Futures	2045.09	2049.35	2044.53	2047.65	58.0
2008-01-29 01:00:00	NQ	Futures	2048.5	2049.35	2044.81	2049.35	354.0
2008-01-29 02:00:00	NQ	Futures	2048.22	2049.92	2046.8	2048.5	405.0
2008-01-29 03:00:00	NQ	Futures	2047.65	2050.49	2044.81	2049.35	460.0
2008-01-29 04:00:00	NQ	Futures	2050.49	2055.6	2050.49	2054.18	533.0
2008-01-29 05:00:00	NQ	Futures	2055.03	2061.27	2053.89	2061.27	575.0
2008-01-29 06:00:00	NQ	Futures	2061.27	2062.41	2055.31	2058.72	1348.0
2008-01-29 07:00:00	NQ	Futures	2057.87	2061.27	2055.31	2057.58	672.0
2008-01-29 08:00:00	NQ	Futures	2057.58	2071.49	2055.88	2070.07	8653.0
2008-01-29 09:00:00	NQ	Futures	2069.5	2072.06	2048.22	2049.64	51786.0
2008-01-29 10:00:00	NQ	Futures	2049.64	2060.42	2040.84	2052.47	66937.0
2008-01-29 11:00:00	NQ	Futures	2052.47	2061.84	2051.91	2058.72	37630.0
2008-01-29 12:00:00	NQ	Futures	2058.43	2059.0	2044.81	2049.35	32244.0
2008-01-29 13:00:00	NQ	Futures	2049.07	2057.02	2046.23	2051.34	23105.0
2008-01-29 14:00:00	NQ	Futures	2051.34	2059.29	2047.08	2057.02	38915.0
2008-01-29 15:00:00	NQ	Futures	2057.3	2064.96	2054.74	2059.29	53314.0
2008-01-29 16:00:00	NQ	Futures	2059.29	2062.12	2051.05	2053.33	8935.0
2008-01-29 17:00:00	NQ	Futures	2053.04	2053.89	2052.76	2053.89	367.0
2008-01-29 18:00:00	NQ	Futures	2053.89	2054.18	2052.19	2052.19	300.0
2008-01-29 19:00:00	NQ	Futures	2052.19	2053.33	2051.05	2051.05	172.0
2008-01-29 20:00:00	NQ	Futures	2051.05	2053.04	2051.05	2053.04	31.0
2008-01-29 21:00:00	NQ	Futures	2053.61	2055.6	2053.33	2053.61	83.0
2008-01-29 22:00:00	NQ	Futures	2053.33	2053.33	2049.64	2049.92	230.0
2008-01-29 23:00:00	NQ	Futures	2050.2	2050.2	2045.95	2047.36	298.0
2008-01-29 00:00:00	YM	Futures	11231.8	11245.4	11229.0	11236.3	221.0
2008-01-29 01:00:00	YM	Futures	11234.5	11239.0	11214.5	11238.1	167.0

> showing 50 of 819 rows — these rows as CSV

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