PREVIEW / futures_1hour / 2008-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-18.parquet
  size:    38 KB
  rows:    1,010

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-04-18 00:00:00	ES	Futures	1278.08	1278.78	1277.38	1278.78	1089.0
2008-04-18 01:00:00	ES	Futures	1278.78	1278.78	1278.31	1278.54	579.0
2008-04-18 02:00:00	ES	Futures	1278.54	1279.24	1275.98	1278.54	6579.0
2008-04-18 03:00:00	ES	Futures	1278.54	1281.8	1277.85	1281.11	12963.0
2008-04-18 04:00:00	ES	Futures	1281.11	1281.11	1276.91	1278.08	8309.0
2008-04-18 05:00:00	ES	Futures	1278.08	1280.87	1278.08	1280.64	8218.0
2008-04-18 06:00:00	ES	Futures	1280.64	1288.79	1279.94	1288.32	41525.0
2008-04-18 07:00:00	ES	Futures	1288.56	1294.61	1288.32	1292.52	75484.0
2008-04-18 08:00:00	ES	Futures	1292.52	1296.24	1291.12	1296.24	63187.0
2008-04-18 09:00:00	ES	Futures	1296.24	1296.71	1291.12	1292.28	275352.0
2008-04-18 10:00:00	ES	Futures	1292.05	1297.17	1289.95	1295.31	328659.0
2008-04-18 11:00:00	ES	Futures	1295.31	1299.97	1293.45	1298.8	266417.0
2008-04-18 12:00:00	ES	Futures	1298.8	1301.13	1297.64	1299.04	172626.0
2008-04-18 13:00:00	ES	Futures	1298.8	1302.29	1298.57	1299.73	135943.0
2008-04-18 14:00:00	ES	Futures	1299.97	1300.2	1295.78	1297.41	148105.0
2008-04-18 15:00:00	ES	Futures	1297.41	1297.87	1292.52	1296.71	313689.0
2008-04-18 16:00:00	ES	Futures	1296.71	1297.17	1291.82	1292.05	91349.0
2008-04-18 00:00:00	NQ	Futures	2121.21	2121.21	2119.52	2119.52	121.0
2008-04-18 01:00:00	NQ	Futures	2119.23	2120.93	2118.95	2120.93	53.0
2008-04-18 02:00:00	NQ	Futures	2120.08	2120.65	2116.12	2119.8	753.0
2008-04-18 03:00:00	NQ	Futures	2119.8	2124.33	2119.23	2123.48	2277.0
2008-04-18 04:00:00	NQ	Futures	2123.76	2124.04	2117.54	2117.82	1425.0
2008-04-18 05:00:00	NQ	Futures	2117.82	2122.63	2117.54	2122.63	612.0
2008-04-18 06:00:00	NQ	Futures	2122.35	2131.68	2121.78	2129.7	3795.0
2008-04-18 07:00:00	NQ	Futures	2129.42	2134.79	2129.13	2132.81	5233.0
2008-04-18 08:00:00	NQ	Futures	2133.09	2142.71	2131.96	2142.14	6907.0
2008-04-18 09:00:00	NQ	Futures	2141.58	2148.08	2134.51	2136.2	59449.0
2008-04-18 10:00:00	NQ	Futures	2136.2	2148.93	2133.09	2146.95	50799.0
2008-04-18 11:00:00	NQ	Futures	2146.95	2159.11	2146.1	2158.83	52343.0
2008-04-18 12:00:00	NQ	Futures	2158.83	2165.05	2157.42	2160.25	36627.0
2008-04-18 13:00:00	NQ	Futures	2160.25	2166.18	2159.68	2163.36	24872.0
2008-04-18 14:00:00	NQ	Futures	2163.36	2163.92	2156.0	2159.11	38877.0
2008-04-18 15:00:00	NQ	Futures	2159.11	2160.81	2150.35	2155.44	66415.0
2008-04-18 16:00:00	NQ	Futures	2155.72	2159.4	2150.91	2151.76	14461.0
2008-04-18 00:00:00	YM	Futures	11498.1	11503.5	11492.6	11501.7	60.0
2008-04-18 01:00:00	YM	Futures	11501.7	11505.3	11499.0	11501.7	72.0
2008-04-18 02:00:00	YM	Futures	11499.9	11505.3	11486.3	11498.1	271.0
2008-04-18 03:00:00	YM	Futures	11499.9	11525.3	11495.4	11523.5	906.0
2008-04-18 04:00:00	YM	Futures	11522.6	11522.6	11489.9	11499.9	510.0
2008-04-18 05:00:00	YM	Futures	11497.2	11516.2	11496.3	11511.7	496.0
2008-04-18 06:00:00	YM	Futures	11512.6	11575.3	11508.1	11572.6	2551.0
2008-04-18 07:00:00	YM	Futures	11572.6	11639.8	11572.6	11618.0	4280.0
2008-04-18 08:00:00	YM	Futures	11618.0	11637.1	11604.4	11637.1	3495.0
2008-04-18 09:00:00	YM	Futures	11637.1	11653.5	11623.5	11626.2	19978.0
2008-04-18 10:00:00	YM	Futures	11625.3	11673.4	11618.9	11660.7	25286.0
2008-04-18 11:00:00	YM	Futures	11660.7	11698.9	11644.4	11690.7	22116.0
2008-04-18 12:00:00	YM	Futures	11690.7	11713.4	11684.3	11699.8	11506.0
2008-04-18 13:00:00	YM	Futures	11698.9	11718.9	11691.6	11702.5	10384.0
2008-04-18 14:00:00	YM	Futures	11702.5	11703.4	11674.4	11686.2	12444.0
2008-04-18 15:00:00	YM	Futures	11686.2	11688.0	11645.3	11682.5	18981.0

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

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