PREVIEW / futures_1hour / 2008-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-17.parquet
  size:    41 KB
  rows:    1,168

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-11-17 00:00:00	ES	Futures	820.94	824.49	814.55	814.78	6224.0
2008-11-17 01:00:00	ES	Futures	815.02	818.81	814.78	818.81	2213.0
2008-11-17 02:00:00	ES	Futures	818.81	822.12	816.68	820.23	8269.0
2008-11-17 03:00:00	ES	Futures	820.46	826.38	818.1	826.38	21071.0
2008-11-17 04:00:00	ES	Futures	826.38	827.56	818.57	819.52	20376.0
2008-11-17 05:00:00	ES	Futures	819.28	819.75	811.94	812.18	20714.0
2008-11-17 06:00:00	ES	Futures	812.18	814.07	807.92	810.53	18741.0
2008-11-17 07:00:00	ES	Futures	810.76	811.23	805.79	807.92	27210.0
2008-11-17 08:00:00	ES	Futures	807.69	811.0	805.32	806.27	38125.0
2008-11-17 09:00:00	ES	Futures	806.03	819.75	806.03	817.86	317765.0
2008-11-17 10:00:00	ES	Futures	817.86	818.1	801.77	804.37	399975.0
2008-11-17 11:00:00	ES	Futures	804.37	825.91	804.14	823.54	357737.0
2008-11-17 12:00:00	ES	Futures	823.78	834.66	820.7	826.62	371158.0
2008-11-17 13:00:00	ES	Futures	826.62	827.56	815.26	822.36	263783.0
2008-11-17 14:00:00	ES	Futures	822.36	827.56	814.78	817.86	311291.0
2008-11-17 15:00:00	ES	Futures	817.62	826.14	802.24	804.14	442338.0
2008-11-17 16:00:00	ES	Futures	804.14	807.69	802.48	802.95	108872.0
2008-11-17 17:00:00	ES	Futures	802.95	805.32	802.48	804.61	2800.0
2008-11-17 18:00:00	ES	Futures	803.9	804.37	801.53	803.66	5050.0
2008-11-17 19:00:00	ES	Futures	803.66	805.08	802.01	803.19	4641.0
2008-11-17 20:00:00	ES	Futures	802.95	805.08	801.06	804.14	5039.0
2008-11-17 21:00:00	ES	Futures	804.14	804.61	801.77	804.14	3021.0
2008-11-17 22:00:00	ES	Futures	804.14	804.61	798.69	799.64	5393.0
2008-11-17 23:00:00	ES	Futures	799.64	802.72	796.56	802.01	5945.0
2008-11-17 00:00:00	NQ	Futures	1317.48	1320.87	1305.03	1306.16	248.0
2008-11-17 01:00:00	NQ	Futures	1306.16	1312.95	1305.59	1312.95	207.0
2008-11-17 02:00:00	NQ	Futures	1312.67	1318.61	1310.4	1315.5	182.0
2008-11-17 03:00:00	NQ	Futures	1316.35	1323.99	1313.8	1323.99	602.0
2008-11-17 04:00:00	NQ	Futures	1323.7	1326.53	1311.25	1312.67	1029.0
2008-11-17 05:00:00	NQ	Futures	1312.95	1312.95	1301.35	1301.35	968.0
2008-11-17 06:00:00	NQ	Futures	1301.07	1305.59	1293.14	1298.8	1268.0
2008-11-17 07:00:00	NQ	Futures	1299.37	1304.74	1293.71	1301.63	2377.0
2008-11-17 08:00:00	NQ	Futures	1301.91	1304.46	1296.54	1297.67	5044.0
2008-11-17 09:00:00	NQ	Futures	1297.67	1326.53	1297.39	1322.29	52047.0
2008-11-17 10:00:00	NQ	Futures	1322.57	1323.42	1299.08	1304.74	47628.0
2008-11-17 11:00:00	NQ	Futures	1304.46	1333.32	1304.46	1329.64	39786.0
2008-11-17 12:00:00	NQ	Futures	1329.64	1345.49	1326.25	1337.28	39443.0
2008-11-17 13:00:00	NQ	Futures	1337.28	1338.7	1315.5	1325.68	46833.0
2008-11-17 14:00:00	NQ	Futures	1325.4	1333.04	1315.78	1323.99	50794.0
2008-11-17 15:00:00	NQ	Futures	1323.99	1337.57	1302.76	1307.29	58308.0
2008-11-17 16:00:00	NQ	Futures	1306.44	1316.91	1304.46	1306.16	14859.0
2008-11-17 17:00:00	NQ	Futures	1306.16	1309.27	1306.16	1308.42	171.0
2008-11-17 18:00:00	NQ	Futures	1308.14	1309.27	1304.46	1307.57	207.0
2008-11-17 19:00:00	NQ	Futures	1306.72	1309.84	1305.59	1307.29	276.0
2008-11-17 20:00:00	NQ	Futures	1307.01	1311.82	1305.31	1310.4	254.0
2008-11-17 21:00:00	NQ	Futures	1310.12	1310.97	1305.03	1308.99	224.0
2008-11-17 22:00:00	NQ	Futures	1308.99	1310.12	1301.91	1302.48	711.0
2008-11-17 23:00:00	NQ	Futures	1302.48	1308.42	1299.37	1306.72	225.0
2008-11-17 00:00:00	YM	Futures	7658.1	7688.2	7606.3	7606.3	502.0
2008-11-17 01:00:00	YM	Futures	7609.0	7644.5	7609.0	7640.0	210.0

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

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