PREVIEW / futures_1hour / 2012-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-02.parquet
  size:    49 KB
  rows:    1,506

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-02 00:00:00	ES	Futures	1418.74	1419.5	1418.48	1419.24	1989.0
2012-05-02 01:00:00	ES	Futures	1419.24	1420.51	1418.99	1419.5	5255.0
2012-05-02 02:00:00	ES	Futures	1419.75	1420.51	1418.74	1420.25	8027.0
2012-05-02 03:00:00	ES	Futures	1420.25	1421.52	1415.7	1416.46	50675.0
2012-05-02 04:00:00	ES	Futures	1416.46	1418.23	1415.7	1416.46	25741.0
2012-05-02 05:00:00	ES	Futures	1416.46	1418.23	1414.44	1415.7	26515.0
2012-05-02 06:00:00	ES	Futures	1415.95	1416.46	1413.17	1413.68	23921.0
2012-05-02 07:00:00	ES	Futures	1413.68	1414.69	1412.66	1413.68	34205.0
2012-05-02 08:00:00	ES	Futures	1413.68	1413.93	1408.87	1409.38	133788.0
2012-05-02 09:00:00	ES	Futures	1409.63	1412.16	1409.12	1410.39	232034.0
2012-05-02 10:00:00	ES	Futures	1410.64	1412.66	1405.83	1411.4	363333.0
2012-05-02 11:00:00	ES	Futures	1411.4	1412.66	1410.13	1411.15	194614.0
2012-05-02 12:00:00	ES	Futures	1411.15	1414.94	1410.39	1413.68	136811.0
2012-05-02 13:00:00	ES	Futures	1413.68	1414.69	1411.4	1413.93	91899.0
2012-05-02 14:00:00	ES	Futures	1414.18	1416.21	1413.42	1413.93	99164.0
2012-05-02 15:00:00	ES	Futures	1413.93	1416.21	1411.65	1414.69	165139.0
2012-05-02 16:00:00	ES	Futures	1414.69	1414.94	1413.42	1414.44	54533.0
2012-05-02 17:00:00	ES	Futures	1414.44	1414.94	1413.68	1413.93	2319.0
2012-05-02 18:00:00	ES	Futures	1413.93	1415.19	1413.68	1414.44	2682.0
2012-05-02 19:00:00	ES	Futures	1414.44	1415.19	1413.93	1414.18	1778.0
2012-05-02 20:00:00	ES	Futures	1414.18	1414.44	1413.68	1413.93	2376.0
2012-05-02 21:00:00	ES	Futures	1413.93	1414.18	1412.41	1412.92	5989.0
2012-05-02 22:00:00	ES	Futures	1412.92	1413.68	1412.16	1413.42	3528.0
2012-05-02 23:00:00	ES	Futures	1413.17	1413.68	1412.92	1413.68	1276.0
2012-05-02 00:00:00	NQ	Futures	3151.71	3152.58	3151.13	3152.58	350.0
2012-05-02 01:00:00	NQ	Futures	3152.58	3155.47	3152.58	3153.15	604.0
2012-05-02 02:00:00	NQ	Futures	3152.86	3153.44	3150.84	3152.29	865.0
2012-05-02 03:00:00	NQ	Futures	3152.29	3154.6	3140.14	3143.32	4564.0
2012-05-02 04:00:00	NQ	Futures	3142.74	3146.21	3141.3	3143.03	2187.0
2012-05-02 05:00:00	NQ	Futures	3143.03	3146.79	3137.25	3140.43	2612.0
2012-05-02 06:00:00	NQ	Futures	3140.72	3142.16	3136.67	3138.4	2199.0
2012-05-02 07:00:00	NQ	Futures	3138.4	3139.85	3135.22	3137.54	2900.0
2012-05-02 08:00:00	NQ	Futures	3137.25	3137.83	3126.55	3126.84	11252.0
2012-05-02 09:00:00	NQ	Futures	3127.41	3143.9	3126.26	3142.16	51394.0
2012-05-02 10:00:00	NQ	Futures	3142.45	3144.48	3126.26	3139.85	38418.0
2012-05-02 11:00:00	NQ	Futures	3139.85	3150.55	3136.67	3145.92	25133.0
2012-05-02 12:00:00	NQ	Futures	3145.92	3155.76	3143.61	3152.0	16306.0
2012-05-02 13:00:00	NQ	Futures	3152.29	3155.18	3145.63	3152.86	13878.0
2012-05-02 14:00:00	NQ	Futures	3153.15	3159.52	3152.29	3153.15	17729.0
2012-05-02 15:00:00	NQ	Futures	3152.86	3160.38	3148.24	3157.78	20536.0
2012-05-02 16:00:00	NQ	Futures	3157.78	3158.07	3154.89	3157.2	5495.0
2012-05-02 17:00:00	NQ	Futures	3156.91	3158.36	3156.62	3156.62	195.0
2012-05-02 18:00:00	NQ	Futures	3156.05	3157.78	3155.76	3156.91	124.0
2012-05-02 19:00:00	NQ	Futures	3156.33	3158.65	3156.33	3156.62	220.0
2012-05-02 20:00:00	NQ	Futures	3156.33	3157.2	3155.76	3155.76	286.0
2012-05-02 21:00:00	NQ	Futures	3155.47	3155.76	3152.29	3153.15	510.0
2012-05-02 22:00:00	NQ	Futures	3153.15	3154.6	3152.29	3153.73	309.0
2012-05-02 23:00:00	NQ	Futures	3154.02	3154.31	3153.15	3154.02	107.0
2012-05-02 00:00:00	YM	Futures	13184.0	13188.0	13181.0	13186.0	116.0
2012-05-02 01:00:00	YM	Futures	13186.0	13196.0	13186.0	13190.0	356.0

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

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