PREVIEW / futures_1hour / 2009-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-24.parquet
  size:    44 KB
  rows:    1,278

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-24 00:00:00	ES	Futures	708.47	711.32	708.24	711.32	4301.0
2009-02-24 01:00:00	ES	Futures	711.08	715.83	711.08	713.45	7221.0
2009-02-24 02:00:00	ES	Futures	713.45	715.35	712.03	714.64	14090.0
2009-02-24 03:00:00	ES	Futures	714.64	716.77	711.79	712.03	37499.0
2009-02-24 04:00:00	ES	Futures	711.79	714.88	708.0	709.66	31667.0
2009-02-24 05:00:00	ES	Futures	709.42	713.22	708.95	711.79	15052.0
2009-02-24 06:00:00	ES	Futures	712.03	715.59	710.13	710.84	22228.0
2009-02-24 07:00:00	ES	Futures	710.84	714.17	710.13	712.98	18118.0
2009-02-24 08:00:00	ES	Futures	713.22	713.69	707.05	708.0	37637.0
2009-02-24 09:00:00	ES	Futures	708.24	714.88	708.0	710.37	255816.0
2009-02-24 10:00:00	ES	Futures	710.37	718.91	705.39	715.11	539484.0
2009-02-24 11:00:00	ES	Futures	714.88	716.77	709.42	710.61	266953.0
2009-02-24 12:00:00	ES	Futures	710.61	716.3	708.0	714.88	264822.0
2009-02-24 13:00:00	ES	Futures	715.11	726.02	712.27	725.31	326298.0
2009-02-24 14:00:00	ES	Futures	725.08	729.82	722.94	728.63	282016.0
2009-02-24 15:00:00	ES	Futures	728.4	735.04	728.4	731.48	452175.0
2009-02-24 16:00:00	ES	Futures	731.48	731.95	727.92	729.58	130533.0
2009-02-24 17:00:00	ES	Futures	729.58	731.48	729.11	731.48	3011.0
2009-02-24 18:00:00	ES	Futures	731.24	732.67	730.53	731.72	5216.0
2009-02-24 19:00:00	ES	Futures	731.95	732.19	729.34	729.58	5189.0
2009-02-24 20:00:00	ES	Futures	729.34	730.06	727.45	727.68	3541.0
2009-02-24 21:00:00	ES	Futures	727.68	730.06	727.45	728.87	5297.0
2009-02-24 22:00:00	ES	Futures	728.87	729.58	723.42	723.65	10008.0
2009-02-24 23:00:00	ES	Futures	723.42	725.31	722.94	725.08	3406.0
2009-02-24 00:00:00	NQ	Futures	1286.24	1289.63	1285.68	1289.63	324.0
2009-02-24 01:00:00	NQ	Futures	1289.35	1295.56	1289.35	1293.02	422.0
2009-02-24 02:00:00	NQ	Futures	1294.15	1295.84	1291.04	1295.28	507.0
2009-02-24 03:00:00	NQ	Futures	1295.56	1296.97	1287.66	1287.94	2074.0
2009-02-24 04:00:00	NQ	Futures	1287.66	1290.48	1280.6	1283.42	2150.0
2009-02-24 05:00:00	NQ	Futures	1283.42	1288.5	1281.73	1286.24	779.0
2009-02-24 06:00:00	NQ	Futures	1286.53	1292.74	1285.11	1287.66	1215.0
2009-02-24 07:00:00	NQ	Futures	1288.22	1292.46	1285.68	1287.94	1311.0
2009-02-24 08:00:00	NQ	Futures	1287.94	1289.07	1282.57	1283.7	4942.0
2009-02-24 09:00:00	NQ	Futures	1283.98	1299.23	1281.73	1290.48	47102.0
2009-02-24 10:00:00	NQ	Futures	1289.63	1307.7	1282.57	1298.95	69985.0
2009-02-24 11:00:00	NQ	Futures	1298.95	1301.77	1288.22	1289.63	37711.0
2009-02-24 12:00:00	NQ	Futures	1289.63	1296.41	1284.83	1292.74	37823.0
2009-02-24 13:00:00	NQ	Futures	1293.02	1308.83	1286.24	1307.14	50994.0
2009-02-24 14:00:00	NQ	Futures	1307.14	1318.15	1303.75	1316.18	43542.0
2009-02-24 15:00:00	NQ	Futures	1316.46	1329.17	1315.05	1319.56	70441.0
2009-02-24 16:00:00	NQ	Futures	1319.85	1320.41	1313.35	1315.89	16530.0
2009-02-24 17:00:00	NQ	Futures	1315.33	1317.87	1314.76	1317.59	433.0
2009-02-24 18:00:00	NQ	Futures	1317.59	1320.13	1315.89	1318.44	242.0
2009-02-24 19:00:00	NQ	Futures	1318.44	1319.85	1315.61	1315.61	149.0
2009-02-24 20:00:00	NQ	Futures	1315.33	1315.61	1312.22	1312.22	283.0
2009-02-24 21:00:00	NQ	Futures	1311.66	1316.18	1311.66	1314.2	133.0
2009-02-24 22:00:00	NQ	Futures	1314.48	1315.33	1304.03	1305.73	764.0
2009-02-24 23:00:00	NQ	Futures	1305.73	1308.83	1303.75	1308.83	152.0
2009-02-24 00:00:00	YM	Futures	6500.1	6524.7	6500.1	6522.0	205.0
2009-02-24 01:00:00	YM	Futures	6522.0	6552.1	6522.0	6541.1	433.0

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

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