PREVIEW / futures_1hour / 2011-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-10.parquet
  size:    48 KB
  rows:    1,422

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
2011-03-10 00:00:00	ES	Futures	1294.79	1296.02	1292.81	1295.28	9392.0
2011-03-10 01:00:00	ES	Futures	1295.28	1296.02	1294.79	1295.78	5712.0
2011-03-10 02:00:00	ES	Futures	1295.78	1296.02	1292.31	1292.31	24370.0
2011-03-10 03:00:00	ES	Futures	1292.31	1294.29	1290.33	1293.8	43020.0
2011-03-10 04:00:00	ES	Futures	1293.8	1296.52	1292.56	1295.53	23289.0
2011-03-10 05:00:00	ES	Futures	1295.28	1295.53	1293.3	1294.79	17935.0
2011-03-10 06:00:00	ES	Futures	1295.03	1296.02	1293.55	1295.53	16776.0
2011-03-10 07:00:00	ES	Futures	1295.53	1298.5	1294.54	1296.27	60796.0
2011-03-10 08:00:00	ES	Futures	1296.52	1299.49	1293.05	1293.3	88035.0
2011-03-10 09:00:00	ES	Futures	1293.3	1294.29	1283.16	1285.88	370951.0
2011-03-10 10:00:00	ES	Futures	1285.88	1287.61	1280.93	1286.62	339638.0
2011-03-10 11:00:00	ES	Futures	1286.62	1290.58	1284.89	1290.08	170064.0
2011-03-10 12:00:00	ES	Futures	1289.84	1290.58	1285.63	1290.33	143415.0
2011-03-10 13:00:00	ES	Futures	1290.08	1291.57	1279.94	1283.4	269199.0
2011-03-10 14:00:00	ES	Futures	1283.65	1288.35	1283.16	1285.88	110682.0
2011-03-10 15:00:00	ES	Futures	1285.88	1286.62	1280.19	1281.42	188579.0
2011-03-10 16:00:00	ES	Futures	1281.42	1281.92	1278.95	1280.68	72463.0
2011-03-10 17:00:00	ES	Futures	1280.93	1282.66	1279.45	1279.94	6016.0
2011-03-10 18:00:00	ES	Futures	1281.42	1284.64	1280.19	1283.9	7284.0
2011-03-10 19:00:00	ES	Futures	1284.15	1285.14	1283.16	1284.64	3804.0
2011-03-10 20:00:00	ES	Futures	1284.39	1285.14	1282.66	1284.39	4732.0
2011-03-10 21:00:00	ES	Futures	1284.39	1284.64	1282.66	1282.91	3273.0
2011-03-10 22:00:00	ES	Futures	1283.16	1284.89	1282.17	1284.89	2382.0
2011-03-10 23:00:00	ES	Futures	1284.89	1285.63	1284.15	1284.39	2657.0
2011-03-10 00:00:00	NQ	Futures	2638.98	2640.41	2635.24	2640.41	255.0
2011-03-10 01:00:00	NQ	Futures	2640.12	2641.27	2638.69	2640.7	218.0
2011-03-10 02:00:00	NQ	Futures	2640.99	2641.27	2631.8	2632.37	1987.0
2011-03-10 03:00:00	NQ	Futures	2632.37	2637.25	2630.08	2635.53	2795.0
2011-03-10 04:00:00	NQ	Futures	2635.82	2639.55	2632.66	2637.83	2835.0
2011-03-10 05:00:00	NQ	Futures	2637.54	2637.83	2633.24	2636.68	1036.0
2011-03-10 06:00:00	NQ	Futures	2636.97	2638.69	2634.1	2636.68	1445.0
2011-03-10 07:00:00	NQ	Futures	2636.39	2643.86	2634.96	2640.41	10134.0
2011-03-10 08:00:00	NQ	Futures	2640.41	2647.59	2634.67	2634.67	13587.0
2011-03-10 09:00:00	NQ	Futures	2634.96	2636.97	2616.01	2624.34	59912.0
2011-03-10 10:00:00	NQ	Futures	2624.62	2627.21	2612.28	2625.77	48785.0
2011-03-10 11:00:00	NQ	Futures	2625.77	2632.66	2621.47	2631.51	30616.0
2011-03-10 12:00:00	NQ	Futures	2631.23	2638.4	2623.76	2637.83	34436.0
2011-03-10 13:00:00	NQ	Futures	2638.12	2640.7	2616.3	2625.49	34547.0
2011-03-10 14:00:00	NQ	Futures	2625.49	2634.67	2624.62	2629.5	15305.0
2011-03-10 15:00:00	NQ	Futures	2629.79	2631.51	2617.74	2623.76	29665.0
2011-03-10 16:00:00	NQ	Futures	2623.76	2624.91	2618.88	2622.9	6552.0
2011-03-10 17:00:00	NQ	Futures	2623.19	2624.62	2622.04	2622.04	53.0
2011-03-10 18:00:00	NQ	Futures	2623.48	2627.78	2621.75	2625.77	242.0
2011-03-10 19:00:00	NQ	Futures	2625.77	2628.64	2625.49	2626.63	162.0
2011-03-10 20:00:00	NQ	Futures	2626.63	2627.78	2622.9	2626.35	193.0
2011-03-10 21:00:00	NQ	Futures	2626.35	2626.35	2621.75	2622.33	192.0
2011-03-10 22:00:00	NQ	Futures	2622.33	2626.92	2621.75	2626.92	112.0
2011-03-10 23:00:00	NQ	Futures	2626.92	2629.22	2626.35	2626.92	148.0
2011-03-10 00:00:00	YM	Futures	11605.4	11615.1	11596.8	11608.3	54.0
2011-03-10 01:00:00	YM	Futures	11611.2	11613.2	11608.3	11613.2	23.0

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

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