PREVIEW / futures_1hour / 2009-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-12.parquet
  size:    44 KB
  rows:    1,273

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-05-12 00:00:00	ES	Futures	867.23	867.95	866.52	866.76	3221.0
2009-05-12 01:00:00	ES	Futures	866.76	867.71	866.04	867.0	2061.0
2009-05-12 02:00:00	ES	Futures	867.0	868.67	866.28	867.71	8607.0
2009-05-12 03:00:00	ES	Futures	867.71	872.99	867.0	872.75	21653.0
2009-05-12 04:00:00	ES	Futures	872.75	876.82	872.27	874.18	24032.0
2009-05-12 05:00:00	ES	Futures	874.42	877.3	873.94	874.9	13271.0
2009-05-12 06:00:00	ES	Futures	874.9	875.38	870.59	870.83	14175.0
2009-05-12 07:00:00	ES	Futures	870.83	874.42	870.35	874.18	17040.0
2009-05-12 08:00:00	ES	Futures	874.18	876.58	874.18	874.9	30970.0
2009-05-12 09:00:00	ES	Futures	874.9	875.62	866.04	868.19	323659.0
2009-05-12 10:00:00	ES	Futures	868.19	868.43	861.96	866.04	420075.0
2009-05-12 11:00:00	ES	Futures	866.28	867.0	861.48	862.68	273932.0
2009-05-12 12:00:00	ES	Futures	862.92	863.88	856.93	857.41	269837.0
2009-05-12 13:00:00	ES	Futures	857.17	861.72	856.93	859.81	168620.0
2009-05-12 14:00:00	ES	Futures	859.81	870.11	859.09	869.15	364294.0
2009-05-12 15:00:00	ES	Futures	868.91	874.42	866.28	867.95	450961.0
2009-05-12 16:00:00	ES	Futures	868.19	871.31	865.8	870.35	90825.0
2009-05-12 17:00:00	ES	Futures	870.59	872.03	870.35	871.55	3134.0
2009-05-12 18:00:00	ES	Futures	871.55	871.79	870.11	870.35	3132.0
2009-05-12 19:00:00	ES	Futures	870.35	870.59	868.91	869.87	2421.0
2009-05-12 20:00:00	ES	Futures	870.11	871.07	868.91	868.91	4342.0
2009-05-12 21:00:00	ES	Futures	868.91	869.63	865.32	867.23	9196.0
2009-05-12 22:00:00	ES	Futures	867.23	871.07	866.76	870.59	5782.0
2009-05-12 23:00:00	ES	Futures	870.59	872.99	870.35	872.27	5576.0
2009-05-12 00:00:00	NQ	Futures	1580.39	1582.37	1580.1	1581.81	94.0
2009-05-12 01:00:00	NQ	Futures	1580.95	1582.66	1579.25	1580.1	101.0
2009-05-12 02:00:00	NQ	Futures	1582.09	1583.23	1580.1	1582.66	410.0
2009-05-12 03:00:00	NQ	Futures	1582.37	1590.05	1580.39	1590.05	1760.0
2009-05-12 04:00:00	NQ	Futures	1590.05	1597.72	1588.91	1594.88	2622.0
2009-05-12 05:00:00	NQ	Futures	1595.16	1598.57	1593.46	1593.74	904.0
2009-05-12 06:00:00	NQ	Futures	1593.46	1593.46	1584.65	1585.22	1141.0
2009-05-12 07:00:00	NQ	Futures	1585.5	1593.46	1584.08	1593.17	1828.0
2009-05-12 08:00:00	NQ	Futures	1592.89	1597.43	1592.89	1594.02	4041.0
2009-05-12 09:00:00	NQ	Futures	1593.74	1594.02	1565.04	1569.87	54997.0
2009-05-12 10:00:00	NQ	Futures	1570.16	1572.43	1559.36	1565.61	58886.0
2009-05-12 11:00:00	NQ	Futures	1565.89	1567.32	1554.53	1556.23	37437.0
2009-05-12 12:00:00	NQ	Futures	1556.23	1557.37	1546.57	1547.14	52615.0
2009-05-12 13:00:00	NQ	Futures	1546.86	1557.37	1546.86	1553.68	28020.0
2009-05-12 14:00:00	NQ	Futures	1553.39	1566.46	1551.97	1563.91	41966.0
2009-05-12 15:00:00	NQ	Futures	1564.19	1574.42	1559.93	1565.33	61865.0
2009-05-12 16:00:00	NQ	Futures	1565.04	1576.69	1562.2	1574.13	17680.0
2009-05-12 17:00:00	NQ	Futures	1574.13	1576.98	1574.13	1576.41	296.0
2009-05-12 18:00:00	NQ	Futures	1576.41	1576.41	1574.13	1574.7	618.0
2009-05-12 19:00:00	NQ	Futures	1574.99	1575.56	1571.86	1574.99	222.0
2009-05-12 20:00:00	NQ	Futures	1574.99	1578.11	1573.85	1574.13	431.0
2009-05-12 21:00:00	NQ	Futures	1573.85	1574.13	1565.33	1569.3	831.0
2009-05-12 22:00:00	NQ	Futures	1569.3	1575.56	1568.45	1574.7	500.0
2009-05-12 23:00:00	NQ	Futures	1574.42	1579.25	1573.85	1577.83	233.0
2009-05-12 00:00:00	YM	Futures	7692.5	7699.0	7688.8	7688.8	175.0
2009-05-12 01:00:00	YM	Futures	7689.8	7696.2	7683.3	7693.4	121.0

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

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