PREVIEW / futures_1hour / 2012-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-21.parquet
  size:    49 KB
  rows:    1,491

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-21 00:00:00	ES	Futures	1419.5	1420.25	1418.99	1419.75	3573.0
2012-03-21 01:00:00	ES	Futures	1420.0	1420.25	1418.48	1418.74	4569.0
2012-03-21 02:00:00	ES	Futures	1418.74	1419.5	1418.23	1419.24	3681.0
2012-03-21 03:00:00	ES	Futures	1419.5	1420.51	1418.48	1420.25	8293.0
2012-03-21 04:00:00	ES	Futures	1420.25	1422.53	1420.0	1421.52	27765.0
2012-03-21 05:00:00	ES	Futures	1421.27	1421.52	1418.74	1420.25	33270.0
2012-03-21 06:00:00	ES	Futures	1420.51	1421.01	1418.99	1419.75	20369.0
2012-03-21 07:00:00	ES	Futures	1419.75	1420.25	1418.74	1420.25	24068.0
2012-03-21 08:00:00	ES	Futures	1420.25	1420.51	1416.21	1417.22	52944.0
2012-03-21 09:00:00	ES	Futures	1417.22	1418.48	1414.69	1415.45	171406.0
2012-03-21 10:00:00	ES	Futures	1415.45	1416.46	1411.65	1412.16	338053.0
2012-03-21 11:00:00	ES	Futures	1412.16	1415.7	1410.89	1413.68	216165.0
2012-03-21 12:00:00	ES	Futures	1413.93	1417.72	1413.68	1417.22	127061.0
2012-03-21 13:00:00	ES	Futures	1416.97	1417.22	1414.18	1415.45	80763.0
2012-03-21 14:00:00	ES	Futures	1415.7	1417.72	1415.19	1416.46	99829.0
2012-03-21 15:00:00	ES	Futures	1416.46	1418.48	1413.93	1413.93	185343.0
2012-03-21 16:00:00	ES	Futures	1414.18	1414.94	1412.66	1413.68	87766.0
2012-03-21 17:00:00	ES	Futures	1413.68	1413.93	1413.17	1413.42	1620.0
2012-03-21 18:00:00	ES	Futures	1413.68	1415.19	1413.68	1414.69	3609.0
2012-03-21 19:00:00	ES	Futures	1414.69	1415.45	1414.18	1415.45	2164.0
2012-03-21 20:00:00	ES	Futures	1415.45	1416.46	1414.69	1416.21	4644.0
2012-03-21 21:00:00	ES	Futures	1416.21	1416.97	1415.45	1416.46	4727.0
2012-03-21 22:00:00	ES	Futures	1416.71	1417.47	1410.39	1411.15	17644.0
2012-03-21 23:00:00	ES	Futures	1410.89	1412.41	1410.89	1411.91	6101.0
2012-03-21 00:00:00	NQ	Futures	3169.64	3170.51	3168.19	3170.22	329.0
2012-03-21 01:00:00	NQ	Futures	3170.22	3170.51	3167.61	3167.9	299.0
2012-03-21 02:00:00	NQ	Futures	3167.9	3169.64	3167.04	3169.64	302.0
2012-03-21 03:00:00	NQ	Futures	3169.64	3171.66	3167.61	3169.93	1000.0
2012-03-21 04:00:00	NQ	Futures	3170.22	3173.98	3169.93	3171.95	2698.0
2012-03-21 05:00:00	NQ	Futures	3171.95	3172.24	3166.17	3169.35	3006.0
2012-03-21 06:00:00	NQ	Futures	3169.35	3171.08	3166.17	3168.19	1897.0
2012-03-21 07:00:00	NQ	Futures	3167.9	3170.51	3165.59	3169.93	4592.0
2012-03-21 08:00:00	NQ	Futures	3169.93	3170.22	3160.96	3162.7	5037.0
2012-03-21 09:00:00	NQ	Futures	3162.41	3171.95	3162.12	3167.32	31314.0
2012-03-21 10:00:00	NQ	Futures	3167.04	3170.79	3159.23	3160.38	44625.0
2012-03-21 11:00:00	NQ	Futures	3160.38	3168.48	3158.07	3164.72	26416.0
2012-03-21 12:00:00	NQ	Futures	3165.01	3175.42	3164.43	3174.27	18659.0
2012-03-21 13:00:00	NQ	Futures	3174.55	3174.84	3167.61	3172.24	12576.0
2012-03-21 14:00:00	NQ	Futures	3172.24	3178.6	3171.08	3175.71	18452.0
2012-03-21 15:00:00	NQ	Futures	3175.71	3179.47	3162.12	3162.12	26854.0
2012-03-21 16:00:00	NQ	Futures	3162.12	3165.01	3160.96	3163.56	7911.0
2012-03-21 17:00:00	NQ	Futures	3163.56	3163.56	3161.83	3162.41	105.0
2012-03-21 18:00:00	NQ	Futures	3162.99	3166.46	3162.99	3165.3	401.0
2012-03-21 19:00:00	NQ	Futures	3165.01	3165.88	3164.14	3165.59	332.0
2012-03-21 20:00:00	NQ	Futures	3165.88	3168.19	3165.3	3167.61	573.0
2012-03-21 21:00:00	NQ	Futures	3167.61	3169.35	3166.75	3169.06	451.0
2012-03-21 22:00:00	NQ	Futures	3169.06	3170.51	3156.05	3157.2	1789.0
2012-03-21 23:00:00	NQ	Futures	3157.78	3159.81	3156.91	3158.07	807.0
2012-03-21 00:00:00	YM	Futures	13083.4	13088.4	13076.4	13087.4	205.0
2012-03-21 01:00:00	YM	Futures	13087.4	13089.4	13077.4	13078.4	229.0

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

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