PREVIEW / futures_1hour / 2012-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-01.parquet
  size:    49 KB
  rows:    1,482

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-03-01 00:00:00	ES	Futures	1373.59	1373.59	1371.82	1371.82	3565.0
2012-03-01 01:00:00	ES	Futures	1372.07	1372.83	1369.55	1371.07	8924.0
2012-03-01 02:00:00	ES	Futures	1370.81	1372.83	1370.81	1372.07	9944.0
2012-03-01 03:00:00	ES	Futures	1371.82	1374.85	1369.81	1374.59	45844.0
2012-03-01 04:00:00	ES	Futures	1374.34	1377.37	1374.09	1376.61	32087.0
2012-03-01 05:00:00	ES	Futures	1376.36	1377.62	1375.6	1376.61	19926.0
2012-03-01 06:00:00	ES	Futures	1376.36	1379.38	1376.11	1378.63	33910.0
2012-03-01 07:00:00	ES	Futures	1378.63	1379.38	1376.86	1378.37	41641.0
2012-03-01 08:00:00	ES	Futures	1378.12	1380.14	1378.12	1378.88	67336.0
2012-03-01 09:00:00	ES	Futures	1379.13	1384.42	1378.63	1383.92	234582.0
2012-03-01 10:00:00	ES	Futures	1383.67	1383.92	1377.11	1380.64	427535.0
2012-03-01 11:00:00	ES	Futures	1380.64	1383.67	1379.38	1382.91	253625.0
2012-03-01 12:00:00	ES	Futures	1382.91	1384.67	1382.15	1383.67	97284.0
2012-03-01 13:00:00	ES	Futures	1383.67	1386.19	1382.91	1385.18	103743.0
2012-03-01 14:00:00	ES	Futures	1385.43	1386.19	1382.66	1383.92	97009.0
2012-03-01 15:00:00	ES	Futures	1383.92	1384.67	1378.63	1383.41	326012.0
2012-03-01 16:00:00	ES	Futures	1383.16	1387.95	1382.66	1385.93	102039.0
2012-03-01 17:00:00	ES	Futures	1385.93	1386.94	1385.43	1386.69	3217.0
2012-03-01 18:00:00	ES	Futures	1386.44	1387.7	1386.44	1387.7	7742.0
2012-03-01 19:00:00	ES	Futures	1387.45	1387.95	1386.44	1386.94	7356.0
2012-03-01 20:00:00	ES	Futures	1386.69	1387.19	1385.93	1386.44	4831.0
2012-03-01 21:00:00	ES	Futures	1386.44	1386.69	1385.43	1385.68	2628.0
2012-03-01 22:00:00	ES	Futures	1385.68	1386.44	1385.43	1386.44	2825.0
2012-03-01 23:00:00	ES	Futures	1386.19	1386.44	1384.93	1385.43	3412.0
2012-03-01 00:00:00	NQ	Futures	3032.09	3032.09	3028.34	3028.63	248.0
2012-03-01 01:00:00	NQ	Futures	3028.34	3029.78	3022.56	3025.45	504.0
2012-03-01 02:00:00	NQ	Futures	3025.16	3029.49	3024.87	3027.76	1146.0
2012-03-01 03:00:00	NQ	Futures	3027.76	3034.12	3022.56	3033.54	4357.0
2012-03-01 04:00:00	NQ	Futures	3033.25	3039.6	3032.67	3037.87	2505.0
2012-03-01 05:00:00	NQ	Futures	3038.16	3040.47	3036.14	3038.16	1365.0
2012-03-01 06:00:00	NQ	Futures	3037.87	3044.22	3037.29	3043.07	2877.0
2012-03-01 07:00:00	NQ	Futures	3043.36	3043.93	3038.45	3041.34	2884.0
2012-03-01 08:00:00	NQ	Futures	3041.34	3044.8	3039.89	3041.62	6794.0
2012-03-01 09:00:00	NQ	Futures	3041.34	3049.71	3034.98	3046.53	42898.0
2012-03-01 10:00:00	NQ	Futures	3047.11	3047.11	3032.38	3038.16	60555.0
2012-03-01 11:00:00	NQ	Futures	3038.45	3049.13	3035.56	3047.69	32295.0
2012-03-01 12:00:00	NQ	Futures	3047.69	3051.15	3045.38	3050.29	16017.0
2012-03-01 13:00:00	NQ	Futures	3050.29	3056.06	3048.27	3054.91	16131.0
2012-03-01 14:00:00	NQ	Futures	3054.91	3056.64	3051.15	3053.46	15301.0
2012-03-01 15:00:00	NQ	Futures	3053.75	3055.78	3042.78	3053.75	36962.0
2012-03-01 16:00:00	NQ	Futures	3054.04	3060.4	3052.89	3056.93	9063.0
2012-03-01 17:00:00	NQ	Futures	3057.22	3059.53	3056.64	3059.24	347.0
2012-03-01 18:00:00	NQ	Futures	3058.37	3059.24	3056.93	3058.95	680.0
2012-03-01 19:00:00	NQ	Futures	3059.24	3059.82	3057.22	3058.37	366.0
2012-03-01 20:00:00	NQ	Futures	3058.09	3058.95	3057.51	3058.09	179.0
2012-03-01 21:00:00	NQ	Futures	3057.8	3057.8	3055.78	3056.06	220.0
2012-03-01 22:00:00	NQ	Futures	3056.06	3057.51	3055.78	3057.22	170.0
2012-03-01 23:00:00	NQ	Futures	3057.22	3057.8	3054.91	3055.49	246.0
2012-03-01 00:00:00	YM	Futures	12816.4	12816.4	12802.5	12803.5	207.0
2012-03-01 01:00:00	YM	Futures	12803.5	12809.4	12782.7	12795.6	692.0

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

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