PREVIEW / futures_1hour / 2009-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-14.parquet
  size:    43 KB
  rows:    1,258

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-14 00:00:00	ES	Futures	810.68	812.36	810.44	811.16	2493.0
2009-04-14 01:00:00	ES	Futures	811.16	812.6	809.96	811.64	2261.0
2009-04-14 02:00:00	ES	Futures	811.64	813.08	807.81	810.2	11470.0
2009-04-14 03:00:00	ES	Futures	810.44	815.23	808.52	813.56	21196.0
2009-04-14 04:00:00	ES	Futures	813.32	816.43	812.6	815.71	15216.0
2009-04-14 05:00:00	ES	Futures	815.71	819.07	814.52	817.87	17923.0
2009-04-14 06:00:00	ES	Futures	817.87	819.31	814.99	816.19	18746.0
2009-04-14 07:00:00	ES	Futures	816.19	818.59	814.99	815.95	18863.0
2009-04-14 08:00:00	ES	Futures	815.95	821.94	810.2	811.4	82075.0
2009-04-14 09:00:00	ES	Futures	811.4	812.36	805.65	810.68	290022.0
2009-04-14 10:00:00	ES	Futures	810.68	817.87	809.24	815.23	373243.0
2009-04-14 11:00:00	ES	Futures	815.47	816.43	810.68	811.4	235582.0
2009-04-14 12:00:00	ES	Futures	811.64	811.64	802.05	803.25	240173.0
2009-04-14 13:00:00	ES	Futures	803.49	805.65	801.58	804.93	204168.0
2009-04-14 14:00:00	ES	Futures	804.69	807.81	801.81	807.81	233006.0
2009-04-14 15:00:00	ES	Futures	807.81	809.96	802.29	803.97	443124.0
2009-04-14 16:00:00	ES	Futures	803.97	805.89	799.42	799.9	116983.0
2009-04-14 17:00:00	ES	Futures	799.9	802.05	799.66	800.86	3203.0
2009-04-14 18:00:00	ES	Futures	800.62	800.86	798.46	800.14	5202.0
2009-04-14 19:00:00	ES	Futures	800.38	800.38	799.18	799.9	1879.0
2009-04-14 20:00:00	ES	Futures	800.14	801.34	798.94	800.62	5153.0
2009-04-14 21:00:00	ES	Futures	800.62	801.81	799.66	801.1	3845.0
2009-04-14 22:00:00	ES	Futures	801.1	801.34	799.42	800.14	3336.0
2009-04-14 23:00:00	ES	Futures	800.14	800.86	799.18	799.18	3182.0
2009-04-14 00:00:00	NQ	Futures	1501.96	1504.8	1500.26	1501.96	215.0
2009-04-14 01:00:00	NQ	Futures	1502.25	1505.09	1500.83	1505.09	215.0
2009-04-14 02:00:00	NQ	Futures	1504.24	1506.23	1498.27	1503.1	403.0
2009-04-14 03:00:00	NQ	Futures	1503.67	1511.34	1499.41	1509.07	1148.0
2009-04-14 04:00:00	NQ	Futures	1508.5	1514.18	1508.21	1513.04	968.0
2009-04-14 05:00:00	NQ	Futures	1512.48	1519.58	1511.62	1517.59	1169.0
2009-04-14 06:00:00	NQ	Futures	1517.59	1519.01	1511.62	1513.61	1168.0
2009-04-14 07:00:00	NQ	Futures	1513.9	1517.59	1513.04	1515.89	1822.0
2009-04-14 08:00:00	NQ	Futures	1515.89	1524.13	1505.94	1507.36	8789.0
2009-04-14 09:00:00	NQ	Futures	1507.36	1513.33	1502.25	1512.48	34874.0
2009-04-14 10:00:00	NQ	Futures	1512.19	1518.16	1503.38	1513.33	41490.0
2009-04-14 11:00:00	NQ	Futures	1513.61	1515.6	1503.67	1506.51	26924.0
2009-04-14 12:00:00	NQ	Futures	1506.51	1506.79	1492.3	1493.72	30869.0
2009-04-14 13:00:00	NQ	Futures	1493.72	1499.12	1489.46	1497.13	35474.0
2009-04-14 14:00:00	NQ	Futures	1497.13	1505.37	1494.01	1505.37	30805.0
2009-04-14 15:00:00	NQ	Futures	1505.37	1508.5	1498.55	1499.41	54553.0
2009-04-14 16:00:00	NQ	Futures	1499.41	1506.79	1482.36	1484.35	16325.0
2009-04-14 17:00:00	NQ	Futures	1484.63	1491.73	1484.63	1489.75	1082.0
2009-04-14 18:00:00	NQ	Futures	1487.19	1490.31	1484.63	1485.2	808.0
2009-04-14 19:00:00	NQ	Futures	1485.48	1486.05	1484.35	1485.48	139.0
2009-04-14 20:00:00	NQ	Futures	1485.77	1488.04	1484.06	1487.19	122.0
2009-04-14 21:00:00	NQ	Futures	1488.32	1488.89	1485.2	1488.04	385.0
2009-04-14 22:00:00	NQ	Futures	1488.32	1488.32	1485.48	1486.34	85.0
2009-04-14 23:00:00	NQ	Futures	1486.34	1487.19	1484.35	1484.63	106.0
2009-04-14 00:00:00	YM	Futures	7294.6	7304.7	7288.2	7296.5	246.0
2009-04-14 01:00:00	YM	Futures	7296.5	7309.3	7285.4	7305.6	249.0

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

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