PREVIEW / futures_1hour / 2009-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-22.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-22 00:00:00	ES	Futures	807.81	809.0	807.57	808.52	1644.0
2009-04-22 01:00:00	ES	Futures	808.52	808.76	807.09	808.05	2388.0
2009-04-22 02:00:00	ES	Futures	808.05	808.28	804.21	805.17	11455.0
2009-04-22 03:00:00	ES	Futures	805.17	806.85	802.29	806.13	28245.0
2009-04-22 04:00:00	ES	Futures	805.89	807.09	803.97	806.37	25126.0
2009-04-22 05:00:00	ES	Futures	806.37	809.48	805.65	808.52	17377.0
2009-04-22 06:00:00	ES	Futures	808.52	809.24	805.41	807.57	13120.0
2009-04-22 07:00:00	ES	Futures	807.57	810.44	804.69	809.0	28432.0
2009-04-22 08:00:00	ES	Futures	809.0	809.72	801.34	803.01	86742.0
2009-04-22 09:00:00	ES	Futures	803.25	807.33	800.86	806.85	261477.0
2009-04-22 10:00:00	ES	Futures	806.61	819.07	806.61	815.95	567711.0
2009-04-22 11:00:00	ES	Futures	815.95	821.23	814.99	820.75	263769.0
2009-04-22 12:00:00	ES	Futures	820.75	820.99	810.44	812.84	313591.0
2009-04-22 13:00:00	ES	Futures	813.08	818.35	810.92	813.8	235008.0
2009-04-22 14:00:00	ES	Futures	813.8	822.9	813.32	819.31	278646.0
2009-04-22 15:00:00	ES	Futures	819.31	823.14	803.97	805.89	633394.0
2009-04-22 16:00:00	ES	Futures	805.65	806.13	800.62	803.01	138986.0
2009-04-22 17:00:00	ES	Futures	803.01	804.21	802.05	803.97	4609.0
2009-04-22 18:00:00	ES	Futures	803.01	804.69	802.05	803.97	4051.0
2009-04-22 19:00:00	ES	Futures	803.97	804.21	802.29	803.73	1607.0
2009-04-22 20:00:00	ES	Futures	803.73	803.97	798.46	799.18	10867.0
2009-04-22 21:00:00	ES	Futures	799.18	800.38	798.46	799.9	3130.0
2009-04-22 22:00:00	ES	Futures	799.66	800.86	798.94	800.38	3256.0
2009-04-22 23:00:00	ES	Futures	800.38	800.86	798.94	800.62	2821.0
2009-04-22 00:00:00	NQ	Futures	1505.09	1506.79	1504.52	1505.94	64.0
2009-04-22 01:00:00	NQ	Futures	1505.94	1505.94	1503.1	1505.94	74.0
2009-04-22 02:00:00	NQ	Futures	1505.09	1505.09	1499.12	1500.83	406.0
2009-04-22 03:00:00	NQ	Futures	1500.26	1501.11	1494.29	1499.12	2294.0
2009-04-22 04:00:00	NQ	Futures	1499.41	1501.11	1495.71	1499.41	1134.0
2009-04-22 05:00:00	NQ	Futures	1499.12	1503.67	1498.27	1501.96	901.0
2009-04-22 06:00:00	NQ	Futures	1501.68	1503.95	1496.28	1500.83	921.0
2009-04-22 07:00:00	NQ	Futures	1500.54	1508.5	1497.42	1506.23	2083.0
2009-04-22 08:00:00	NQ	Futures	1505.94	1506.23	1494.86	1499.12	7672.0
2009-04-22 09:00:00	NQ	Futures	1499.12	1519.86	1494.86	1519.58	41407.0
2009-04-22 10:00:00	NQ	Futures	1519.3	1538.62	1519.3	1531.23	80877.0
2009-04-22 11:00:00	NQ	Futures	1531.23	1544.58	1528.1	1542.6	38966.0
2009-04-22 12:00:00	NQ	Futures	1542.6	1543.16	1524.13	1528.96	38679.0
2009-04-22 13:00:00	NQ	Futures	1528.96	1537.2	1525.55	1527.25	25369.0
2009-04-22 14:00:00	NQ	Futures	1527.54	1545.44	1526.4	1540.61	32114.0
2009-04-22 15:00:00	NQ	Futures	1540.32	1547.99	1512.48	1514.47	85773.0
2009-04-22 16:00:00	NQ	Futures	1514.18	1516.74	1499.97	1514.47	23830.0
2009-04-22 17:00:00	NQ	Futures	1514.47	1517.88	1509.92	1517.59	1324.0
2009-04-22 18:00:00	NQ	Futures	1515.89	1518.16	1512.76	1517.02	735.0
2009-04-22 19:00:00	NQ	Futures	1517.02	1517.02	1515.32	1516.45	402.0
2009-04-22 20:00:00	NQ	Futures	1516.74	1517.31	1507.93	1509.92	352.0
2009-04-22 21:00:00	NQ	Futures	1509.35	1511.91	1507.93	1511.34	359.0
2009-04-22 22:00:00	NQ	Futures	1511.06	1514.18	1509.63	1511.06	259.0
2009-04-22 23:00:00	NQ	Futures	1510.49	1511.62	1509.35	1511.62	116.0
2009-04-22 00:00:00	YM	Futures	7240.4	7252.3	7240.4	7250.5	127.0
2009-04-22 01:00:00	YM	Futures	7248.7	7248.7	7237.6	7242.2	147.0

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

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