PREVIEW / futures_1hour / 2011-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-06.parquet
  size:    46 KB
  rows:    1,417

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-06-06 00:00:00	ES	Futures	1288.11	1288.86	1287.62	1288.11	2132.0
2011-06-06 01:00:00	ES	Futures	1288.11	1288.86	1286.62	1288.36	5339.0
2011-06-06 02:00:00	ES	Futures	1288.36	1288.86	1287.12	1288.36	8646.0
2011-06-06 03:00:00	ES	Futures	1288.36	1289.35	1286.62	1287.37	31533.0
2011-06-06 04:00:00	ES	Futures	1287.12	1289.35	1285.13	1287.12	32188.0
2011-06-06 05:00:00	ES	Futures	1286.87	1289.35	1286.37	1287.86	14272.0
2011-06-06 06:00:00	ES	Futures	1287.86	1288.11	1284.63	1285.38	23424.0
2011-06-06 07:00:00	ES	Futures	1285.38	1286.37	1284.14	1284.39	30403.0
2011-06-06 08:00:00	ES	Futures	1284.39	1289.35	1284.39	1288.11	64653.0
2011-06-06 09:00:00	ES	Futures	1288.11	1290.1	1285.13	1286.37	226862.0
2011-06-06 10:00:00	ES	Futures	1286.62	1286.87	1281.9	1283.14	354249.0
2011-06-06 11:00:00	ES	Futures	1283.14	1288.11	1282.65	1287.12	214230.0
2011-06-06 12:00:00	ES	Futures	1287.12	1287.86	1284.39	1285.38	109459.0
2011-06-06 13:00:00	ES	Futures	1285.38	1286.87	1280.41	1281.65	189243.0
2011-06-06 14:00:00	ES	Futures	1281.9	1283.89	1278.18	1279.17	181388.0
2011-06-06 15:00:00	ES	Futures	1279.42	1280.66	1275.19	1277.18	489260.0
2011-06-06 16:00:00	ES	Futures	1276.93	1277.68	1276.19	1276.93	107037.0
2011-06-06 17:00:00	ES	Futures	1276.68	1276.93	1275.69	1276.44	2404.0
2011-06-06 18:00:00	ES	Futures	1276.44	1277.93	1276.19	1276.93	5084.0
2011-06-06 19:00:00	ES	Futures	1277.18	1277.68	1276.68	1276.93	3626.0
2011-06-06 20:00:00	ES	Futures	1276.93	1277.68	1275.94	1277.43	4791.0
2011-06-06 21:00:00	ES	Futures	1277.43	1277.43	1275.94	1277.18	6260.0
2011-06-06 22:00:00	ES	Futures	1276.93	1277.68	1276.68	1277.68	2784.0
2011-06-06 23:00:00	ES	Futures	1277.68	1278.92	1277.18	1278.92	6885.0
2011-06-06 00:00:00	NQ	Futures	2629.79	2631.8	2628.93	2629.79	393.0
2011-06-06 01:00:00	NQ	Futures	2629.79	2630.94	2626.92	2630.65	346.0
2011-06-06 02:00:00	NQ	Futures	2629.5	2630.94	2627.49	2630.94	514.0
2011-06-06 03:00:00	NQ	Futures	2630.65	2633.53	2626.34	2628.64	3100.0
2011-06-06 04:00:00	NQ	Futures	2628.64	2633.24	2624.05	2628.64	3733.0
2011-06-06 05:00:00	NQ	Futures	2628.36	2632.67	2627.21	2630.37	2452.0
2011-06-06 06:00:00	NQ	Futures	2630.65	2630.94	2616.58	2621.75	4490.0
2011-06-06 07:00:00	NQ	Futures	2622.03	2624.62	2620.31	2620.6	1711.0
2011-06-06 08:00:00	NQ	Futures	2620.89	2632.09	2620.89	2629.79	3553.0
2011-06-06 09:00:00	NQ	Futures	2629.79	2639.56	2627.78	2638.99	30341.0
2011-06-06 10:00:00	NQ	Futures	2638.99	2639.56	2628.07	2630.37	33457.0
2011-06-06 11:00:00	NQ	Futures	2630.08	2642.43	2629.22	2636.98	20330.0
2011-06-06 12:00:00	NQ	Futures	2636.69	2638.12	2630.37	2632.95	11934.0
2011-06-06 13:00:00	NQ	Futures	2632.95	2639.56	2621.75	2623.76	25211.0
2011-06-06 14:00:00	NQ	Futures	2624.05	2630.37	2616.86	2619.74	19273.0
2011-06-06 15:00:00	NQ	Futures	2619.45	2622.9	2611.69	2612.84	44557.0
2011-06-06 16:00:00	NQ	Futures	2612.55	2615.14	2610.25	2612.27	11909.0
2011-06-06 17:00:00	NQ	Futures	2612.27	2612.27	2609.68	2611.69	171.0
2011-06-06 18:00:00	NQ	Futures	2611.69	2613.42	2610.54	2611.12	557.0
2011-06-06 19:00:00	NQ	Futures	2611.69	2613.13	2611.4	2611.69	370.0
2011-06-06 20:00:00	NQ	Futures	2611.4	2613.13	2610.25	2612.55	212.0
2011-06-06 21:00:00	NQ	Futures	2612.27	2612.55	2610.25	2612.27	390.0
2011-06-06 22:00:00	NQ	Futures	2612.27	2613.7	2612.27	2613.7	146.0
2011-06-06 23:00:00	NQ	Futures	2613.42	2615.71	2612.84	2615.71	431.0
2011-06-06 00:00:00	YM	Futures	11677.7	11683.5	11674.8	11677.7	211.0
2011-06-06 01:00:00	YM	Futures	11676.7	11679.6	11665.2	11673.8	477.0

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

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