PREVIEW / futures_1hour / 2011-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-25.parquet
  size:    40 KB
  rows:    1,155

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-03-25 00:00:00	ES	Futures	1301.28	1301.78	1300.29	1301.53	3982.0
2011-03-25 01:00:00	ES	Futures	1301.53	1302.27	1300.53	1302.02	3751.0
2011-03-25 02:00:00	ES	Futures	1301.78	1302.77	1301.28	1302.27	3767.0
2011-03-25 03:00:00	ES	Futures	1302.27	1303.52	1300.78	1302.77	14782.0
2011-03-25 04:00:00	ES	Futures	1302.77	1302.77	1299.79	1300.78	27966.0
2011-03-25 05:00:00	ES	Futures	1300.78	1302.77	1300.29	1302.52	15110.0
2011-03-25 06:00:00	ES	Futures	1302.77	1303.52	1301.53	1302.52	18129.0
2011-03-25 07:00:00	ES	Futures	1302.52	1302.77	1300.29	1300.53	17030.0
2011-03-25 08:00:00	ES	Futures	1300.78	1301.28	1298.79	1299.54	54943.0
2011-03-25 09:00:00	ES	Futures	1299.54	1300.53	1297.06	1299.04	177405.0
2011-03-25 10:00:00	ES	Futures	1299.04	1305.01	1297.8	1304.26	254228.0
2011-03-25 11:00:00	ES	Futures	1304.51	1306.0	1303.76	1305.25	218334.0
2011-03-25 12:00:00	ES	Futures	1305.25	1306.25	1303.76	1303.76	203271.0
2011-03-25 13:00:00	ES	Futures	1303.76	1304.76	1302.27	1302.77	129034.0
2011-03-25 14:00:00	ES	Futures	1303.02	1304.26	1300.78	1303.27	110244.0
2011-03-25 15:00:00	ES	Futures	1303.27	1304.01	1300.04	1300.04	254048.0
2011-03-25 16:00:00	ES	Futures	1300.29	1302.77	1300.04	1302.52	87626.0
2011-03-25 00:00:00	NQ	Futures	2664.84	2664.84	2661.11	2663.12	336.0
2011-03-25 01:00:00	NQ	Futures	2662.83	2665.13	2661.68	2664.84	328.0
2011-03-25 02:00:00	NQ	Futures	2664.56	2666.28	2662.83	2665.99	620.0
2011-03-25 03:00:00	NQ	Futures	2665.71	2668.01	2663.12	2667.43	1587.0
2011-03-25 04:00:00	NQ	Futures	2667.72	2667.72	2658.52	2660.53	4887.0
2011-03-25 05:00:00	NQ	Futures	2660.53	2665.42	2658.52	2664.56	1889.0
2011-03-25 06:00:00	NQ	Futures	2664.56	2666.57	2663.41	2665.99	1231.0
2011-03-25 07:00:00	NQ	Futures	2665.71	2665.99	2661.97	2661.97	1810.0
2011-03-25 08:00:00	NQ	Futures	2662.26	2663.7	2658.52	2660.82	5692.0
2011-03-25 09:00:00	NQ	Futures	2660.53	2664.27	2656.23	2663.12	36234.0
2011-03-25 10:00:00	NQ	Futures	2662.83	2676.34	2656.8	2675.48	48323.0
2011-03-25 11:00:00	NQ	Futures	2675.19	2677.49	2670.88	2675.76	31329.0
2011-03-25 12:00:00	NQ	Futures	2676.05	2676.62	2669.73	2670.3	26512.0
2011-03-25 13:00:00	NQ	Futures	2670.3	2672.6	2666.28	2667.72	19811.0
2011-03-25 14:00:00	NQ	Futures	2667.43	2668.01	2659.39	2663.98	23771.0
2011-03-25 15:00:00	NQ	Futures	2663.98	2665.99	2658.24	2659.39	39162.0
2011-03-25 16:00:00	NQ	Futures	2659.39	2664.84	2658.81	2662.83	7040.0
2011-03-25 00:00:00	YM	Futures	11701.8	11704.7	11692.1	11702.7	149.0
2011-03-25 01:00:00	YM	Futures	11701.8	11707.5	11697.0	11706.6	213.0
2011-03-25 02:00:00	YM	Futures	11706.6	11711.4	11698.9	11706.6	458.0
2011-03-25 03:00:00	YM	Futures	11704.7	11721.0	11696.0	11713.3	724.0
2011-03-25 04:00:00	YM	Futures	11714.3	11714.3	11694.1	11699.8	2334.0
2011-03-25 05:00:00	YM	Futures	11699.8	11716.2	11697.9	11716.2	908.0
2011-03-25 06:00:00	YM	Futures	11716.2	11724.9	11706.6	11715.3	1094.0
2011-03-25 07:00:00	YM	Futures	11716.2	11716.2	11698.9	11702.7	796.0
2011-03-25 08:00:00	YM	Futures	11701.8	11706.6	11685.4	11689.2	2485.0
2011-03-25 09:00:00	YM	Futures	11688.3	11700.8	11675.8	11687.3	13149.0
2011-03-25 10:00:00	YM	Futures	11688.3	11732.6	11678.7	11729.7	15626.0
2011-03-25 11:00:00	YM	Futures	11729.7	11740.3	11723.0	11732.6	11499.0
2011-03-25 12:00:00	YM	Futures	11732.6	11747.0	11723.0	11723.9	14654.0
2011-03-25 13:00:00	YM	Futures	11723.0	11735.5	11713.3	11723.9	7171.0
2011-03-25 14:00:00	YM	Futures	11723.0	11730.7	11703.7	11723.0	6792.0
2011-03-25 15:00:00	YM	Futures	11723.0	11730.7	11698.9	11709.5	11142.0

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

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