PREVIEW / futures_1hour / 2012-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-03.parquet
  size:    48 KB
  rows:    1,493

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-05-03 00:00:00	ES	Futures	1413.42	1413.93	1413.17	1413.17	1176.0
2012-05-03 01:00:00	ES	Futures	1413.17	1414.44	1413.17	1414.18	1771.0
2012-05-03 02:00:00	ES	Futures	1414.18	1414.69	1412.41	1413.42	5063.0
2012-05-03 03:00:00	ES	Futures	1413.42	1416.97	1413.17	1415.7	28627.0
2012-05-03 04:00:00	ES	Futures	1415.7	1416.46	1412.66	1413.93	19673.0
2012-05-03 05:00:00	ES	Futures	1414.18	1415.95	1413.17	1415.95	16559.0
2012-05-03 06:00:00	ES	Futures	1415.7	1417.72	1415.19	1416.97	13666.0
2012-05-03 07:00:00	ES	Futures	1416.97	1418.48	1416.97	1417.72	24910.0
2012-05-03 08:00:00	ES	Futures	1417.47	1419.5	1414.44	1415.95	112462.0
2012-05-03 09:00:00	ES	Futures	1415.7	1416.46	1412.16	1414.18	211572.0
2012-05-03 10:00:00	ES	Futures	1414.18	1414.18	1407.6	1413.17	363263.0
2012-05-03 11:00:00	ES	Futures	1413.17	1414.18	1407.6	1408.62	237571.0
2012-05-03 12:00:00	ES	Futures	1408.62	1409.88	1407.35	1407.86	124841.0
2012-05-03 13:00:00	ES	Futures	1408.11	1408.62	1401.79	1403.3	173077.0
2012-05-03 14:00:00	ES	Futures	1403.05	1404.06	1401.03	1402.55	93628.0
2012-05-03 15:00:00	ES	Futures	1402.55	1406.09	1401.79	1404.32	220171.0
2012-05-03 16:00:00	ES	Futures	1404.06	1404.32	1401.53	1403.81	90026.0
2012-05-03 17:00:00	ES	Futures	1403.56	1403.81	1402.55	1402.8	3049.0
2012-05-03 18:00:00	ES	Futures	1403.56	1404.06	1402.04	1403.3	3735.0
2012-05-03 19:00:00	ES	Futures	1403.3	1404.06	1402.8	1403.05	1739.0
2012-05-03 20:00:00	ES	Futures	1403.05	1403.05	1401.28	1401.79	2975.0
2012-05-03 21:00:00	ES	Futures	1402.04	1403.56	1401.53	1403.05	2239.0
2012-05-03 22:00:00	ES	Futures	1403.05	1403.81	1402.29	1402.8	1358.0
2012-05-03 23:00:00	ES	Futures	1402.8	1403.3	1402.55	1402.55	983.0
2012-05-03 00:00:00	NQ	Futures	3153.73	3154.31	3152.86	3153.15	72.0
2012-05-03 01:00:00	NQ	Futures	3153.44	3156.33	3153.15	3156.05	199.0
2012-05-03 02:00:00	NQ	Futures	3156.05	3156.33	3152.29	3154.02	526.0
2012-05-03 03:00:00	NQ	Futures	3154.02	3161.54	3154.02	3159.81	2821.0
2012-05-03 04:00:00	NQ	Futures	3159.52	3162.12	3154.31	3156.91	1767.0
2012-05-03 05:00:00	NQ	Futures	3156.91	3160.38	3154.31	3160.09	1339.0
2012-05-03 06:00:00	NQ	Futures	3160.67	3163.85	3158.94	3162.99	1148.0
2012-05-03 07:00:00	NQ	Futures	3162.99	3165.3	3162.7	3163.85	1811.0
2012-05-03 08:00:00	NQ	Futures	3163.56	3167.61	3158.65	3162.7	8722.0
2012-05-03 09:00:00	NQ	Futures	3162.41	3162.7	3151.13	3155.76	35629.0
2012-05-03 10:00:00	NQ	Futures	3155.47	3155.76	3144.77	3155.18	52327.0
2012-05-03 11:00:00	NQ	Futures	3155.18	3155.47	3134.93	3136.09	54111.0
2012-05-03 12:00:00	NQ	Futures	3136.09	3138.98	3128.57	3133.78	20543.0
2012-05-03 13:00:00	NQ	Futures	3134.07	3135.51	3117.87	3119.9	24160.0
2012-05-03 14:00:00	NQ	Futures	3119.9	3124.52	3115.56	3120.18	16174.0
2012-05-03 15:00:00	NQ	Futures	3119.9	3131.17	3117.58	3124.81	35864.0
2012-05-03 16:00:00	NQ	Futures	3125.1	3126.26	3114.98	3119.32	14164.0
2012-05-03 17:00:00	NQ	Futures	3119.32	3119.61	3116.71	3117.29	497.0
2012-05-03 18:00:00	NQ	Futures	3117.87	3119.61	3115.85	3117.29	278.0
2012-05-03 19:00:00	NQ	Futures	3117.0	3119.32	3117.0	3117.87	246.0
2012-05-03 20:00:00	NQ	Futures	3118.45	3118.45	3114.4	3115.56	368.0
2012-05-03 21:00:00	NQ	Futures	3115.85	3119.32	3114.98	3118.45	308.0
2012-05-03 22:00:00	NQ	Futures	3118.74	3119.61	3116.71	3117.29	169.0
2012-05-03 23:00:00	NQ	Futures	3117.29	3118.16	3117.0	3117.58	84.0
2012-05-03 00:00:00	YM	Futures	13149.2	13152.2	13147.2	13147.2	78.0
2012-05-03 01:00:00	YM	Futures	13149.2	13156.1	13149.2	13155.1	205.0

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

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