PREVIEW / futures_1hour / 2009-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-28.parquet
  size:    42 KB
  rows:    1,242

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-28 00:00:00	ES	Futures	814.75	814.99	808.76	809.24	10190.0
2009-04-28 01:00:00	ES	Futures	809.48	811.88	808.28	809.72	5745.0
2009-04-28 02:00:00	ES	Futures	809.72	811.16	803.73	805.17	24359.0
2009-04-28 03:00:00	ES	Futures	805.17	809.0	803.97	807.33	30159.0
2009-04-28 04:00:00	ES	Futures	807.57	809.0	805.89	808.05	17223.0
2009-04-28 05:00:00	ES	Futures	808.05	808.76	805.89	807.09	10274.0
2009-04-28 06:00:00	ES	Futures	806.85	807.81	805.65	807.09	12256.0
2009-04-28 07:00:00	ES	Futures	807.33	808.28	806.13	807.57	21519.0
2009-04-28 08:00:00	ES	Futures	807.81	811.16	806.13	809.96	50761.0
2009-04-28 09:00:00	ES	Futures	809.96	814.52	806.37	814.52	301211.0
2009-04-28 10:00:00	ES	Futures	814.52	822.9	814.52	819.79	445733.0
2009-04-28 11:00:00	ES	Futures	819.79	820.99	815.95	817.63	211696.0
2009-04-28 12:00:00	ES	Futures	817.63	821.46	817.39	820.75	114819.0
2009-04-28 13:00:00	ES	Futures	820.51	822.42	817.15	818.83	228783.0
2009-04-28 14:00:00	ES	Futures	819.07	825.78	818.59	822.18	242539.0
2009-04-28 15:00:00	ES	Futures	822.18	824.34	815.23	815.71	358634.0
2009-04-28 16:00:00	ES	Futures	815.95	817.87	814.04	814.52	101916.0
2009-04-28 17:00:00	ES	Futures	814.52	815.47	814.04	814.75	1798.0
2009-04-28 18:00:00	ES	Futures	814.75	815.23	814.04	815.23	1712.0
2009-04-28 19:00:00	ES	Futures	815.23	816.19	814.99	815.47	1309.0
2009-04-28 20:00:00	ES	Futures	815.47	821.46	815.23	821.23	7397.0
2009-04-28 21:00:00	ES	Futures	820.99	821.23	817.87	818.35	3598.0
2009-04-28 22:00:00	ES	Futures	818.59	819.79	816.43	818.83	3851.0
2009-04-28 23:00:00	ES	Futures	819.07	822.18	817.87	820.99	4174.0
2009-04-28 00:00:00	NQ	Futures	1552.26	1552.26	1541.46	1542.31	713.0
2009-04-28 01:00:00	NQ	Futures	1542.6	1547.71	1541.74	1544.3	333.0
2009-04-28 02:00:00	NQ	Futures	1544.3	1546.29	1536.34	1537.2	1322.0
2009-04-28 03:00:00	NQ	Futures	1537.48	1544.02	1535.49	1540.61	2189.0
2009-04-28 04:00:00	NQ	Futures	1540.61	1542.6	1536.91	1540.32	1388.0
2009-04-28 05:00:00	NQ	Futures	1540.89	1541.74	1538.33	1540.61	621.0
2009-04-28 06:00:00	NQ	Futures	1540.32	1541.17	1537.48	1539.75	965.0
2009-04-28 07:00:00	NQ	Futures	1539.47	1542.31	1538.05	1542.03	1456.0
2009-04-28 08:00:00	NQ	Futures	1542.31	1548.85	1540.04	1546.57	5894.0
2009-04-28 09:00:00	NQ	Futures	1546.57	1552.54	1539.19	1551.97	39271.0
2009-04-28 10:00:00	NQ	Futures	1551.97	1565.61	1551.4	1560.78	49167.0
2009-04-28 11:00:00	NQ	Futures	1560.78	1562.2	1553.39	1555.95	23811.0
2009-04-28 12:00:00	NQ	Futures	1555.67	1563.05	1555.67	1560.21	19532.0
2009-04-28 13:00:00	NQ	Futures	1560.21	1562.48	1546.86	1547.71	28070.0
2009-04-28 14:00:00	NQ	Futures	1547.99	1561.92	1547.43	1556.23	35190.0
2009-04-28 15:00:00	NQ	Futures	1556.23	1559.93	1544.3	1544.87	41682.0
2009-04-28 16:00:00	NQ	Futures	1544.87	1549.7	1541.46	1541.46	10029.0
2009-04-28 17:00:00	NQ	Futures	1541.46	1543.16	1540.61	1541.46	245.0
2009-04-28 18:00:00	NQ	Futures	1541.46	1542.88	1540.04	1542.03	205.0
2009-04-28 19:00:00	NQ	Futures	1542.6	1544.3	1542.31	1543.16	82.0
2009-04-28 20:00:00	NQ	Futures	1543.16	1553.68	1543.16	1552.82	272.0
2009-04-28 21:00:00	NQ	Futures	1552.82	1553.11	1547.99	1549.13	105.0
2009-04-28 22:00:00	NQ	Futures	1549.13	1551.4	1546.0	1549.7	167.0
2009-04-28 23:00:00	NQ	Futures	1549.7	1554.81	1549.7	1554.24	167.0
2009-04-28 00:00:00	YM	Futures	7302.9	7302.9	7256.0	7261.5	745.0
2009-04-28 01:00:00	YM	Futures	7263.4	7284.5	7255.1	7268.9	833.0

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

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