PREVIEW / futures_1hour / 2012-04-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	1391.92	1392.43	1391.67	1391.92	1267.0
2012-04-25 01:00:00	ES	Futures	1391.92	1392.43	1390.15	1390.66	3575.0
2012-04-25 02:00:00	ES	Futures	1390.91	1392.43	1390.15	1391.92	7309.0
2012-04-25 03:00:00	ES	Futures	1392.17	1395.46	1391.41	1394.45	28386.0
2012-04-25 04:00:00	ES	Futures	1394.45	1398.5	1394.45	1396.98	46714.0
2012-04-25 05:00:00	ES	Futures	1396.98	1397.49	1394.45	1394.7	19352.0
2012-04-25 06:00:00	ES	Futures	1394.7	1396.47	1394.7	1396.22	11351.0
2012-04-25 07:00:00	ES	Futures	1395.97	1396.98	1394.96	1395.46	27866.0
2012-04-25 08:00:00	ES	Futures	1395.71	1396.47	1392.68	1394.96	66844.0
2012-04-25 09:00:00	ES	Futures	1394.96	1403.3	1394.45	1402.04	326828.0
2012-04-25 10:00:00	ES	Futures	1401.79	1402.55	1398.5	1398.75	346641.0
2012-04-25 11:00:00	ES	Futures	1398.75	1399.76	1396.98	1398.24	164268.0
2012-04-25 12:00:00	ES	Futures	1398.24	1400.52	1396.73	1400.52	132107.0
2012-04-25 13:00:00	ES	Futures	1400.52	1402.29	1400.02	1400.52	89145.0
2012-04-25 14:00:00	ES	Futures	1400.52	1403.81	1397.49	1402.8	201406.0
2012-04-25 15:00:00	ES	Futures	1402.55	1404.06	1400.77	1403.3	201088.0
2012-04-25 16:00:00	ES	Futures	1403.3	1404.57	1402.55	1404.32	85984.0
2012-04-25 17:00:00	ES	Futures	1404.32	1404.57	1403.56	1404.32	3146.0
2012-04-25 18:00:00	ES	Futures	1404.32	1404.32	1403.56	1403.56	2614.0
2012-04-25 19:00:00	ES	Futures	1403.56	1404.32	1403.3	1403.81	2386.0
2012-04-25 20:00:00	ES	Futures	1403.81	1404.32	1402.8	1404.32	3948.0
2012-04-25 21:00:00	ES	Futures	1404.32	1405.58	1403.81	1405.08	6286.0
2012-04-25 22:00:00	ES	Futures	1404.82	1405.58	1404.57	1405.58	3711.0
2012-04-25 23:00:00	ES	Futures	1405.58	1406.09	1404.57	1405.33	5161.0
2012-04-25 00:00:00	NQ	Futures	3088.66	3088.95	3087.79	3088.37	333.0
2012-04-25 01:00:00	NQ	Futures	3088.66	3088.95	3084.61	3084.61	603.0
2012-04-25 02:00:00	NQ	Futures	3084.61	3086.64	3083.17	3085.77	1400.0
2012-04-25 03:00:00	NQ	Futures	3085.77	3095.6	3084.61	3095.31	4701.0
2012-04-25 04:00:00	NQ	Futures	3095.02	3105.44	3094.73	3103.7	5864.0
2012-04-25 05:00:00	NQ	Futures	3103.99	3105.15	3100.23	3103.7	3006.0
2012-04-25 06:00:00	NQ	Futures	3103.7	3106.01	3101.39	3104.57	2792.0
2012-04-25 07:00:00	NQ	Futures	3104.86	3107.75	3103.99	3106.59	6010.0
2012-04-25 08:00:00	NQ	Futures	3106.88	3110.06	3101.97	3103.99	12658.0
2012-04-25 09:00:00	NQ	Futures	3103.99	3131.17	3102.83	3129.44	78889.0
2012-04-25 10:00:00	NQ	Futures	3129.44	3130.02	3115.85	3117.87	64502.0
2012-04-25 11:00:00	NQ	Futures	3117.87	3121.92	3114.69	3115.85	19816.0
2012-04-25 12:00:00	NQ	Futures	3115.56	3122.21	3113.24	3120.76	20062.0
2012-04-25 13:00:00	NQ	Futures	3120.47	3125.97	3118.74	3122.5	15018.0
2012-04-25 14:00:00	NQ	Futures	3122.5	3128.86	3116.43	3125.97	27041.0
2012-04-25 15:00:00	NQ	Futures	3125.68	3130.02	3123.94	3129.73	35610.0
2012-04-25 16:00:00	NQ	Futures	3129.44	3130.89	3125.39	3130.89	10520.0
2012-04-25 17:00:00	NQ	Futures	3130.6	3130.89	3128.57	3130.02	142.0
2012-04-25 18:00:00	NQ	Futures	3129.73	3130.02	3127.7	3127.99	325.0
2012-04-25 19:00:00	NQ	Futures	3128.57	3130.31	3127.99	3129.15	220.0
2012-04-25 20:00:00	NQ	Futures	3129.44	3130.31	3127.7	3130.02	318.0
2012-04-25 21:00:00	NQ	Futures	3130.02	3132.33	3129.15	3131.17	743.0
2012-04-25 22:00:00	NQ	Futures	3131.17	3133.49	3130.89	3133.2	455.0
2012-04-25 23:00:00	NQ	Futures	3132.91	3134.36	3130.89	3131.46	635.0
2012-04-25 00:00:00	YM	Futures	12942.9	12949.9	12941.9	12947.9	351.0
2012-04-25 01:00:00	YM	Futures	12947.9	12950.9	12932.0	12935.0	353.0

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

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