PREVIEW / futures_1hour / 2009-04-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	820.75	821.23	818.11	819.55	2747.0
2009-04-29 01:00:00	ES	Futures	819.55	820.51	818.35	820.51	1918.0
2009-04-29 02:00:00	ES	Futures	820.51	823.62	818.83	821.46	9798.0
2009-04-29 03:00:00	ES	Futures	821.46	823.38	820.27	821.7	20762.0
2009-04-29 04:00:00	ES	Futures	821.94	823.38	820.75	821.46	9135.0
2009-04-29 05:00:00	ES	Futures	821.7	827.46	821.7	826.74	21330.0
2009-04-29 06:00:00	ES	Futures	826.74	826.98	824.1	824.34	17542.0
2009-04-29 07:00:00	ES	Futures	824.34	825.06	822.42	824.58	17191.0
2009-04-29 08:00:00	ES	Futures	824.58	827.22	820.99	824.1	73370.0
2009-04-29 09:00:00	ES	Futures	824.1	828.89	821.7	828.41	246980.0
2009-04-29 10:00:00	ES	Futures	828.65	834.88	826.74	833.21	370499.0
2009-04-29 11:00:00	ES	Futures	833.45	835.6	831.77	833.21	183370.0
2009-04-29 12:00:00	ES	Futures	832.97	834.17	831.77	833.21	108009.0
2009-04-29 13:00:00	ES	Futures	833.21	838.24	832.97	836.08	126261.0
2009-04-29 14:00:00	ES	Futures	836.08	842.79	833.45	837.52	482676.0
2009-04-29 15:00:00	ES	Futures	837.52	838.96	827.93	833.69	586822.0
2009-04-29 16:00:00	ES	Futures	833.69	834.64	831.29	832.97	110791.0
2009-04-29 17:00:00	ES	Futures	832.97	834.17	832.73	833.69	2162.0
2009-04-29 18:00:00	ES	Futures	833.69	833.93	830.33	830.81	5509.0
2009-04-29 19:00:00	ES	Futures	830.81	831.77	830.57	831.29	2407.0
2009-04-29 20:00:00	ES	Futures	831.53	836.8	830.81	836.32	6655.0
2009-04-29 21:00:00	ES	Futures	836.32	840.16	835.6	839.92	9169.0
2009-04-29 22:00:00	ES	Futures	839.68	840.16	838.0	838.72	4590.0
2009-04-29 23:00:00	ES	Futures	838.48	839.2	837.52	837.76	3620.0
2009-04-29 00:00:00	NQ	Futures	1552.54	1552.82	1548.56	1549.98	87.0
2009-04-29 01:00:00	NQ	Futures	1550.27	1553.39	1548.56	1552.26	96.0
2009-04-29 02:00:00	NQ	Futures	1553.11	1557.65	1551.12	1554.81	653.0
2009-04-29 03:00:00	NQ	Futures	1554.53	1558.79	1551.97	1553.68	1173.0
2009-04-29 04:00:00	NQ	Futures	1553.96	1558.22	1552.26	1553.68	754.0
2009-04-29 05:00:00	NQ	Futures	1553.68	1563.91	1553.68	1562.77	1845.0
2009-04-29 06:00:00	NQ	Futures	1562.77	1563.34	1559.36	1560.21	1083.0
2009-04-29 07:00:00	NQ	Futures	1560.21	1560.78	1557.09	1559.64	1405.0
2009-04-29 08:00:00	NQ	Futures	1559.36	1562.77	1551.4	1558.22	7481.0
2009-04-29 09:00:00	NQ	Futures	1558.22	1565.89	1555.1	1565.89	35129.0
2009-04-29 10:00:00	NQ	Futures	1565.89	1576.98	1562.77	1574.99	46320.0
2009-04-29 11:00:00	NQ	Futures	1574.7	1581.52	1570.44	1576.98	35378.0
2009-04-29 12:00:00	NQ	Futures	1576.98	1578.68	1573.28	1574.7	16349.0
2009-04-29 13:00:00	NQ	Futures	1574.99	1581.81	1574.42	1576.69	16629.0
2009-04-29 14:00:00	NQ	Futures	1576.69	1588.06	1572.43	1580.67	54848.0
2009-04-29 15:00:00	NQ	Futures	1580.67	1582.66	1561.35	1566.46	58404.0
2009-04-29 16:00:00	NQ	Futures	1566.75	1571.29	1564.19	1567.32	10104.0
2009-04-29 17:00:00	NQ	Futures	1567.32	1569.02	1566.75	1567.88	160.0
2009-04-29 18:00:00	NQ	Futures	1568.45	1570.16	1564.47	1564.76	397.0
2009-04-29 19:00:00	NQ	Futures	1565.04	1566.75	1564.76	1565.89	113.0
2009-04-29 20:00:00	NQ	Futures	1565.89	1574.7	1565.04	1574.42	351.0
2009-04-29 21:00:00	NQ	Futures	1574.13	1578.68	1572.71	1578.4	429.0
2009-04-29 22:00:00	NQ	Futures	1578.4	1578.4	1574.7	1576.69	268.0
2009-04-29 23:00:00	NQ	Futures	1576.12	1577.54	1575.27	1575.27	150.0
2009-04-29 00:00:00	YM	Futures	7358.9	7358.9	7336.0	7344.2	283.0
2009-04-29 01:00:00	YM	Futures	7349.8	7355.3	7338.7	7354.4	176.0

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

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