PREVIEW / futures_1hour / 2009-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-06.parquet
  size:    38 KB
  rows:    1,028

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-06 00:00:00	ES	Futures	649.89	650.84	648.7	650.6	2170.0
2009-03-06 01:00:00	ES	Futures	650.6	652.97	649.65	650.6	3204.0
2009-03-06 02:00:00	ES	Futures	650.6	653.21	648.7	650.6	8268.0
2009-03-06 03:00:00	ES	Futures	650.6	654.63	649.41	653.21	27139.0
2009-03-06 04:00:00	ES	Futures	652.97	655.34	652.5	653.68	18653.0
2009-03-06 05:00:00	ES	Futures	653.68	653.92	647.28	648.7	26271.0
2009-03-06 06:00:00	ES	Futures	648.7	649.18	643.25	648.7	30509.0
2009-03-06 07:00:00	ES	Futures	648.46	649.89	645.86	647.52	19986.0
2009-03-06 08:00:00	ES	Futures	647.52	658.66	647.28	656.29	146718.0
2009-03-06 09:00:00	ES	Futures	656.29	663.41	650.36	654.87	383566.0
2009-03-06 10:00:00	ES	Futures	654.87	656.77	639.93	641.11	600288.0
2009-03-06 11:00:00	ES	Futures	641.11	646.09	639.21	643.25	345134.0
2009-03-06 12:00:00	ES	Futures	643.25	647.75	637.32	640.87	269555.0
2009-03-06 13:00:00	ES	Futures	640.64	641.11	634.23	637.08	248433.0
2009-03-06 14:00:00	ES	Futures	637.08	640.4	632.34	633.05	353641.0
2009-03-06 15:00:00	ES	Futures	633.05	649.89	631.62	648.23	615043.0
2009-03-06 16:00:00	ES	Futures	648.46	653.45	647.28	653.21	118959.0
2009-03-06 00:00:00	NQ	Futures	1219.88	1222.71	1219.88	1222.71	170.0
2009-03-06 01:00:00	NQ	Futures	1222.71	1224.97	1221.3	1221.58	222.0
2009-03-06 02:00:00	NQ	Futures	1222.71	1224.97	1218.75	1222.43	403.0
2009-03-06 03:00:00	NQ	Futures	1222.71	1227.51	1219.04	1224.68	1154.0
2009-03-06 04:00:00	NQ	Futures	1224.68	1227.51	1222.99	1223.56	991.0
2009-03-06 05:00:00	NQ	Futures	1223.84	1223.84	1213.11	1216.21	1464.0
2009-03-06 06:00:00	NQ	Futures	1216.5	1222.43	1210.85	1221.01	2130.0
2009-03-06 07:00:00	NQ	Futures	1220.73	1223.84	1211.98	1216.21	3294.0
2009-03-06 08:00:00	NQ	Futures	1215.93	1230.61	1215.37	1226.66	13682.0
2009-03-06 09:00:00	NQ	Futures	1226.66	1229.2	1213.11	1213.95	47329.0
2009-03-06 10:00:00	NQ	Futures	1214.52	1216.78	1182.33	1184.3	96780.0
2009-03-06 11:00:00	NQ	Futures	1184.02	1192.49	1179.22	1189.39	53695.0
2009-03-06 12:00:00	NQ	Futures	1189.39	1197.29	1184.3	1192.21	43201.0
2009-03-06 13:00:00	NQ	Futures	1192.49	1192.49	1180.63	1188.26	38125.0
2009-03-06 14:00:00	NQ	Futures	1188.26	1195.6	1180.07	1181.48	53334.0
2009-03-06 15:00:00	NQ	Futures	1181.2	1204.92	1178.09	1204.64	81571.0
2009-03-06 16:00:00	NQ	Futures	1204.64	1216.78	1202.94	1215.08	15468.0
2009-03-06 00:00:00	YM	Futures	6030.8	6039.0	6023.5	6039.0	103.0
2009-03-06 01:00:00	YM	Futures	6037.2	6052.7	6028.1	6031.7	294.0
2009-03-06 02:00:00	YM	Futures	6033.5	6053.6	6019.9	6034.5	817.0
2009-03-06 03:00:00	YM	Futures	6033.5	6064.5	6012.6	6048.1	2250.0
2009-03-06 04:00:00	YM	Futures	6046.3	6062.7	6032.6	6049.9	1039.0
2009-03-06 05:00:00	YM	Futures	6050.9	6050.9	6002.6	6015.3	1361.0
2009-03-06 06:00:00	YM	Futures	6015.3	6018.1	5973.4	6008.0	2291.0
2009-03-06 07:00:00	YM	Futures	6004.4	6022.6	5988.0	6001.6	934.0
2009-03-06 08:00:00	YM	Futures	6001.6	6094.6	5999.8	6076.4	7357.0
2009-03-06 09:00:00	YM	Futures	6075.5	6147.5	6035.4	6071.8	31194.0
2009-03-06 10:00:00	YM	Futures	6072.7	6088.2	5956.1	5965.2	53138.0
2009-03-06 11:00:00	YM	Futures	5965.2	6005.3	5952.4	5983.4	29862.0
2009-03-06 12:00:00	YM	Futures	5983.4	6018.1	5930.6	5959.7	24362.0
2009-03-06 13:00:00	YM	Futures	5959.7	5960.6	5914.2	5936.9	22324.0
2009-03-06 14:00:00	YM	Futures	5936.9	5963.4	5893.2	5900.5	33496.0
2009-03-06 15:00:00	YM	Futures	5900.5	6049.0	5886.8	6039.9	50565.0

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

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