PREVIEW / futures_1hour / 2009-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-23.parquet
  size:    43 KB
  rows:    1,243

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-23 00:00:00	ES	Futures	744.78	745.98	742.86	743.58	4011.0
2009-03-23 01:00:00	ES	Futures	743.34	746.7	742.86	745.98	4492.0
2009-03-23 02:00:00	ES	Futures	746.22	747.9	745.5	746.94	5551.0
2009-03-23 03:00:00	ES	Futures	746.94	755.81	746.94	753.41	23631.0
2009-03-23 04:00:00	ES	Futures	753.41	753.89	750.77	751.73	23942.0
2009-03-23 05:00:00	ES	Futures	751.97	754.37	751.73	753.89	16048.0
2009-03-23 06:00:00	ES	Futures	753.89	755.57	751.97	753.89	21525.0
2009-03-23 07:00:00	ES	Futures	753.65	757.48	751.97	757.24	36481.0
2009-03-23 08:00:00	ES	Futures	757.48	757.96	747.42	748.62	98307.0
2009-03-23 09:00:00	ES	Futures	748.86	753.89	746.22	751.97	276898.0
2009-03-23 10:00:00	ES	Futures	751.73	763.71	751.73	762.99	490391.0
2009-03-23 11:00:00	ES	Futures	762.99	767.79	760.12	766.59	272129.0
2009-03-23 12:00:00	ES	Futures	766.59	767.55	764.19	764.19	172598.0
2009-03-23 13:00:00	ES	Futures	764.43	768.98	759.64	761.32	275843.0
2009-03-23 14:00:00	ES	Futures	761.32	772.82	759.88	772.1	319971.0
2009-03-23 15:00:00	ES	Futures	772.34	785.52	770.18	785.28	619550.0
2009-03-23 16:00:00	ES	Futures	785.52	786.96	783.12	784.08	214154.0
2009-03-23 17:00:00	ES	Futures	784.32	785.28	783.6	784.8	4645.0
2009-03-23 18:00:00	ES	Futures	784.8	785.28	782.64	782.64	4472.0
2009-03-23 19:00:00	ES	Futures	782.88	782.88	781.93	782.4	3756.0
2009-03-23 20:00:00	ES	Futures	782.4	783.12	781.21	781.93	5346.0
2009-03-23 21:00:00	ES	Futures	781.93	782.64	780.01	780.01	4804.0
2009-03-23 22:00:00	ES	Futures	780.01	780.97	779.77	780.73	3363.0
2009-03-23 23:00:00	ES	Futures	780.73	780.97	778.57	778.81	5046.0
2009-03-23 00:00:00	NQ	Futures	1370.41	1371.26	1367.85	1369.55	173.0
2009-03-23 01:00:00	NQ	Futures	1368.99	1373.25	1367.57	1371.83	236.0
2009-03-23 02:00:00	NQ	Futures	1372.11	1375.24	1371.54	1373.82	205.0
2009-03-23 03:00:00	NQ	Futures	1374.1	1388.59	1374.1	1385.47	1388.0
2009-03-23 04:00:00	NQ	Futures	1385.47	1386.6	1380.92	1382.62	1524.0
2009-03-23 05:00:00	NQ	Futures	1383.76	1387.17	1383.19	1386.03	1346.0
2009-03-23 06:00:00	NQ	Futures	1386.6	1386.89	1382.91	1384.9	1398.0
2009-03-23 07:00:00	NQ	Futures	1384.9	1389.73	1381.49	1386.89	3950.0
2009-03-23 08:00:00	NQ	Futures	1386.89	1388.31	1372.11	1376.09	9166.0
2009-03-23 09:00:00	NQ	Futures	1376.37	1381.2	1367.28	1375.81	36427.0
2009-03-23 10:00:00	NQ	Futures	1376.37	1394.56	1376.37	1392.57	63747.0
2009-03-23 11:00:00	NQ	Futures	1392.85	1405.07	1390.58	1403.37	44037.0
2009-03-23 12:00:00	NQ	Futures	1403.65	1405.36	1397.97	1398.25	25572.0
2009-03-23 13:00:00	NQ	Futures	1397.97	1403.65	1390.01	1393.71	30971.0
2009-03-23 14:00:00	NQ	Futures	1393.42	1410.75	1390.58	1410.47	40667.0
2009-03-23 15:00:00	NQ	Futures	1410.47	1429.22	1407.06	1429.22	85789.0
2009-03-23 16:00:00	NQ	Futures	1429.22	1429.79	1421.55	1424.39	24181.0
2009-03-23 17:00:00	NQ	Futures	1425.25	1426.38	1423.26	1425.81	232.0
2009-03-23 18:00:00	NQ	Futures	1426.38	1426.38	1422.69	1422.69	302.0
2009-03-23 19:00:00	NQ	Futures	1422.69	1422.69	1420.13	1420.98	512.0
2009-03-23 20:00:00	NQ	Futures	1421.55	1422.4	1419.85	1420.13	245.0
2009-03-23 21:00:00	NQ	Futures	1420.13	1420.98	1417.29	1417.29	227.0
2009-03-23 22:00:00	NQ	Futures	1417.29	1418.43	1416.15	1417.57	201.0
2009-03-23 23:00:00	NQ	Futures	1417.29	1417.29	1413.88	1413.88	282.0
2009-03-23 00:00:00	YM	Futures	6731.3	6739.6	6721.2	6725.8	326.0
2009-03-23 01:00:00	YM	Futures	6725.8	6746.0	6722.1	6740.5	201.0

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

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