PREVIEW / futures_1hour / 2009-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-09.parquet
  size:    44 KB
  rows:    1,260

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-02-09 00:00:00	ES	Futures	812.36	812.83	809.28	809.51	5118.0
2009-02-09 01:00:00	ES	Futures	809.28	811.89	809.04	811.65	4619.0
2009-02-09 02:00:00	ES	Futures	811.41	814.26	809.75	813.31	7370.0
2009-02-09 03:00:00	ES	Futures	813.07	814.49	810.94	812.12	14929.0
2009-02-09 04:00:00	ES	Futures	812.12	815.68	809.75	815.21	12658.0
2009-02-09 05:00:00	ES	Futures	815.44	815.92	812.83	814.97	8384.0
2009-02-09 06:00:00	ES	Futures	814.97	816.87	814.73	816.39	9156.0
2009-02-09 07:00:00	ES	Futures	816.39	817.82	813.55	814.49	18333.0
2009-02-09 08:00:00	ES	Futures	814.49	818.76	814.02	818.53	49801.0
2009-02-09 09:00:00	ES	Futures	818.53	822.08	817.34	820.42	224384.0
2009-02-09 10:00:00	ES	Futures	820.42	828.25	814.97	827.78	345912.0
2009-02-09 11:00:00	ES	Futures	827.54	827.78	820.19	822.32	205657.0
2009-02-09 12:00:00	ES	Futures	822.08	826.12	820.66	825.4	130350.0
2009-02-09 13:00:00	ES	Futures	825.17	826.59	819.24	822.56	180450.0
2009-02-09 14:00:00	ES	Futures	822.56	823.03	816.39	819.0	166110.0
2009-02-09 15:00:00	ES	Futures	819.0	825.88	817.34	822.8	289560.0
2009-02-09 16:00:00	ES	Futures	822.8	823.03	818.05	818.53	59708.0
2009-02-09 17:00:00	ES	Futures	818.29	818.76	817.1	818.29	2193.0
2009-02-09 18:00:00	ES	Futures	818.05	818.76	815.92	817.1	4678.0
2009-02-09 19:00:00	ES	Futures	817.1	817.58	809.51	810.94	13859.0
2009-02-09 20:00:00	ES	Futures	811.17	811.89	808.09	811.89	10232.0
2009-02-09 21:00:00	ES	Futures	811.89	815.44	810.94	815.44	6132.0
2009-02-09 22:00:00	ES	Futures	815.21	815.21	810.94	812.6	3788.0
2009-02-09 23:00:00	ES	Futures	812.36	812.6	808.8	809.28	4796.0
2009-02-09 00:00:00	NQ	Futures	1424.89	1425.46	1421.5	1421.5	276.0
2009-02-09 01:00:00	NQ	Futures	1421.5	1425.18	1420.94	1424.89	219.0
2009-02-09 02:00:00	NQ	Futures	1425.18	1429.98	1422.35	1428.56	241.0
2009-02-09 03:00:00	NQ	Futures	1428.28	1430.82	1424.33	1426.59	876.0
2009-02-09 04:00:00	NQ	Futures	1426.3	1432.52	1422.63	1431.67	1096.0
2009-02-09 05:00:00	NQ	Futures	1431.95	1433.08	1429.13	1430.82	546.0
2009-02-09 06:00:00	NQ	Futures	1431.67	1436.75	1431.11	1436.47	837.0
2009-02-09 07:00:00	NQ	Futures	1436.47	1437.6	1430.54	1432.8	2258.0
2009-02-09 08:00:00	NQ	Futures	1432.8	1439.58	1431.67	1436.47	5112.0
2009-02-09 09:00:00	NQ	Futures	1436.47	1442.97	1432.23	1439.01	31445.0
2009-02-09 10:00:00	NQ	Futures	1439.01	1452.0	1430.26	1450.59	45547.0
2009-02-09 11:00:00	NQ	Futures	1450.59	1451.15	1440.14	1442.97	24908.0
2009-02-09 12:00:00	NQ	Futures	1443.25	1449.46	1440.71	1447.77	17910.0
2009-02-09 13:00:00	NQ	Futures	1448.05	1449.74	1438.45	1445.22	20317.0
2009-02-09 14:00:00	NQ	Futures	1445.22	1446.07	1433.65	1437.88	23314.0
2009-02-09 15:00:00	NQ	Futures	1437.6	1448.9	1435.62	1445.51	34349.0
2009-02-09 16:00:00	NQ	Futures	1445.22	1446.35	1439.29	1439.86	7382.0
2009-02-09 17:00:00	NQ	Futures	1439.01	1440.42	1437.88	1439.01	138.0
2009-02-09 18:00:00	NQ	Futures	1439.01	1440.99	1436.47	1439.29	344.0
2009-02-09 19:00:00	NQ	Futures	1439.01	1439.58	1428.56	1429.98	570.0
2009-02-09 20:00:00	NQ	Futures	1429.98	1430.54	1424.61	1428.85	771.0
2009-02-09 21:00:00	NQ	Futures	1429.69	1437.6	1427.72	1437.6	344.0
2009-02-09 22:00:00	NQ	Futures	1437.04	1437.04	1430.54	1431.95	146.0
2009-02-09 23:00:00	NQ	Futures	1432.23	1433.36	1427.43	1428.28	186.0
2009-02-09 00:00:00	YM	Futures	7436.9	7442.4	7415.0	7415.0	327.0
2009-02-09 01:00:00	YM	Futures	7415.0	7435.1	7408.7	7435.1	578.0

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

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