PREVIEW / futures_1hour / 2008-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-21.parquet
  size:    38 KB
  rows:    1,026

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
2008-11-21 00:00:00	ES	Futures	722.96	728.17	719.89	727.93	9324.0
2008-11-21 01:00:00	ES	Futures	727.93	731.72	724.86	727.46	11550.0
2008-11-21 02:00:00	ES	Futures	727.46	738.11	726.99	735.51	37417.0
2008-11-21 03:00:00	ES	Futures	735.27	740.24	729.35	738.82	40004.0
2008-11-21 04:00:00	ES	Futures	738.82	741.9	735.74	736.45	27710.0
2008-11-21 05:00:00	ES	Futures	736.22	743.08	731.01	733.85	26588.0
2008-11-21 06:00:00	ES	Futures	733.85	735.27	727.22	729.83	27873.0
2008-11-21 07:00:00	ES	Futures	729.83	731.96	725.09	725.57	43068.0
2008-11-21 08:00:00	ES	Futures	725.33	731.01	724.15	728.64	63165.0
2008-11-21 09:00:00	ES	Futures	728.88	731.48	715.39	718.94	447934.0
2008-11-21 10:00:00	ES	Futures	719.18	723.67	705.45	707.35	597302.0
2008-11-21 11:00:00	ES	Futures	707.35	721.78	699.54	712.32	465336.0
2008-11-21 12:00:00	ES	Futures	712.32	726.99	709.24	719.89	327874.0
2008-11-21 13:00:00	ES	Futures	719.89	720.83	704.98	705.22	285224.0
2008-11-21 14:00:00	ES	Futures	705.22	718.7	701.67	707.82	480001.0
2008-11-21 15:00:00	ES	Futures	707.82	758.7	707.11	756.57	1075844.0
2008-11-21 16:00:00	ES	Futures	756.57	759.41	747.34	748.76	223081.0
2008-11-21 00:00:00	NQ	Futures	1198.07	1205.14	1194.11	1202.59	202.0
2008-11-21 01:00:00	NQ	Futures	1203.44	1211.08	1202.31	1205.71	371.0
2008-11-21 02:00:00	NQ	Futures	1205.42	1222.12	1204.58	1216.74	676.0
2008-11-21 03:00:00	NQ	Futures	1216.46	1231.46	1207.97	1231.17	3089.0
2008-11-21 04:00:00	NQ	Futures	1230.61	1234.0	1218.44	1218.44	2153.0
2008-11-21 05:00:00	NQ	Futures	1219.57	1230.32	1213.91	1218.44	1438.0
2008-11-21 06:00:00	NQ	Futures	1219.86	1221.55	1211.37	1216.18	1234.0
2008-11-21 07:00:00	NQ	Futures	1215.04	1215.33	1193.26	1193.54	3932.0
2008-11-21 08:00:00	NQ	Futures	1193.54	1202.88	1190.43	1198.35	8422.0
2008-11-21 09:00:00	NQ	Futures	1198.35	1206.27	1185.33	1194.39	66584.0
2008-11-21 10:00:00	NQ	Futures	1194.11	1200.05	1165.81	1167.51	76050.0
2008-11-21 11:00:00	NQ	Futures	1167.51	1194.11	1159.02	1181.09	54928.0
2008-11-21 12:00:00	NQ	Futures	1181.09	1198.35	1175.43	1184.77	42243.0
2008-11-21 13:00:00	NQ	Futures	1185.05	1186.47	1158.73	1159.3	34763.0
2008-11-21 14:00:00	NQ	Futures	1159.02	1177.98	1151.94	1160.43	61396.0
2008-11-21 15:00:00	NQ	Futures	1160.43	1230.04	1159.87	1226.93	125775.0
2008-11-21 16:00:00	NQ	Futures	1226.93	1237.12	1226.08	1226.93	25606.0
2008-11-21 00:00:00	YM	Futures	6961.5	7007.8	6943.3	7005.1	758.0
2008-11-21 01:00:00	YM	Futures	7004.2	7034.2	6980.6	7005.1	1208.0
2008-11-21 02:00:00	YM	Futures	7004.2	7078.8	6998.7	7057.9	2030.0
2008-11-21 03:00:00	YM	Futures	7057.0	7089.7	7007.8	7085.2	3644.0
2008-11-21 04:00:00	YM	Futures	7080.6	7106.1	7059.7	7059.7	1998.0
2008-11-21 05:00:00	YM	Futures	7063.3	7112.4	7026.9	7047.9	1981.0
2008-11-21 06:00:00	YM	Futures	7052.4	7063.3	6994.2	7014.2	2163.0
2008-11-21 07:00:00	YM	Futures	7013.3	7034.2	6982.4	6983.3	2171.0
2008-11-21 08:00:00	YM	Futures	6982.4	7017.8	6958.7	7000.6	4768.0
2008-11-21 09:00:00	YM	Futures	6997.8	7033.3	6868.7	6900.5	45617.0
2008-11-21 10:00:00	YM	Futures	6899.6	6963.3	6823.2	6838.7	57833.0
2008-11-21 11:00:00	YM	Futures	6838.7	6966.0	6763.2	6883.2	44401.0
2008-11-21 12:00:00	YM	Futures	6882.3	7009.7	6852.3	6939.6	34428.0
2008-11-21 13:00:00	YM	Futures	6939.6	6946.0	6796.8	6802.3	29710.0
2008-11-21 14:00:00	YM	Futures	6803.2	6932.4	6775.9	6829.6	48705.0
2008-11-21 15:00:00	YM	Futures	6830.5	7333.5	6826.8	7317.1	101148.0

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

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