PREVIEW / futures_1hour / 2009-02-11

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-11.parquet
  size:    43 KB
  rows:    1,249

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-02-11 00:00:00	ES	Futures	787.46	788.4	786.51	788.17	3830.0
2009-02-11 01:00:00	ES	Futures	788.4	788.64	785.32	786.74	2115.0
2009-02-11 02:00:00	ES	Futures	786.74	789.35	785.08	787.46	8525.0
2009-02-11 03:00:00	ES	Futures	787.46	790.3	785.08	788.4	24364.0
2009-02-11 04:00:00	ES	Futures	788.64	789.12	785.56	787.69	11135.0
2009-02-11 05:00:00	ES	Futures	787.69	789.12	785.8	788.17	10059.0
2009-02-11 06:00:00	ES	Futures	788.17	789.83	784.13	784.85	15582.0
2009-02-11 07:00:00	ES	Futures	784.85	785.8	781.05	782.24	30321.0
2009-02-11 08:00:00	ES	Futures	782.24	788.17	781.76	786.98	38821.0
2009-02-11 09:00:00	ES	Futures	786.98	792.67	785.56	789.83	237105.0
2009-02-11 10:00:00	ES	Futures	790.06	791.49	782.0	788.64	359863.0
2009-02-11 11:00:00	ES	Futures	788.88	793.38	786.03	788.4	271057.0
2009-02-11 12:00:00	ES	Futures	788.4	790.78	785.8	786.74	169025.0
2009-02-11 13:00:00	ES	Futures	786.74	788.88	779.15	780.58	247381.0
2009-02-11 14:00:00	ES	Futures	780.58	791.49	777.49	790.3	380920.0
2009-02-11 15:00:00	ES	Futures	790.3	792.91	783.9	789.59	364194.0
2009-02-11 16:00:00	ES	Futures	789.35	791.01	787.69	790.06	78562.0
2009-02-11 17:00:00	ES	Futures	790.3	790.54	789.59	790.3	1422.0
2009-02-11 18:00:00	ES	Futures	789.59	790.3	787.46	787.69	4117.0
2009-02-11 19:00:00	ES	Futures	787.93	789.12	785.56	788.88	5514.0
2009-02-11 20:00:00	ES	Futures	788.88	789.35	787.22	787.93	2362.0
2009-02-11 21:00:00	ES	Futures	787.93	788.64	786.03	786.51	2184.0
2009-02-11 22:00:00	ES	Futures	786.74	787.22	784.85	785.08	3754.0
2009-02-11 23:00:00	ES	Futures	785.32	787.46	785.32	787.22	1830.0
2009-02-11 00:00:00	NQ	Futures	1395.53	1395.81	1394.68	1395.81	457.0
2009-02-11 01:00:00	NQ	Futures	1395.81	1395.81	1391.29	1394.11	171.0
2009-02-11 02:00:00	NQ	Futures	1393.55	1396.09	1391.57	1394.68	474.0
2009-02-11 03:00:00	NQ	Futures	1394.68	1398.35	1390.44	1397.78	2252.0
2009-02-11 04:00:00	NQ	Futures	1397.78	1399.48	1392.42	1397.5	1248.0
2009-02-11 05:00:00	NQ	Futures	1398.35	1400.33	1394.96	1397.78	788.0
2009-02-11 06:00:00	NQ	Futures	1397.5	1399.2	1389.88	1390.44	872.0
2009-02-11 07:00:00	NQ	Futures	1390.16	1394.11	1381.69	1383.95	2402.0
2009-02-11 08:00:00	NQ	Futures	1383.95	1393.83	1382.25	1390.72	7505.0
2009-02-11 09:00:00	NQ	Futures	1390.72	1399.76	1387.34	1393.83	35371.0
2009-02-11 10:00:00	NQ	Futures	1393.83	1397.5	1370.96	1384.23	51003.0
2009-02-11 11:00:00	NQ	Futures	1384.51	1396.37	1379.71	1385.92	36267.0
2009-02-11 12:00:00	NQ	Futures	1385.64	1389.31	1379.71	1382.25	24766.0
2009-02-11 13:00:00	NQ	Futures	1382.25	1386.21	1366.44	1368.7	33757.0
2009-02-11 14:00:00	NQ	Futures	1368.42	1391.01	1362.77	1388.18	49649.0
2009-02-11 15:00:00	NQ	Futures	1387.9	1392.42	1378.3	1385.08	40193.0
2009-02-11 16:00:00	NQ	Futures	1385.08	1386.49	1379.15	1384.23	7248.0
2009-02-11 17:00:00	NQ	Futures	1383.95	1384.79	1383.1	1383.67	17.0
2009-02-11 18:00:00	NQ	Futures	1383.1	1383.95	1381.12	1381.97	332.0
2009-02-11 19:00:00	NQ	Futures	1381.41	1383.95	1378.3	1382.54	170.0
2009-02-11 20:00:00	NQ	Futures	1382.82	1383.1	1379.99	1381.97	50.0
2009-02-11 21:00:00	NQ	Futures	1381.41	1381.41	1378.86	1379.15	50.0
2009-02-11 22:00:00	NQ	Futures	1378.3	1379.15	1375.76	1376.89	95.0
2009-02-11 23:00:00	NQ	Futures	1377.17	1380.56	1377.17	1378.86	93.0
2009-02-11 00:00:00	YM	Futures	7202.7	7210.9	7198.2	7209.1	245.0
2009-02-11 01:00:00	YM	Futures	7210.9	7213.6	7190.0	7195.4	190.0

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

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