PREVIEW / futures_1hour / 2009-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-13.parquet
  size:    35 KB
  rows:    1,009

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-13 00:00:00	ES	Futures	813.8	813.8	812.36	812.84	1288.0
2009-04-13 01:00:00	ES	Futures	812.84	813.08	811.4	811.4	1164.0
2009-04-13 02:00:00	ES	Futures	811.4	811.64	810.44	811.16	1368.0
2009-04-13 03:00:00	ES	Futures	811.4	812.12	810.68	811.64	1182.0
2009-04-13 04:00:00	ES	Futures	811.4	811.88	810.68	810.68	636.0
2009-04-13 05:00:00	ES	Futures	810.92	811.16	809.48	809.72	1540.0
2009-04-13 06:00:00	ES	Futures	809.72	811.4	809.48	810.92	1585.0
2009-04-13 07:00:00	ES	Futures	810.92	812.6	809.72	810.2	4432.0
2009-04-13 08:00:00	ES	Futures	810.2	813.08	810.2	812.12	9514.0
2009-04-13 09:00:00	ES	Futures	812.36	812.36	806.61	807.57	178737.0
2009-04-13 10:00:00	ES	Futures	807.57	815.47	807.33	811.4	289474.0
2009-04-13 11:00:00	ES	Futures	811.4	812.84	808.28	810.2	159540.0
2009-04-13 12:00:00	ES	Futures	810.2	814.99	809.96	814.52	86380.0
2009-04-13 13:00:00	ES	Futures	814.52	818.59	812.12	818.59	145238.0
2009-04-13 14:00:00	ES	Futures	818.35	819.31	814.99	815.71	196573.0
2009-04-13 15:00:00	ES	Futures	815.95	825.54	814.28	818.59	409153.0
2009-04-13 16:00:00	ES	Futures	818.35	821.46	817.15	819.55	137798.0
2009-04-13 17:00:00	ES	Futures	819.55	819.55	818.35	818.83	1271.0
2009-04-13 18:00:00	ES	Futures	818.11	818.59	816.91	816.91	2827.0
2009-04-13 19:00:00	ES	Futures	816.91	818.35	816.19	817.87	2498.0
2009-04-13 20:00:00	ES	Futures	817.87	818.11	813.8	814.04	5781.0
2009-04-13 21:00:00	ES	Futures	813.8	814.52	812.84	813.56	4622.0
2009-04-13 22:00:00	ES	Futures	813.56	814.75	809.0	811.16	11478.0
2009-04-13 23:00:00	ES	Futures	811.16	812.84	810.2	810.68	3843.0
2009-04-13 00:00:00	NQ	Futures	1515.89	1516.74	1512.76	1513.33	303.0
2009-04-13 01:00:00	NQ	Futures	1513.9	1513.9	1511.06	1511.62	245.0
2009-04-13 02:00:00	NQ	Futures	1511.06	1511.34	1509.92	1511.06	118.0
2009-04-13 03:00:00	NQ	Futures	1511.06	1512.19	1510.49	1512.19	171.0
2009-04-13 04:00:00	NQ	Futures	1512.48	1512.76	1510.49	1511.06	251.0
2009-04-13 05:00:00	NQ	Futures	1511.06	1512.19	1506.79	1507.08	563.0
2009-04-13 06:00:00	NQ	Futures	1506.79	1512.76	1506.79	1511.62	448.0
2009-04-13 07:00:00	NQ	Futures	1512.19	1513.9	1509.35	1509.35	699.0
2009-04-13 08:00:00	NQ	Futures	1509.63	1515.89	1509.35	1513.33	1624.0
2009-04-13 09:00:00	NQ	Futures	1513.33	1517.59	1507.93	1510.2	24755.0
2009-04-13 10:00:00	NQ	Futures	1510.49	1517.31	1506.23	1507.08	29744.0
2009-04-13 11:00:00	NQ	Futures	1506.79	1509.63	1501.96	1506.79	23888.0
2009-04-13 12:00:00	NQ	Futures	1506.79	1513.04	1506.51	1512.19	11602.0
2009-04-13 13:00:00	NQ	Futures	1512.19	1517.88	1509.07	1517.02	18437.0
2009-04-13 14:00:00	NQ	Futures	1517.31	1518.16	1510.49	1513.04	22196.0
2009-04-13 15:00:00	NQ	Futures	1513.04	1526.97	1511.06	1518.16	44949.0
2009-04-13 16:00:00	NQ	Futures	1518.44	1519.58	1513.04	1517.31	8695.0
2009-04-13 17:00:00	NQ	Futures	1517.31	1517.88	1515.89	1516.45	92.0
2009-04-13 18:00:00	NQ	Futures	1515.89	1517.31	1513.33	1514.47	168.0
2009-04-13 19:00:00	NQ	Futures	1514.18	1515.89	1514.18	1515.6	65.0
2009-04-13 20:00:00	NQ	Futures	1515.03	1515.03	1508.5	1508.5	285.0
2009-04-13 21:00:00	NQ	Futures	1508.78	1508.78	1505.37	1507.08	486.0
2009-04-13 22:00:00	NQ	Futures	1507.08	1508.21	1499.97	1502.82	652.0
2009-04-13 23:00:00	NQ	Futures	1502.82	1505.37	1500.26	1501.11	479.0
2009-04-13 00:00:00	YM	Futures	7340.6	7341.5	7331.4	7333.2	76.0
2009-04-13 01:00:00	YM	Futures	7336.0	7336.9	7322.2	7324.0	99.0

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

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