PREVIEW / futures_1hour / 2011-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-25.parquet
  size:    47 KB
  rows:    1,425

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
2011-07-25 00:00:00	ES	Futures	1324.34	1325.34	1322.6	1323.84	4720.0
2011-07-25 01:00:00	ES	Futures	1324.09	1325.34	1322.35	1325.09	5904.0
2011-07-25 02:00:00	ES	Futures	1325.09	1326.34	1323.6	1324.09	15033.0
2011-07-25 03:00:00	ES	Futures	1324.09	1327.34	1323.35	1326.84	32296.0
2011-07-25 04:00:00	ES	Futures	1326.59	1329.08	1325.59	1327.84	23095.0
2011-07-25 05:00:00	ES	Futures	1327.84	1328.58	1326.84	1327.84	11040.0
2011-07-25 06:00:00	ES	Futures	1327.84	1328.33	1325.59	1326.84	13855.0
2011-07-25 07:00:00	ES	Futures	1327.09	1328.83	1326.84	1327.59	22118.0
2011-07-25 08:00:00	ES	Futures	1327.84	1329.33	1326.84	1327.34	45622.0
2011-07-25 09:00:00	ES	Futures	1327.09	1329.08	1323.6	1328.83	279096.0
2011-07-25 10:00:00	ES	Futures	1328.58	1333.57	1328.58	1331.33	276522.0
2011-07-25 11:00:00	ES	Futures	1331.08	1334.57	1330.08	1333.07	185787.0
2011-07-25 12:00:00	ES	Futures	1333.07	1336.31	1332.57	1335.32	88077.0
2011-07-25 13:00:00	ES	Futures	1335.32	1337.06	1334.32	1334.32	74705.0
2011-07-25 14:00:00	ES	Futures	1334.57	1336.56	1332.57	1333.32	113795.0
2011-07-25 15:00:00	ES	Futures	1333.07	1333.57	1329.83	1330.58	274386.0
2011-07-25 16:00:00	ES	Futures	1330.58	1333.82	1329.08	1330.33	91824.0
2011-07-25 17:00:00	ES	Futures	1330.33	1331.08	1329.33	1329.58	1800.0
2011-07-25 18:00:00	ES	Futures	1330.08	1330.58	1327.84	1328.33	7098.0
2011-07-25 19:00:00	ES	Futures	1328.33	1329.08	1328.08	1328.83	3055.0
2011-07-25 20:00:00	ES	Futures	1328.83	1328.83	1326.34	1328.33	7572.0
2011-07-25 21:00:00	ES	Futures	1328.33	1328.58	1323.84	1325.59	19709.0
2011-07-25 22:00:00	ES	Futures	1325.59	1329.83	1325.34	1328.83	9079.0
2011-07-25 23:00:00	ES	Futures	1328.83	1333.57	1328.08	1332.32	10479.0
2011-07-25 00:00:00	NQ	Futures	2764.85	2766.58	2760.82	2764.27	351.0
2011-07-25 01:00:00	NQ	Futures	2764.56	2766.58	2760.53	2765.71	348.0
2011-07-25 02:00:00	NQ	Futures	2765.71	2770.89	2765.71	2767.44	1399.0
2011-07-25 03:00:00	NQ	Futures	2767.44	2777.22	2766.29	2776.07	5930.0
2011-07-25 04:00:00	NQ	Futures	2776.07	2782.98	2773.77	2778.66	3512.0
2011-07-25 05:00:00	NQ	Futures	2778.66	2781.83	2776.94	2779.81	2392.0
2011-07-25 06:00:00	NQ	Futures	2780.1	2780.39	2774.92	2777.51	2145.0
2011-07-25 07:00:00	NQ	Futures	2777.51	2781.83	2776.94	2778.95	2221.0
2011-07-25 08:00:00	NQ	Futures	2778.66	2780.68	2775.5	2776.07	4010.0
2011-07-25 09:00:00	NQ	Futures	2776.36	2782.11	2765.14	2780.96	43223.0
2011-07-25 10:00:00	NQ	Futures	2780.68	2791.04	2778.66	2783.84	28479.0
2011-07-25 11:00:00	NQ	Futures	2783.55	2795.06	2782.11	2791.9	18520.0
2011-07-25 12:00:00	NQ	Futures	2791.9	2802.26	2790.75	2799.67	13950.0
2011-07-25 13:00:00	NQ	Futures	2799.67	2801.4	2793.91	2795.35	9290.0
2011-07-25 14:00:00	NQ	Futures	2795.06	2800.53	2792.19	2792.47	12586.0
2011-07-25 15:00:00	NQ	Futures	2792.47	2793.05	2783.84	2787.58	28363.0
2011-07-25 16:00:00	NQ	Futures	2787.29	2794.78	2787.29	2792.19	7999.0
2011-07-25 17:00:00	NQ	Futures	2792.47	2793.34	2790.75	2790.75	173.0
2011-07-25 18:00:00	NQ	Futures	2791.04	2792.47	2786.43	2786.72	236.0
2011-07-25 19:00:00	NQ	Futures	2786.43	2789.02	2786.14	2788.45	180.0
2011-07-25 20:00:00	NQ	Futures	2788.45	2788.45	2781.25	2786.72	577.0
2011-07-25 21:00:00	NQ	Futures	2786.72	2787.01	2777.22	2781.83	1428.0
2011-07-25 22:00:00	NQ	Futures	2781.83	2789.88	2781.83	2787.58	303.0
2011-07-25 23:00:00	NQ	Futures	2787.29	2796.79	2787.01	2793.91	690.0
2011-07-25 00:00:00	YM	Futures	12103.1	12109.8	12090.5	12102.1	409.0
2011-07-25 01:00:00	YM	Futures	12102.1	12109.8	12087.6	12106.9	519.0

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

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