PREVIEW / futures_1hour / 2011-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-29.parquet
  size:    50 KB
  rows:    1,505

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-09-29 00:00:00	ES	Futures	1155.24	1162.01	1155.24	1158.75	15055.0
2011-09-29 01:00:00	ES	Futures	1159.0	1160.76	1155.49	1160.76	8371.0
2011-09-29 02:00:00	ES	Futures	1160.26	1162.01	1158.0	1158.5	15193.0
2011-09-29 03:00:00	ES	Futures	1158.5	1164.52	1158.0	1162.51	50974.0
2011-09-29 04:00:00	ES	Futures	1162.51	1164.52	1160.76	1163.52	27264.0
2011-09-29 05:00:00	ES	Futures	1163.27	1165.52	1159.51	1164.02	30665.0
2011-09-29 06:00:00	ES	Futures	1163.77	1167.28	1158.5	1159.0	49443.0
2011-09-29 07:00:00	ES	Futures	1159.0	1160.76	1156.5	1158.0	58735.0
2011-09-29 08:00:00	ES	Futures	1158.25	1170.29	1156.75	1168.28	139075.0
2011-09-29 09:00:00	ES	Futures	1168.53	1174.3	1166.78	1169.79	290625.0
2011-09-29 10:00:00	ES	Futures	1170.04	1171.54	1153.24	1157.5	490597.0
2011-09-29 11:00:00	ES	Futures	1157.25	1164.27	1154.99	1161.76	264742.0
2011-09-29 12:00:00	ES	Futures	1161.51	1164.52	1154.24	1157.75	209322.0
2011-09-29 13:00:00	ES	Futures	1157.75	1161.76	1145.96	1149.47	268858.0
2011-09-29 14:00:00	ES	Futures	1149.47	1150.73	1138.94	1144.46	371167.0
2011-09-29 15:00:00	ES	Futures	1144.71	1158.25	1136.94	1158.25	509692.0
2011-09-29 16:00:00	ES	Futures	1158.25	1162.51	1157.0	1161.01	113794.0
2011-09-29 17:00:00	ES	Futures	1161.01	1163.02	1160.76	1162.01	2132.0
2011-09-29 18:00:00	ES	Futures	1161.76	1163.27	1161.26	1162.01	6216.0
2011-09-29 19:00:00	ES	Futures	1161.76	1162.01	1160.01	1160.51	3832.0
2011-09-29 20:00:00	ES	Futures	1160.51	1161.01	1156.25	1156.75	13582.0
2011-09-29 21:00:00	ES	Futures	1157.0	1159.25	1154.99	1154.99	8856.0
2011-09-29 22:00:00	ES	Futures	1154.99	1156.75	1151.98	1153.99	14149.0
2011-09-29 23:00:00	ES	Futures	1153.74	1154.49	1150.73	1151.98	7780.0
2011-09-29 00:00:00	NQ	Futures	2566.07	2578.47	2566.07	2574.43	1669.0
2011-09-29 01:00:00	NQ	Futures	2573.57	2578.47	2566.93	2578.18	1077.0
2011-09-29 02:00:00	NQ	Futures	2577.89	2580.77	2573.28	2574.43	1963.0
2011-09-29 03:00:00	NQ	Futures	2574.43	2590.29	2572.99	2585.96	5264.0
2011-09-29 04:00:00	NQ	Futures	2586.25	2589.71	2580.77	2586.54	2465.0
2011-09-29 05:00:00	NQ	Futures	2586.83	2591.44	2580.49	2587.69	2711.0
2011-09-29 06:00:00	NQ	Futures	2587.41	2593.46	2576.74	2578.18	4074.0
2011-09-29 07:00:00	NQ	Futures	2577.89	2578.47	2568.66	2573.28	4177.0
2011-09-29 08:00:00	NQ	Futures	2573.57	2605.57	2571.55	2601.25	12720.0
2011-09-29 09:00:00	NQ	Futures	2600.96	2606.15	2581.93	2584.81	44651.0
2011-09-29 10:00:00	NQ	Futures	2584.52	2588.56	2534.07	2543.29	64060.0
2011-09-29 11:00:00	NQ	Futures	2543.0	2561.17	2537.24	2553.67	35617.0
2011-09-29 12:00:00	NQ	Futures	2553.38	2559.44	2534.64	2538.97	23806.0
2011-09-29 13:00:00	NQ	Futures	2538.68	2547.91	2503.5	2511.87	49287.0
2011-09-29 14:00:00	NQ	Futures	2512.15	2515.04	2482.46	2499.76	71620.0
2011-09-29 15:00:00	NQ	Futures	2500.04	2528.01	2484.19	2527.43	61906.0
2011-09-29 16:00:00	NQ	Futures	2527.43	2534.35	2524.55	2530.61	13958.0
2011-09-29 17:00:00	NQ	Futures	2530.61	2533.49	2530.03	2532.62	249.0
2011-09-29 18:00:00	NQ	Futures	2532.62	2535.51	2530.89	2531.47	816.0
2011-09-29 19:00:00	NQ	Futures	2531.47	2531.47	2528.88	2529.74	436.0
2011-09-29 20:00:00	NQ	Futures	2529.45	2531.76	2522.53	2523.11	1114.0
2011-09-29 21:00:00	NQ	Futures	2523.69	2527.43	2520.8	2521.09	1333.0
2011-09-29 22:00:00	NQ	Futures	2520.8	2523.11	2515.04	2517.06	1696.0
2011-09-29 23:00:00	NQ	Futures	2517.63	2517.63	2510.14	2511.87	937.0
2011-09-29 00:00:00	YM	Futures	10836.1	10888.3	10836.1	10868.6	1723.0
2011-09-29 01:00:00	YM	Futures	10867.6	10880.4	10842.0	10880.4	1072.0

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

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