PREVIEW / futures_1hour / 2009-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-25.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-25 00:00:00	ES	Futures	774.02	774.74	771.62	772.58	3805.0
2009-03-25 01:00:00	ES	Futures	772.58	773.06	770.66	772.82	2328.0
2009-03-25 02:00:00	ES	Futures	772.58	774.5	771.86	772.34	2912.0
2009-03-25 03:00:00	ES	Futures	772.34	772.58	767.55	768.98	12235.0
2009-03-25 04:00:00	ES	Futures	768.98	776.17	768.75	775.22	30513.0
2009-03-25 05:00:00	ES	Futures	775.22	776.65	773.54	774.02	16750.0
2009-03-25 06:00:00	ES	Futures	773.78	774.98	771.86	772.1	12930.0
2009-03-25 07:00:00	ES	Futures	772.1	772.82	769.22	772.1	19568.0
2009-03-25 08:00:00	ES	Futures	772.1	775.45	770.66	772.82	77225.0
2009-03-25 09:00:00	ES	Futures	772.82	781.69	772.34	780.49	259659.0
2009-03-25 10:00:00	ES	Futures	780.73	789.35	780.49	783.36	503870.0
2009-03-25 11:00:00	ES	Futures	783.36	786.72	781.21	783.84	254656.0
2009-03-25 12:00:00	ES	Futures	783.6	787.44	778.33	779.77	216925.0
2009-03-25 13:00:00	ES	Futures	780.01	781.69	768.98	770.42	342792.0
2009-03-25 14:00:00	ES	Futures	770.42	770.66	755.57	756.76	550205.0
2009-03-25 15:00:00	ES	Futures	757.0	778.33	754.37	776.41	656003.0
2009-03-25 16:00:00	ES	Futures	776.17	777.61	773.78	776.89	117981.0
2009-03-25 17:00:00	ES	Futures	776.89	779.05	776.65	778.57	3509.0
2009-03-25 18:00:00	ES	Futures	777.85	778.33	776.89	778.33	2733.0
2009-03-25 19:00:00	ES	Futures	778.33	778.81	777.13	777.37	2561.0
2009-03-25 20:00:00	ES	Futures	777.13	779.29	776.65	779.05	4884.0
2009-03-25 21:00:00	ES	Futures	779.05	782.88	779.05	782.16	9638.0
2009-03-25 22:00:00	ES	Futures	781.93	782.64	780.25	780.49	3697.0
2009-03-25 23:00:00	ES	Futures	780.25	782.88	779.29	781.69	4248.0
2009-03-25 00:00:00	NQ	Futures	1410.19	1411.61	1406.78	1409.05	130.0
2009-03-25 01:00:00	NQ	Futures	1409.33	1409.33	1405.36	1409.33	94.0
2009-03-25 02:00:00	NQ	Futures	1408.77	1412.46	1408.48	1409.33	200.0
2009-03-25 03:00:00	NQ	Futures	1409.33	1409.33	1402.23	1404.5	410.0
2009-03-25 04:00:00	NQ	Futures	1404.79	1412.18	1404.22	1410.75	1400.0
2009-03-25 05:00:00	NQ	Futures	1410.75	1413.31	1409.05	1409.9	1153.0
2009-03-25 06:00:00	NQ	Futures	1409.9	1412.18	1407.06	1407.91	540.0
2009-03-25 07:00:00	NQ	Futures	1407.91	1409.33	1403.93	1405.36	2176.0
2009-03-25 08:00:00	NQ	Futures	1405.36	1412.74	1403.08	1409.62	6304.0
2009-03-25 09:00:00	NQ	Futures	1409.62	1423.82	1408.77	1422.97	39289.0
2009-03-25 10:00:00	NQ	Futures	1422.4	1433.77	1421.27	1423.26	69160.0
2009-03-25 11:00:00	NQ	Futures	1423.26	1428.66	1416.72	1420.42	35186.0
2009-03-25 12:00:00	NQ	Futures	1420.13	1426.1	1407.06	1411.04	33693.0
2009-03-25 13:00:00	NQ	Futures	1411.32	1413.88	1390.3	1393.71	50358.0
2009-03-25 14:00:00	NQ	Futures	1393.99	1394.56	1370.97	1373.82	61882.0
2009-03-25 15:00:00	NQ	Futures	1373.82	1408.48	1369.84	1406.78	80694.0
2009-03-25 16:00:00	NQ	Futures	1407.06	1408.2	1399.1	1406.49	12797.0
2009-03-25 17:00:00	NQ	Futures	1406.21	1409.9	1406.21	1409.05	256.0
2009-03-25 18:00:00	NQ	Futures	1408.2	1409.33	1406.49	1408.48	136.0
2009-03-25 19:00:00	NQ	Futures	1409.33	1409.62	1407.06	1407.91	162.0
2009-03-25 20:00:00	NQ	Futures	1407.06	1411.04	1407.06	1409.9	153.0
2009-03-25 21:00:00	NQ	Futures	1410.19	1416.44	1410.19	1415.3	434.0
2009-03-25 22:00:00	NQ	Futures	1415.87	1416.72	1412.46	1412.46	176.0
2009-03-25 23:00:00	NQ	Futures	1412.18	1416.15	1410.75	1415.3	139.0
2009-03-25 00:00:00	YM	Futures	7035.5	7041.9	7019.9	7025.4	248.0
2009-03-25 01:00:00	YM	Futures	7025.4	7027.2	7011.6	7027.2	162.0

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

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