PREVIEW / futures_1hour / 2009-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-21.parquet
  size:    44 KB
  rows:    1,275

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-21 00:00:00	ES	Futures	799.9	802.29	799.42	801.1	5341.0
2009-04-21 01:00:00	ES	Futures	801.1	802.29	800.14	801.1	3570.0
2009-04-21 02:00:00	ES	Futures	801.1	802.29	800.14	801.34	8040.0
2009-04-21 03:00:00	ES	Futures	801.34	803.01	798.7	801.58	27641.0
2009-04-21 04:00:00	ES	Futures	801.58	803.25	800.38	802.05	26415.0
2009-04-21 05:00:00	ES	Futures	802.05	803.49	799.42	799.42	18564.0
2009-04-21 06:00:00	ES	Futures	799.42	802.77	792.95	794.15	33698.0
2009-04-21 07:00:00	ES	Futures	794.15	795.1	791.99	792.95	48586.0
2009-04-21 08:00:00	ES	Futures	792.95	793.19	789.83	790.79	60667.0
2009-04-21 09:00:00	ES	Futures	790.79	797.02	788.87	795.1	359097.0
2009-04-21 10:00:00	ES	Futures	795.1	796.3	790.31	795.82	324478.0
2009-04-21 11:00:00	ES	Futures	796.06	804.45	795.82	803.49	399926.0
2009-04-21 12:00:00	ES	Futures	803.25	807.09	802.77	804.45	209951.0
2009-04-21 13:00:00	ES	Futures	804.45	806.37	802.53	804.45	200502.0
2009-04-21 14:00:00	ES	Futures	804.69	807.57	801.1	804.69	274441.0
2009-04-21 15:00:00	ES	Futures	804.93	811.88	803.97	810.92	499731.0
2009-04-21 16:00:00	ES	Futures	811.16	813.56	810.68	811.16	149138.0
2009-04-21 17:00:00	ES	Futures	811.16	811.4	809.72	810.2	3479.0
2009-04-21 18:00:00	ES	Futures	810.44	811.64	809.72	810.2	3489.0
2009-04-21 19:00:00	ES	Futures	810.2	810.44	809.48	809.72	2471.0
2009-04-21 20:00:00	ES	Futures	809.48	809.96	808.28	809.24	3864.0
2009-04-21 21:00:00	ES	Futures	809.24	810.2	807.33	808.28	4710.0
2009-04-21 22:00:00	ES	Futures	808.05	809.96	807.33	809.24	3074.0
2009-04-21 23:00:00	ES	Futures	809.24	809.48	807.09	807.57	2649.0
2009-04-21 00:00:00	NQ	Futures	1498.27	1499.97	1497.7	1499.97	334.0
2009-04-21 01:00:00	NQ	Futures	1499.97	1501.96	1498.84	1500.26	232.0
2009-04-21 02:00:00	NQ	Futures	1500.26	1500.26	1496.28	1497.42	472.0
2009-04-21 03:00:00	NQ	Futures	1498.27	1501.11	1493.72	1500.26	2286.0
2009-04-21 04:00:00	NQ	Futures	1499.97	1501.68	1496.85	1499.12	1030.0
2009-04-21 05:00:00	NQ	Futures	1499.12	1501.68	1494.01	1494.29	1076.0
2009-04-21 06:00:00	NQ	Futures	1494.01	1498.55	1486.05	1488.89	1540.0
2009-04-21 07:00:00	NQ	Futures	1488.89	1490.31	1483.49	1486.9	3023.0
2009-04-21 08:00:00	NQ	Futures	1487.19	1487.47	1481.51	1483.21	6554.0
2009-04-21 09:00:00	NQ	Futures	1483.49	1507.65	1477.24	1502.82	59438.0
2009-04-21 10:00:00	NQ	Futures	1502.82	1503.67	1488.32	1496.0	48288.0
2009-04-21 11:00:00	NQ	Futures	1495.71	1506.79	1495.43	1503.67	42983.0
2009-04-21 12:00:00	NQ	Futures	1503.67	1507.93	1501.96	1502.82	27809.0
2009-04-21 13:00:00	NQ	Futures	1502.82	1504.52	1495.14	1497.99	24921.0
2009-04-21 14:00:00	NQ	Futures	1498.27	1502.53	1492.02	1497.7	35574.0
2009-04-21 15:00:00	NQ	Futures	1497.7	1511.34	1496.56	1509.07	53419.0
2009-04-21 16:00:00	NQ	Futures	1509.07	1511.62	1507.08	1509.07	10587.0
2009-04-21 17:00:00	NQ	Futures	1509.07	1509.07	1508.21	1509.07	330.0
2009-04-21 18:00:00	NQ	Futures	1509.07	1510.49	1507.93	1508.5	121.0
2009-04-21 19:00:00	NQ	Futures	1508.5	1508.78	1507.93	1508.21	152.0
2009-04-21 20:00:00	NQ	Futures	1508.21	1508.21	1505.94	1507.08	210.0
2009-04-21 21:00:00	NQ	Futures	1507.36	1508.21	1503.95	1504.8	229.0
2009-04-21 22:00:00	NQ	Futures	1504.8	1507.36	1503.95	1507.36	168.0
2009-04-21 23:00:00	NQ	Futures	1507.36	1507.65	1503.38	1504.8	172.0
2009-04-21 00:00:00	YM	Futures	7191.7	7210.1	7187.1	7200.9	388.0
2009-04-21 01:00:00	YM	Futures	7201.8	7211.9	7197.2	7203.6	303.0

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

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