PREVIEW / futures_1hour / 2009-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-12.parquet
  size:    44 KB
  rows:    1,251

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-01-12 00:00:00	ES	Futures	835.13	837.74	835.13	837.03	2019.0
2009-01-12 01:00:00	ES	Futures	837.26	837.5	834.89	836.32	1020.0
2009-01-12 02:00:00	ES	Futures	836.32	838.92	836.08	838.69	4658.0
2009-01-12 03:00:00	ES	Futures	838.69	839.16	836.08	838.69	11638.0
2009-01-12 04:00:00	ES	Futures	838.69	839.87	837.26	837.74	9133.0
2009-01-12 05:00:00	ES	Futures	837.5	840.11	837.03	839.16	6624.0
2009-01-12 06:00:00	ES	Futures	839.16	839.87	837.26	838.92	7595.0
2009-01-12 07:00:00	ES	Futures	839.16	840.11	837.5	837.74	8223.0
2009-01-12 08:00:00	ES	Futures	837.98	839.64	836.79	838.45	17142.0
2009-01-12 09:00:00	ES	Futures	838.45	840.11	832.05	835.13	188773.0
2009-01-12 10:00:00	ES	Futures	835.13	835.37	829.2	831.57	247212.0
2009-01-12 11:00:00	ES	Futures	831.33	832.28	826.12	826.12	191103.0
2009-01-12 12:00:00	ES	Futures	826.12	828.96	825.17	826.35	114794.0
2009-01-12 13:00:00	ES	Futures	826.59	829.44	825.4	826.59	129003.0
2009-01-12 14:00:00	ES	Futures	826.59	826.83	818.76	820.42	221085.0
2009-01-12 15:00:00	ES	Futures	820.42	823.98	816.15	821.37	373633.0
2009-01-12 16:00:00	ES	Futures	821.37	825.64	820.9	825.4	108496.0
2009-01-12 17:00:00	ES	Futures	825.4	825.88	825.17	825.64	1777.0
2009-01-12 18:00:00	ES	Futures	825.64	827.3	825.4	826.35	3472.0
2009-01-12 19:00:00	ES	Futures	826.35	827.07	825.4	826.12	3642.0
2009-01-12 20:00:00	ES	Futures	825.88	828.25	825.4	828.01	2367.0
2009-01-12 21:00:00	ES	Futures	828.01	828.25	827.07	827.78	2982.0
2009-01-12 22:00:00	ES	Futures	827.78	828.25	827.07	828.01	3045.0
2009-01-12 23:00:00	ES	Futures	828.25	828.73	827.3	828.49	2374.0
2009-01-12 00:00:00	NQ	Futures	1372.37	1376.61	1372.37	1374.91	59.0
2009-01-12 01:00:00	NQ	Futures	1375.19	1376.32	1372.37	1373.22	72.0
2009-01-12 02:00:00	NQ	Futures	1373.22	1378.3	1373.22	1378.02	189.0
2009-01-12 03:00:00	NQ	Futures	1377.74	1380.56	1374.35	1379.43	700.0
2009-01-12 04:00:00	NQ	Futures	1379.43	1384.79	1377.45	1380.56	1965.0
2009-01-12 05:00:00	NQ	Futures	1379.99	1384.51	1379.99	1383.38	562.0
2009-01-12 06:00:00	NQ	Futures	1382.82	1384.79	1379.15	1381.69	1060.0
2009-01-12 07:00:00	NQ	Futures	1381.69	1383.1	1379.43	1379.43	475.0
2009-01-12 08:00:00	NQ	Futures	1379.43	1382.54	1376.89	1380.84	1988.0
2009-01-12 09:00:00	NQ	Futures	1380.84	1384.51	1368.42	1375.19	29636.0
2009-01-12 10:00:00	NQ	Futures	1375.19	1376.61	1362.77	1367.0	34520.0
2009-01-12 11:00:00	NQ	Futures	1367.29	1368.13	1352.6	1353.45	32823.0
2009-01-12 12:00:00	NQ	Futures	1353.45	1359.66	1351.19	1355.14	14625.0
2009-01-12 13:00:00	NQ	Futures	1354.86	1359.38	1353.73	1354.86	14849.0
2009-01-12 14:00:00	NQ	Futures	1354.58	1354.58	1339.9	1349.78	33162.0
2009-01-12 15:00:00	NQ	Futures	1349.78	1360.23	1345.26	1355.14	47289.0
2009-01-12 16:00:00	NQ	Futures	1355.43	1365.31	1354.58	1365.31	12033.0
2009-01-12 17:00:00	NQ	Futures	1363.9	1365.31	1362.49	1365.31	317.0
2009-01-12 18:00:00	NQ	Futures	1364.46	1367.0	1363.33	1364.18	331.0
2009-01-12 19:00:00	NQ	Futures	1365.03	1365.88	1363.62	1364.18	81.0
2009-01-12 20:00:00	NQ	Futures	1365.03	1368.42	1364.75	1368.13	208.0
2009-01-12 21:00:00	NQ	Futures	1367.85	1369.26	1367.57	1368.13	77.0
2009-01-12 22:00:00	NQ	Futures	1367.85	1368.98	1367.29	1368.42	124.0
2009-01-12 23:00:00	NQ	Futures	1367.85	1368.7	1367.57	1368.7	9.0
2009-01-12 00:00:00	YM	Futures	7741.3	7758.6	7738.5	7754.0	150.0
2009-01-12 01:00:00	YM	Futures	7754.9	7760.4	7739.4	7749.5	111.0

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

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