PREVIEW / futures_1hour / 2008-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-06.parquet
  size:    45 KB
  rows:    1,265

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-06 00:00:00	ES	Futures	895.48	899.03	893.35	898.56	4738.0
2008-11-06 01:00:00	ES	Futures	898.32	899.27	897.14	898.56	2717.0
2008-11-06 02:00:00	ES	Futures	898.8	900.22	893.35	895.01	13011.0
2008-11-06 03:00:00	ES	Futures	895.25	901.4	893.35	899.74	26411.0
2008-11-06 04:00:00	ES	Futures	899.51	902.11	894.54	895.01	13701.0
2008-11-06 05:00:00	ES	Futures	894.77	895.01	887.91	890.75	24028.0
2008-11-06 06:00:00	ES	Futures	890.75	895.48	886.02	894.54	20424.0
2008-11-06 07:00:00	ES	Futures	894.77	906.84	887.91	888.86	107164.0
2008-11-06 08:00:00	ES	Futures	889.09	897.14	885.54	894.54	64608.0
2008-11-06 09:00:00	ES	Futures	894.77	900.22	886.02	889.09	346243.0
2008-11-06 10:00:00	ES	Futures	889.09	890.28	874.18	879.63	535344.0
2008-11-06 11:00:00	ES	Futures	879.39	881.28	868.03	871.34	410016.0
2008-11-06 12:00:00	ES	Futures	871.34	873.95	859.98	864.48	396773.0
2008-11-06 13:00:00	ES	Futures	864.48	865.43	852.41	860.22	353411.0
2008-11-06 14:00:00	ES	Futures	860.22	871.11	857.14	864.72	383887.0
2008-11-06 15:00:00	ES	Futures	864.72	867.08	849.1	854.78	615338.0
2008-11-06 16:00:00	ES	Futures	854.78	860.69	851.94	859.04	148500.0
2008-11-06 17:00:00	ES	Futures	859.04	859.75	856.91	856.91	2242.0
2008-11-06 18:00:00	ES	Futures	857.14	858.33	855.96	858.09	3763.0
2008-11-06 19:00:00	ES	Futures	858.09	860.46	855.73	856.44	6172.0
2008-11-06 20:00:00	ES	Futures	856.67	863.3	856.2	862.35	5629.0
2008-11-06 21:00:00	ES	Futures	862.11	866.61	861.17	864.48	6818.0
2008-11-06 22:00:00	ES	Futures	864.48	866.85	860.22	865.9	7648.0
2008-11-06 23:00:00	ES	Futures	865.9	870.63	865.66	868.98	13504.0
2008-11-06 00:00:00	NQ	Futures	1447.07	1451.32	1444.81	1451.04	291.0
2008-11-06 01:00:00	NQ	Futures	1451.04	1451.32	1448.21	1449.06	296.0
2008-11-06 02:00:00	NQ	Futures	1448.77	1449.06	1441.7	1445.66	547.0
2008-11-06 03:00:00	NQ	Futures	1443.96	1452.17	1441.98	1451.04	2372.0
2008-11-06 04:00:00	NQ	Futures	1451.32	1452.17	1443.11	1443.96	1239.0
2008-11-06 05:00:00	NQ	Futures	1443.68	1444.81	1431.23	1435.76	2152.0
2008-11-06 06:00:00	NQ	Futures	1435.76	1444.81	1428.12	1443.4	1632.0
2008-11-06 07:00:00	NQ	Futures	1443.68	1464.62	1431.79	1434.06	6806.0
2008-11-06 08:00:00	NQ	Futures	1434.91	1459.53	1432.36	1452.17	7314.0
2008-11-06 09:00:00	NQ	Futures	1453.02	1466.03	1435.76	1438.87	62906.0
2008-11-06 10:00:00	NQ	Futures	1438.59	1451.32	1421.04	1433.21	80287.0
2008-11-06 11:00:00	NQ	Futures	1433.49	1435.76	1421.32	1429.25	42008.0
2008-11-06 12:00:00	NQ	Futures	1429.25	1434.06	1409.72	1416.51	46519.0
2008-11-06 13:00:00	NQ	Futures	1416.8	1419.06	1403.78	1415.38	44737.0
2008-11-06 14:00:00	NQ	Futures	1415.67	1434.91	1412.55	1422.46	53550.0
2008-11-06 15:00:00	NQ	Futures	1422.46	1425.85	1397.84	1405.48	79835.0
2008-11-06 16:00:00	NQ	Futures	1405.48	1415.67	1402.65	1412.84	21379.0
2008-11-06 17:00:00	NQ	Futures	1411.7	1412.27	1409.72	1410.01	157.0
2008-11-06 18:00:00	NQ	Futures	1409.72	1412.27	1408.03	1410.86	230.0
2008-11-06 19:00:00	NQ	Futures	1411.42	1416.8	1410.57	1410.57	399.0
2008-11-06 20:00:00	NQ	Futures	1411.14	1420.48	1410.86	1419.63	241.0
2008-11-06 21:00:00	NQ	Futures	1419.63	1423.59	1417.65	1420.48	335.0
2008-11-06 22:00:00	NQ	Futures	1421.32	1424.15	1416.23	1424.15	210.0
2008-11-06 23:00:00	NQ	Futures	1424.15	1426.98	1422.17	1424.72	231.0
2008-11-06 00:00:00	YM	Futures	8249.3	8277.5	8233.9	8274.8	342.0
2008-11-06 01:00:00	YM	Futures	8274.8	8283.0	8262.1	8274.8	210.0

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

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