PREVIEW / futures_1hour / 2011-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-23.parquet
  size:    48 KB
  rows:    1,455

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-03-23 00:00:00	ES	Futures	1277.68	1278.67	1276.93	1277.68	3271.0
2011-03-23 01:00:00	ES	Futures	1277.93	1278.42	1274.95	1275.69	7465.0
2011-03-23 02:00:00	ES	Futures	1275.94	1278.18	1274.95	1277.43	5256.0
2011-03-23 03:00:00	ES	Futures	1277.43	1278.67	1275.44	1276.19	13571.0
2011-03-23 04:00:00	ES	Futures	1275.94	1279.42	1275.94	1277.43	20203.0
2011-03-23 05:00:00	ES	Futures	1277.18	1285.63	1276.44	1283.89	40188.0
2011-03-23 06:00:00	ES	Futures	1283.89	1285.38	1283.14	1283.89	15189.0
2011-03-23 07:00:00	ES	Futures	1284.14	1284.39	1277.43	1277.93	46409.0
2011-03-23 08:00:00	ES	Futures	1277.93	1279.91	1276.44	1277.18	54649.0
2011-03-23 09:00:00	ES	Futures	1276.93	1278.92	1273.45	1276.68	233184.0
2011-03-23 10:00:00	ES	Futures	1276.44	1276.68	1270.97	1272.96	276244.0
2011-03-23 11:00:00	ES	Futures	1273.21	1277.43	1272.96	1275.94	234676.0
2011-03-23 12:00:00	ES	Futures	1275.94	1280.91	1274.95	1279.42	204746.0
2011-03-23 13:00:00	ES	Futures	1279.67	1283.64	1278.42	1282.15	164268.0
2011-03-23 14:00:00	ES	Futures	1282.4	1286.37	1280.91	1285.63	173339.0
2011-03-23 15:00:00	ES	Futures	1285.38	1287.86	1284.14	1284.14	309478.0
2011-03-23 16:00:00	ES	Futures	1284.39	1285.13	1282.9	1283.39	102017.0
2011-03-23 17:00:00	ES	Futures	1283.14	1283.39	1281.4	1281.65	7081.0
2011-03-23 18:00:00	ES	Futures	1281.4	1284.39	1281.4	1283.89	5952.0
2011-03-23 19:00:00	ES	Futures	1283.89	1285.13	1283.39	1284.14	3552.0
2011-03-23 20:00:00	ES	Futures	1284.14	1285.13	1282.4	1283.39	6407.0
2011-03-23 21:00:00	ES	Futures	1283.39	1284.63	1282.4	1282.9	5815.0
2011-03-23 22:00:00	ES	Futures	1282.65	1284.39	1281.65	1284.14	4728.0
2011-03-23 23:00:00	ES	Futures	1283.89	1284.14	1282.65	1283.39	2014.0
2011-03-23 00:00:00	NQ	Futures	2587.56	2588.71	2586.7	2588.42	173.0
2011-03-23 01:00:00	NQ	Futures	2588.42	2588.71	2581.52	2582.96	465.0
2011-03-23 02:00:00	NQ	Futures	2583.25	2588.13	2582.39	2586.98	269.0
2011-03-23 03:00:00	NQ	Futures	2586.7	2589.57	2578.65	2580.66	1714.0
2011-03-23 04:00:00	NQ	Futures	2580.66	2587.84	2577.79	2580.37	2425.0
2011-03-23 05:00:00	NQ	Futures	2580.37	2599.62	2577.79	2596.75	4327.0
2011-03-23 06:00:00	NQ	Futures	2596.18	2599.05	2595.03	2596.46	749.0
2011-03-23 07:00:00	NQ	Futures	2596.75	2597.33	2582.96	2583.82	3836.0
2011-03-23 08:00:00	NQ	Futures	2583.53	2588.13	2582.39	2582.67	5080.0
2011-03-23 09:00:00	NQ	Futures	2582.67	2586.98	2573.19	2581.24	39629.0
2011-03-23 10:00:00	NQ	Futures	2580.95	2582.39	2565.15	2573.48	42497.0
2011-03-23 11:00:00	NQ	Futures	2573.77	2591.29	2573.77	2586.7	37250.0
2011-03-23 12:00:00	NQ	Futures	2586.41	2599.91	2585.55	2594.74	27900.0
2011-03-23 13:00:00	NQ	Futures	2594.74	2601.06	2591.58	2598.19	21885.0
2011-03-23 14:00:00	NQ	Futures	2598.47	2611.98	2594.45	2609.39	33148.0
2011-03-23 15:00:00	NQ	Futures	2609.68	2614.28	2605.66	2606.52	43248.0
2011-03-23 16:00:00	NQ	Futures	2606.23	2607.67	2600.49	2602.78	9733.0
2011-03-23 17:00:00	NQ	Futures	2603.07	2603.07	2600.49	2600.49	203.0
2011-03-23 18:00:00	NQ	Futures	2600.49	2604.22	2599.91	2603.36	282.0
2011-03-23 19:00:00	NQ	Futures	2603.36	2605.37	2602.5	2604.51	208.0
2011-03-23 20:00:00	NQ	Futures	2604.22	2606.23	2602.21	2603.65	635.0
2011-03-23 21:00:00	NQ	Futures	2603.36	2605.08	2601.06	2602.5	317.0
2011-03-23 22:00:00	NQ	Futures	2602.5	2604.51	2600.49	2604.22	269.0
2011-03-23 23:00:00	NQ	Futures	2603.65	2604.22	2601.64	2603.07	161.0
2011-03-23 00:00:00	YM	Futures	11490.8	11500.5	11488.9	11493.7	133.0
2011-03-23 01:00:00	YM	Futures	11493.7	11499.5	11476.4	11481.2	736.0

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

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