PREVIEW / futures_1hour / 2009-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-01.parquet
  size:    42 KB
  rows:    1,225

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
2009-04-01 00:00:00	ES	Futures	751.01	751.01	748.38	749.57	4680.0
2009-04-01 01:00:00	ES	Futures	749.57	752.45	748.62	751.73	6647.0
2009-04-01 02:00:00	ES	Futures	751.73	756.76	751.73	756.52	10733.0
2009-04-01 03:00:00	ES	Futures	756.52	758.92	749.81	750.77	36070.0
2009-04-01 04:00:00	ES	Futures	751.01	753.65	749.57	752.69	15261.0
2009-04-01 05:00:00	ES	Futures	752.69	754.85	751.97	753.65	10345.0
2009-04-01 06:00:00	ES	Futures	753.65	756.04	752.93	754.13	11989.0
2009-04-01 07:00:00	ES	Futures	754.13	758.68	753.65	754.85	27845.0
2009-04-01 08:00:00	ES	Futures	754.85	756.76	750.77	751.73	47967.0
2009-04-01 09:00:00	ES	Futures	751.73	752.69	746.7	752.45	235720.0
2009-04-01 10:00:00	ES	Futures	752.45	766.83	752.21	764.19	576560.0
2009-04-01 11:00:00	ES	Futures	764.43	768.75	761.8	768.03	264761.0
2009-04-01 12:00:00	ES	Futures	768.03	771.86	765.87	766.35	178398.0
2009-04-01 13:00:00	ES	Futures	766.59	772.82	764.67	772.34	179929.0
2009-04-01 14:00:00	ES	Futures	772.34	775.45	770.9	773.3	239646.0
2009-04-01 15:00:00	ES	Futures	773.06	776.65	764.67	772.82	578775.0
2009-04-01 16:00:00	ES	Futures	772.58	775.93	772.1	775.22	121796.0
2009-04-01 17:00:00	ES	Futures	775.22	776.41	774.5	776.41	2526.0
2009-04-01 18:00:00	ES	Futures	776.41	776.65	775.22	775.22	2843.0
2009-04-01 19:00:00	ES	Futures	774.98	775.45	774.74	774.98	2880.0
2009-04-01 20:00:00	ES	Futures	774.74	783.6	773.78	779.53	13669.0
2009-04-01 21:00:00	ES	Futures	779.29	787.44	778.33	784.8	10544.0
2009-04-01 22:00:00	ES	Futures	784.56	789.11	784.08	785.76	10688.0
2009-04-01 23:00:00	ES	Futures	785.52	787.44	785.04	786.96	3123.0
2009-04-01 00:00:00	NQ	Futures	1386.32	1386.6	1382.06	1384.05	424.0
2009-04-01 01:00:00	NQ	Futures	1383.76	1389.73	1382.34	1389.44	219.0
2009-04-01 02:00:00	NQ	Futures	1389.16	1396.26	1389.16	1396.26	613.0
2009-04-01 03:00:00	NQ	Futures	1395.98	1399.67	1385.47	1387.45	1696.0
2009-04-01 04:00:00	NQ	Futures	1387.74	1393.14	1384.9	1392.57	1313.0
2009-04-01 05:00:00	NQ	Futures	1392.29	1395.98	1391.15	1392.85	1428.0
2009-04-01 06:00:00	NQ	Futures	1392.57	1395.41	1390.3	1392.29	1256.0
2009-04-01 07:00:00	NQ	Futures	1392.29	1397.4	1390.58	1390.58	3847.0
2009-04-01 08:00:00	NQ	Futures	1391.15	1394.84	1383.76	1384.9	6738.0
2009-04-01 09:00:00	NQ	Futures	1384.61	1388.59	1375.24	1382.34	37075.0
2009-04-01 10:00:00	NQ	Futures	1382.62	1411.89	1382.34	1408.2	74024.0
2009-04-01 11:00:00	NQ	Futures	1408.48	1416.15	1403.65	1415.02	37430.0
2009-04-01 12:00:00	NQ	Futures	1415.02	1420.42	1410.19	1411.61	25075.0
2009-04-01 13:00:00	NQ	Futures	1411.61	1419.56	1408.48	1418.43	23723.0
2009-04-01 14:00:00	NQ	Futures	1418.71	1425.53	1417.29	1422.4	31560.0
2009-04-01 15:00:00	NQ	Futures	1422.69	1426.1	1406.78	1421.27	68946.0
2009-04-01 16:00:00	NQ	Futures	1421.27	1422.97	1419.85	1420.13	10232.0
2009-04-01 17:00:00	NQ	Futures	1421.27	1424.11	1419.28	1422.69	306.0
2009-04-01 18:00:00	NQ	Futures	1422.4	1423.82	1421.84	1421.84	324.0
2009-04-01 19:00:00	NQ	Futures	1421.84	1422.4	1421.55	1422.12	250.0
2009-04-01 20:00:00	NQ	Futures	1421.55	1432.92	1419.56	1427.23	763.0
2009-04-01 21:00:00	NQ	Futures	1426.67	1439.17	1426.1	1437.18	1033.0
2009-04-01 22:00:00	NQ	Futures	1437.18	1442.29	1435.19	1436.61	942.0
2009-04-01 23:00:00	NQ	Futures	1437.46	1441.16	1436.04	1440.59	210.0
2009-04-01 00:00:00	YM	Futures	6863.6	6864.6	6840.7	6848.9	364.0
2009-04-01 01:00:00	YM	Futures	6851.7	6875.6	6846.2	6871.9	389.0

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

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