PREVIEW / futures_1hour / 2011-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-03.parquet
  size:    45 KB
  rows:    1,326

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-01-03 00:00:00	ES	Futures	1247.03	1247.28	1246.79	1247.03	937.0
2011-01-03 01:00:00	ES	Futures	1246.79	1247.53	1246.29	1247.53	2860.0
2011-01-03 02:00:00	ES	Futures	1247.53	1248.52	1245.55	1247.03	11322.0
2011-01-03 03:00:00	ES	Futures	1246.79	1248.52	1245.55	1247.77	25430.0
2011-01-03 04:00:00	ES	Futures	1247.77	1247.77	1246.04	1247.53	13073.0
2011-01-03 05:00:00	ES	Futures	1247.53	1248.52	1247.28	1248.27	15072.0
2011-01-03 06:00:00	ES	Futures	1248.27	1248.52	1247.53	1247.53	7398.0
2011-01-03 07:00:00	ES	Futures	1247.53	1251.24	1246.79	1250.25	41205.0
2011-01-03 08:00:00	ES	Futures	1250.5	1250.99	1249.51	1250.0	24718.0
2011-01-03 09:00:00	ES	Futures	1250.0	1254.7	1249.51	1254.7	213674.0
2011-01-03 10:00:00	ES	Futures	1254.46	1257.67	1252.72	1257.18	246162.0
2011-01-03 11:00:00	ES	Futures	1257.18	1259.4	1256.43	1257.92	202994.0
2011-01-03 12:00:00	ES	Futures	1258.17	1258.91	1256.68	1257.42	107822.0
2011-01-03 13:00:00	ES	Futures	1257.42	1257.92	1256.68	1257.67	80030.0
2011-01-03 14:00:00	ES	Futures	1257.67	1258.17	1255.2	1256.19	125666.0
2011-01-03 15:00:00	ES	Futures	1256.43	1256.43	1253.47	1253.71	321858.0
2011-01-03 16:00:00	ES	Futures	1253.47	1253.96	1251.49	1252.48	132580.0
2011-01-03 17:00:00	ES	Futures	1252.48	1252.72	1251.98	1251.98	1281.0
2011-01-03 18:00:00	ES	Futures	1252.23	1253.22	1251.98	1252.72	4775.0
2011-01-03 19:00:00	ES	Futures	1252.72	1252.72	1251.73	1252.23	3219.0
2011-01-03 20:00:00	ES	Futures	1252.23	1252.97	1252.23	1252.72	2837.0
2011-01-03 21:00:00	ES	Futures	1252.72	1253.96	1252.72	1253.71	2874.0
2011-01-03 22:00:00	ES	Futures	1253.47	1253.96	1253.22	1253.22	1694.0
2011-01-03 23:00:00	ES	Futures	1252.97	1253.47	1252.97	1253.22	1244.0
2011-01-03 00:00:00	NQ	Futures	2558.03	2558.32	2556.89	2557.17	183.0
2011-01-03 01:00:00	NQ	Futures	2557.46	2558.61	2556.89	2558.61	226.0
2011-01-03 02:00:00	NQ	Futures	2558.89	2560.33	2555.74	2557.17	716.0
2011-01-03 03:00:00	NQ	Futures	2556.6	2564.35	2555.74	2561.76	2560.0
2011-01-03 04:00:00	NQ	Futures	2561.76	2562.05	2558.61	2561.48	1493.0
2011-01-03 05:00:00	NQ	Futures	2561.48	2567.22	2561.19	2566.64	2811.0
2011-01-03 06:00:00	NQ	Futures	2566.93	2567.22	2564.63	2564.63	1084.0
2011-01-03 07:00:00	NQ	Futures	2564.35	2573.25	2563.2	2570.95	4045.0
2011-01-03 08:00:00	NQ	Futures	2571.24	2572.1	2568.37	2569.51	3592.0
2011-01-03 09:00:00	NQ	Futures	2569.51	2589.03	2568.65	2587.6	61531.0
2011-01-03 10:00:00	NQ	Futures	2587.6	2601.38	2585.3	2600.51	55417.0
2011-01-03 11:00:00	NQ	Futures	2600.51	2603.67	2596.5	2598.79	28485.0
2011-01-03 12:00:00	NQ	Futures	2598.5	2600.51	2591.33	2592.76	19537.0
2011-01-03 13:00:00	NQ	Futures	2592.76	2593.63	2590.18	2592.48	14956.0
2011-01-03 14:00:00	NQ	Futures	2592.48	2594.49	2585.88	2587.88	21705.0
2011-01-03 15:00:00	NQ	Futures	2587.6	2589.03	2582.72	2585.88	42883.0
2011-01-03 16:00:00	NQ	Futures	2585.59	2588.17	2581.28	2584.15	13194.0
2011-01-03 17:00:00	NQ	Futures	2584.73	2584.73	2583.87	2584.15	77.0
2011-01-03 18:00:00	NQ	Futures	2584.73	2586.16	2584.15	2585.01	348.0
2011-01-03 19:00:00	NQ	Futures	2584.44	2584.73	2583.29	2584.44	146.0
2011-01-03 20:00:00	NQ	Futures	2584.44	2585.59	2584.15	2584.44	118.0
2011-01-03 21:00:00	NQ	Futures	2585.01	2587.88	2584.73	2586.74	161.0
2011-01-03 22:00:00	NQ	Futures	2586.74	2587.88	2586.16	2586.45	169.0
2011-01-03 23:00:00	NQ	Futures	2586.45	2587.6	2586.45	2587.31	303.0
2011-01-03 00:00:00	YM	Futures	11090.2	11092.1	11087.3	11087.3	62.0
2011-01-03 01:00:00	YM	Futures	11088.2	11094.0	11083.5	11094.0	60.0

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

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