PREVIEW / futures_1hour / 2012-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-12.parquet
  size:    46 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
2012-11-12 00:00:00	ES	Futures	1408.37	1408.88	1407.09	1407.61	2834.0
2012-11-12 01:00:00	ES	Futures	1407.61	1408.63	1407.61	1408.12	2074.0
2012-11-12 02:00:00	ES	Futures	1408.12	1408.88	1406.33	1407.86	9191.0
2012-11-12 03:00:00	ES	Futures	1408.12	1409.14	1405.05	1406.58	28275.0
2012-11-12 04:00:00	ES	Futures	1406.58	1409.65	1405.31	1408.37	23875.0
2012-11-12 05:00:00	ES	Futures	1408.63	1410.16	1407.09	1407.61	14393.0
2012-11-12 06:00:00	ES	Futures	1407.35	1409.39	1407.35	1409.14	12080.0
2012-11-12 07:00:00	ES	Futures	1409.14	1411.69	1408.63	1411.18	28711.0
2012-11-12 08:00:00	ES	Futures	1411.18	1411.44	1408.88	1410.67	23856.0
2012-11-12 09:00:00	ES	Futures	1410.93	1411.18	1407.61	1409.65	149236.0
2012-11-12 10:00:00	ES	Futures	1409.39	1409.65	1403.77	1404.28	188691.0
2012-11-12 11:00:00	ES	Futures	1404.28	1405.56	1403.01	1403.77	159092.0
2012-11-12 12:00:00	ES	Futures	1403.77	1408.37	1403.52	1408.12	79270.0
2012-11-12 13:00:00	ES	Futures	1408.37	1411.95	1408.12	1409.9	94889.0
2012-11-12 14:00:00	ES	Futures	1410.16	1410.93	1406.58	1407.86	72661.0
2012-11-12 15:00:00	ES	Futures	1407.86	1408.88	1405.56	1406.33	152722.0
2012-11-12 16:00:00	ES	Futures	1406.58	1409.14	1405.82	1408.88	57310.0
2012-11-12 17:00:00	ES	Futures	1408.88	1409.14	1408.37	1408.37	671.0
2012-11-12 18:00:00	ES	Futures	1408.37	1408.63	1405.05	1405.31	6425.0
2012-11-12 19:00:00	ES	Futures	1405.31	1405.82	1403.77	1404.28	6480.0
2012-11-12 20:00:00	ES	Futures	1404.28	1404.79	1401.22	1401.47	9426.0
2012-11-12 21:00:00	ES	Futures	1401.47	1403.01	1399.43	1402.24	11981.0
2012-11-12 22:00:00	ES	Futures	1402.5	1403.26	1400.71	1401.22	6506.0
2012-11-12 23:00:00	ES	Futures	1401.47	1401.73	1397.9	1398.15	8914.0
2012-11-12 00:00:00	NQ	Futures	3007.18	3007.76	3005.14	3006.01	524.0
2012-11-12 01:00:00	NQ	Futures	3006.01	3008.05	3005.72	3006.88	160.0
2012-11-12 02:00:00	NQ	Futures	3006.88	3007.76	3003.4	3006.01	763.0
2012-11-12 03:00:00	NQ	Futures	3006.3	3007.47	2998.17	3001.07	2057.0
2012-11-12 04:00:00	NQ	Futures	3001.07	3008.63	2999.33	3007.47	2018.0
2012-11-12 05:00:00	NQ	Futures	3007.47	3011.53	3005.14	3006.01	2307.0
2012-11-12 06:00:00	NQ	Futures	3006.01	3010.37	3006.01	3008.92	1195.0
2012-11-12 07:00:00	NQ	Futures	3009.21	3017.35	3008.34	3015.89	2792.0
2012-11-12 08:00:00	NQ	Futures	3015.6	3016.47	3012.11	3015.6	3645.0
2012-11-12 09:00:00	NQ	Futures	3015.6	3018.8	3010.95	3014.73	26435.0
2012-11-12 10:00:00	NQ	Futures	3014.73	3014.73	2992.36	2993.23	46245.0
2012-11-12 11:00:00	NQ	Futures	2992.94	2995.84	2989.45	2992.36	21424.0
2012-11-12 12:00:00	NQ	Futures	2992.65	3009.79	2991.48	3009.79	14583.0
2012-11-12 13:00:00	NQ	Futures	3009.79	3015.6	3001.65	3005.43	18515.0
2012-11-12 14:00:00	NQ	Futures	3005.43	3008.63	2995.84	2999.91	16829.0
2012-11-12 15:00:00	NQ	Futures	2999.91	3003.98	2994.1	2997.59	24943.0
2012-11-12 16:00:00	NQ	Futures	2997.88	3002.82	2997.3	3001.94	3784.0
2012-11-12 17:00:00	NQ	Futures	3001.36	3001.94	3000.78	3001.36	36.0
2012-11-12 18:00:00	NQ	Futures	3001.07	3001.07	2996.13	2996.13	440.0
2012-11-12 19:00:00	NQ	Futures	2996.42	2997.3	2993.23	2994.39	539.0
2012-11-12 20:00:00	NQ	Futures	2994.39	2995.55	2987.42	2988.0	998.0
2012-11-12 21:00:00	NQ	Futures	2988.0	2989.45	2984.51	2987.13	1518.0
2012-11-12 22:00:00	NQ	Futures	2987.42	2988.87	2983.64	2985.38	899.0
2012-11-12 23:00:00	NQ	Futures	2985.38	2985.38	2979.57	2980.44	1341.0
2012-11-12 00:00:00	YM	Futures	12794.6	12797.6	12784.6	12788.6	215.0
2012-11-12 01:00:00	YM	Futures	12789.6	12796.6	12788.6	12790.6	305.0

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

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