PREVIEW / futures_1hour / 2012-10-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1460.23	1460.49	1459.46	1459.98	3072.0
2012-10-23 01:00:00	ES	Futures	1459.98	1459.98	1458.7	1458.95	4013.0
2012-10-23 02:00:00	ES	Futures	1458.95	1459.21	1456.91	1457.68	10577.0
2012-10-23 03:00:00	ES	Futures	1457.68	1458.19	1450.27	1451.54	50628.0
2012-10-23 04:00:00	ES	Futures	1451.54	1452.06	1450.27	1451.29	26848.0
2012-10-23 05:00:00	ES	Futures	1451.03	1452.82	1449.5	1451.8	30940.0
2012-10-23 06:00:00	ES	Futures	1451.8	1452.31	1441.84	1444.14	85751.0
2012-10-23 07:00:00	ES	Futures	1444.14	1447.71	1443.88	1445.92	48947.0
2012-10-23 08:00:00	ES	Futures	1445.92	1446.18	1441.84	1444.14	74413.0
2012-10-23 09:00:00	ES	Futures	1444.14	1445.16	1438.26	1440.56	261678.0
2012-10-23 10:00:00	ES	Futures	1440.3	1442.86	1432.64	1436.22	440589.0
2012-10-23 11:00:00	ES	Futures	1436.47	1438.26	1434.17	1436.98	222789.0
2012-10-23 12:00:00	ES	Futures	1437.24	1441.58	1435.71	1440.56	159506.0
2012-10-23 13:00:00	ES	Futures	1440.82	1443.37	1439.03	1441.58	155647.0
2012-10-23 14:00:00	ES	Futures	1441.58	1444.65	1437.24	1443.37	208705.0
2012-10-23 15:00:00	ES	Futures	1443.37	1445.41	1437.49	1438.52	346030.0
2012-10-23 16:00:00	ES	Futures	1438.52	1439.28	1436.47	1439.28	133384.0
2012-10-23 17:00:00	ES	Futures	1439.28	1439.54	1438.77	1439.28	2578.0
2012-10-23 18:00:00	ES	Futures	1439.03	1439.79	1439.03	1439.03	1807.0
2012-10-23 19:00:00	ES	Futures	1439.03	1440.3	1438.77	1439.79	3417.0
2012-10-23 20:00:00	ES	Futures	1439.79	1441.84	1439.79	1441.84	8532.0
2012-10-23 21:00:00	ES	Futures	1441.58	1443.63	1441.33	1442.35	10495.0
2012-10-23 22:00:00	ES	Futures	1442.35	1444.39	1442.35	1442.6	7489.0
2012-10-23 23:00:00	ES	Futures	1442.86	1444.9	1442.6	1444.65	6872.0
2012-10-23 00:00:00	NQ	Futures	3121.66	3122.53	3120.79	3122.24	266.0
2012-10-23 01:00:00	NQ	Futures	3121.95	3121.95	3119.92	3120.21	351.0
2012-10-23 02:00:00	NQ	Futures	3119.92	3120.79	3116.72	3117.01	840.0
2012-10-23 03:00:00	NQ	Futures	3117.3	3118.76	3101.03	3103.94	4759.0
2012-10-23 04:00:00	NQ	Futures	3103.36	3104.52	3101.32	3101.61	2243.0
2012-10-23 05:00:00	NQ	Futures	3101.61	3105.1	3099.58	3102.77	3371.0
2012-10-23 06:00:00	NQ	Futures	3103.07	3104.52	3089.12	3090.86	6197.0
2012-10-23 07:00:00	NQ	Futures	3091.15	3100.16	3090.86	3095.22	6230.0
2012-10-23 08:00:00	NQ	Futures	3095.51	3095.8	3087.96	3091.44	8719.0
2012-10-23 09:00:00	NQ	Futures	3091.44	3100.45	3087.66	3094.35	44571.0
2012-10-23 10:00:00	NQ	Futures	3094.35	3105.39	3081.85	3093.48	66602.0
2012-10-23 11:00:00	NQ	Futures	3093.48	3098.42	3089.12	3097.54	31158.0
2012-10-23 12:00:00	NQ	Futures	3097.83	3113.53	3094.35	3109.75	32104.0
2012-10-23 13:00:00	NQ	Futures	3109.75	3118.18	3101.61	3107.71	37424.0
2012-10-23 14:00:00	NQ	Futures	3108.01	3112.65	3089.99	3105.97	43557.0
2012-10-23 15:00:00	NQ	Futures	3105.97	3112.07	3088.54	3090.57	53410.0
2012-10-23 16:00:00	NQ	Futures	3090.28	3096.09	3088.54	3095.8	10465.0
2012-10-23 17:00:00	NQ	Futures	3095.8	3097.54	3095.51	3097.54	376.0
2012-10-23 18:00:00	NQ	Futures	3097.25	3098.13	3095.8	3095.8	227.0
2012-10-23 19:00:00	NQ	Futures	3095.51	3098.42	3095.22	3097.83	250.0
2012-10-23 20:00:00	NQ	Futures	3098.13	3102.19	3098.13	3101.9	692.0
2012-10-23 21:00:00	NQ	Futures	3101.9	3107.13	3101.32	3104.23	1144.0
2012-10-23 22:00:00	NQ	Futures	3104.52	3109.75	3104.52	3106.84	1277.0
2012-10-23 23:00:00	NQ	Futures	3106.84	3108.3	3105.39	3107.71	1384.0
2012-10-23 00:00:00	YM	Futures	13287.8	13289.8	13283.8	13288.8	273.0
2012-10-23 01:00:00	YM	Futures	13288.8	13288.8	13278.8	13280.8	265.0

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

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