PREVIEW / futures_1hour / 2012-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-24.parquet
  size:    48 KB
  rows:    1,502

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-24 00:00:00	ES	Futures	1444.65	1445.67	1444.39	1444.39	5394.0
2012-10-24 01:00:00	ES	Futures	1444.65	1444.9	1442.09	1442.6	6127.0
2012-10-24 02:00:00	ES	Futures	1442.35	1443.37	1441.33	1441.84	6851.0
2012-10-24 03:00:00	ES	Futures	1441.84	1443.37	1438.77	1440.05	37205.0
2012-10-24 04:00:00	ES	Futures	1440.05	1441.84	1435.45	1440.82	60115.0
2012-10-24 05:00:00	ES	Futures	1440.82	1442.35	1440.05	1441.07	21336.0
2012-10-24 06:00:00	ES	Futures	1441.07	1443.37	1440.3	1441.58	24926.0
2012-10-24 07:00:00	ES	Futures	1441.33	1442.86	1439.54	1442.35	30517.0
2012-10-24 08:00:00	ES	Futures	1442.35	1444.39	1442.09	1443.88	40892.0
2012-10-24 09:00:00	ES	Futures	1444.14	1445.92	1440.3	1442.09	212393.0
2012-10-24 10:00:00	ES	Futures	1441.84	1443.11	1438.26	1441.33	360311.0
2012-10-24 11:00:00	ES	Futures	1441.33	1442.86	1437.24	1437.75	153268.0
2012-10-24 12:00:00	ES	Futures	1437.49	1441.58	1436.98	1441.33	116610.0
2012-10-24 13:00:00	ES	Futures	1441.07	1441.84	1439.54	1440.05	59566.0
2012-10-24 14:00:00	ES	Futures	1440.05	1442.09	1435.71	1437.24	184554.0
2012-10-24 15:00:00	ES	Futures	1437.24	1438.52	1432.39	1434.68	310611.0
2012-10-24 16:00:00	ES	Futures	1434.68	1438.26	1433.92	1437.49	84511.0
2012-10-24 17:00:00	ES	Futures	1437.49	1437.75	1437.49	1437.75	2034.0
2012-10-24 18:00:00	ES	Futures	1437.75	1438.01	1435.96	1436.73	5909.0
2012-10-24 19:00:00	ES	Futures	1436.73	1436.98	1435.71	1435.96	3606.0
2012-10-24 20:00:00	ES	Futures	1435.71	1438.77	1435.2	1437.75	5321.0
2012-10-24 21:00:00	ES	Futures	1438.01	1439.03	1437.49	1438.77	4604.0
2012-10-24 22:00:00	ES	Futures	1438.77	1442.35	1438.77	1440.3	10000.0
2012-10-24 23:00:00	ES	Futures	1440.3	1441.07	1439.28	1440.05	3238.0
2012-10-24 00:00:00	NQ	Futures	3107.71	3108.01	3105.39	3105.68	929.0
2012-10-24 01:00:00	NQ	Futures	3105.68	3106.26	3101.32	3102.19	713.0
2012-10-24 02:00:00	NQ	Futures	3101.9	3102.48	3099.0	3099.0	947.0
2012-10-24 03:00:00	NQ	Futures	3099.0	3102.19	3094.64	3096.96	2981.0
2012-10-24 04:00:00	NQ	Futures	3096.09	3101.03	3088.54	3099.0	4360.0
2012-10-24 05:00:00	NQ	Futures	3099.0	3101.03	3093.77	3097.25	2017.0
2012-10-24 06:00:00	NQ	Futures	3096.96	3102.48	3095.22	3098.42	1867.0
2012-10-24 07:00:00	NQ	Futures	3098.42	3102.48	3095.51	3101.9	1824.0
2012-10-24 08:00:00	NQ	Futures	3102.19	3107.13	3101.03	3106.26	4260.0
2012-10-24 09:00:00	NQ	Futures	3106.26	3115.56	3098.13	3104.52	39436.0
2012-10-24 10:00:00	NQ	Futures	3104.23	3107.13	3089.99	3091.44	48442.0
2012-10-24 11:00:00	NQ	Futures	3091.73	3095.22	3079.53	3081.27	28903.0
2012-10-24 12:00:00	NQ	Futures	3080.98	3093.48	3078.08	3091.73	24956.0
2012-10-24 13:00:00	NQ	Futures	3091.73	3093.48	3086.5	3090.57	14000.0
2012-10-24 14:00:00	NQ	Futures	3090.57	3095.51	3081.27	3086.21	30510.0
2012-10-24 15:00:00	NQ	Futures	3086.5	3088.83	3075.75	3078.37	43796.0
2012-10-24 16:00:00	NQ	Futures	3078.95	3086.79	3077.79	3085.05	6442.0
2012-10-24 17:00:00	NQ	Futures	3085.05	3086.21	3085.05	3085.34	121.0
2012-10-24 18:00:00	NQ	Futures	3085.34	3086.79	3083.6	3084.76	343.0
2012-10-24 19:00:00	NQ	Futures	3085.05	3085.92	3082.43	3083.02	322.0
2012-10-24 20:00:00	NQ	Futures	3083.31	3088.54	3080.69	3087.66	578.0
2012-10-24 21:00:00	NQ	Futures	3087.66	3088.83	3085.05	3088.25	457.0
2012-10-24 22:00:00	NQ	Futures	3088.25	3096.96	3088.25	3093.48	1730.0
2012-10-24 23:00:00	NQ	Futures	3093.48	3094.64	3090.86	3093.19	324.0
2012-10-24 00:00:00	YM	Futures	13095.7	13098.7	13085.7	13085.7	792.0
2012-10-24 01:00:00	YM	Futures	13084.7	13086.7	13070.7	13070.7	1410.0

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

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