PREVIEW / futures_1hour / 2009-04-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	799.42	801.1	798.94	799.9	3766.0
2009-04-15 01:00:00	ES	Futures	799.9	800.38	798.94	799.66	2879.0
2009-04-15 02:00:00	ES	Futures	799.66	800.86	798.94	800.62	6393.0
2009-04-15 03:00:00	ES	Futures	800.62	804.69	798.22	804.21	32807.0
2009-04-15 04:00:00	ES	Futures	804.21	808.28	803.73	807.57	20182.0
2009-04-15 05:00:00	ES	Futures	807.81	808.28	803.97	804.45	13339.0
2009-04-15 06:00:00	ES	Futures	804.45	807.09	804.21	806.61	11111.0
2009-04-15 07:00:00	ES	Futures	806.61	808.52	802.53	802.77	23721.0
2009-04-15 08:00:00	ES	Futures	803.01	804.93	800.14	801.34	43685.0
2009-04-15 09:00:00	ES	Futures	801.34	803.97	797.02	803.73	239009.0
2009-04-15 10:00:00	ES	Futures	803.49	806.85	800.38	800.86	319248.0
2009-04-15 11:00:00	ES	Futures	800.62	805.89	798.94	804.93	230104.0
2009-04-15 12:00:00	ES	Futures	805.17	808.52	804.21	808.28	142443.0
2009-04-15 13:00:00	ES	Futures	808.28	809.48	802.53	804.45	193070.0
2009-04-15 14:00:00	ES	Futures	804.45	807.33	799.66	800.86	311478.0
2009-04-15 15:00:00	ES	Futures	800.86	814.75	800.86	813.32	440224.0
2009-04-15 16:00:00	ES	Futures	813.32	815.23	812.36	814.04	106179.0
2009-04-15 17:00:00	ES	Futures	814.04	814.28	813.32	814.04	2102.0
2009-04-15 18:00:00	ES	Futures	814.28	814.52	813.08	813.56	2408.0
2009-04-15 19:00:00	ES	Futures	813.56	813.8	812.84	813.56	1540.0
2009-04-15 20:00:00	ES	Futures	813.56	820.27	813.32	818.35	11226.0
2009-04-15 21:00:00	ES	Futures	818.59	820.03	817.63	819.07	4593.0
2009-04-15 22:00:00	ES	Futures	819.07	819.07	810.44	811.16	18778.0
2009-04-15 23:00:00	ES	Futures	811.16	815.95	810.2	812.84	6910.0
2009-04-15 00:00:00	NQ	Futures	1484.63	1486.62	1483.49	1485.2	220.0
2009-04-15 01:00:00	NQ	Futures	1484.91	1486.9	1483.49	1486.05	293.0
2009-04-15 02:00:00	NQ	Futures	1486.05	1487.76	1484.63	1487.47	465.0
2009-04-15 03:00:00	NQ	Futures	1486.9	1496.28	1483.78	1495.43	1951.0
2009-04-15 04:00:00	NQ	Futures	1495.71	1500.26	1494.29	1499.69	1299.0
2009-04-15 05:00:00	NQ	Futures	1499.97	1499.97	1493.15	1493.72	809.0
2009-04-15 06:00:00	NQ	Futures	1494.58	1498.55	1493.44	1497.7	641.0
2009-04-15 07:00:00	NQ	Futures	1497.99	1500.26	1491.45	1491.73	1844.0
2009-04-15 08:00:00	NQ	Futures	1491.73	1496.0	1489.18	1491.45	4924.0
2009-04-15 09:00:00	NQ	Futures	1491.45	1494.01	1481.22	1486.9	43021.0
2009-04-15 10:00:00	NQ	Futures	1486.9	1495.14	1480.94	1480.94	41131.0
2009-04-15 11:00:00	NQ	Futures	1481.22	1484.35	1475.54	1482.64	38228.0
2009-04-15 12:00:00	NQ	Futures	1482.93	1486.9	1480.37	1485.48	18668.0
2009-04-15 13:00:00	NQ	Futures	1485.77	1492.02	1483.78	1486.9	35554.0
2009-04-15 14:00:00	NQ	Futures	1486.62	1489.46	1470.14	1473.27	40630.0
2009-04-15 15:00:00	NQ	Futures	1473.27	1497.42	1472.7	1496.0	65315.0
2009-04-15 16:00:00	NQ	Futures	1496.28	1498.27	1494.01	1497.13	10609.0
2009-04-15 17:00:00	NQ	Futures	1497.99	1498.55	1496.28	1498.55	237.0
2009-04-15 18:00:00	NQ	Futures	1497.13	1499.12	1496.56	1497.13	192.0
2009-04-15 19:00:00	NQ	Futures	1497.13	1498.84	1497.13	1498.27	99.0
2009-04-15 20:00:00	NQ	Futures	1498.27	1513.61	1498.27	1508.78	1460.0
2009-04-15 21:00:00	NQ	Futures	1508.21	1511.91	1506.79	1509.07	391.0
2009-04-15 22:00:00	NQ	Futures	1508.78	1508.78	1494.29	1495.71	1529.0
2009-04-15 23:00:00	NQ	Futures	1495.14	1503.67	1494.01	1498.27	366.0
2009-04-15 00:00:00	YM	Futures	7195.4	7211.0	7189.9	7201.8	161.0
2009-04-15 01:00:00	YM	Futures	7201.8	7203.6	7193.5	7199.0	103.0

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

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