PREVIEW / futures_1hour / 2012-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-02.parquet
  size:    40 KB
  rows:    1,190

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-02 00:00:00	ES	Futures	1385.18	1385.68	1384.67	1384.67	2409.0
2012-03-02 01:00:00	ES	Futures	1384.93	1385.43	1384.17	1385.18	4032.0
2012-03-02 02:00:00	ES	Futures	1385.18	1385.18	1383.67	1383.67	7401.0
2012-03-02 03:00:00	ES	Futures	1383.67	1384.67	1382.15	1382.15	30118.0
2012-03-02 04:00:00	ES	Futures	1382.41	1383.41	1381.9	1381.9	17386.0
2012-03-02 05:00:00	ES	Futures	1381.9	1383.41	1381.9	1382.15	14407.0
2012-03-02 06:00:00	ES	Futures	1382.41	1383.41	1381.9	1382.15	15624.0
2012-03-02 07:00:00	ES	Futures	1382.41	1382.41	1379.13	1380.64	41950.0
2012-03-02 08:00:00	ES	Futures	1380.64	1382.41	1379.89	1382.15	36445.0
2012-03-02 09:00:00	ES	Futures	1382.41	1383.41	1379.89	1380.89	157689.0
2012-03-02 10:00:00	ES	Futures	1380.64	1384.17	1379.89	1381.65	236089.0
2012-03-02 11:00:00	ES	Futures	1381.4	1382.15	1378.12	1379.13	230607.0
2012-03-02 12:00:00	ES	Futures	1379.38	1379.89	1377.11	1378.63	140248.0
2012-03-02 13:00:00	ES	Futures	1378.88	1379.63	1375.85	1378.88	120596.0
2012-03-02 14:00:00	ES	Futures	1378.63	1379.89	1378.12	1379.63	78945.0
2012-03-02 15:00:00	ES	Futures	1379.89	1381.9	1378.37	1379.38	192040.0
2012-03-02 16:00:00	ES	Futures	1379.13	1380.39	1378.88	1379.38	71648.0
2012-03-02 00:00:00	NQ	Futures	3055.78	3056.35	3054.91	3054.91	110.0
2012-03-02 01:00:00	NQ	Futures	3054.62	3056.06	3053.46	3055.49	194.0
2012-03-02 02:00:00	NQ	Futures	3055.49	3055.49	3052.89	3052.89	533.0
2012-03-02 03:00:00	NQ	Futures	3052.89	3055.2	3047.98	3048.56	2377.0
2012-03-02 04:00:00	NQ	Futures	3048.27	3052.31	3048.27	3049.13	1339.0
2012-03-02 05:00:00	NQ	Futures	3049.42	3051.15	3047.4	3048.56	1537.0
2012-03-02 06:00:00	NQ	Futures	3048.56	3050.87	3047.69	3048.84	1118.0
2012-03-02 07:00:00	NQ	Futures	3048.56	3049.13	3042.2	3045.38	2799.0
2012-03-02 08:00:00	NQ	Futures	3045.67	3049.13	3043.65	3048.27	3373.0
2012-03-02 09:00:00	NQ	Futures	3048.56	3055.49	3046.53	3052.31	23979.0
2012-03-02 10:00:00	NQ	Futures	3052.31	3061.26	3051.44	3055.2	30681.0
2012-03-02 11:00:00	NQ	Futures	3055.49	3060.97	3047.11	3050.29	29854.0
2012-03-02 12:00:00	NQ	Futures	3050.58	3051.73	3043.65	3048.56	18581.0
2012-03-02 13:00:00	NQ	Futures	3048.27	3050.58	3041.34	3050.0	16090.0
2012-03-02 14:00:00	NQ	Futures	3050.0	3053.18	3048.56	3051.15	12070.0
2012-03-02 15:00:00	NQ	Futures	3051.44	3055.78	3047.98	3051.15	23214.0
2012-03-02 16:00:00	NQ	Futures	3050.87	3056.35	3050.0	3054.04	8370.0
2012-03-02 00:00:00	YM	Futures	12860.0	12862.0	12856.0	12856.0	121.0
2012-03-02 01:00:00	YM	Futures	12856.0	12859.0	12851.1	12858.0	317.0
2012-03-02 02:00:00	YM	Futures	12857.0	12858.0	12847.1	12847.1	563.0
2012-03-02 03:00:00	YM	Futures	12847.1	12857.0	12834.2	12835.2	1705.0
2012-03-02 04:00:00	YM	Futures	12836.2	12845.1	12834.2	12837.2	1086.0
2012-03-02 05:00:00	YM	Futures	12835.2	12848.1	12834.2	12838.2	883.0
2012-03-02 06:00:00	YM	Futures	12838.2	12846.1	12835.2	12840.2	795.0
2012-03-02 07:00:00	YM	Futures	12838.2	12839.2	12816.4	12828.3	2802.0
2012-03-02 08:00:00	YM	Futures	12827.3	12842.1	12823.3	12840.2	1732.0
2012-03-02 09:00:00	YM	Futures	12841.1	12849.1	12812.4	12821.3	10121.0
2012-03-02 10:00:00	YM	Futures	12821.3	12854.0	12815.4	12840.2	13220.0
2012-03-02 11:00:00	YM	Futures	12840.2	12843.1	12814.4	12824.3	11344.0
2012-03-02 12:00:00	YM	Futures	12824.3	12828.3	12804.5	12821.3	8275.0
2012-03-02 13:00:00	YM	Futures	12820.3	12826.3	12797.5	12823.3	7664.0
2012-03-02 14:00:00	YM	Futures	12823.3	12850.1	12823.3	12843.1	9484.0
2012-03-02 15:00:00	YM	Futures	12844.1	12869.9	12833.2	12847.1	13902.0

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

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