PREVIEW / futures_1hour / 2012-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-25.parquet
  size:    49 KB
  rows:    1,472

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-01-25 00:00:00	ES	Futures	1324.45	1326.46	1324.45	1326.46	3328.0
2012-01-25 01:00:00	ES	Futures	1326.21	1326.72	1325.46	1326.21	3117.0
2012-01-25 02:00:00	ES	Futures	1326.46	1326.72	1324.2	1324.45	7565.0
2012-01-25 03:00:00	ES	Futures	1324.45	1325.2	1322.43	1322.94	20488.0
2012-01-25 04:00:00	ES	Futures	1322.94	1324.2	1318.65	1319.41	38466.0
2012-01-25 05:00:00	ES	Futures	1319.16	1319.91	1316.64	1317.14	35817.0
2012-01-25 06:00:00	ES	Futures	1316.89	1318.65	1316.13	1318.15	29197.0
2012-01-25 07:00:00	ES	Futures	1318.4	1318.91	1315.88	1317.65	30391.0
2012-01-25 08:00:00	ES	Futures	1317.65	1319.41	1317.14	1318.15	34377.0
2012-01-25 09:00:00	ES	Futures	1318.15	1319.16	1313.61	1314.37	191779.0
2012-01-25 10:00:00	ES	Futures	1314.37	1318.15	1313.36	1317.9	192248.0
2012-01-25 11:00:00	ES	Futures	1317.9	1320.17	1317.65	1318.91	161588.0
2012-01-25 12:00:00	ES	Futures	1318.91	1323.44	1316.39	1321.17	281348.0
2012-01-25 13:00:00	ES	Futures	1320.92	1331.25	1320.67	1330.75	262914.0
2012-01-25 14:00:00	ES	Futures	1330.75	1331.0	1324.95	1328.98	219566.0
2012-01-25 15:00:00	ES	Futures	1328.98	1335.28	1327.72	1332.01	311332.0
2012-01-25 16:00:00	ES	Futures	1332.01	1332.51	1330.5	1331.25	94169.0
2012-01-25 17:00:00	ES	Futures	1331.25	1331.5	1330.75	1331.25	1257.0
2012-01-25 18:00:00	ES	Futures	1331.25	1331.5	1328.98	1328.98	6557.0
2012-01-25 19:00:00	ES	Futures	1328.98	1330.24	1328.73	1329.99	2849.0
2012-01-25 20:00:00	ES	Futures	1329.99	1330.5	1328.98	1329.24	4149.0
2012-01-25 21:00:00	ES	Futures	1329.24	1330.5	1328.98	1329.49	3356.0
2012-01-25 22:00:00	ES	Futures	1329.49	1329.99	1328.73	1328.98	1895.0
2012-01-25 23:00:00	ES	Futures	1328.98	1330.5	1328.73	1329.99	1643.0
2012-01-25 00:00:00	NQ	Futures	2843.22	2846.11	2843.22	2845.53	146.0
2012-01-25 01:00:00	NQ	Futures	2845.53	2846.4	2844.09	2845.82	221.0
2012-01-25 02:00:00	NQ	Futures	2845.82	2845.82	2841.2	2842.06	888.0
2012-01-25 03:00:00	NQ	Futures	2842.06	2842.35	2836.29	2837.44	3186.0
2012-01-25 04:00:00	NQ	Futures	2837.44	2839.75	2827.91	2829.65	3611.0
2012-01-25 05:00:00	NQ	Futures	2829.65	2832.82	2825.6	2826.47	2363.0
2012-01-25 06:00:00	NQ	Futures	2826.47	2831.09	2824.45	2830.51	2114.0
2012-01-25 07:00:00	NQ	Futures	2830.22	2834.84	2829.94	2833.98	2904.0
2012-01-25 08:00:00	NQ	Futures	2833.69	2838.6	2830.8	2836.87	6171.0
2012-01-25 09:00:00	NQ	Futures	2836.58	2840.33	2818.67	2820.69	34013.0
2012-01-25 10:00:00	NQ	Futures	2820.98	2825.6	2814.92	2823.29	42590.0
2012-01-25 11:00:00	NQ	Futures	2823.58	2831.67	2822.72	2829.65	18175.0
2012-01-25 12:00:00	NQ	Futures	2829.36	2835.42	2821.85	2823.58	29475.0
2012-01-25 13:00:00	NQ	Futures	2823.58	2846.69	2823.0	2846.11	26384.0
2012-01-25 14:00:00	NQ	Futures	2845.82	2846.11	2833.11	2838.6	19806.0
2012-01-25 15:00:00	NQ	Futures	2838.6	2850.15	2836.87	2842.93	31463.0
2012-01-25 16:00:00	NQ	Futures	2842.93	2844.66	2839.18	2840.91	8934.0
2012-01-25 17:00:00	NQ	Futures	2841.2	2841.2	2840.04	2840.62	86.0
2012-01-25 18:00:00	NQ	Futures	2840.62	2840.91	2837.73	2838.31	264.0
2012-01-25 19:00:00	NQ	Futures	2838.31	2840.62	2838.31	2839.47	381.0
2012-01-25 20:00:00	NQ	Futures	2840.04	2840.62	2839.18	2839.75	187.0
2012-01-25 21:00:00	NQ	Futures	2839.47	2841.2	2839.18	2840.04	121.0
2012-01-25 22:00:00	NQ	Futures	2840.04	2840.04	2838.6	2838.89	57.0
2012-01-25 23:00:00	NQ	Futures	2838.89	2840.62	2838.6	2840.04	68.0
2012-01-25 00:00:00	YM	Futures	12530.9	12544.8	12529.9	12542.8	265.0
2012-01-25 01:00:00	YM	Futures	12541.8	12545.8	12538.9	12543.8	285.0

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

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