PREVIEW / futures_1hour / 2009-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-23.parquet
  size:    38 KB
  rows:    1,047

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-23 00:00:00	ES	Futures	778.92	781.05	776.54	777.02	2231.0
2009-01-23 01:00:00	ES	Futures	777.02	778.44	776.07	778.21	2234.0
2009-01-23 02:00:00	ES	Futures	778.21	778.92	774.17	774.41	4935.0
2009-01-23 03:00:00	ES	Futures	774.41	777.26	767.53	770.85	28028.0
2009-01-23 04:00:00	ES	Futures	770.62	772.04	760.18	761.84	35545.0
2009-01-23 05:00:00	ES	Futures	761.84	766.35	760.42	764.69	24733.0
2009-01-23 06:00:00	ES	Futures	764.69	770.14	763.26	767.53	38961.0
2009-01-23 07:00:00	ES	Futures	767.29	770.62	765.4	766.11	29723.0
2009-01-23 08:00:00	ES	Futures	766.11	767.53	758.52	758.76	77498.0
2009-01-23 09:00:00	ES	Futures	758.76	771.56	758.76	768.72	323812.0
2009-01-23 10:00:00	ES	Futures	768.72	775.36	766.58	769.67	331460.0
2009-01-23 11:00:00	ES	Futures	769.43	782.71	769.43	773.94	350151.0
2009-01-23 12:00:00	ES	Futures	773.7	782.47	773.22	778.21	279611.0
2009-01-23 13:00:00	ES	Futures	778.21	791.72	776.31	791.49	348690.0
2009-01-23 14:00:00	ES	Futures	791.49	793.15	779.15	781.29	291705.0
2009-01-23 15:00:00	ES	Futures	781.29	788.88	778.68	784.61	310154.0
2009-01-23 16:00:00	ES	Futures	784.61	785.08	780.81	781.29	93521.0
2009-01-23 00:00:00	NQ	Futures	1320.13	1320.98	1315.33	1316.46	123.0
2009-01-23 01:00:00	NQ	Futures	1315.33	1317.87	1313.07	1317.87	138.0
2009-01-23 02:00:00	NQ	Futures	1317.59	1319.0	1311.94	1311.94	205.0
2009-01-23 03:00:00	NQ	Futures	1312.22	1316.18	1300.36	1305.16	2158.0
2009-01-23 04:00:00	NQ	Futures	1304.88	1307.14	1289.35	1291.04	2265.0
2009-01-23 05:00:00	NQ	Futures	1291.33	1298.95	1289.91	1296.13	853.0
2009-01-23 06:00:00	NQ	Futures	1295.84	1306.01	1293.02	1300.93	1413.0
2009-01-23 07:00:00	NQ	Futures	1300.36	1304.88	1296.69	1298.39	1468.0
2009-01-23 08:00:00	NQ	Futures	1298.39	1302.06	1290.76	1291.61	4577.0
2009-01-23 09:00:00	NQ	Futures	1291.89	1309.12	1289.35	1304.32	47680.0
2009-01-23 10:00:00	NQ	Futures	1304.03	1314.76	1301.21	1303.75	40644.0
2009-01-23 11:00:00	NQ	Futures	1304.03	1326.06	1303.47	1314.2	47318.0
2009-01-23 12:00:00	NQ	Futures	1314.2	1328.6	1313.35	1321.26	37924.0
2009-01-23 13:00:00	NQ	Futures	1320.98	1342.44	1317.59	1341.87	56767.0
2009-01-23 14:00:00	NQ	Futures	1342.16	1345.26	1321.54	1324.37	45555.0
2009-01-23 15:00:00	NQ	Futures	1324.37	1331.71	1317.87	1324.93	45896.0
2009-01-23 16:00:00	NQ	Futures	1324.93	1324.93	1314.2	1315.05	10588.0
2009-01-23 00:00:00	YM	Futures	7331.2	7347.6	7314.8	7315.7	276.0
2009-01-23 01:00:00	YM	Futures	7315.7	7329.4	7311.2	7329.4	217.0
2009-01-23 02:00:00	YM	Futures	7329.4	7335.8	7297.5	7297.5	432.0
2009-01-23 03:00:00	YM	Futures	7302.0	7322.1	7243.7	7266.5	1906.0
2009-01-23 04:00:00	YM	Futures	7270.1	7278.3	7182.7	7194.5	2214.0
2009-01-23 05:00:00	YM	Futures	7196.3	7231.9	7185.4	7219.1	1264.0
2009-01-23 06:00:00	YM	Futures	7220.9	7257.4	7207.3	7235.5	2375.0
2009-01-23 07:00:00	YM	Futures	7232.8	7258.3	7213.6	7216.4	1402.0
2009-01-23 08:00:00	YM	Futures	7220.0	7231.0	7155.3	7159.0	4623.0
2009-01-23 09:00:00	YM	Futures	7158.1	7237.3	7157.1	7219.1	25322.0
2009-01-23 10:00:00	YM	Futures	7218.2	7250.1	7182.7	7202.7	26120.0
2009-01-23 11:00:00	YM	Futures	7202.7	7305.7	7202.7	7233.7	27204.0
2009-01-23 12:00:00	YM	Futures	7232.8	7293.8	7224.6	7260.1	26635.0
2009-01-23 13:00:00	YM	Futures	7260.1	7369.5	7243.7	7369.5	38639.0
2009-01-23 14:00:00	YM	Futures	7368.6	7388.6	7261.0	7274.7	36815.0
2009-01-23 15:00:00	YM	Futures	7277.4	7340.3	7251.9	7304.8	36740.0

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

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