PREVIEW / futures_1hour / 2009-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-07.parquet
  size:    45 KB
  rows:    1,274

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-07 00:00:00	ES	Futures	880.19	880.91	879.25	879.25	1136.0
2009-01-07 01:00:00	ES	Futures	879.25	880.19	878.3	878.3	2132.0
2009-01-07 02:00:00	ES	Futures	878.53	879.25	877.82	878.06	4336.0
2009-01-07 03:00:00	ES	Futures	878.3	878.53	874.98	875.45	16423.0
2009-01-07 04:00:00	ES	Futures	875.45	877.11	873.79	876.16	8457.0
2009-01-07 05:00:00	ES	Futures	876.16	878.77	875.45	877.82	5573.0
2009-01-07 06:00:00	ES	Futures	877.35	878.77	876.64	876.87	8245.0
2009-01-07 07:00:00	ES	Futures	876.87	877.35	874.5	875.21	12907.0
2009-01-07 08:00:00	ES	Futures	874.98	877.11	869.05	872.13	71069.0
2009-01-07 09:00:00	ES	Futures	871.89	872.84	866.44	870.94	256181.0
2009-01-07 10:00:00	ES	Futures	871.18	872.6	862.88	865.25	324639.0
2009-01-07 11:00:00	ES	Futures	865.49	871.42	864.07	870.23	216250.0
2009-01-07 12:00:00	ES	Futures	870.47	870.47	863.83	864.3	151387.0
2009-01-07 13:00:00	ES	Futures	864.3	867.62	859.8	860.03	185243.0
2009-01-07 14:00:00	ES	Futures	860.03	861.22	856.0	856.71	231735.0
2009-01-07 15:00:00	ES	Futures	856.71	858.85	852.68	857.9	365659.0
2009-01-07 16:00:00	ES	Futures	857.66	860.98	856.71	860.51	83831.0
2009-01-07 17:00:00	ES	Futures	860.51	860.98	859.8	859.8	2184.0
2009-01-07 18:00:00	ES	Futures	859.56	860.51	858.61	859.32	3122.0
2009-01-07 19:00:00	ES	Futures	859.32	860.51	858.61	858.61	1758.0
2009-01-07 20:00:00	ES	Futures	858.85	860.98	858.61	860.03	1296.0
2009-01-07 21:00:00	ES	Futures	860.03	860.27	858.14	860.03	1442.0
2009-01-07 22:00:00	ES	Futures	859.8	859.8	858.37	859.56	1212.0
2009-01-07 23:00:00	ES	Futures	859.8	859.8	857.43	857.66	1918.0
2009-01-07 00:00:00	NQ	Futures	1432.8	1433.36	1430.82	1431.95	14.0
2009-01-07 01:00:00	NQ	Futures	1431.67	1433.08	1428.0	1428.0	127.0
2009-01-07 02:00:00	NQ	Futures	1429.13	1429.98	1427.72	1429.13	95.0
2009-01-07 03:00:00	NQ	Futures	1429.41	1429.69	1424.05	1426.87	869.0
2009-01-07 04:00:00	NQ	Futures	1426.87	1429.69	1424.05	1428.28	430.0
2009-01-07 05:00:00	NQ	Futures	1428.56	1433.08	1427.15	1431.39	506.0
2009-01-07 06:00:00	NQ	Futures	1430.54	1433.08	1429.69	1429.98	444.0
2009-01-07 07:00:00	NQ	Futures	1429.69	1430.82	1424.33	1424.33	783.0
2009-01-07 08:00:00	NQ	Futures	1424.61	1427.43	1411.62	1417.83	6981.0
2009-01-07 09:00:00	NQ	Futures	1417.83	1419.81	1406.26	1416.42	44648.0
2009-01-07 10:00:00	NQ	Futures	1416.14	1417.55	1400.04	1406.82	48308.0
2009-01-07 11:00:00	NQ	Futures	1406.82	1418.12	1405.69	1416.14	29656.0
2009-01-07 12:00:00	NQ	Futures	1416.14	1416.14	1406.54	1407.95	23883.0
2009-01-07 13:00:00	NQ	Futures	1407.67	1413.88	1398.07	1398.35	27214.0
2009-01-07 14:00:00	NQ	Futures	1398.35	1400.89	1390.44	1394.11	35582.0
2009-01-07 15:00:00	NQ	Futures	1393.83	1399.2	1386.49	1398.07	49048.0
2009-01-07 16:00:00	NQ	Futures	1398.35	1402.58	1396.94	1401.74	8466.0
2009-01-07 17:00:00	NQ	Futures	1401.74	1403.43	1401.17	1401.17	517.0
2009-01-07 18:00:00	NQ	Futures	1401.17	1401.17	1398.35	1399.76	169.0
2009-01-07 19:00:00	NQ	Futures	1399.2	1400.61	1398.35	1399.48	59.0
2009-01-07 20:00:00	NQ	Futures	1398.63	1402.58	1398.35	1401.46	159.0
2009-01-07 21:00:00	NQ	Futures	1401.74	1402.3	1398.91	1401.74	107.0
2009-01-07 22:00:00	NQ	Futures	1401.17	1401.17	1398.91	1401.17	77.0
2009-01-07 23:00:00	NQ	Futures	1400.61	1400.61	1397.78	1398.63	19.0
2009-01-07 00:00:00	YM	Futures	8136.8	8143.1	8131.3	8131.3	93.0
2009-01-07 01:00:00	YM	Futures	8128.6	8137.7	8118.5	8118.5	184.0

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

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