PREVIEW / futures_1hour / 2012-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-25.parquet
  size:    49 KB
  rows:    1,499

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-10-25 00:00:00	ES	Futures	1440.05	1440.56	1438.52	1438.52	3755.0
2012-10-25 01:00:00	ES	Futures	1438.77	1441.84	1438.52	1441.58	4677.0
2012-10-25 02:00:00	ES	Futures	1441.84	1442.86	1438.52	1439.28	13496.0
2012-10-25 03:00:00	ES	Futures	1439.28	1444.14	1438.52	1443.11	35626.0
2012-10-25 04:00:00	ES	Futures	1443.37	1445.67	1443.11	1444.14	31448.0
2012-10-25 05:00:00	ES	Futures	1444.14	1445.67	1443.11	1443.37	19377.0
2012-10-25 06:00:00	ES	Futures	1443.63	1444.39	1442.09	1443.37	18066.0
2012-10-25 07:00:00	ES	Futures	1443.37	1445.16	1443.11	1444.14	25086.0
2012-10-25 08:00:00	ES	Futures	1444.14	1446.69	1442.35	1443.88	52968.0
2012-10-25 09:00:00	ES	Futures	1444.14	1447.71	1442.6	1443.88	244965.0
2012-10-25 10:00:00	ES	Futures	1443.63	1444.9	1436.47	1438.52	394277.0
2012-10-25 11:00:00	ES	Futures	1438.77	1440.05	1430.09	1433.41	313981.0
2012-10-25 12:00:00	ES	Futures	1433.41	1437.49	1431.62	1437.24	137966.0
2012-10-25 13:00:00	ES	Futures	1437.49	1439.28	1435.96	1438.01	108719.0
2012-10-25 14:00:00	ES	Futures	1438.26	1439.79	1435.2	1437.24	92966.0
2012-10-25 15:00:00	ES	Futures	1436.98	1439.28	1434.94	1438.77	188902.0
2012-10-25 16:00:00	ES	Futures	1438.77	1441.84	1427.53	1436.98	164811.0
2012-10-25 17:00:00	ES	Futures	1436.98	1438.77	1433.41	1436.22	18725.0
2012-10-25 18:00:00	ES	Futures	1435.96	1438.01	1434.94	1437.24	6077.0
2012-10-25 19:00:00	ES	Futures	1437.24	1437.75	1434.94	1437.49	4214.0
2012-10-25 20:00:00	ES	Futures	1437.24	1437.49	1433.92	1434.94	8849.0
2012-10-25 21:00:00	ES	Futures	1434.68	1435.2	1433.41	1433.66	6384.0
2012-10-25 22:00:00	ES	Futures	1433.66	1434.94	1432.13	1432.39	5891.0
2012-10-25 23:00:00	ES	Futures	1432.39	1432.39	1427.53	1428.55	12419.0
2012-10-25 00:00:00	NQ	Futures	3093.48	3094.64	3091.15	3091.15	480.0
2012-10-25 01:00:00	NQ	Futures	3091.15	3096.09	3090.86	3095.8	532.0
2012-10-25 02:00:00	NQ	Futures	3096.09	3098.42	3091.44	3092.9	1565.0
2012-10-25 03:00:00	NQ	Futures	3092.6	3101.03	3091.44	3098.71	3496.0
2012-10-25 04:00:00	NQ	Futures	3098.71	3103.36	3098.13	3099.58	2353.0
2012-10-25 05:00:00	NQ	Futures	3099.87	3104.23	3097.83	3100.45	2021.0
2012-10-25 06:00:00	NQ	Futures	3100.45	3102.19	3099.0	3101.03	1188.0
2012-10-25 07:00:00	NQ	Futures	3101.32	3104.81	3099.29	3102.77	2076.0
2012-10-25 08:00:00	NQ	Futures	3103.07	3103.07	3097.54	3101.32	4860.0
2012-10-25 09:00:00	NQ	Futures	3101.32	3107.42	3092.02	3094.35	38344.0
2012-10-25 10:00:00	NQ	Futures	3094.35	3103.65	3082.72	3086.5	43993.0
2012-10-25 11:00:00	NQ	Futures	3086.5	3090.57	3071.68	3078.37	37003.0
2012-10-25 12:00:00	NQ	Futures	3078.66	3082.14	3071.1	3081.85	25049.0
2012-10-25 13:00:00	NQ	Futures	3082.14	3087.37	3077.49	3085.63	17637.0
2012-10-25 14:00:00	NQ	Futures	3085.92	3089.12	3077.2	3083.02	19522.0
2012-10-25 15:00:00	NQ	Futures	3083.31	3084.76	3074.59	3080.11	35406.0
2012-10-25 16:00:00	NQ	Futures	3080.11	3085.05	3027.22	3065.58	54242.0
2012-10-25 17:00:00	NQ	Futures	3066.16	3071.97	3054.83	3068.49	10792.0
2012-10-25 18:00:00	NQ	Futures	3069.94	3077.79	3067.32	3076.04	3368.0
2012-10-25 19:00:00	NQ	Futures	3076.04	3078.08	3073.43	3075.17	1268.0
2012-10-25 20:00:00	NQ	Futures	3074.88	3075.46	3072.85	3075.17	951.0
2012-10-25 21:00:00	NQ	Futures	3075.17	3076.33	3071.39	3071.97	530.0
2012-10-25 22:00:00	NQ	Futures	3071.97	3074.3	3067.61	3068.49	803.0
2012-10-25 23:00:00	NQ	Futures	3068.49	3068.49	3055.99	3057.44	1516.0
2012-10-25 00:00:00	YM	Futures	13057.7	13062.7	13047.7	13047.7	411.0
2012-10-25 01:00:00	YM	Futures	13047.7	13068.7	13046.7	13068.7	580.0

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

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