PREVIEW / futures_1hour / 2011-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-22.parquet
  size:    46 KB
  rows:    1,439

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-22 00:00:00	ES	Futures	1242.8	1243.31	1242.05	1242.8	2730.0
2011-12-22 01:00:00	ES	Futures	1242.8	1244.57	1242.55	1244.32	3068.0
2011-12-22 02:00:00	ES	Futures	1244.32	1247.84	1244.06	1246.08	6411.0
2011-12-22 03:00:00	ES	Futures	1246.33	1252.88	1245.58	1249.61	29754.0
2011-12-22 04:00:00	ES	Futures	1249.61	1254.14	1249.1	1253.64	17735.0
2011-12-22 05:00:00	ES	Futures	1253.89	1254.65	1250.11	1253.39	19010.0
2011-12-22 06:00:00	ES	Futures	1253.39	1253.39	1250.87	1251.88	10187.0
2011-12-22 07:00:00	ES	Futures	1252.13	1253.89	1251.12	1252.63	14495.0
2011-12-22 08:00:00	ES	Futures	1252.88	1255.91	1249.36	1251.12	56503.0
2011-12-22 09:00:00	ES	Futures	1251.12	1256.16	1248.85	1255.15	155061.0
2011-12-22 10:00:00	ES	Futures	1255.15	1256.66	1251.12	1253.39	224926.0
2011-12-22 11:00:00	ES	Futures	1253.39	1255.4	1252.13	1254.4	189823.0
2011-12-22 12:00:00	ES	Futures	1254.4	1258.68	1253.89	1257.92	124432.0
2011-12-22 13:00:00	ES	Futures	1257.67	1259.44	1256.92	1257.67	101166.0
2011-12-22 14:00:00	ES	Futures	1257.42	1259.18	1256.16	1256.66	68294.0
2011-12-22 15:00:00	ES	Futures	1256.66	1259.44	1256.16	1258.68	201234.0
2011-12-22 16:00:00	ES	Futures	1258.68	1261.7	1258.68	1260.95	79595.0
2011-12-22 17:00:00	ES	Futures	1260.95	1262.21	1259.94	1261.45	1890.0
2011-12-22 18:00:00	ES	Futures	1260.95	1263.47	1260.95	1262.96	3579.0
2011-12-22 19:00:00	ES	Futures	1263.22	1263.47	1262.21	1262.71	3963.0
2011-12-22 20:00:00	ES	Futures	1262.96	1266.74	1262.71	1266.24	10254.0
2011-12-22 21:00:00	ES	Futures	1266.24	1266.74	1265.48	1266.49	4339.0
2011-12-22 22:00:00	ES	Futures	1266.24	1266.49	1265.48	1265.74	2404.0
2011-12-22 23:00:00	ES	Futures	1265.48	1266.24	1265.48	1265.48	1036.0
2011-12-22 00:00:00	NQ	Futures	2582.15	2583.59	2581.28	2583.3	138.0
2011-12-22 01:00:00	NQ	Futures	2583.3	2587.92	2582.72	2587.34	249.0
2011-12-22 02:00:00	NQ	Futures	2587.06	2593.41	2586.77	2589.08	611.0
2011-12-22 03:00:00	NQ	Futures	2589.08	2599.76	2588.5	2593.12	2566.0
2011-12-22 04:00:00	NQ	Futures	2593.41	2603.81	2592.54	2602.94	1832.0
2011-12-22 05:00:00	NQ	Futures	2602.94	2604.38	2595.43	2602.36	1165.0
2011-12-22 06:00:00	NQ	Futures	2602.65	2602.94	2597.45	2597.74	1011.0
2011-12-22 07:00:00	NQ	Futures	2598.32	2601.78	2597.45	2599.76	860.0
2011-12-22 08:00:00	NQ	Futures	2600.05	2603.52	2592.83	2596.01	3780.0
2011-12-22 09:00:00	NQ	Futures	2596.3	2611.31	2594.28	2606.98	21848.0
2011-12-22 10:00:00	NQ	Futures	2606.98	2610.45	2598.03	2603.23	24225.0
2011-12-22 11:00:00	NQ	Futures	2602.94	2609.87	2602.36	2608.14	18511.0
2011-12-22 12:00:00	NQ	Futures	2608.14	2614.78	2607.27	2612.47	11055.0
2011-12-22 13:00:00	NQ	Futures	2612.76	2613.91	2610.74	2610.74	7929.0
2011-12-22 14:00:00	NQ	Futures	2610.74	2613.34	2608.72	2610.74	8443.0
2011-12-22 15:00:00	NQ	Futures	2610.74	2614.78	2609.58	2613.63	17428.0
2011-12-22 16:00:00	NQ	Futures	2613.34	2615.65	2611.03	2615.36	5541.0
2011-12-22 17:00:00	NQ	Futures	2615.36	2616.8	2614.2	2615.07	99.0
2011-12-22 18:00:00	NQ	Futures	2615.65	2619.69	2615.07	2619.11	236.0
2011-12-22 19:00:00	NQ	Futures	2619.11	2619.98	2618.25	2619.11	202.0
2011-12-22 20:00:00	NQ	Futures	2619.11	2626.91	2618.82	2625.47	531.0
2011-12-22 21:00:00	NQ	Futures	2625.75	2626.04	2624.31	2625.47	187.0
2011-12-22 22:00:00	NQ	Futures	2625.18	2625.47	2623.44	2624.02	99.0
2011-12-22 23:00:00	NQ	Futures	2624.02	2624.89	2623.16	2624.31	90.0
2011-12-22 00:00:00	YM	Futures	11890.7	11897.6	11887.7	11897.6	163.0
2011-12-22 01:00:00	YM	Futures	11896.6	11911.5	11893.6	11910.5	281.0

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

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