PREVIEW / futures_1hour / 2012-03-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1411.65	1413.42	1411.4	1412.92	3673.0
2012-03-22 01:00:00	ES	Futures	1412.92	1414.44	1412.41	1413.17	4327.0
2012-03-22 02:00:00	ES	Futures	1413.17	1413.42	1411.91	1412.66	1925.0
2012-03-22 03:00:00	ES	Futures	1412.92	1414.69	1411.91	1412.16	6755.0
2012-03-22 04:00:00	ES	Futures	1412.16	1412.66	1405.33	1406.59	71569.0
2012-03-22 05:00:00	ES	Futures	1406.34	1407.35	1403.3	1405.33	48629.0
2012-03-22 06:00:00	ES	Futures	1405.33	1406.59	1404.32	1406.09	23146.0
2012-03-22 07:00:00	ES	Futures	1406.09	1406.85	1404.57	1405.08	34972.0
2012-03-22 08:00:00	ES	Futures	1405.08	1407.6	1404.82	1406.85	64213.0
2012-03-22 09:00:00	ES	Futures	1406.85	1407.35	1402.55	1405.08	231773.0
2012-03-22 10:00:00	ES	Futures	1405.33	1407.35	1400.52	1401.03	267492.0
2012-03-22 11:00:00	ES	Futures	1401.03	1403.56	1399.0	1403.05	195561.0
2012-03-22 12:00:00	ES	Futures	1403.05	1405.58	1402.8	1405.58	144473.0
2012-03-22 13:00:00	ES	Futures	1405.58	1405.58	1403.3	1404.06	69134.0
2012-03-22 14:00:00	ES	Futures	1404.32	1404.57	1402.04	1402.29	90394.0
2012-03-22 15:00:00	ES	Futures	1402.55	1405.58	1399.0	1403.3	296109.0
2012-03-22 16:00:00	ES	Futures	1403.3	1406.34	1403.3	1406.34	86358.0
2012-03-22 17:00:00	ES	Futures	1406.09	1406.85	1406.09	1406.34	4361.0
2012-03-22 18:00:00	ES	Futures	1406.59	1406.59	1405.58	1405.58	2892.0
2012-03-22 19:00:00	ES	Futures	1405.83	1406.59	1405.08	1406.34	2649.0
2012-03-22 20:00:00	ES	Futures	1406.59	1407.35	1406.59	1407.1	3882.0
2012-03-22 21:00:00	ES	Futures	1407.1	1407.1	1405.83	1406.59	3090.0
2012-03-22 22:00:00	ES	Futures	1406.34	1407.35	1406.09	1406.85	2342.0
2012-03-22 23:00:00	ES	Futures	1406.59	1408.36	1406.59	1408.11	4297.0
2012-03-22 00:00:00	NQ	Futures	3158.36	3162.99	3158.07	3161.25	335.0
2012-03-22 01:00:00	NQ	Futures	3161.83	3164.14	3160.38	3161.54	344.0
2012-03-22 02:00:00	NQ	Futures	3161.25	3162.41	3159.23	3160.38	236.0
2012-03-22 03:00:00	NQ	Futures	3160.38	3165.01	3158.94	3158.94	817.0
2012-03-22 04:00:00	NQ	Futures	3159.23	3160.09	3147.08	3149.1	7394.0
2012-03-22 05:00:00	NQ	Futures	3149.1	3151.42	3143.32	3146.79	6134.0
2012-03-22 06:00:00	NQ	Futures	3146.79	3150.55	3145.92	3149.68	2494.0
2012-03-22 07:00:00	NQ	Futures	3149.39	3150.84	3145.92	3146.5	2409.0
2012-03-22 08:00:00	NQ	Futures	3146.5	3152.86	3146.5	3150.55	5045.0
2012-03-22 09:00:00	NQ	Futures	3150.26	3156.05	3141.3	3152.86	44734.0
2012-03-22 10:00:00	NQ	Futures	3152.58	3159.23	3145.35	3147.37	34873.0
2012-03-22 11:00:00	NQ	Futures	3147.08	3154.31	3142.74	3153.44	23916.0
2012-03-22 12:00:00	NQ	Futures	3153.73	3162.99	3153.73	3162.7	18415.0
2012-03-22 13:00:00	NQ	Futures	3162.7	3162.99	3155.18	3157.78	14573.0
2012-03-22 14:00:00	NQ	Futures	3157.78	3158.07	3150.84	3152.29	16418.0
2012-03-22 15:00:00	NQ	Futures	3152.29	3160.09	3142.16	3155.18	44170.0
2012-03-22 16:00:00	NQ	Futures	3155.18	3162.41	3154.89	3162.12	6245.0
2012-03-22 17:00:00	NQ	Futures	3162.12	3162.99	3161.83	3162.12	263.0
2012-03-22 18:00:00	NQ	Futures	3162.7	3162.7	3158.65	3158.65	647.0
2012-03-22 19:00:00	NQ	Futures	3158.65	3161.54	3158.07	3161.54	248.0
2012-03-22 20:00:00	NQ	Futures	3161.54	3163.28	3161.54	3162.12	367.0
2012-03-22 21:00:00	NQ	Futures	3161.83	3162.12	3160.09	3160.67	455.0
2012-03-22 22:00:00	NQ	Futures	3160.67	3162.7	3160.38	3161.83	234.0
2012-03-22 23:00:00	NQ	Futures	3162.12	3167.04	3161.83	3166.46	983.0
2012-03-22 00:00:00	YM	Futures	12996.7	13012.7	12996.7	13007.7	217.0
2012-03-22 01:00:00	YM	Futures	13008.7	13020.6	13004.7	13010.7	284.0

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

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