PREVIEW / futures_1hour / 2009-02-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	765.16	766.35	764.92	766.11	1577.0
2009-02-17 01:00:00	ES	Futures	766.11	766.35	765.16	765.63	1970.0
2009-02-17 02:00:00	ES	Futures	765.63	765.87	761.84	762.79	15524.0
2009-02-17 03:00:00	ES	Futures	762.79	764.45	761.13	763.26	24006.0
2009-02-17 04:00:00	ES	Futures	763.03	764.21	760.42	763.74	20957.0
2009-02-17 05:00:00	ES	Futures	763.74	765.4	763.5	764.45	10923.0
2009-02-17 06:00:00	ES	Futures	764.45	764.92	760.18	760.65	28837.0
2009-02-17 07:00:00	ES	Futures	760.89	764.21	760.65	763.97	24929.0
2009-02-17 08:00:00	ES	Futures	763.74	765.16	751.88	752.35	115095.0
2009-02-17 09:00:00	ES	Futures	752.35	760.42	746.42	751.17	464231.0
2009-02-17 10:00:00	ES	Futures	751.17	756.62	749.74	754.72	417808.0
2009-02-17 11:00:00	ES	Futures	754.96	755.44	748.56	749.98	245704.0
2009-02-17 12:00:00	ES	Futures	749.98	752.59	747.61	752.11	207200.0
2009-02-17 13:00:00	ES	Futures	752.11	754.96	747.13	750.93	276019.0
2009-02-17 14:00:00	ES	Futures	750.93	755.91	749.51	751.4	270149.0
2009-02-17 15:00:00	ES	Futures	751.17	758.76	746.42	746.9	599726.0
2009-02-17 16:00:00	ES	Futures	746.66	747.85	745.24	745.95	137725.0
2009-02-17 17:00:00	ES	Futures	745.95	746.9	745.24	746.42	3186.0
2009-02-17 18:00:00	ES	Futures	746.66	747.13	745.47	746.19	4487.0
2009-02-17 19:00:00	ES	Futures	746.19	748.56	746.19	748.32	4384.0
2009-02-17 20:00:00	ES	Futures	748.32	749.74	747.85	749.51	4170.0
2009-02-17 21:00:00	ES	Futures	749.74	750.45	747.13	747.61	3951.0
2009-02-17 22:00:00	ES	Futures	747.61	750.45	746.9	749.27	2756.0
2009-02-17 23:00:00	ES	Futures	749.51	749.98	747.37	748.08	1778.0
2009-02-17 00:00:00	NQ	Futures	1362.49	1363.62	1362.49	1363.05	12.0
2009-02-17 01:00:00	NQ	Futures	1363.33	1364.46	1362.2	1362.49	65.0
2009-02-17 02:00:00	NQ	Futures	1362.2	1362.77	1355.43	1357.69	669.0
2009-02-17 03:00:00	NQ	Futures	1357.97	1365.03	1357.97	1363.05	2034.0
2009-02-17 04:00:00	NQ	Futures	1362.49	1362.77	1357.69	1359.95	2538.0
2009-02-17 05:00:00	NQ	Futures	1360.23	1362.77	1356.84	1357.97	1931.0
2009-02-17 06:00:00	NQ	Futures	1357.97	1358.53	1350.06	1351.47	1688.0
2009-02-17 07:00:00	NQ	Futures	1351.47	1359.1	1350.91	1358.25	3049.0
2009-02-17 08:00:00	NQ	Futures	1358.53	1362.77	1346.67	1347.52	9151.0
2009-02-17 09:00:00	NQ	Futures	1347.52	1357.12	1331.71	1342.44	78145.0
2009-02-17 10:00:00	NQ	Futures	1342.44	1354.3	1339.9	1350.34	57906.0
2009-02-17 11:00:00	NQ	Futures	1350.34	1350.34	1337.92	1340.46	36699.0
2009-02-17 12:00:00	NQ	Futures	1340.18	1345.26	1336.79	1342.72	27586.0
2009-02-17 13:00:00	NQ	Futures	1343.0	1349.78	1335.66	1342.72	32657.0
2009-02-17 14:00:00	NQ	Futures	1343.28	1353.45	1340.18	1346.67	32508.0
2009-02-17 15:00:00	NQ	Futures	1346.96	1359.66	1339.9	1340.74	66099.0
2009-02-17 16:00:00	NQ	Futures	1340.18	1342.72	1334.53	1339.61	17091.0
2009-02-17 17:00:00	NQ	Futures	1339.61	1341.31	1339.05	1340.74	466.0
2009-02-17 18:00:00	NQ	Futures	1340.74	1341.31	1340.18	1341.03	201.0
2009-02-17 19:00:00	NQ	Futures	1341.31	1343.57	1341.31	1343.57	254.0
2009-02-17 20:00:00	NQ	Futures	1343.57	1346.96	1343.28	1346.96	256.0
2009-02-17 21:00:00	NQ	Futures	1346.67	1347.52	1339.33	1339.61	845.0
2009-02-17 22:00:00	NQ	Futures	1339.61	1343.57	1339.05	1342.44	505.0
2009-02-17 23:00:00	NQ	Futures	1342.72	1343.28	1339.61	1340.46	93.0
2009-02-17 00:00:00	YM	Futures	6993.1	7005.0	6993.1	7003.1	133.0
2009-02-17 01:00:00	YM	Futures	7003.1	7003.1	6991.3	6994.9	163.0

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

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