PREVIEW / futures_1hour / 2012-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-17.parquet
  size:    48 KB
  rows:    1,484

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-04-17 00:00:00	ES	Futures	1380.28	1380.28	1379.02	1379.52	1797.0
2012-04-17 01:00:00	ES	Futures	1379.78	1379.78	1378.51	1379.52	3293.0
2012-04-17 02:00:00	ES	Futures	1379.52	1379.52	1375.48	1377.25	14509.0
2012-04-17 03:00:00	ES	Futures	1377.5	1384.84	1376.49	1383.82	36284.0
2012-04-17 04:00:00	ES	Futures	1384.08	1386.35	1382.81	1385.85	28071.0
2012-04-17 05:00:00	ES	Futures	1385.85	1388.38	1385.6	1386.1	31198.0
2012-04-17 06:00:00	ES	Futures	1385.85	1389.39	1385.34	1387.37	21940.0
2012-04-17 07:00:00	ES	Futures	1387.62	1389.9	1386.61	1387.62	39296.0
2012-04-17 08:00:00	ES	Futures	1387.37	1389.39	1386.35	1388.88	53384.0
2012-04-17 09:00:00	ES	Futures	1389.14	1392.93	1388.88	1390.66	289630.0
2012-04-17 10:00:00	ES	Futures	1390.66	1398.24	1388.13	1397.23	354466.0
2012-04-17 11:00:00	ES	Futures	1397.49	1401.03	1397.23	1399.76	260909.0
2012-04-17 12:00:00	ES	Futures	1400.02	1403.81	1399.76	1402.8	174351.0
2012-04-17 13:00:00	ES	Futures	1402.8	1404.32	1402.29	1403.3	78791.0
2012-04-17 14:00:00	ES	Futures	1403.56	1405.33	1402.8	1404.06	100514.0
2012-04-17 15:00:00	ES	Futures	1403.81	1405.33	1402.04	1402.29	205448.0
2012-04-17 16:00:00	ES	Futures	1402.55	1403.05	1399.26	1400.02	129497.0
2012-04-17 17:00:00	ES	Futures	1399.76	1400.52	1399.26	1399.51	3548.0
2012-04-17 18:00:00	ES	Futures	1399.51	1400.77	1399.51	1400.27	2700.0
2012-04-17 19:00:00	ES	Futures	1400.02	1401.53	1400.02	1401.53	3101.0
2012-04-17 20:00:00	ES	Futures	1401.28	1403.05	1401.28	1402.55	8517.0
2012-04-17 21:00:00	ES	Futures	1402.55	1402.8	1401.28	1401.28	3512.0
2012-04-17 22:00:00	ES	Futures	1401.28	1401.79	1400.77	1401.53	2362.0
2012-04-17 23:00:00	ES	Futures	1401.53	1403.3	1401.53	1402.55	4115.0
2012-04-17 00:00:00	NQ	Futures	3079.99	3080.85	3078.25	3079.99	360.0
2012-04-17 01:00:00	NQ	Futures	3079.99	3079.99	3077.38	3077.96	375.0
2012-04-17 02:00:00	NQ	Futures	3077.67	3078.83	3070.44	3073.62	2452.0
2012-04-17 03:00:00	NQ	Futures	3073.62	3089.53	3071.89	3088.37	4973.0
2012-04-17 04:00:00	NQ	Futures	3088.37	3090.98	3086.06	3089.82	2829.0
2012-04-17 05:00:00	NQ	Futures	3090.11	3095.31	3089.53	3090.98	3549.0
2012-04-17 06:00:00	NQ	Futures	3091.26	3097.34	3089.53	3094.45	3184.0
2012-04-17 07:00:00	NQ	Futures	3094.16	3096.18	3090.4	3092.13	3614.0
2012-04-17 08:00:00	NQ	Futures	3092.13	3099.65	3090.98	3097.05	10245.0
2012-04-17 09:00:00	NQ	Futures	3096.76	3114.11	3091.26	3112.95	62988.0
2012-04-17 10:00:00	NQ	Futures	3112.95	3127.99	3106.59	3125.68	58806.0
2012-04-17 11:00:00	NQ	Futures	3125.68	3136.09	3125.68	3133.49	33300.0
2012-04-17 12:00:00	NQ	Futures	3133.49	3146.5	3132.91	3144.19	23218.0
2012-04-17 13:00:00	NQ	Futures	3144.48	3149.97	3141.59	3148.53	17200.0
2012-04-17 14:00:00	NQ	Futures	3148.53	3153.15	3148.24	3151.13	16733.0
2012-04-17 15:00:00	NQ	Futures	3151.13	3156.05	3145.35	3145.35	39636.0
2012-04-17 16:00:00	NQ	Futures	3145.35	3146.21	3137.54	3139.56	14488.0
2012-04-17 17:00:00	NQ	Futures	3139.56	3140.72	3138.69	3138.69	474.0
2012-04-17 18:00:00	NQ	Futures	3140.14	3142.45	3139.27	3141.01	260.0
2012-04-17 19:00:00	NQ	Futures	3141.01	3144.19	3141.01	3143.9	308.0
2012-04-17 20:00:00	NQ	Futures	3144.19	3147.08	3143.61	3145.35	606.0
2012-04-17 21:00:00	NQ	Futures	3145.35	3146.21	3142.74	3143.03	383.0
2012-04-17 22:00:00	NQ	Futures	3143.03	3143.9	3141.87	3143.61	246.0
2012-04-17 23:00:00	NQ	Futures	3143.9	3146.79	3143.61	3145.35	445.0
2012-04-17 00:00:00	YM	Futures	12806.4	12806.4	12797.5	12803.4	172.0
2012-04-17 01:00:00	YM	Futures	12802.4	12804.4	12793.5	12798.5	608.0

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

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