PREVIEW / futures_1hour / 2012-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-10.parquet
  size:    39 KB
  rows:    1,175

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
2012-08-10 00:00:00	ES	Futures	1419.41	1419.92	1418.65	1418.9	1918.0
2012-08-10 01:00:00	ES	Futures	1418.9	1419.41	1418.39	1418.65	4398.0
2012-08-10 02:00:00	ES	Futures	1418.65	1420.17	1418.39	1418.65	6842.0
2012-08-10 03:00:00	ES	Futures	1418.65	1419.41	1416.87	1418.39	25428.0
2012-08-10 04:00:00	ES	Futures	1418.65	1421.44	1418.39	1421.19	16689.0
2012-08-10 05:00:00	ES	Futures	1420.94	1421.19	1418.9	1419.92	12756.0
2012-08-10 06:00:00	ES	Futures	1419.66	1420.43	1417.88	1418.39	14878.0
2012-08-10 07:00:00	ES	Futures	1418.39	1418.9	1417.38	1417.88	15836.0
2012-08-10 08:00:00	ES	Futures	1417.88	1419.66	1417.38	1419.16	29516.0
2012-08-10 09:00:00	ES	Futures	1419.41	1419.92	1415.85	1418.14	167531.0
2012-08-10 10:00:00	ES	Futures	1418.14	1422.97	1417.12	1421.95	268176.0
2012-08-10 11:00:00	ES	Futures	1421.95	1422.46	1417.38	1421.95	213129.0
2012-08-10 12:00:00	ES	Futures	1421.7	1422.21	1420.43	1420.94	51515.0
2012-08-10 13:00:00	ES	Futures	1420.94	1422.46	1419.41	1421.95	58019.0
2012-08-10 14:00:00	ES	Futures	1421.95	1422.97	1420.68	1422.21	49194.0
2012-08-10 15:00:00	ES	Futures	1422.21	1426.78	1421.95	1426.53	206856.0
2012-08-10 16:00:00	ES	Futures	1426.28	1426.78	1425.51	1426.28	62913.0
2012-08-10 00:00:00	NQ	Futures	3143.8	3144.38	3142.06	3142.35	296.0
2012-08-10 01:00:00	NQ	Futures	3142.35	3144.09	3141.19	3142.06	428.0
2012-08-10 02:00:00	NQ	Futures	3142.35	3146.12	3141.48	3141.77	1116.0
2012-08-10 03:00:00	NQ	Futures	3142.06	3144.09	3137.71	3140.9	2621.0
2012-08-10 04:00:00	NQ	Futures	3141.48	3147.86	3141.19	3146.12	2074.0
2012-08-10 05:00:00	NQ	Futures	3146.12	3146.12	3142.35	3144.67	1532.0
2012-08-10 06:00:00	NQ	Futures	3144.38	3145.54	3140.9	3141.77	1267.0
2012-08-10 07:00:00	NQ	Futures	3141.77	3142.93	3139.16	3141.19	1321.0
2012-08-10 08:00:00	NQ	Futures	3141.19	3144.09	3138.58	3142.64	4024.0
2012-08-10 09:00:00	NQ	Futures	3142.93	3144.67	3133.37	3137.14	29406.0
2012-08-10 10:00:00	NQ	Futures	3137.14	3147.28	3135.69	3146.7	27551.0
2012-08-10 11:00:00	NQ	Futures	3146.99	3148.44	3137.71	3146.41	20761.0
2012-08-10 12:00:00	NQ	Futures	3146.41	3146.99	3142.35	3144.09	6650.0
2012-08-10 13:00:00	NQ	Futures	3144.09	3146.7	3141.48	3145.54	7332.0
2012-08-10 14:00:00	NQ	Futures	3145.83	3147.57	3143.51	3145.83	6180.0
2012-08-10 15:00:00	NQ	Futures	3145.83	3155.4	3145.25	3155.4	21938.0
2012-08-10 16:00:00	NQ	Futures	3155.4	3157.43	3154.53	3156.85	7069.0
2012-08-10 00:00:00	YM	Futures	13018.7	13021.7	13013.7	13016.7	242.0
2012-08-10 01:00:00	YM	Futures	13017.7	13021.7	13010.8	13015.7	381.0
2012-08-10 02:00:00	YM	Futures	13015.7	13027.7	13013.7	13015.7	705.0
2012-08-10 03:00:00	YM	Futures	13016.7	13021.7	12997.8	13012.8	1763.0
2012-08-10 04:00:00	YM	Futures	13014.7	13037.6	13012.8	13032.6	1365.0
2012-08-10 05:00:00	YM	Futures	13032.6	13033.6	13015.7	13024.7	932.0
2012-08-10 06:00:00	YM	Futures	13023.7	13027.7	13009.8	13012.8	963.0
2012-08-10 07:00:00	YM	Futures	13013.7	13015.7	13003.8	13008.8	1015.0
2012-08-10 08:00:00	YM	Futures	13009.8	13024.7	13007.8	13019.7	2814.0
2012-08-10 09:00:00	YM	Futures	13020.7	13025.7	12977.9	12990.9	14996.0
2012-08-10 10:00:00	YM	Futures	12990.9	13043.6	12984.9	13034.6	16792.0
2012-08-10 11:00:00	YM	Futures	13034.6	13039.6	12994.9	13036.6	12625.0
2012-08-10 12:00:00	YM	Futures	13036.6	13039.6	13023.7	13027.7	3790.0
2012-08-10 13:00:00	YM	Futures	13026.7	13043.6	13015.7	13037.6	4151.0
2012-08-10 14:00:00	YM	Futures	13038.6	13048.6	13030.7	13044.6	4027.0
2012-08-10 15:00:00	YM	Futures	13044.6	13092.3	13043.6	13089.3	14378.0

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

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