PREVIEW / futures_1hour / 2009-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-31.parquet
  size:    44 KB
  rows:    1,264

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-31 00:00:00	ES	Futures	756.52	757.48	754.37	754.37	4822.0
2009-03-31 01:00:00	ES	Futures	754.61	755.57	751.73	752.21	6017.0
2009-03-31 02:00:00	ES	Futures	752.21	757.48	751.49	756.04	11778.0
2009-03-31 03:00:00	ES	Futures	756.28	759.4	755.81	759.16	30288.0
2009-03-31 04:00:00	ES	Futures	759.16	760.12	757.72	757.72	16053.0
2009-03-31 05:00:00	ES	Futures	757.96	759.88	757.48	757.96	11415.0
2009-03-31 06:00:00	ES	Futures	758.2	760.6	755.81	759.88	21087.0
2009-03-31 07:00:00	ES	Futures	760.12	760.36	757.72	758.68	15237.0
2009-03-31 08:00:00	ES	Futures	758.68	760.84	758.68	759.64	31075.0
2009-03-31 09:00:00	ES	Futures	759.64	760.84	754.37	755.81	216283.0
2009-03-31 10:00:00	ES	Futures	755.57	762.51	753.89	758.92	387467.0
2009-03-31 11:00:00	ES	Futures	758.92	763.47	758.92	762.28	278221.0
2009-03-31 12:00:00	ES	Futures	762.04	762.99	758.68	762.51	163059.0
2009-03-31 13:00:00	ES	Futures	762.75	767.55	762.28	767.07	246327.0
2009-03-31 14:00:00	ES	Futures	767.07	773.54	766.11	770.9	329171.0
2009-03-31 15:00:00	ES	Futures	770.9	771.38	757.48	758.68	685543.0
2009-03-31 16:00:00	ES	Futures	758.44	760.36	755.57	756.28	205091.0
2009-03-31 17:00:00	ES	Futures	756.04	756.52	753.65	754.13	7915.0
2009-03-31 18:00:00	ES	Futures	754.13	754.61	752.93	753.17	5396.0
2009-03-31 19:00:00	ES	Futures	752.93	756.04	752.45	753.41	7060.0
2009-03-31 20:00:00	ES	Futures	753.41	753.89	747.18	750.05	17474.0
2009-03-31 21:00:00	ES	Futures	750.29	755.33	749.33	753.17	12277.0
2009-03-31 22:00:00	ES	Futures	753.17	754.13	751.49	752.45	6807.0
2009-03-31 23:00:00	ES	Futures	752.21	752.45	750.53	751.25	3574.0
2009-03-31 00:00:00	NQ	Futures	1400.24	1400.81	1396.26	1396.83	282.0
2009-03-31 01:00:00	NQ	Futures	1396.55	1398.54	1392.29	1393.42	343.0
2009-03-31 02:00:00	NQ	Futures	1393.42	1401.95	1392.85	1400.24	546.0
2009-03-31 03:00:00	NQ	Futures	1400.53	1407.06	1398.82	1406.49	1581.0
2009-03-31 04:00:00	NQ	Futures	1406.49	1410.19	1403.65	1404.79	1747.0
2009-03-31 05:00:00	NQ	Futures	1404.79	1408.48	1403.93	1404.79	721.0
2009-03-31 06:00:00	NQ	Futures	1404.79	1407.06	1397.68	1407.06	3135.0
2009-03-31 07:00:00	NQ	Futures	1407.06	1407.63	1401.66	1403.08	1439.0
2009-03-31 08:00:00	NQ	Futures	1403.37	1405.92	1401.95	1404.79	3764.0
2009-03-31 09:00:00	NQ	Futures	1404.79	1407.34	1397.97	1401.38	30979.0
2009-03-31 10:00:00	NQ	Futures	1401.38	1411.04	1399.39	1402.23	48745.0
2009-03-31 11:00:00	NQ	Futures	1402.51	1410.19	1402.23	1407.06	31085.0
2009-03-31 12:00:00	NQ	Futures	1406.78	1412.18	1401.38	1411.32	25317.0
2009-03-31 13:00:00	NQ	Futures	1411.32	1417.57	1410.75	1416.44	31330.0
2009-03-31 14:00:00	NQ	Futures	1416.44	1429.51	1415.3	1424.39	39267.0
2009-03-31 15:00:00	NQ	Futures	1424.68	1425.53	1397.97	1401.38	69454.0
2009-03-31 16:00:00	NQ	Futures	1401.38	1404.22	1393.14	1394.56	20698.0
2009-03-31 17:00:00	NQ	Futures	1394.84	1394.84	1390.58	1392.0	700.0
2009-03-31 18:00:00	NQ	Futures	1391.43	1392.85	1389.16	1389.44	302.0
2009-03-31 19:00:00	NQ	Futures	1390.01	1394.84	1388.59	1389.44	372.0
2009-03-31 20:00:00	NQ	Futures	1389.73	1390.01	1380.92	1384.33	1054.0
2009-03-31 21:00:00	NQ	Futures	1384.61	1392.29	1384.33	1389.44	864.0
2009-03-31 22:00:00	NQ	Futures	1389.44	1390.86	1386.89	1387.45	178.0
2009-03-31 23:00:00	NQ	Futures	1387.45	1388.02	1385.47	1386.6	300.0
2009-03-31 00:00:00	YM	Futures	6915.1	6919.7	6895.8	6895.8	444.0
2009-03-31 01:00:00	YM	Futures	6894.9	6904.1	6873.7	6878.3	380.0

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

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