PREVIEW / futures_1hour / 2011-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-07.parquet
  size:    48 KB
  rows:    1,446

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-07 00:00:00	ES	Futures	1278.92	1280.16	1278.42	1279.67	6892.0
2011-06-07 01:00:00	ES	Futures	1279.42	1280.91	1278.18	1280.66	8505.0
2011-06-07 02:00:00	ES	Futures	1280.66	1282.15	1280.41	1281.9	17095.0
2011-06-07 03:00:00	ES	Futures	1281.65	1284.39	1281.16	1283.64	39989.0
2011-06-07 04:00:00	ES	Futures	1283.64	1285.13	1282.9	1284.39	21579.0
2011-06-07 05:00:00	ES	Futures	1284.39	1284.88	1281.9	1282.9	16697.0
2011-06-07 06:00:00	ES	Futures	1282.9	1285.63	1282.65	1283.89	29514.0
2011-06-07 07:00:00	ES	Futures	1283.89	1284.14	1281.9	1282.4	29404.0
2011-06-07 08:00:00	ES	Futures	1282.4	1284.39	1281.16	1284.39	50259.0
2011-06-07 09:00:00	ES	Futures	1284.39	1285.13	1280.16	1281.9	269615.0
2011-06-07 10:00:00	ES	Futures	1281.9	1286.62	1281.9	1285.38	344064.0
2011-06-07 11:00:00	ES	Futures	1285.63	1285.88	1281.16	1283.39	241591.0
2011-06-07 12:00:00	ES	Futures	1283.14	1284.63	1281.65	1284.39	108197.0
2011-06-07 13:00:00	ES	Futures	1284.14	1285.63	1283.39	1284.14	87887.0
2011-06-07 14:00:00	ES	Futures	1284.39	1287.37	1283.39	1284.63	140265.0
2011-06-07 15:00:00	ES	Futures	1284.63	1285.38	1275.19	1275.94	425380.0
2011-06-07 16:00:00	ES	Futures	1275.69	1277.93	1274.45	1277.68	128836.0
2011-06-07 17:00:00	ES	Futures	1277.43	1279.17	1277.18	1278.92	3889.0
2011-06-07 18:00:00	ES	Futures	1278.92	1279.42	1277.93	1278.18	4934.0
2011-06-07 19:00:00	ES	Futures	1278.18	1279.17	1278.18	1278.67	1636.0
2011-06-07 20:00:00	ES	Futures	1278.67	1279.67	1276.19	1276.44	8174.0
2011-06-07 21:00:00	ES	Futures	1276.68	1276.93	1273.95	1274.2	9959.0
2011-06-07 22:00:00	ES	Futures	1273.95	1274.7	1272.96	1273.45	9884.0
2011-06-07 23:00:00	ES	Futures	1273.7	1274.95	1273.45	1274.45	3946.0
2011-06-07 00:00:00	NQ	Futures	2615.71	2618.01	2615.14	2616.86	310.0
2011-06-07 01:00:00	NQ	Futures	2616.86	2619.16	2614.28	2618.87	754.0
2011-06-07 02:00:00	NQ	Futures	2618.87	2622.03	2618.59	2620.31	674.0
2011-06-07 03:00:00	NQ	Futures	2620.6	2625.77	2618.87	2624.62	2579.0
2011-06-07 04:00:00	NQ	Futures	2624.33	2627.21	2622.61	2624.91	1897.0
2011-06-07 05:00:00	NQ	Futures	2624.91	2625.77	2620.31	2622.32	1235.0
2011-06-07 06:00:00	NQ	Futures	2622.61	2627.21	2622.03	2624.91	1791.0
2011-06-07 07:00:00	NQ	Futures	2624.62	2624.62	2620.31	2621.17	2308.0
2011-06-07 08:00:00	NQ	Futures	2620.89	2624.62	2618.3	2624.62	3842.0
2011-06-07 09:00:00	NQ	Futures	2624.33	2626.34	2612.27	2617.44	41279.0
2011-06-07 10:00:00	NQ	Futures	2617.15	2627.21	2616.86	2625.2	42816.0
2011-06-07 11:00:00	NQ	Futures	2625.2	2626.06	2613.13	2617.44	24475.0
2011-06-07 12:00:00	NQ	Futures	2617.15	2618.01	2612.55	2617.44	14697.0
2011-06-07 13:00:00	NQ	Futures	2617.73	2624.05	2616.58	2621.17	12398.0
2011-06-07 14:00:00	NQ	Futures	2621.17	2629.79	2619.74	2621.75	18127.0
2011-06-07 15:00:00	NQ	Futures	2621.75	2624.05	2606.52	2607.96	34957.0
2011-06-07 16:00:00	NQ	Futures	2607.96	2615.71	2606.52	2614.56	10921.0
2011-06-07 17:00:00	NQ	Futures	2614.85	2617.44	2614.28	2617.15	225.0
2011-06-07 18:00:00	NQ	Futures	2616.86	2618.01	2615.43	2615.71	297.0
2011-06-07 19:00:00	NQ	Futures	2615.71	2617.73	2615.43	2616.58	147.0
2011-06-07 20:00:00	NQ	Futures	2616.58	2618.01	2611.12	2611.69	511.0
2011-06-07 21:00:00	NQ	Futures	2611.98	2611.98	2605.37	2605.66	1438.0
2011-06-07 22:00:00	NQ	Futures	2605.37	2606.52	2603.07	2603.93	1429.0
2011-06-07 23:00:00	NQ	Futures	2604.22	2606.23	2604.22	2605.37	970.0
2011-06-07 00:00:00	YM	Futures	11656.5	11666.1	11653.6	11662.3	241.0
2011-06-07 01:00:00	YM	Futures	11659.4	11669.0	11649.8	11669.0	423.0

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

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