PREVIEW / futures_1hour / 2009-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-09.parquet
  size:    36 KB
  rows:    1,010

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-09 00:00:00	ES	Futures	794.15	797.74	793.67	796.54	8328.0
2009-04-09 01:00:00	ES	Futures	796.54	797.74	796.06	796.78	4238.0
2009-04-09 02:00:00	ES	Futures	796.78	797.74	795.82	796.06	6472.0
2009-04-09 03:00:00	ES	Futures	796.3	796.3	792.71	794.87	20757.0
2009-04-09 04:00:00	ES	Futures	794.87	795.34	790.79	793.67	17167.0
2009-04-09 05:00:00	ES	Futures	793.43	797.26	792.95	796.06	12395.0
2009-04-09 06:00:00	ES	Futures	796.06	796.3	793.67	794.15	12161.0
2009-04-09 07:00:00	ES	Futures	794.39	794.87	791.27	792.23	14597.0
2009-04-09 08:00:00	ES	Futures	792.47	809.24	792.23	807.09	150226.0
2009-04-09 09:00:00	ES	Futures	806.85	811.64	804.21	810.92	284644.0
2009-04-09 10:00:00	ES	Futures	810.92	812.6	807.81	808.76	296403.0
2009-04-09 11:00:00	ES	Futures	809.0	810.44	805.17	808.05	170738.0
2009-04-09 12:00:00	ES	Futures	808.05	809.96	806.13	808.52	148350.0
2009-04-09 13:00:00	ES	Futures	808.76	811.64	808.28	811.64	135569.0
2009-04-09 14:00:00	ES	Futures	811.4	815.71	808.05	813.8	275184.0
2009-04-09 15:00:00	ES	Futures	813.8	818.83	812.36	818.59	367345.0
2009-04-09 16:00:00	ES	Futures	818.59	819.07	816.91	817.39	125053.0
2009-04-09 00:00:00	NQ	Futures	1484.91	1490.88	1484.63	1489.46	312.0
2009-04-09 01:00:00	NQ	Futures	1489.46	1491.45	1488.89	1489.46	289.0
2009-04-09 02:00:00	NQ	Futures	1489.46	1492.3	1488.61	1488.61	401.0
2009-04-09 03:00:00	NQ	Futures	1488.89	1488.89	1482.64	1487.19	1124.0
2009-04-09 04:00:00	NQ	Futures	1486.9	1488.32	1480.65	1485.48	1212.0
2009-04-09 05:00:00	NQ	Futures	1485.48	1490.88	1484.35	1489.75	1214.0
2009-04-09 06:00:00	NQ	Futures	1489.75	1489.75	1484.91	1486.05	879.0
2009-04-09 07:00:00	NQ	Futures	1486.34	1487.76	1478.38	1482.64	2085.0
2009-04-09 08:00:00	NQ	Futures	1482.36	1504.52	1482.36	1501.96	13815.0
2009-04-09 09:00:00	NQ	Futures	1501.68	1521.28	1497.13	1519.86	55678.0
2009-04-09 10:00:00	NQ	Futures	1520.15	1523.27	1513.33	1513.9	40654.0
2009-04-09 11:00:00	NQ	Futures	1513.9	1518.44	1509.92	1516.74	24812.0
2009-04-09 12:00:00	NQ	Futures	1516.74	1518.44	1513.04	1516.74	17969.0
2009-04-09 13:00:00	NQ	Futures	1516.45	1521.85	1516.45	1521.0	17658.0
2009-04-09 14:00:00	NQ	Futures	1521.28	1524.41	1516.17	1521.85	27310.0
2009-04-09 15:00:00	NQ	Futures	1521.85	1523.56	1515.03	1521.28	44463.0
2009-04-09 16:00:00	NQ	Futures	1521.0	1523.84	1515.6	1519.58	16324.0
2009-04-09 00:00:00	YM	Futures	7209.2	7235.8	7203.6	7227.5	448.0
2009-04-09 01:00:00	YM	Futures	7225.7	7234.0	7223.9	7226.6	229.0
2009-04-09 02:00:00	YM	Futures	7226.6	7237.6	7223.9	7224.8	378.0
2009-04-09 03:00:00	YM	Futures	7224.8	7230.3	7200.0	7214.7	1808.0
2009-04-09 04:00:00	YM	Futures	7215.6	7220.2	7187.1	7205.5	1125.0
2009-04-09 05:00:00	YM	Futures	7204.6	7233.0	7200.9	7223.9	728.0
2009-04-09 06:00:00	YM	Futures	7225.7	7225.7	7205.5	7209.2	760.0
2009-04-09 07:00:00	YM	Futures	7209.2	7214.7	7189.9	7196.3	718.0
2009-04-09 08:00:00	YM	Futures	7197.2	7311.2	7197.2	7296.5	9098.0
2009-04-09 09:00:00	YM	Futures	7296.5	7339.6	7277.2	7334.1	21947.0
2009-04-09 10:00:00	YM	Futures	7335.1	7349.8	7313.9	7322.2	25028.0
2009-04-09 11:00:00	YM	Futures	7321.3	7336.0	7285.4	7313.0	15187.0
2009-04-09 12:00:00	YM	Futures	7313.0	7332.3	7302.9	7318.5	13045.0
2009-04-09 13:00:00	YM	Futures	7319.4	7347.0	7317.6	7343.3	10961.0
2009-04-09 14:00:00	YM	Futures	7343.3	7380.1	7313.9	7365.4	25407.0
2009-04-09 15:00:00	YM	Futures	7365.4	7385.6	7347.0	7383.8	23666.0

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

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