PREVIEW / futures_1hour / 2012-02-17

all futures 1-hour files

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

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-02-17 00:00:00	ES	Futures	1365.02	1366.03	1364.77	1365.27	2577.0
2012-02-17 01:00:00	ES	Futures	1365.27	1365.52	1364.26	1365.27	3577.0
2012-02-17 02:00:00	ES	Futures	1365.27	1367.03	1365.02	1366.28	8960.0
2012-02-17 03:00:00	ES	Futures	1366.28	1366.78	1363.76	1364.26	26343.0
2012-02-17 04:00:00	ES	Futures	1364.26	1366.78	1364.26	1366.28	19645.0
2012-02-17 05:00:00	ES	Futures	1366.28	1366.78	1365.27	1365.77	13286.0
2012-02-17 06:00:00	ES	Futures	1365.77	1366.53	1364.77	1366.53	16350.0
2012-02-17 07:00:00	ES	Futures	1366.53	1369.55	1366.03	1367.79	40298.0
2012-02-17 08:00:00	ES	Futures	1367.79	1368.8	1366.78	1367.54	37235.0
2012-02-17 09:00:00	ES	Futures	1367.54	1372.07	1367.29	1370.06	245636.0
2012-02-17 10:00:00	ES	Futures	1370.31	1370.56	1367.03	1368.04	221097.0
2012-02-17 11:00:00	ES	Futures	1367.79	1368.29	1365.77	1367.54	179671.0
2012-02-17 12:00:00	ES	Futures	1367.54	1368.04	1366.53	1367.54	48681.0
2012-02-17 13:00:00	ES	Futures	1367.79	1369.3	1367.29	1369.05	46068.0
2012-02-17 14:00:00	ES	Futures	1369.05	1370.31	1368.8	1369.81	50746.0
2012-02-17 15:00:00	ES	Futures	1369.81	1371.57	1369.05	1370.06	182420.0
2012-02-17 16:00:00	ES	Futures	1370.31	1371.07	1369.81	1371.07	69129.0
2012-02-17 00:00:00	NQ	Futures	2993.97	2995.42	2993.39	2994.84	148.0
2012-02-17 01:00:00	NQ	Futures	2994.84	2995.13	2993.39	2993.68	144.0
2012-02-17 02:00:00	NQ	Futures	2993.97	2998.3	2993.39	2997.44	673.0
2012-02-17 03:00:00	NQ	Futures	2997.73	2998.02	2991.95	2992.53	1606.0
2012-02-17 04:00:00	NQ	Futures	2992.53	2997.73	2992.53	2995.71	868.0
2012-02-17 05:00:00	NQ	Futures	2995.71	2996.28	2992.82	2993.97	797.0
2012-02-17 06:00:00	NQ	Futures	2993.68	2995.99	2992.24	2995.99	1239.0
2012-02-17 07:00:00	NQ	Futures	2995.99	3000.33	2994.55	2996.28	2899.0
2012-02-17 08:00:00	NQ	Futures	2995.99	2996.57	2993.11	2994.26	4939.0
2012-02-17 09:00:00	NQ	Futures	2993.97	2996.57	2983.86	2989.35	56112.0
2012-02-17 10:00:00	NQ	Futures	2989.06	2990.22	2982.42	2983.0	31119.0
2012-02-17 11:00:00	NQ	Futures	2983.0	2983.0	2971.16	2979.53	33134.0
2012-02-17 12:00:00	NQ	Futures	2979.53	2980.4	2976.64	2978.95	8535.0
2012-02-17 13:00:00	NQ	Futures	2978.95	2983.29	2977.8	2982.13	9760.0
2012-02-17 14:00:00	NQ	Futures	2982.13	2985.02	2980.69	2983.86	10747.0
2012-02-17 15:00:00	NQ	Futures	2984.15	2988.49	2982.42	2984.15	25883.0
2012-02-17 16:00:00	NQ	Futures	2984.15	2984.73	2981.84	2983.0	6405.0
2012-02-17 00:00:00	YM	Futures	12751.9	12759.9	12749.0	12755.9	163.0
2012-02-17 01:00:00	YM	Futures	12755.9	12755.9	12746.0	12752.9	212.0
2012-02-17 02:00:00	YM	Futures	12752.9	12769.8	12752.9	12766.8	596.0
2012-02-17 03:00:00	YM	Futures	12766.8	12767.8	12746.0	12753.9	2421.0
2012-02-17 04:00:00	YM	Futures	12754.9	12774.7	12752.9	12770.8	1779.0
2012-02-17 05:00:00	YM	Futures	12770.8	12774.7	12761.9	12764.8	839.0
2012-02-17 06:00:00	YM	Futures	12763.8	12778.7	12757.9	12778.7	2512.0
2012-02-17 07:00:00	YM	Futures	12777.7	12803.5	12775.7	12792.6	2820.0
2012-02-17 08:00:00	YM	Futures	12793.6	12799.5	12783.7	12786.6	2439.0
2012-02-17 09:00:00	YM	Futures	12786.6	12826.3	12786.6	12798.5	17460.0
2012-02-17 10:00:00	YM	Futures	12799.5	12806.5	12782.7	12791.6	14442.0
2012-02-17 11:00:00	YM	Futures	12791.6	12799.5	12777.7	12792.6	9480.0
2012-02-17 12:00:00	YM	Futures	12793.6	12797.5	12786.6	12796.5	3127.0
2012-02-17 13:00:00	YM	Futures	12795.6	12809.4	12792.6	12808.4	3428.0
2012-02-17 14:00:00	YM	Futures	12808.4	12818.4	12805.5	12815.4	3909.0
2012-02-17 15:00:00	YM	Futures	12816.4	12830.2	12807.5	12813.4	10380.0

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

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