PREVIEW / futures_1hour / 2009-02-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	738.6	739.31	736.93	739.31	1918.0
2009-02-23 01:00:00	ES	Futures	739.31	739.78	737.65	737.65	1734.0
2009-02-23 02:00:00	ES	Futures	737.88	746.19	737.65	744.05	16490.0
2009-02-23 03:00:00	ES	Futures	743.81	745.24	741.2	741.44	22641.0
2009-02-23 04:00:00	ES	Futures	741.44	744.05	740.49	743.34	11408.0
2009-02-23 05:00:00	ES	Futures	743.34	744.76	739.31	739.78	13112.0
2009-02-23 06:00:00	ES	Futures	740.02	740.73	737.17	739.07	12968.0
2009-02-23 07:00:00	ES	Futures	738.83	739.07	732.67	735.99	31648.0
2009-02-23 08:00:00	ES	Futures	735.99	740.97	735.51	740.26	41861.0
2009-02-23 09:00:00	ES	Futures	740.26	740.49	729.82	731.24	283051.0
2009-02-23 10:00:00	ES	Futures	731.24	731.95	719.62	719.86	406469.0
2009-02-23 11:00:00	ES	Futures	719.86	723.18	717.01	718.43	271394.0
2009-02-23 12:00:00	ES	Futures	718.2	718.67	709.9	710.37	233091.0
2009-02-23 13:00:00	ES	Futures	710.13	715.83	709.9	712.5	281822.0
2009-02-23 14:00:00	ES	Futures	712.5	718.43	707.05	707.05	352199.0
2009-02-23 15:00:00	ES	Futures	707.05	711.32	703.02	704.68	550387.0
2009-02-23 16:00:00	ES	Futures	704.68	707.29	701.83	706.1	154410.0
2009-02-23 17:00:00	ES	Futures	706.1	708.0	705.86	707.52	2835.0
2009-02-23 18:00:00	ES	Futures	707.76	708.95	706.58	706.58	5811.0
2009-02-23 19:00:00	ES	Futures	706.34	710.13	706.34	708.71	5641.0
2009-02-23 20:00:00	ES	Futures	708.95	711.32	708.24	708.71	4472.0
2009-02-23 21:00:00	ES	Futures	708.71	710.37	706.1	707.05	4195.0
2009-02-23 22:00:00	ES	Futures	707.29	709.18	706.81	708.47	2071.0
2009-02-23 23:00:00	ES	Futures	708.71	710.61	708.24	708.47	3369.0
2009-02-23 00:00:00	NQ	Futures	1339.61	1340.46	1335.94	1339.33	66.0
2009-02-23 01:00:00	NQ	Futures	1339.33	1340.46	1336.51	1336.79	146.0
2009-02-23 02:00:00	NQ	Futures	1337.35	1350.63	1336.51	1346.96	699.0
2009-02-23 03:00:00	NQ	Futures	1347.24	1350.91	1343.28	1344.13	2303.0
2009-02-23 04:00:00	NQ	Futures	1344.13	1348.37	1343.0	1347.52	930.0
2009-02-23 05:00:00	NQ	Futures	1346.96	1349.21	1340.74	1340.74	1069.0
2009-02-23 06:00:00	NQ	Futures	1341.31	1342.44	1335.66	1339.61	1046.0
2009-02-23 07:00:00	NQ	Futures	1339.61	1339.61	1328.6	1333.97	3298.0
2009-02-23 08:00:00	NQ	Futures	1334.53	1340.74	1331.71	1337.35	5678.0
2009-02-23 09:00:00	NQ	Futures	1337.07	1337.35	1311.09	1312.51	44400.0
2009-02-23 10:00:00	NQ	Futures	1312.51	1314.2	1299.52	1300.08	58612.0
2009-02-23 11:00:00	NQ	Futures	1300.08	1305.73	1290.76	1293.87	43030.0
2009-02-23 12:00:00	NQ	Futures	1293.59	1295.84	1283.98	1284.27	36339.0
2009-02-23 13:00:00	NQ	Futures	1284.27	1294.43	1283.14	1288.5	39177.0
2009-02-23 14:00:00	NQ	Futures	1288.79	1297.82	1279.18	1280.03	50513.0
2009-02-23 15:00:00	NQ	Futures	1280.03	1287.66	1271.28	1278.62	72834.0
2009-02-23 16:00:00	NQ	Futures	1278.62	1284.83	1274.1	1281.73	13869.0
2009-02-23 17:00:00	NQ	Futures	1282.57	1284.83	1282.01	1283.14	250.0
2009-02-23 18:00:00	NQ	Futures	1283.42	1285.11	1281.44	1282.86	420.0
2009-02-23 19:00:00	NQ	Futures	1282.01	1286.24	1281.16	1284.27	363.0
2009-02-23 20:00:00	NQ	Futures	1284.27	1287.94	1283.7	1284.27	396.0
2009-02-23 21:00:00	NQ	Futures	1284.27	1287.37	1280.88	1281.44	194.0
2009-02-23 22:00:00	NQ	Futures	1282.01	1286.81	1282.01	1285.96	94.0
2009-02-23 23:00:00	NQ	Futures	1286.53	1289.35	1284.55	1284.55	249.0
2009-02-23 00:00:00	YM	Futures	6768.9	6776.2	6757.1	6776.2	146.0
2009-02-23 01:00:00	YM	Futures	6775.3	6779.0	6767.1	6768.0	93.0

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

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