PREVIEW / futures_1hour / 2009-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-24.parquet
  size:    43 KB
  rows:    1,244

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-03-24 00:00:00	ES	Futures	778.57	780.49	778.33	779.29	4013.0
2009-03-24 01:00:00	ES	Futures	779.29	784.08	779.29	783.12	6094.0
2009-03-24 02:00:00	ES	Futures	783.12	783.6	780.97	781.93	3033.0
2009-03-24 03:00:00	ES	Futures	781.69	783.12	781.45	782.4	8135.0
2009-03-24 04:00:00	ES	Futures	782.4	782.64	777.61	778.57	35925.0
2009-03-24 05:00:00	ES	Futures	778.57	778.57	774.5	774.98	43359.0
2009-03-24 06:00:00	ES	Futures	774.98	777.85	774.02	777.37	25285.0
2009-03-24 07:00:00	ES	Futures	777.37	778.09	776.17	776.65	21299.0
2009-03-24 08:00:00	ES	Futures	776.65	777.85	774.5	776.17	34894.0
2009-03-24 09:00:00	ES	Futures	775.93	777.37	771.86	777.13	256540.0
2009-03-24 10:00:00	ES	Futures	777.37	781.21	771.86	774.5	427761.0
2009-03-24 11:00:00	ES	Futures	774.26	780.25	773.06	776.41	259554.0
2009-03-24 12:00:00	ES	Futures	776.17	783.12	774.5	782.16	204053.0
2009-03-24 13:00:00	ES	Futures	782.16	786.0	779.29	780.73	250603.0
2009-03-24 14:00:00	ES	Futures	780.73	785.04	777.37	779.05	263868.0
2009-03-24 15:00:00	ES	Futures	779.05	780.25	768.03	768.98	429549.0
2009-03-24 16:00:00	ES	Futures	768.98	770.66	768.27	768.98	115341.0
2009-03-24 17:00:00	ES	Futures	769.22	769.94	768.27	769.22	4578.0
2009-03-24 18:00:00	ES	Futures	769.22	770.66	768.03	770.66	6702.0
2009-03-24 19:00:00	ES	Futures	770.66	772.34	770.18	772.1	3365.0
2009-03-24 20:00:00	ES	Futures	772.1	772.82	770.9	771.38	3396.0
2009-03-24 21:00:00	ES	Futures	771.38	772.1	769.7	770.9	3718.0
2009-03-24 22:00:00	ES	Futures	770.9	772.58	770.42	772.34	2437.0
2009-03-24 23:00:00	ES	Futures	772.1	774.02	771.86	774.02	3376.0
2009-03-24 00:00:00	NQ	Futures	1413.88	1417.29	1413.6	1414.73	214.0
2009-03-24 01:00:00	NQ	Futures	1414.73	1422.12	1414.73	1420.7	235.0
2009-03-24 02:00:00	NQ	Futures	1420.13	1421.27	1416.15	1417.57	168.0
2009-03-24 03:00:00	NQ	Futures	1417.57	1420.42	1417.01	1419.28	412.0
2009-03-24 04:00:00	NQ	Futures	1419.28	1419.28	1412.74	1415.87	2424.0
2009-03-24 05:00:00	NQ	Futures	1415.58	1415.58	1409.05	1409.33	2372.0
2009-03-24 06:00:00	NQ	Futures	1409.62	1415.3	1408.48	1414.16	2342.0
2009-03-24 07:00:00	NQ	Futures	1414.16	1415.87	1412.46	1413.88	2066.0
2009-03-24 08:00:00	NQ	Futures	1414.16	1415.87	1411.89	1414.16	6325.0
2009-03-24 09:00:00	NQ	Futures	1413.88	1419.56	1408.77	1415.3	30724.0
2009-03-24 10:00:00	NQ	Futures	1415.58	1421.84	1401.38	1405.92	51808.0
2009-03-24 11:00:00	NQ	Futures	1405.92	1415.87	1404.22	1407.34	29323.0
2009-03-24 12:00:00	NQ	Futures	1407.06	1421.84	1404.22	1420.7	23285.0
2009-03-24 13:00:00	NQ	Futures	1420.98	1426.1	1411.61	1415.3	32875.0
2009-03-24 14:00:00	NQ	Futures	1415.3	1422.12	1409.33	1412.18	31303.0
2009-03-24 15:00:00	NQ	Futures	1412.18	1413.88	1399.67	1401.38	44599.0
2009-03-24 16:00:00	NQ	Futures	1401.38	1405.92	1400.53	1401.09	13304.0
2009-03-24 17:00:00	NQ	Futures	1401.38	1401.95	1398.25	1399.1	1622.0
2009-03-24 18:00:00	NQ	Futures	1399.96	1403.08	1399.1	1402.8	805.0
2009-03-24 19:00:00	NQ	Futures	1402.8	1405.92	1402.23	1405.64	214.0
2009-03-24 20:00:00	NQ	Futures	1406.21	1407.06	1404.22	1405.07	199.0
2009-03-24 21:00:00	NQ	Futures	1405.36	1406.78	1401.95	1405.36	173.0
2009-03-24 22:00:00	NQ	Futures	1404.79	1407.91	1404.5	1406.78	196.0
2009-03-24 23:00:00	NQ	Futures	1407.34	1410.75	1407.34	1409.9	219.0
2009-03-24 00:00:00	YM	Futures	7046.5	7057.5	7042.8	7052.0	195.0
2009-03-24 01:00:00	YM	Futures	7052.0	7094.3	7052.0	7087.9	589.0

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

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