PREVIEW / futures_1hour / 2009-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-16.parquet
  size:    41 KB
  rows:    1,222

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-16 00:00:00	ES	Futures	719.14	719.14	717.22	718.66	1616.0
2009-03-16 01:00:00	ES	Futures	718.66	718.9	717.46	717.46	1632.0
2009-03-16 02:00:00	ES	Futures	717.7	719.86	717.46	719.86	2499.0
2009-03-16 03:00:00	ES	Futures	719.86	730.4	719.86	728.97	14516.0
2009-03-16 04:00:00	ES	Futures	729.21	730.64	725.85	730.16	20975.0
2009-03-16 05:00:00	ES	Futures	730.16	734.0	727.53	733.52	23099.0
2009-03-16 06:00:00	ES	Futures	733.52	734.0	731.12	731.36	19247.0
2009-03-16 07:00:00	ES	Futures	731.6	733.28	729.92	732.32	16869.0
2009-03-16 08:00:00	ES	Futures	732.32	732.32	729.45	730.16	35007.0
2009-03-16 09:00:00	ES	Futures	729.92	732.32	727.29	729.68	301093.0
2009-03-16 10:00:00	ES	Futures	729.92	733.28	725.85	728.73	362135.0
2009-03-16 11:00:00	ES	Futures	728.73	736.16	728.25	733.04	281644.0
2009-03-16 12:00:00	ES	Futures	733.04	739.51	731.36	738.79	210995.0
2009-03-16 13:00:00	ES	Futures	739.03	739.51	734.72	735.44	210556.0
2009-03-16 14:00:00	ES	Futures	735.44	735.68	728.49	729.21	278285.0
2009-03-16 15:00:00	ES	Futures	729.21	730.16	718.42	719.86	461294.0
2009-03-16 16:00:00	ES	Futures	719.86	723.45	719.38	722.5	122445.0
2009-03-16 17:00:00	ES	Futures	722.5	722.5	721.78	722.02	1678.0
2009-03-16 18:00:00	ES	Futures	722.02	722.74	721.54	722.26	1969.0
2009-03-16 19:00:00	ES	Futures	722.26	722.98	721.78	722.74	1724.0
2009-03-16 20:00:00	ES	Futures	722.74	723.21	721.06	722.98	3611.0
2009-03-16 21:00:00	ES	Futures	722.98	724.17	722.5	722.74	2140.0
2009-03-16 22:00:00	ES	Futures	722.74	722.74	721.54	721.54	3560.0
2009-03-16 23:00:00	ES	Futures	721.54	723.69	720.1	723.45	5371.0
2009-03-16 00:00:00	NQ	Futures	1317.56	1317.56	1314.72	1316.7	188.0
2009-03-16 01:00:00	NQ	Futures	1316.7	1318.12	1315.0	1316.14	72.0
2009-03-16 02:00:00	NQ	Futures	1316.14	1319.83	1316.14	1319.83	113.0
2009-03-16 03:00:00	NQ	Futures	1319.83	1336.59	1319.83	1334.6	1383.0
2009-03-16 04:00:00	NQ	Futures	1334.6	1335.74	1329.21	1334.89	1845.0
2009-03-16 05:00:00	NQ	Futures	1335.17	1340.57	1330.91	1340.0	1712.0
2009-03-16 06:00:00	NQ	Futures	1339.72	1341.14	1334.89	1335.46	1080.0
2009-03-16 07:00:00	NQ	Futures	1335.17	1339.72	1333.18	1339.15	1580.0
2009-03-16 08:00:00	NQ	Futures	1339.15	1339.15	1330.63	1332.33	4451.0
2009-03-16 09:00:00	NQ	Futures	1332.62	1335.17	1314.43	1318.12	51079.0
2009-03-16 10:00:00	NQ	Futures	1318.41	1321.25	1305.91	1307.33	51990.0
2009-03-16 11:00:00	NQ	Futures	1307.33	1322.96	1306.47	1319.55	38407.0
2009-03-16 12:00:00	NQ	Futures	1319.55	1332.9	1316.7	1332.05	28690.0
2009-03-16 13:00:00	NQ	Futures	1331.76	1332.62	1319.26	1320.97	30317.0
2009-03-16 14:00:00	NQ	Futures	1320.68	1322.96	1313.01	1314.15	35519.0
2009-03-16 15:00:00	NQ	Futures	1314.15	1315.28	1298.23	1301.64	59916.0
2009-03-16 16:00:00	NQ	Futures	1301.36	1310.17	1301.36	1307.9	12441.0
2009-03-16 17:00:00	NQ	Futures	1307.9	1308.75	1307.04	1307.61	129.0
2009-03-16 18:00:00	NQ	Futures	1307.04	1308.18	1306.47	1307.61	85.0
2009-03-16 19:00:00	NQ	Futures	1307.61	1309.32	1306.76	1307.61	82.0
2009-03-16 20:00:00	NQ	Futures	1308.18	1311.31	1305.62	1310.74	179.0
2009-03-16 21:00:00	NQ	Futures	1310.74	1312.73	1310.17	1310.45	214.0
2009-03-16 22:00:00	NQ	Futures	1310.45	1310.45	1308.46	1308.75	207.0
2009-03-16 23:00:00	NQ	Futures	1308.18	1311.87	1304.77	1311.87	169.0
2009-03-16 00:00:00	YM	Futures	6562.2	6565.9	6552.1	6561.3	60.0
2009-03-16 01:00:00	YM	Futures	6561.3	6564.1	6553.9	6553.9	61.0

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

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