PREVIEW / futures_1hour / 2011-12-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1246.33	1247.09	1246.08	1246.84	3923.0
2011-12-21 01:00:00	ES	Futures	1246.84	1248.6	1246.58	1247.59	4851.0
2011-12-21 02:00:00	ES	Futures	1247.59	1252.88	1247.09	1252.13	14375.0
2011-12-21 03:00:00	ES	Futures	1252.13	1253.39	1250.62	1252.13	22147.0
2011-12-21 04:00:00	ES	Futures	1252.38	1253.39	1250.36	1251.88	19239.0
2011-12-21 05:00:00	ES	Futures	1252.13	1258.93	1250.87	1251.88	66067.0
2011-12-21 06:00:00	ES	Futures	1251.88	1254.4	1246.58	1248.85	41015.0
2011-12-21 07:00:00	ES	Futures	1248.85	1250.11	1242.55	1244.57	46318.0
2011-12-21 08:00:00	ES	Futures	1244.32	1245.58	1238.77	1244.57	73558.0
2011-12-21 09:00:00	ES	Futures	1244.57	1246.08	1236.76	1238.27	266207.0
2011-12-21 10:00:00	ES	Futures	1238.02	1243.31	1236.0	1238.27	302409.0
2011-12-21 11:00:00	ES	Futures	1238.52	1238.77	1234.99	1237.26	232959.0
2011-12-21 12:00:00	ES	Futures	1237.26	1239.28	1232.73	1238.77	201509.0
2011-12-21 13:00:00	ES	Futures	1238.52	1241.54	1236.76	1241.29	132605.0
2011-12-21 14:00:00	ES	Futures	1241.29	1244.32	1239.53	1242.8	165371.0
2011-12-21 15:00:00	ES	Futures	1242.8	1249.1	1241.54	1247.34	287820.0
2011-12-21 16:00:00	ES	Futures	1247.34	1249.36	1243.81	1245.07	75693.0
2011-12-21 17:00:00	ES	Futures	1245.32	1246.33	1244.57	1246.33	1318.0
2011-12-21 18:00:00	ES	Futures	1246.58	1246.58	1244.82	1245.83	4567.0
2011-12-21 19:00:00	ES	Futures	1245.83	1246.58	1245.32	1246.08	3414.0
2011-12-21 20:00:00	ES	Futures	1246.33	1246.33	1244.57	1245.58	4706.0
2011-12-21 21:00:00	ES	Futures	1245.83	1245.83	1242.3	1243.06	4682.0
2011-12-21 22:00:00	ES	Futures	1243.06	1245.07	1242.55	1244.57	3306.0
2011-12-21 23:00:00	ES	Futures	1244.32	1245.07	1242.3	1242.55	3101.0
2011-12-21 00:00:00	NQ	Futures	2622.87	2624.89	2622.58	2624.89	209.0
2011-12-21 01:00:00	NQ	Futures	2625.18	2628.06	2624.89	2625.47	319.0
2011-12-21 02:00:00	NQ	Futures	2625.75	2636.15	2625.47	2635.57	780.0
2011-12-21 03:00:00	NQ	Futures	2635.57	2640.48	2633.84	2637.6	2212.0
2011-12-21 04:00:00	NQ	Futures	2637.6	2638.75	2633.84	2636.73	1030.0
2011-12-21 05:00:00	NQ	Futures	2637.02	2646.84	2625.47	2627.2	4901.0
2011-12-21 06:00:00	NQ	Futures	2627.2	2636.73	2619.98	2624.31	3762.0
2011-12-21 07:00:00	NQ	Futures	2624.02	2627.49	2615.36	2618.82	4349.0
2011-12-21 08:00:00	NQ	Futures	2618.53	2619.98	2607.85	2617.09	6910.0
2011-12-21 09:00:00	NQ	Futures	2617.09	2620.56	2585.32	2589.94	45567.0
2011-12-21 10:00:00	NQ	Futures	2589.94	2595.14	2578.68	2581.57	37015.0
2011-12-21 11:00:00	NQ	Futures	2581.86	2582.15	2571.17	2574.35	26852.0
2011-12-21 12:00:00	NQ	Futures	2574.64	2576.95	2561.93	2571.17	27449.0
2011-12-21 13:00:00	NQ	Futures	2570.88	2576.08	2565.11	2574.35	15620.0
2011-12-21 14:00:00	NQ	Futures	2574.35	2582.43	2571.17	2579.55	22502.0
2011-12-21 15:00:00	NQ	Futures	2579.55	2595.72	2576.37	2592.25	35425.0
2011-12-21 16:00:00	NQ	Futures	2592.25	2594.56	2584.75	2587.63	8768.0
2011-12-21 17:00:00	NQ	Futures	2587.63	2589.94	2586.77	2588.79	78.0
2011-12-21 18:00:00	NQ	Futures	2589.94	2591.68	2588.21	2589.65	321.0
2011-12-21 19:00:00	NQ	Futures	2589.65	2590.23	2588.5	2590.23	154.0
2011-12-21 20:00:00	NQ	Futures	2589.94	2590.81	2587.92	2589.08	298.0
2011-12-21 21:00:00	NQ	Futures	2589.08	2589.65	2583.01	2583.88	233.0
2011-12-21 22:00:00	NQ	Futures	2583.3	2587.06	2583.3	2585.61	134.0
2011-12-21 23:00:00	NQ	Futures	2585.61	2587.06	2582.15	2582.15	95.0
2011-12-21 00:00:00	YM	Futures	11930.3	11933.3	11927.3	11933.3	200.0
2011-12-21 01:00:00	YM	Futures	11934.3	11945.2	11930.3	11936.2	716.0

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

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