PREVIEW / futures_1hour / 2012-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-02.parquet
  size:    49 KB
  rows:    1,464

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
2012-08-02 00:00:00	ES	Futures	1396.52	1398.05	1395.76	1397.8	3244.0
2012-08-02 01:00:00	ES	Futures	1397.8	1397.8	1396.02	1396.78	2937.0
2012-08-02 02:00:00	ES	Futures	1396.78	1397.8	1395.0	1396.02	7477.0
2012-08-02 03:00:00	ES	Futures	1396.27	1397.03	1395.0	1395.76	24840.0
2012-08-02 04:00:00	ES	Futures	1396.02	1397.29	1394.24	1397.03	21749.0
2012-08-02 05:00:00	ES	Futures	1396.78	1400.59	1396.27	1400.08	29446.0
2012-08-02 06:00:00	ES	Futures	1400.34	1400.59	1397.8	1398.81	17885.0
2012-08-02 07:00:00	ES	Futures	1399.07	1400.85	1396.02	1399.32	60238.0
2012-08-02 08:00:00	ES	Futures	1399.32	1406.7	1381.01	1382.79	488987.0
2012-08-02 09:00:00	ES	Futures	1383.05	1388.13	1379.23	1387.62	500466.0
2012-08-02 10:00:00	ES	Futures	1387.62	1392.96	1384.57	1385.59	446175.0
2012-08-02 11:00:00	ES	Futures	1385.84	1387.37	1375.93	1378.47	426418.0
2012-08-02 12:00:00	ES	Futures	1378.22	1379.49	1372.37	1377.45	218153.0
2012-08-02 13:00:00	ES	Futures	1377.45	1378.47	1375.16	1375.42	104777.0
2012-08-02 14:00:00	ES	Futures	1375.16	1381.27	1374.4	1378.47	136534.0
2012-08-02 15:00:00	ES	Futures	1378.47	1384.83	1378.47	1383.56	214813.0
2012-08-02 16:00:00	ES	Futures	1383.81	1385.84	1382.79	1384.83	91977.0
2012-08-02 17:00:00	ES	Futures	1384.83	1385.08	1383.81	1385.08	1964.0
2012-08-02 18:00:00	ES	Futures	1384.57	1385.08	1383.81	1385.08	2857.0
2012-08-02 19:00:00	ES	Futures	1385.08	1385.08	1384.06	1384.32	1150.0
2012-08-02 20:00:00	ES	Futures	1384.32	1385.08	1383.3	1384.57	3781.0
2012-08-02 21:00:00	ES	Futures	1384.57	1386.86	1384.57	1385.59	6468.0
2012-08-02 22:00:00	ES	Futures	1385.34	1385.84	1383.81	1385.59	4356.0
2012-08-02 23:00:00	ES	Futures	1385.59	1386.61	1385.08	1385.84	3212.0
2012-08-02 00:00:00	NQ	Futures	3049.01	3052.2	3047.56	3051.91	514.0
2012-08-02 01:00:00	NQ	Futures	3051.62	3051.91	3049.01	3049.59	466.0
2012-08-02 02:00:00	NQ	Futures	3049.3	3052.49	3046.69	3048.72	664.0
2012-08-02 03:00:00	NQ	Futures	3048.43	3050.75	3045.24	3047.85	2144.0
2012-08-02 04:00:00	NQ	Futures	3047.85	3050.17	3043.5	3049.59	1757.0
2012-08-02 05:00:00	NQ	Futures	3049.59	3058.58	3048.43	3058.0	2863.0
2012-08-02 06:00:00	NQ	Futures	3058.0	3058.87	3052.2	3055.1	2508.0
2012-08-02 07:00:00	NQ	Futures	3055.1	3059.45	3048.14	3054.81	4770.0
2012-08-02 08:00:00	NQ	Futures	3055.1	3071.33	3017.41	3020.89	33899.0
2012-08-02 09:00:00	NQ	Futures	3020.89	3051.33	3014.8	3050.17	54399.0
2012-08-02 10:00:00	NQ	Futures	3050.17	3068.43	3043.5	3049.01	57604.0
2012-08-02 11:00:00	NQ	Futures	3049.3	3053.36	3021.76	3028.43	46395.0
2012-08-02 12:00:00	NQ	Futures	3028.14	3032.78	3017.41	3027.56	24555.0
2012-08-02 13:00:00	NQ	Futures	3027.56	3029.88	3020.89	3021.18	13384.0
2012-08-02 14:00:00	NQ	Futures	3021.18	3034.23	3019.73	3029.01	17509.0
2012-08-02 15:00:00	NQ	Futures	3029.01	3042.05	3028.43	3037.41	27968.0
2012-08-02 16:00:00	NQ	Futures	3037.12	3038.57	3033.36	3036.83	7632.0
2012-08-02 17:00:00	NQ	Futures	3036.54	3037.12	3034.52	3037.12	82.0
2012-08-02 18:00:00	NQ	Futures	3035.68	3037.12	3033.36	3036.83	287.0
2012-08-02 19:00:00	NQ	Futures	3037.12	3037.41	3034.81	3035.97	377.0
2012-08-02 20:00:00	NQ	Futures	3035.97	3037.7	3033.36	3036.83	717.0
2012-08-02 21:00:00	NQ	Futures	3037.12	3041.47	3037.12	3039.15	897.0
2012-08-02 22:00:00	NQ	Futures	3039.15	3039.44	3035.39	3038.57	1175.0
2012-08-02 23:00:00	NQ	Futures	3038.28	3040.89	3037.7	3039.44	993.0
2012-08-02 00:00:00	YM	Futures	12874.5	12882.5	12869.6	12882.5	629.0
2012-08-02 01:00:00	YM	Futures	12881.5	12883.5	12870.6	12874.5	358.0

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

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