PREVIEW / futures_1hour / 2009-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-30.parquet
  size:    39 KB
  rows:    1,151

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-03-30 00:00:00	ES	Futures	773.3	773.54	768.75	769.46	12171.0
2009-03-30 01:00:00	ES	Futures	769.7	769.94	767.07	767.55	5807.0
2009-03-30 02:00:00	ES	Futures	767.55	768.03	764.19	766.83	12922.0
2009-03-30 03:00:00	ES	Futures	766.83	768.27	756.76	760.36	51580.0
2009-03-30 04:00:00	ES	Futures	760.36	762.75	758.68	761.08	21676.0
2009-03-30 05:00:00	ES	Futures	761.08	763.47	760.36	762.99	12914.0
2009-03-30 06:00:00	ES	Futures	762.99	764.19	761.8	763.95	12762.0
2009-03-30 07:00:00	ES	Futures	763.95	765.39	763.23	763.47	22092.0
2009-03-30 08:00:00	ES	Futures	763.47	765.87	762.99	762.99	25572.0
2009-03-30 09:00:00	ES	Futures	762.99	763.47	753.89	756.52	319884.0
2009-03-30 10:00:00	ES	Futures	756.28	757.96	749.81	751.73	316477.0
2009-03-30 11:00:00	ES	Futures	751.73	754.37	747.9	751.01	238214.0
2009-03-30 12:00:00	ES	Futures	751.01	753.89	749.81	750.29	161752.0
2009-03-30 13:00:00	ES	Futures	750.05	752.45	746.22	746.7	174019.0
2009-03-30 14:00:00	ES	Futures	746.94	751.01	743.34	743.58	257703.0
2009-03-30 15:00:00	ES	Futures	743.82	752.93	743.34	751.73	471250.0
2009-03-30 16:00:00	ES	Futures	751.73	754.37	750.29	753.65	123427.0
2009-03-30 17:00:00	ES	Futures	753.65	753.89	751.97	752.45	2604.0
2009-03-30 18:00:00	ES	Futures	752.45	755.09	752.21	754.85	3813.0
2009-03-30 19:00:00	ES	Futures	754.61	755.81	754.13	755.81	3827.0
2009-03-30 20:00:00	ES	Futures	755.57	757.0	753.41	756.76	8331.0
2009-03-30 21:00:00	ES	Futures	757.0	757.24	755.09	756.04	4267.0
2009-03-30 22:00:00	ES	Futures	756.28	757.48	755.09	757.0	5376.0
2009-03-30 23:00:00	ES	Futures	757.24	758.44	756.28	756.52	5644.0
2009-03-30 00:00:00	NQ	Futures	1411.04	1411.61	1404.5	1405.64	625.0
2009-03-30 01:00:00	NQ	Futures	1406.21	1406.49	1401.66	1402.51	318.0
2009-03-30 02:00:00	NQ	Futures	1402.8	1402.8	1399.67	1402.51	703.0
2009-03-30 03:00:00	NQ	Futures	1402.8	1405.36	1386.32	1391.72	4071.0
2009-03-30 04:00:00	NQ	Futures	1391.43	1392.57	1388.31	1389.44	2277.0
2009-03-30 05:00:00	NQ	Futures	1389.44	1395.13	1388.88	1393.71	918.0
2009-03-30 06:00:00	NQ	Futures	1393.71	1399.96	1392.0	1398.25	1403.0
2009-03-30 07:00:00	NQ	Futures	1397.68	1402.51	1397.4	1399.1	1779.0
2009-03-30 08:00:00	NQ	Futures	1399.67	1404.22	1398.82	1401.09	3875.0
2009-03-30 09:00:00	NQ	Futures	1401.09	1403.37	1378.65	1384.9	52070.0
2009-03-30 10:00:00	NQ	Futures	1384.9	1386.89	1368.42	1374.38	51320.0
2009-03-30 11:00:00	NQ	Futures	1374.1	1377.79	1367.85	1376.37	35060.0
2009-03-30 12:00:00	NQ	Futures	1376.09	1383.48	1373.25	1376.94	23570.0
2009-03-30 13:00:00	NQ	Futures	1376.94	1379.78	1369.84	1374.1	24933.0
2009-03-30 14:00:00	NQ	Futures	1374.1	1381.2	1368.7	1369.27	34214.0
2009-03-30 15:00:00	NQ	Futures	1369.55	1388.31	1368.7	1387.45	56034.0
2009-03-30 16:00:00	NQ	Futures	1387.45	1393.42	1385.75	1391.43	13446.0
2009-03-30 17:00:00	NQ	Futures	1391.43	1391.43	1388.88	1388.88	128.0
2009-03-30 18:00:00	NQ	Futures	1391.15	1393.99	1390.58	1393.71	347.0
2009-03-30 19:00:00	NQ	Futures	1393.99	1396.26	1393.42	1396.26	306.0
2009-03-30 20:00:00	NQ	Futures	1395.69	1400.24	1394.56	1399.67	532.0
2009-03-30 21:00:00	NQ	Futures	1399.39	1400.53	1397.4	1398.82	266.0
2009-03-30 22:00:00	NQ	Futures	1398.82	1401.38	1397.97	1400.53	116.0
2009-03-30 23:00:00	NQ	Futures	1400.53	1403.65	1399.1	1399.67	331.0
2009-03-30 00:00:00	YM	Futures	7058.4	7059.4	7023.5	7029.0	676.0
2009-03-30 01:00:00	YM	Futures	7028.1	7031.8	7011.6	7019.9	730.0

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

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