PREVIEW / futures_1hour / 2013-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-01.parquet
  size:    44 KB
  rows:    1,275

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
2013-02-01 00:00:00	ES	Futures	1537.49	1538.26	1536.72	1537.75	3651.0
2013-02-01 01:00:00	ES	Futures	1537.75	1538.26	1536.72	1536.98	3364.0
2013-02-01 02:00:00	ES	Futures	1536.98	1537.75	1536.47	1536.72	7066.0
2013-02-01 03:00:00	ES	Futures	1536.72	1538.52	1535.95	1538.26	31161.0
2013-02-01 04:00:00	ES	Futures	1538.26	1539.29	1538.01	1538.26	23392.0
2013-02-01 05:00:00	ES	Futures	1538.01	1539.29	1537.24	1537.49	17367.0
2013-02-01 06:00:00	ES	Futures	1537.49	1537.75	1535.18	1536.47	21530.0
2013-02-01 07:00:00	ES	Futures	1536.21	1538.26	1536.21	1537.49	25420.0
2013-02-01 08:00:00	ES	Futures	1537.49	1545.19	1536.21	1543.65	179799.0
2013-02-01 09:00:00	ES	Futures	1543.65	1543.91	1539.55	1540.06	269787.0
2013-02-01 10:00:00	ES	Futures	1540.32	1547.24	1540.32	1545.96	361414.0
2013-02-01 11:00:00	ES	Futures	1545.96	1548.53	1545.19	1548.27	165994.0
2013-02-01 12:00:00	ES	Futures	1548.27	1549.04	1547.24	1548.27	101936.0
2013-02-01 13:00:00	ES	Futures	1548.27	1550.32	1547.76	1549.55	112073.0
2013-02-01 14:00:00	ES	Futures	1549.55	1549.81	1546.99	1547.5	110361.0
2013-02-01 15:00:00	ES	Futures	1547.24	1549.55	1546.22	1548.01	203048.0
2013-02-01 16:00:00	ES	Futures	1548.01	1548.78	1545.96	1547.5	95076.0
2013-02-01 17:00:00	ES	Futures	1547.24	1547.76	1547.24	1547.24	1392.0
2013-02-01 00:00:00	NQ	Futures	3185.17	3186.62	3184.3	3185.46	343.0
2013-02-01 01:00:00	NQ	Futures	3185.17	3186.33	3183.13	3183.42	189.0
2013-02-01 02:00:00	NQ	Futures	3184.0	3184.0	3181.68	3182.55	671.0
2013-02-01 03:00:00	NQ	Futures	3182.55	3186.33	3180.8	3185.75	2994.0
2013-02-01 04:00:00	NQ	Futures	3185.75	3188.66	3184.59	3185.17	2058.0
2013-02-01 05:00:00	NQ	Futures	3185.46	3188.95	3183.13	3183.71	1638.0
2013-02-01 06:00:00	NQ	Futures	3183.71	3184.0	3179.06	3182.26	2828.0
2013-02-01 07:00:00	NQ	Futures	3181.97	3187.5	3181.68	3187.21	2452.0
2013-02-01 08:00:00	NQ	Futures	3187.21	3200.01	3185.75	3198.56	14374.0
2013-02-01 09:00:00	NQ	Futures	3198.56	3199.43	3183.71	3185.75	35051.0
2013-02-01 10:00:00	NQ	Futures	3186.04	3203.51	3186.04	3196.52	45489.0
2013-02-01 11:00:00	NQ	Futures	3196.52	3211.07	3195.94	3209.91	30662.0
2013-02-01 12:00:00	NQ	Futures	3209.91	3216.31	3207.58	3213.69	20710.0
2013-02-01 13:00:00	NQ	Futures	3213.69	3218.06	3211.37	3216.02	15956.0
2013-02-01 14:00:00	NQ	Futures	3216.02	3216.6	3209.91	3211.07	13134.0
2013-02-01 15:00:00	NQ	Futures	3211.07	3212.53	3205.83	3211.37	24264.0
2013-02-01 16:00:00	NQ	Futures	3211.07	3212.53	3209.33	3211.66	6007.0
2013-02-01 17:00:00	NQ	Futures	3211.66	3211.66	3209.04	3209.04	288.0
2013-02-01 00:00:00	YM	Futures	13931.4	13938.5	13929.4	13935.5	653.0
2013-02-01 01:00:00	YM	Futures	13935.5	13938.5	13928.4	13930.4	237.0
2013-02-01 02:00:00	YM	Futures	13930.4	13934.5	13926.4	13929.4	924.0
2013-02-01 03:00:00	YM	Futures	13928.4	13945.5	13922.4	13944.5	2592.0
2013-02-01 04:00:00	YM	Futures	13945.5	13952.6	13943.5	13944.5	2062.0
2013-02-01 05:00:00	YM	Futures	13945.5	13953.6	13939.5	13940.5	1362.0
2013-02-01 06:00:00	YM	Futures	13939.5	13941.5	13924.4	13931.4	2230.0
2013-02-01 07:00:00	YM	Futures	13931.4	13944.5	13928.4	13940.5	2699.0
2013-02-01 08:00:00	YM	Futures	13940.5	14003.9	13933.4	13993.8	13142.0
2013-02-01 09:00:00	YM	Futures	13992.8	13995.8	13959.6	13968.7	18308.0
2013-02-01 10:00:00	YM	Futures	13970.7	14027.0	13970.7	14024.0	25122.0
2013-02-01 11:00:00	YM	Futures	14025.0	14031.0	14011.9	14027.0	11776.0
2013-02-01 12:00:00	YM	Futures	14027.0	14030.0	14013.9	14023.0	5194.0
2013-02-01 13:00:00	YM	Futures	14023.0	14042.1	14016.9	14039.1	7961.0

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

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