PREVIEW / futures_1hour / 2009-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-07.parquet
  size:    44 KB
  rows:    1,278

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-04-07 00:00:00	ES	Futures	795.34	798.7	794.63	798.22	4604.0
2009-04-07 01:00:00	ES	Futures	798.46	798.94	794.87	795.1	3270.0
2009-04-07 02:00:00	ES	Futures	795.1	797.98	794.15	796.78	5626.0
2009-04-07 03:00:00	ES	Futures	796.54	798.46	792.71	794.15	16377.0
2009-04-07 04:00:00	ES	Futures	794.15	794.39	785.04	786.0	33240.0
2009-04-07 05:00:00	ES	Futures	786.0	788.4	785.52	787.44	17165.0
2009-04-07 06:00:00	ES	Futures	787.44	788.4	781.93	782.64	29599.0
2009-04-07 07:00:00	ES	Futures	782.4	784.8	779.77	781.69	29270.0
2009-04-07 08:00:00	ES	Futures	781.69	784.8	781.45	783.12	30676.0
2009-04-07 09:00:00	ES	Futures	783.36	784.56	778.57	781.45	253320.0
2009-04-07 10:00:00	ES	Futures	781.45	788.16	779.29	785.76	372715.0
2009-04-07 11:00:00	ES	Futures	786.0	787.44	782.4	783.12	219640.0
2009-04-07 12:00:00	ES	Futures	783.12	786.48	782.16	785.04	197168.0
2009-04-07 13:00:00	ES	Futures	784.8	785.28	777.61	779.29	208176.0
2009-04-07 14:00:00	ES	Futures	779.29	780.73	777.13	780.49	184757.0
2009-04-07 15:00:00	ES	Futures	780.25	785.52	777.61	778.09	356994.0
2009-04-07 16:00:00	ES	Futures	777.85	782.16	777.61	779.29	119991.0
2009-04-07 17:00:00	ES	Futures	779.53	780.73	779.05	780.73	3850.0
2009-04-07 18:00:00	ES	Futures	780.49	780.73	779.77	780.73	2299.0
2009-04-07 19:00:00	ES	Futures	780.49	782.16	780.25	781.45	2200.0
2009-04-07 20:00:00	ES	Futures	781.45	782.16	777.61	777.85	7491.0
2009-04-07 21:00:00	ES	Futures	777.85	779.05	776.41	776.65	6950.0
2009-04-07 22:00:00	ES	Futures	776.65	776.89	769.7	772.1	17406.0
2009-04-07 23:00:00	ES	Futures	772.1	772.82	769.22	770.18	5097.0
2009-04-07 00:00:00	NQ	Futures	1491.17	1497.13	1490.03	1496.85	247.0
2009-04-07 01:00:00	NQ	Futures	1496.85	1497.13	1490.6	1492.02	228.0
2009-04-07 02:00:00	NQ	Futures	1492.3	1495.71	1490.03	1493.72	316.0
2009-04-07 03:00:00	NQ	Futures	1493.72	1496.56	1487.47	1489.46	1016.0
2009-04-07 04:00:00	NQ	Futures	1488.89	1490.03	1472.13	1474.69	2129.0
2009-04-07 05:00:00	NQ	Futures	1474.4	1477.24	1473.83	1475.54	1283.0
2009-04-07 06:00:00	NQ	Futures	1475.25	1476.67	1466.45	1467.3	1778.0
2009-04-07 07:00:00	NQ	Futures	1467.58	1472.98	1465.59	1467.58	2597.0
2009-04-07 08:00:00	NQ	Futures	1467.87	1476.11	1467.87	1472.98	3572.0
2009-04-07 09:00:00	NQ	Futures	1473.27	1474.12	1454.8	1459.63	45414.0
2009-04-07 10:00:00	NQ	Futures	1459.34	1469.29	1454.8	1465.03	45485.0
2009-04-07 11:00:00	NQ	Futures	1465.31	1466.73	1456.5	1458.77	31962.0
2009-04-07 12:00:00	NQ	Futures	1458.77	1462.47	1456.5	1459.91	28078.0
2009-04-07 13:00:00	NQ	Futures	1459.63	1459.91	1439.74	1446.27	46482.0
2009-04-07 14:00:00	NQ	Futures	1446.27	1448.26	1441.73	1447.69	26916.0
2009-04-07 15:00:00	NQ	Futures	1447.41	1458.49	1443.43	1449.11	56147.0
2009-04-07 16:00:00	NQ	Futures	1449.11	1460.76	1449.11	1456.5	15165.0
2009-04-07 17:00:00	NQ	Futures	1456.5	1458.77	1455.36	1457.35	313.0
2009-04-07 18:00:00	NQ	Futures	1458.21	1458.49	1455.93	1457.64	181.0
2009-04-07 19:00:00	NQ	Futures	1457.64	1459.91	1457.07	1459.06	201.0
2009-04-07 20:00:00	NQ	Futures	1459.06	1460.48	1452.52	1453.09	643.0
2009-04-07 21:00:00	NQ	Futures	1453.66	1455.93	1452.52	1452.81	423.0
2009-04-07 22:00:00	NQ	Futures	1452.24	1452.24	1442.01	1444.85	1107.0
2009-04-07 23:00:00	NQ	Futures	1445.14	1445.7	1440.02	1442.29	448.0
2009-04-07 00:00:00	YM	Futures	7265.2	7294.6	7260.6	7291.9	346.0
2009-04-07 01:00:00	YM	Futures	7291.9	7292.8	7260.6	7265.2	226.0

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

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