PREVIEW / futures_1hour / 2009-02-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	743.58	743.81	741.2	742.15	2108.0
2009-02-19 01:00:00	ES	Futures	741.92	742.86	741.44	742.15	1221.0
2009-02-19 02:00:00	ES	Futures	742.15	747.13	742.15	746.66	11050.0
2009-02-19 03:00:00	ES	Futures	746.66	748.08	743.81	745.95	18735.0
2009-02-19 04:00:00	ES	Futures	745.95	749.51	744.76	748.32	18050.0
2009-02-19 05:00:00	ES	Futures	748.32	749.27	747.13	747.37	8789.0
2009-02-19 06:00:00	ES	Futures	747.37	748.32	745.95	747.13	12262.0
2009-02-19 07:00:00	ES	Futures	747.13	751.4	746.42	751.17	23991.0
2009-02-19 08:00:00	ES	Futures	751.17	753.54	746.19	751.4	80314.0
2009-02-19 09:00:00	ES	Futures	751.64	755.91	750.93	754.49	296433.0
2009-02-19 10:00:00	ES	Futures	754.72	754.96	746.66	746.9	354974.0
2009-02-19 11:00:00	ES	Futures	746.9	752.11	742.86	743.34	287013.0
2009-02-19 12:00:00	ES	Futures	743.58	745.0	740.26	744.05	202050.0
2009-02-19 13:00:00	ES	Futures	743.81	749.27	742.39	744.52	212139.0
2009-02-19 14:00:00	ES	Futures	744.29	746.9	739.78	742.63	239925.0
2009-02-19 15:00:00	ES	Futures	742.39	744.29	735.51	738.36	489461.0
2009-02-19 16:00:00	ES	Futures	738.36	739.78	735.27	737.65	114509.0
2009-02-19 17:00:00	ES	Futures	737.65	738.83	737.41	738.6	2101.0
2009-02-19 18:00:00	ES	Futures	737.88	739.54	736.7	738.36	4760.0
2009-02-19 19:00:00	ES	Futures	738.6	739.07	735.75	736.46	3530.0
2009-02-19 20:00:00	ES	Futures	736.46	737.17	732.67	733.38	4596.0
2009-02-19 21:00:00	ES	Futures	733.38	733.85	732.9	733.85	2431.0
2009-02-19 22:00:00	ES	Futures	733.85	735.27	733.38	734.56	2630.0
2009-02-19 23:00:00	ES	Futures	734.33	734.33	732.43	733.14	2825.0
2009-02-19 00:00:00	NQ	Futures	1334.81	1334.81	1331.14	1331.71	119.0
2009-02-19 01:00:00	NQ	Futures	1331.71	1333.4	1331.71	1332.84	29.0
2009-02-19 02:00:00	NQ	Futures	1332.55	1340.18	1331.71	1340.18	522.0
2009-02-19 03:00:00	NQ	Futures	1340.18	1341.87	1335.38	1339.05	1162.0
2009-02-19 04:00:00	NQ	Futures	1339.05	1344.7	1337.07	1342.44	1050.0
2009-02-19 05:00:00	NQ	Futures	1342.44	1344.13	1341.31	1341.59	735.0
2009-02-19 06:00:00	NQ	Futures	1341.31	1343.28	1340.18	1341.03	889.0
2009-02-19 07:00:00	NQ	Futures	1341.03	1348.09	1340.74	1347.8	1946.0
2009-02-19 08:00:00	NQ	Futures	1347.52	1350.91	1340.46	1349.21	5992.0
2009-02-19 09:00:00	NQ	Futures	1348.93	1357.12	1346.67	1353.45	44764.0
2009-02-19 10:00:00	NQ	Futures	1353.73	1354.3	1331.71	1333.12	65219.0
2009-02-19 11:00:00	NQ	Futures	1333.12	1340.74	1326.34	1328.32	41834.0
2009-02-19 12:00:00	NQ	Futures	1328.04	1332.55	1321.54	1329.73	32510.0
2009-02-19 13:00:00	NQ	Futures	1330.01	1337.92	1326.06	1329.73	33260.0
2009-02-19 14:00:00	NQ	Futures	1329.45	1334.25	1321.82	1326.62	35847.0
2009-02-19 15:00:00	NQ	Futures	1326.34	1329.45	1316.18	1319.28	59339.0
2009-02-19 16:00:00	NQ	Futures	1319.0	1323.52	1316.18	1318.72	11383.0
2009-02-19 17:00:00	NQ	Futures	1319.28	1320.98	1319.28	1320.13	117.0
2009-02-19 18:00:00	NQ	Futures	1319.85	1321.26	1318.15	1319.28	188.0
2009-02-19 19:00:00	NQ	Futures	1319.85	1320.13	1316.74	1317.31	137.0
2009-02-19 20:00:00	NQ	Futures	1317.59	1318.44	1312.22	1313.07	397.0
2009-02-19 21:00:00	NQ	Futures	1313.63	1314.76	1312.79	1314.48	202.0
2009-02-19 22:00:00	NQ	Futures	1315.89	1317.59	1313.92	1315.61	96.0
2009-02-19 23:00:00	NQ	Futures	1315.05	1315.05	1312.79	1313.63	105.0
2009-02-19 00:00:00	YM	Futures	6851.9	6852.8	6834.6	6837.3	160.0
2009-02-19 01:00:00	YM	Futures	6837.3	6844.6	6834.6	6839.1	201.0

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

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