PREVIEW / futures_1hour / 2012-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-29.parquet
  size:    50 KB
  rows:    1,488

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-03-29 00:00:00	ES	Futures	1416.97	1417.47	1415.95	1416.97	2571.0
2012-03-29 01:00:00	ES	Futures	1416.97	1417.22	1414.94	1415.45	3205.0
2012-03-29 02:00:00	ES	Futures	1415.19	1417.47	1415.19	1416.97	6387.0
2012-03-29 03:00:00	ES	Futures	1416.71	1420.76	1415.95	1419.75	44608.0
2012-03-29 04:00:00	ES	Futures	1419.75	1420.0	1416.21	1416.97	25549.0
2012-03-29 05:00:00	ES	Futures	1417.22	1417.47	1412.16	1412.16	46318.0
2012-03-29 06:00:00	ES	Futures	1412.41	1413.42	1411.4	1412.66	28101.0
2012-03-29 07:00:00	ES	Futures	1412.41	1414.18	1411.4	1413.93	43764.0
2012-03-29 08:00:00	ES	Futures	1413.68	1414.18	1410.39	1412.41	59142.0
2012-03-29 09:00:00	ES	Futures	1412.41	1412.66	1405.58	1407.6	255685.0
2012-03-29 10:00:00	ES	Futures	1407.6	1409.63	1403.05	1406.59	299053.0
2012-03-29 11:00:00	ES	Futures	1406.59	1407.6	1402.8	1404.32	267788.0
2012-03-29 12:00:00	ES	Futures	1404.32	1407.6	1403.3	1407.1	157757.0
2012-03-29 13:00:00	ES	Futures	1407.35	1407.35	1404.82	1405.83	92525.0
2012-03-29 14:00:00	ES	Futures	1405.83	1410.89	1405.58	1409.38	130414.0
2012-03-29 15:00:00	ES	Futures	1409.63	1416.46	1408.62	1414.18	259088.0
2012-03-29 16:00:00	ES	Futures	1414.44	1415.45	1413.93	1415.45	78647.0
2012-03-29 17:00:00	ES	Futures	1415.7	1416.21	1414.44	1414.44	3331.0
2012-03-29 18:00:00	ES	Futures	1414.69	1414.94	1414.18	1414.44	3346.0
2012-03-29 19:00:00	ES	Futures	1414.44	1414.69	1413.42	1414.18	4328.0
2012-03-29 20:00:00	ES	Futures	1414.44	1416.21	1413.93	1415.7	5441.0
2012-03-29 21:00:00	ES	Futures	1415.7	1419.75	1415.45	1418.74	13320.0
2012-03-29 22:00:00	ES	Futures	1418.99	1420.25	1418.23	1418.48	3913.0
2012-03-29 23:00:00	ES	Futures	1418.74	1418.99	1417.72	1418.23	1868.0
2012-03-29 00:00:00	NQ	Futures	3200.58	3202.61	3198.85	3202.03	248.0
2012-03-29 01:00:00	NQ	Futures	3201.45	3201.74	3196.53	3197.4	391.0
2012-03-29 02:00:00	NQ	Futures	3197.4	3202.32	3197.11	3200.58	793.0
2012-03-29 03:00:00	NQ	Futures	3200.58	3208.1	3198.85	3206.37	3517.0
2012-03-29 04:00:00	NQ	Futures	3206.66	3206.94	3200.87	3202.32	1755.0
2012-03-29 05:00:00	NQ	Futures	3202.61	3202.61	3193.06	3193.35	2931.0
2012-03-29 06:00:00	NQ	Futures	3193.06	3195.38	3190.75	3194.22	3597.0
2012-03-29 07:00:00	NQ	Futures	3193.93	3197.11	3189.3	3195.96	3920.0
2012-03-29 08:00:00	NQ	Futures	3195.67	3197.11	3189.3	3193.93	4967.0
2012-03-29 09:00:00	NQ	Futures	3193.93	3200.29	3181.5	3186.99	41016.0
2012-03-29 10:00:00	NQ	Futures	3186.7	3194.8	3178.02	3186.12	39689.0
2012-03-29 11:00:00	NQ	Futures	3185.83	3187.57	3167.04	3169.93	38651.0
2012-03-29 12:00:00	NQ	Futures	3170.22	3178.89	3166.17	3178.02	25911.0
2012-03-29 13:00:00	NQ	Futures	3177.74	3178.02	3168.77	3171.95	13787.0
2012-03-29 14:00:00	NQ	Futures	3171.95	3186.12	3171.66	3184.39	19586.0
2012-03-29 15:00:00	NQ	Futures	3184.39	3195.67	3181.21	3189.59	33840.0
2012-03-29 16:00:00	NQ	Futures	3189.59	3192.48	3189.01	3192.48	8997.0
2012-03-29 17:00:00	NQ	Futures	3192.48	3193.35	3187.86	3187.86	585.0
2012-03-29 18:00:00	NQ	Futures	3190.17	3190.17	3186.99	3187.86	438.0
2012-03-29 19:00:00	NQ	Futures	3187.86	3188.73	3186.41	3187.57	508.0
2012-03-29 20:00:00	NQ	Futures	3187.86	3192.2	3187.57	3191.33	525.0
2012-03-29 21:00:00	NQ	Futures	3191.33	3200.29	3191.33	3197.98	1396.0
2012-03-29 22:00:00	NQ	Futures	3198.27	3200.58	3196.53	3197.69	406.0
2012-03-29 23:00:00	NQ	Futures	3197.69	3198.56	3196.24	3197.4	239.0
2012-03-29 00:00:00	YM	Futures	13002.7	13007.7	12997.7	13002.7	131.0
2012-03-29 01:00:00	YM	Futures	13003.7	13004.7	12986.8	12992.7	383.0

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

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