PREVIEW / futures_1hour / 2011-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-01.parquet
  size:    48 KB
  rows:    1,468

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-12-01 00:00:00	ES	Futures	1251.28	1251.78	1246.02	1247.52	8914.0
2011-12-01 01:00:00	ES	Futures	1247.77	1248.27	1247.02	1248.27	5159.0
2011-12-01 02:00:00	ES	Futures	1248.02	1248.52	1244.76	1245.01	13131.0
2011-12-01 03:00:00	ES	Futures	1245.01	1245.52	1239.5	1243.01	51542.0
2011-12-01 04:00:00	ES	Futures	1243.01	1246.52	1240.75	1246.02	41187.0
2011-12-01 05:00:00	ES	Futures	1246.02	1248.52	1244.26	1248.02	31466.0
2011-12-01 06:00:00	ES	Futures	1247.77	1248.02	1243.26	1246.02	26813.0
2011-12-01 07:00:00	ES	Futures	1246.02	1249.78	1245.77	1248.78	36554.0
2011-12-01 08:00:00	ES	Futures	1248.78	1251.78	1245.26	1247.52	69330.0
2011-12-01 09:00:00	ES	Futures	1247.52	1252.29	1245.26	1251.53	249514.0
2011-12-01 10:00:00	ES	Futures	1251.78	1254.79	1246.77	1247.52	424990.0
2011-12-01 11:00:00	ES	Futures	1247.27	1249.53	1242.51	1247.27	367428.0
2011-12-01 12:00:00	ES	Futures	1247.27	1248.27	1242.76	1243.01	133266.0
2011-12-01 13:00:00	ES	Futures	1243.01	1251.78	1242.76	1251.53	135455.0
2011-12-01 14:00:00	ES	Futures	1251.28	1251.78	1247.77	1249.03	113974.0
2011-12-01 15:00:00	ES	Futures	1249.03	1251.03	1245.01	1248.02	251048.0
2011-12-01 16:00:00	ES	Futures	1247.77	1248.27	1246.27	1247.02	72904.0
2011-12-01 17:00:00	ES	Futures	1247.02	1248.02	1246.52	1247.27	1187.0
2011-12-01 18:00:00	ES	Futures	1247.02	1248.02	1246.02	1247.52	4162.0
2011-12-01 19:00:00	ES	Futures	1247.77	1251.28	1247.52	1250.53	6794.0
2011-12-01 20:00:00	ES	Futures	1250.53	1251.03	1248.02	1249.53	7377.0
2011-12-01 21:00:00	ES	Futures	1249.53	1250.28	1248.02	1248.52	2479.0
2011-12-01 22:00:00	ES	Futures	1248.52	1248.78	1247.52	1248.52	2816.0
2011-12-01 23:00:00	ES	Futures	1248.52	1252.79	1248.27	1252.29	5788.0
2011-12-01 00:00:00	NQ	Futures	2656.6	2656.6	2646.8	2649.11	453.0
2011-12-01 01:00:00	NQ	Futures	2649.11	2651.13	2648.53	2650.55	252.0
2011-12-01 02:00:00	NQ	Futures	2650.55	2652.28	2645.36	2645.36	930.0
2011-12-01 03:00:00	NQ	Futures	2645.36	2645.36	2634.98	2639.59	3840.0
2011-12-01 04:00:00	NQ	Futures	2639.3	2646.22	2634.11	2645.07	2952.0
2011-12-01 05:00:00	NQ	Futures	2645.07	2651.13	2642.76	2649.68	2411.0
2011-12-01 06:00:00	NQ	Futures	2649.68	2649.68	2639.3	2646.51	1612.0
2011-12-01 07:00:00	NQ	Futures	2646.51	2651.7	2644.78	2649.97	2058.0
2011-12-01 08:00:00	NQ	Futures	2650.26	2655.16	2643.34	2647.09	4912.0
2011-12-01 09:00:00	NQ	Futures	2647.38	2664.68	2643.05	2661.5	31043.0
2011-12-01 10:00:00	NQ	Futures	2662.37	2668.42	2647.67	2649.11	40608.0
2011-12-01 11:00:00	NQ	Futures	2649.4	2656.89	2643.05	2656.03	37189.0
2011-12-01 12:00:00	NQ	Futures	2656.31	2660.35	2649.68	2650.55	15778.0
2011-12-01 13:00:00	NQ	Futures	2650.55	2666.69	2649.97	2666.12	11880.0
2011-12-01 14:00:00	NQ	Futures	2666.12	2666.98	2658.33	2662.95	16046.0
2011-12-01 15:00:00	NQ	Futures	2662.95	2670.44	2658.91	2662.95	39964.0
2011-12-01 16:00:00	NQ	Futures	2662.95	2666.41	2660.35	2662.95	9049.0
2011-12-01 17:00:00	NQ	Futures	2662.95	2664.68	2662.66	2663.81	116.0
2011-12-01 18:00:00	NQ	Futures	2663.81	2665.25	2662.66	2663.81	291.0
2011-12-01 19:00:00	NQ	Futures	2664.1	2669.87	2663.52	2668.71	415.0
2011-12-01 20:00:00	NQ	Futures	2669.0	2670.15	2665.54	2669.29	615.0
2011-12-01 21:00:00	NQ	Futures	2669.58	2670.44	2667.56	2668.14	332.0
2011-12-01 22:00:00	NQ	Futures	2668.14	2668.71	2665.54	2667.56	176.0
2011-12-01 23:00:00	NQ	Futures	2667.56	2674.48	2666.98	2673.33	459.0
2011-12-01 00:00:00	YM	Futures	11871.8	11871.8	11828.5	11838.4	547.0
2011-12-01 01:00:00	YM	Futures	11838.4	11846.2	11834.4	11846.2	452.0

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

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