PREVIEW / futures_1hour / 2009-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-22.parquet
  size:    45 KB
  rows:    1,298

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-01-22 00:00:00	ES	Futures	798.37	800.5	798.37	800.03	3851.0
2009-01-22 01:00:00	ES	Futures	800.03	800.74	796.47	796.94	3102.0
2009-01-22 02:00:00	ES	Futures	796.94	797.18	793.38	793.62	10653.0
2009-01-22 03:00:00	ES	Futures	793.62	795.52	790.54	793.15	23005.0
2009-01-22 04:00:00	ES	Futures	792.91	797.42	792.67	795.52	14448.0
2009-01-22 05:00:00	ES	Futures	795.52	795.52	789.59	790.54	14898.0
2009-01-22 06:00:00	ES	Futures	790.3	791.49	785.32	788.64	31242.0
2009-01-22 07:00:00	ES	Futures	788.64	791.72	788.64	790.3	18855.0
2009-01-22 08:00:00	ES	Futures	790.3	790.78	783.19	784.85	65166.0
2009-01-22 09:00:00	ES	Futures	784.85	785.32	774.65	777.73	377117.0
2009-01-22 10:00:00	ES	Futures	777.73	783.19	773.22	774.65	400972.0
2009-01-22 11:00:00	ES	Futures	774.65	777.73	766.35	767.29	355908.0
2009-01-22 12:00:00	ES	Futures	767.06	777.26	766.11	774.17	247177.0
2009-01-22 13:00:00	ES	Futures	774.17	783.42	771.09	783.19	315159.0
2009-01-22 14:00:00	ES	Futures	783.42	793.62	781.05	785.56	500215.0
2009-01-22 15:00:00	ES	Futures	785.56	787.46	773.94	781.53	505750.0
2009-01-22 16:00:00	ES	Futures	781.29	784.37	780.34	782.0	113069.0
2009-01-22 17:00:00	ES	Futures	782.0	783.19	781.29	782.95	1174.0
2009-01-22 18:00:00	ES	Futures	782.71	783.9	781.53	783.66	2720.0
2009-01-22 19:00:00	ES	Futures	783.66	784.37	780.34	780.34	3539.0
2009-01-22 20:00:00	ES	Futures	780.58	782.24	779.63	782.24	2024.0
2009-01-22 21:00:00	ES	Futures	782.24	782.24	779.63	779.63	2023.0
2009-01-22 22:00:00	ES	Futures	779.39	781.53	778.92	781.53	1813.0
2009-01-22 23:00:00	ES	Futures	781.53	781.53	778.44	779.15	1545.0
2009-01-22 00:00:00	NQ	Futures	1355.14	1357.4	1354.3	1357.12	187.0
2009-01-22 01:00:00	NQ	Futures	1356.56	1356.84	1349.78	1349.78	171.0
2009-01-22 02:00:00	NQ	Futures	1349.78	1350.06	1344.98	1344.98	690.0
2009-01-22 03:00:00	NQ	Futures	1344.98	1349.5	1341.87	1346.11	1458.0
2009-01-22 04:00:00	NQ	Futures	1346.39	1352.32	1346.39	1349.78	731.0
2009-01-22 05:00:00	NQ	Futures	1349.5	1349.5	1339.61	1340.46	985.0
2009-01-22 06:00:00	NQ	Futures	1340.74	1342.72	1334.53	1339.33	1964.0
2009-01-22 07:00:00	NQ	Futures	1339.05	1345.26	1339.05	1342.16	1585.0
2009-01-22 08:00:00	NQ	Futures	1341.59	1344.7	1329.45	1331.14	5428.0
2009-01-22 09:00:00	NQ	Futures	1331.14	1331.71	1302.9	1311.09	58272.0
2009-01-22 10:00:00	NQ	Futures	1310.81	1320.13	1304.6	1306.29	52396.0
2009-01-22 11:00:00	NQ	Futures	1305.73	1312.79	1296.13	1297.54	34039.0
2009-01-22 12:00:00	NQ	Futures	1297.54	1312.79	1294.43	1308.83	27892.0
2009-01-22 13:00:00	NQ	Futures	1308.83	1322.95	1304.88	1322.67	31156.0
2009-01-22 14:00:00	NQ	Futures	1322.39	1339.61	1319.0	1324.65	58206.0
2009-01-22 15:00:00	NQ	Futures	1324.65	1325.49	1306.58	1318.15	57387.0
2009-01-22 16:00:00	NQ	Futures	1318.15	1326.06	1312.22	1321.82	17013.0
2009-01-22 17:00:00	NQ	Futures	1322.11	1323.24	1319.56	1323.24	332.0
2009-01-22 18:00:00	NQ	Futures	1322.67	1323.8	1320.41	1322.67	248.0
2009-01-22 19:00:00	NQ	Futures	1323.52	1323.8	1316.74	1317.31	206.0
2009-01-22 20:00:00	NQ	Futures	1318.44	1322.95	1317.59	1322.95	162.0
2009-01-22 21:00:00	NQ	Futures	1323.52	1324.08	1320.13	1320.13	104.0
2009-01-22 22:00:00	NQ	Futures	1319.85	1322.11	1319.0	1322.11	53.0
2009-01-22 23:00:00	NQ	Futures	1321.82	1321.82	1316.74	1316.74	26.0
2009-01-22 00:00:00	YM	Futures	7484.3	7499.8	7484.3	7495.2	275.0
2009-01-22 01:00:00	YM	Futures	7496.1	7499.8	7469.7	7469.7	231.0

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

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