PREVIEW / futures_1hour / 2009-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-02.parquet
  size:    45 KB
  rows:    1,296

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-02 00:00:00	ES	Futures	786.96	788.16	785.76	787.44	4235.0
2009-04-02 01:00:00	ES	Futures	787.68	788.63	785.52	786.0	4622.0
2009-04-02 02:00:00	ES	Futures	785.76	788.4	784.56	784.8	12297.0
2009-04-02 03:00:00	ES	Futures	785.04	790.55	784.32	790.31	28700.0
2009-04-02 04:00:00	ES	Futures	790.31	791.51	788.87	789.59	23528.0
2009-04-02 05:00:00	ES	Futures	789.59	794.15	789.35	793.67	24317.0
2009-04-02 06:00:00	ES	Futures	793.67	795.34	791.03	791.51	21186.0
2009-04-02 07:00:00	ES	Futures	791.51	792.23	786.24	790.07	46334.0
2009-04-02 08:00:00	ES	Futures	790.07	792.95	786.72	788.87	92459.0
2009-04-02 09:00:00	ES	Futures	788.87	795.34	788.4	795.1	272611.0
2009-04-02 10:00:00	ES	Futures	795.1	798.46	791.75	797.98	488352.0
2009-04-02 11:00:00	ES	Futures	797.74	803.97	797.5	801.81	379670.0
2009-04-02 12:00:00	ES	Futures	801.81	807.33	800.14	803.01	294459.0
2009-04-02 13:00:00	ES	Futures	803.25	803.97	796.78	798.46	279754.0
2009-04-02 14:00:00	ES	Futures	798.46	805.89	797.26	801.81	278677.0
2009-04-02 15:00:00	ES	Futures	801.58	803.73	791.99	795.58	537711.0
2009-04-02 16:00:00	ES	Futures	795.34	802.53	795.34	801.1	152632.0
2009-04-02 17:00:00	ES	Futures	801.1	802.29	800.86	802.05	2230.0
2009-04-02 18:00:00	ES	Futures	801.58	801.58	799.9	800.62	3750.0
2009-04-02 19:00:00	ES	Futures	800.86	801.34	799.42	800.38	3534.0
2009-04-02 20:00:00	ES	Futures	800.38	800.86	798.94	799.18	5655.0
2009-04-02 21:00:00	ES	Futures	799.18	799.42	798.22	798.22	4427.0
2009-04-02 22:00:00	ES	Futures	798.22	800.38	797.74	800.14	4284.0
2009-04-02 23:00:00	ES	Futures	800.14	800.62	797.74	800.38	2983.0
2009-04-02 00:00:00	NQ	Futures	1441.16	1442.29	1438.88	1441.73	208.0
2009-04-02 01:00:00	NQ	Futures	1441.73	1442.29	1438.32	1438.32	303.0
2009-04-02 02:00:00	NQ	Futures	1438.6	1442.29	1436.61	1437.18	502.0
2009-04-02 03:00:00	NQ	Futures	1436.9	1446.56	1435.47	1446.27	2781.0
2009-04-02 04:00:00	NQ	Futures	1446.56	1449.11	1445.42	1446.84	1879.0
2009-04-02 05:00:00	NQ	Futures	1446.56	1457.64	1446.27	1457.07	3387.0
2009-04-02 06:00:00	NQ	Futures	1457.35	1459.34	1451.67	1452.24	2592.0
2009-04-02 07:00:00	NQ	Futures	1452.24	1454.8	1445.42	1448.54	4677.0
2009-04-02 08:00:00	NQ	Futures	1448.54	1452.52	1441.16	1444.85	11178.0
2009-04-02 09:00:00	NQ	Futures	1444.85	1458.77	1441.16	1458.49	51876.0
2009-04-02 10:00:00	NQ	Futures	1458.21	1472.13	1455.93	1471.28	71743.0
2009-04-02 11:00:00	NQ	Futures	1471.28	1482.36	1470.71	1479.23	56395.0
2009-04-02 12:00:00	NQ	Futures	1479.52	1489.75	1476.96	1482.07	39288.0
2009-04-02 13:00:00	NQ	Futures	1482.07	1482.93	1467.01	1473.55	52205.0
2009-04-02 14:00:00	NQ	Futures	1473.83	1486.05	1471.56	1478.95	37286.0
2009-04-02 15:00:00	NQ	Futures	1478.95	1482.64	1458.77	1467.01	69778.0
2009-04-02 16:00:00	NQ	Futures	1466.45	1482.93	1465.59	1480.94	20868.0
2009-04-02 17:00:00	NQ	Futures	1481.22	1482.93	1480.37	1482.93	610.0
2009-04-02 18:00:00	NQ	Futures	1481.22	1482.07	1479.23	1481.22	855.0
2009-04-02 19:00:00	NQ	Futures	1480.94	1482.64	1479.52	1480.94	175.0
2009-04-02 20:00:00	NQ	Futures	1480.65	1482.36	1478.38	1478.66	386.0
2009-04-02 21:00:00	NQ	Futures	1478.66	1479.23	1476.67	1476.67	213.0
2009-04-02 22:00:00	NQ	Futures	1476.96	1479.23	1475.54	1478.95	280.0
2009-04-02 23:00:00	NQ	Futures	1478.38	1479.8	1474.97	1477.24	269.0
2009-04-02 00:00:00	YM	Futures	7181.6	7189.9	7172.4	7187.1	233.0
2009-04-02 01:00:00	YM	Futures	7186.2	7193.5	7170.6	7170.6	346.0

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

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