PREVIEW / futures_1hour / 2009-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-08.parquet
  size:    42 KB
  rows:    1,233

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-04-08 00:00:00	ES	Futures	770.42	772.1	770.18	772.1	3268.0
2009-04-08 01:00:00	ES	Futures	772.1	772.1	769.22	770.42	3398.0
2009-04-08 02:00:00	ES	Futures	770.66	771.38	769.22	769.94	8892.0
2009-04-08 03:00:00	ES	Futures	769.94	773.54	768.98	772.58	23062.0
2009-04-08 04:00:00	ES	Futures	772.58	774.5	770.9	774.26	15686.0
2009-04-08 05:00:00	ES	Futures	774.26	775.69	770.42	771.14	18361.0
2009-04-08 06:00:00	ES	Futures	771.38	777.13	769.94	775.69	19238.0
2009-04-08 07:00:00	ES	Futures	775.45	778.09	774.74	774.98	22426.0
2009-04-08 08:00:00	ES	Futures	774.98	784.32	774.74	782.88	65661.0
2009-04-08 09:00:00	ES	Futures	783.12	787.68	781.93	784.32	233264.0
2009-04-08 10:00:00	ES	Futures	784.32	784.56	777.37	781.21	375098.0
2009-04-08 11:00:00	ES	Futures	781.21	787.2	780.97	785.04	268309.0
2009-04-08 12:00:00	ES	Futures	784.8	791.03	783.12	789.59	185220.0
2009-04-08 13:00:00	ES	Futures	789.83	790.07	786.96	787.68	122084.0
2009-04-08 14:00:00	ES	Futures	787.68	788.16	780.25	782.16	243958.0
2009-04-08 15:00:00	ES	Futures	781.93	787.92	778.09	787.2	345099.0
2009-04-08 16:00:00	ES	Futures	787.44	790.55	786.48	790.31	87222.0
2009-04-08 17:00:00	ES	Futures	790.31	791.51	790.07	790.55	2930.0
2009-04-08 18:00:00	ES	Futures	790.55	791.27	789.11	789.59	2240.0
2009-04-08 19:00:00	ES	Futures	789.59	790.55	788.63	789.35	2024.0
2009-04-08 20:00:00	ES	Futures	789.35	793.43	789.11	793.19	6081.0
2009-04-08 21:00:00	ES	Futures	793.19	794.39	792.23	792.71	5019.0
2009-04-08 22:00:00	ES	Futures	792.47	793.19	790.07	791.51	3681.0
2009-04-08 23:00:00	ES	Futures	791.27	794.63	790.79	794.15	4061.0
2009-04-08 00:00:00	NQ	Futures	1443.71	1444.85	1442.29	1444.57	149.0
2009-04-08 01:00:00	NQ	Futures	1444.57	1444.57	1440.3	1442.86	302.0
2009-04-08 02:00:00	NQ	Futures	1442.86	1444.28	1440.02	1440.87	654.0
2009-04-08 03:00:00	NQ	Futures	1441.16	1447.98	1440.3	1446.27	1444.0
2009-04-08 04:00:00	NQ	Futures	1446.27	1448.54	1442.86	1447.98	1292.0
2009-04-08 05:00:00	NQ	Futures	1447.98	1451.95	1442.86	1443.71	1178.0
2009-04-08 06:00:00	NQ	Futures	1443.43	1454.8	1442.01	1451.67	1142.0
2009-04-08 07:00:00	NQ	Futures	1451.67	1456.5	1450.53	1454.8	3222.0
2009-04-08 08:00:00	NQ	Futures	1454.8	1470.14	1454.8	1467.01	7460.0
2009-04-08 09:00:00	NQ	Futures	1467.01	1475.54	1462.18	1472.13	35710.0
2009-04-08 10:00:00	NQ	Futures	1472.41	1472.98	1453.66	1459.06	51935.0
2009-04-08 11:00:00	NQ	Futures	1459.06	1474.4	1459.06	1470.14	36118.0
2009-04-08 12:00:00	NQ	Futures	1470.42	1484.06	1469.0	1480.94	29141.0
2009-04-08 13:00:00	NQ	Futures	1480.94	1481.51	1473.55	1476.39	18464.0
2009-04-08 14:00:00	NQ	Futures	1476.39	1476.96	1464.74	1467.58	29731.0
2009-04-08 15:00:00	NQ	Futures	1467.3	1476.67	1460.48	1475.54	42107.0
2009-04-08 16:00:00	NQ	Futures	1475.54	1480.08	1473.83	1478.95	8391.0
2009-04-08 17:00:00	NQ	Futures	1479.52	1480.65	1478.38	1478.66	228.0
2009-04-08 18:00:00	NQ	Futures	1478.66	1479.52	1477.24	1478.1	197.0
2009-04-08 19:00:00	NQ	Futures	1478.38	1479.23	1476.67	1478.66	180.0
2009-04-08 20:00:00	NQ	Futures	1478.1	1484.35	1477.81	1483.78	370.0
2009-04-08 21:00:00	NQ	Futures	1483.21	1485.48	1481.79	1482.36	213.0
2009-04-08 22:00:00	NQ	Futures	1482.36	1482.93	1478.1	1480.37	168.0
2009-04-08 23:00:00	NQ	Futures	1480.37	1486.34	1479.8	1486.05	182.0
2009-04-08 00:00:00	YM	Futures	7041.0	7053.9	7037.3	7050.2	455.0
2009-04-08 01:00:00	YM	Futures	7050.2	7051.1	7032.7	7042.8	357.0

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

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