PREVIEW / futures_1hour / 2012-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-03.parquet
  size:    42 KB
  rows:    1,175

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-08-03 00:00:00	ES	Futures	1385.84	1385.84	1384.57	1385.59	1771.0
2012-08-03 01:00:00	ES	Futures	1385.59	1386.86	1385.08	1385.34	3349.0
2012-08-03 02:00:00	ES	Futures	1385.34	1388.64	1385.34	1388.39	10441.0
2012-08-03 03:00:00	ES	Futures	1388.64	1391.95	1387.12	1391.95	46710.0
2012-08-03 04:00:00	ES	Futures	1391.69	1395.0	1391.69	1393.73	49185.0
2012-08-03 05:00:00	ES	Futures	1393.47	1397.03	1392.96	1393.73	35421.0
2012-08-03 06:00:00	ES	Futures	1393.98	1398.3	1393.47	1398.05	43181.0
2012-08-03 07:00:00	ES	Futures	1398.05	1400.34	1396.52	1396.78	54047.0
2012-08-03 08:00:00	ES	Futures	1396.78	1403.64	1396.02	1401.36	156120.0
2012-08-03 09:00:00	ES	Futures	1401.61	1408.22	1401.36	1407.71	360050.0
2012-08-03 10:00:00	ES	Futures	1407.97	1412.04	1407.71	1410.26	308339.0
2012-08-03 11:00:00	ES	Futures	1410.0	1413.56	1409.49	1413.31	261752.0
2012-08-03 12:00:00	ES	Futures	1413.31	1414.32	1412.04	1412.04	87962.0
2012-08-03 13:00:00	ES	Futures	1412.04	1413.31	1411.27	1412.29	52249.0
2012-08-03 14:00:00	ES	Futures	1412.54	1413.56	1411.27	1412.29	64537.0
2012-08-03 15:00:00	ES	Futures	1412.29	1413.31	1408.22	1411.02	265747.0
2012-08-03 16:00:00	ES	Futures	1411.02	1413.56	1410.0	1413.31	110384.0
2012-08-03 00:00:00	NQ	Futures	3039.15	3039.44	3036.54	3038.28	382.0
2012-08-03 01:00:00	NQ	Futures	3038.57	3040.89	3037.12	3037.99	367.0
2012-08-03 02:00:00	NQ	Futures	3037.99	3045.82	3037.99	3044.37	1200.0
2012-08-03 03:00:00	NQ	Futures	3044.37	3052.2	3041.76	3051.91	3689.0
2012-08-03 04:00:00	NQ	Futures	3051.91	3059.45	3051.91	3056.55	3435.0
2012-08-03 05:00:00	NQ	Futures	3056.55	3063.5	3055.97	3057.42	2682.0
2012-08-03 06:00:00	NQ	Futures	3057.71	3065.82	3057.71	3065.82	3691.0
2012-08-03 07:00:00	NQ	Futures	3065.82	3069.59	3062.63	3063.5	5161.0
2012-08-03 08:00:00	NQ	Futures	3063.21	3079.16	3061.76	3078.29	18676.0
2012-08-03 09:00:00	NQ	Futures	3078.29	3095.1	3075.68	3093.94	51243.0
2012-08-03 10:00:00	NQ	Futures	3094.23	3102.64	3093.94	3098.87	37215.0
2012-08-03 11:00:00	NQ	Futures	3099.16	3106.12	3097.71	3105.25	22295.0
2012-08-03 12:00:00	NQ	Futures	3105.54	3106.7	3100.03	3102.06	11688.0
2012-08-03 13:00:00	NQ	Futures	3102.35	3104.67	3101.48	3103.51	6521.0
2012-08-03 14:00:00	NQ	Futures	3103.51	3109.02	3101.77	3102.64	11521.0
2012-08-03 15:00:00	NQ	Futures	3102.93	3105.83	3093.36	3095.97	31433.0
2012-08-03 16:00:00	NQ	Futures	3095.97	3101.48	3093.94	3099.74	9371.0
2012-08-03 00:00:00	YM	Futures	12767.1	12768.1	12758.2	12765.1	212.0
2012-08-03 01:00:00	YM	Futures	12766.1	12773.1	12759.2	12763.2	254.0
2012-08-03 02:00:00	YM	Futures	12762.2	12785.0	12762.2	12783.0	752.0
2012-08-03 03:00:00	YM	Futures	12783.0	12809.9	12772.1	12806.9	2340.0
2012-08-03 04:00:00	YM	Futures	12807.9	12831.8	12806.9	12820.8	2753.0
2012-08-03 05:00:00	YM	Futures	12818.8	12844.7	12816.9	12821.8	1853.0
2012-08-03 06:00:00	YM	Futures	12822.8	12861.6	12822.8	12860.6	2071.0
2012-08-03 07:00:00	YM	Futures	12861.6	12877.5	12851.7	12853.6	2538.0
2012-08-03 08:00:00	YM	Futures	12853.6	12911.3	12844.7	12891.4	9330.0
2012-08-03 09:00:00	YM	Futures	12892.4	12953.1	12891.4	12949.1	22587.0
2012-08-03 10:00:00	YM	Futures	12950.1	12986.9	12950.1	12969.0	17599.0
2012-08-03 11:00:00	YM	Futures	12969.0	12998.8	12961.0	12996.8	12734.0
2012-08-03 12:00:00	YM	Futures	12997.8	13006.8	12986.9	12987.9	7455.0
2012-08-03 13:00:00	YM	Futures	12988.9	12996.8	12977.0	12984.9	3540.0
2012-08-03 14:00:00	YM	Futures	12983.9	12990.9	12973.0	12977.9	4240.0
2012-08-03 15:00:00	YM	Futures	12977.9	12988.9	12942.2	12977.9	13081.0

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

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