PREVIEW / futures_1hour / 2012-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-27.parquet
  size:    42 KB
  rows:    1,211

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-27 00:00:00	ES	Futures	1409.63	1410.13	1407.6	1408.11	4186.0
2012-04-27 01:00:00	ES	Futures	1408.11	1408.36	1406.85	1407.1	6480.0
2012-04-27 02:00:00	ES	Futures	1407.1	1407.6	1405.58	1406.59	16210.0
2012-04-27 03:00:00	ES	Futures	1406.59	1410.89	1403.05	1410.64	57540.0
2012-04-27 04:00:00	ES	Futures	1410.89	1411.4	1409.12	1410.89	31003.0
2012-04-27 05:00:00	ES	Futures	1411.15	1414.18	1410.89	1411.91	43582.0
2012-04-27 06:00:00	ES	Futures	1411.91	1414.18	1411.15	1413.93	22756.0
2012-04-27 07:00:00	ES	Futures	1413.93	1416.97	1412.66	1415.95	52218.0
2012-04-27 08:00:00	ES	Futures	1415.95	1418.48	1412.92	1416.71	133811.0
2012-04-27 09:00:00	ES	Futures	1416.71	1419.75	1411.91	1413.68	210949.0
2012-04-27 10:00:00	ES	Futures	1413.68	1414.69	1409.63	1414.18	279087.0
2012-04-27 11:00:00	ES	Futures	1413.93	1415.7	1413.42	1414.94	176325.0
2012-04-27 12:00:00	ES	Futures	1414.94	1415.95	1414.18	1415.7	102960.0
2012-04-27 13:00:00	ES	Futures	1415.7	1419.5	1415.19	1418.23	94421.0
2012-04-27 14:00:00	ES	Futures	1418.23	1418.48	1415.7	1416.97	45785.0
2012-04-27 15:00:00	ES	Futures	1417.22	1418.23	1414.94	1415.95	160328.0
2012-04-27 16:00:00	ES	Futures	1415.7	1416.21	1413.17	1415.7	81709.0
2012-04-27 00:00:00	NQ	Futures	3147.08	3148.24	3143.61	3144.19	374.0
2012-04-27 01:00:00	NQ	Futures	3144.48	3145.06	3141.87	3142.45	625.0
2012-04-27 02:00:00	NQ	Futures	3142.45	3143.03	3138.69	3139.85	1120.0
2012-04-27 03:00:00	NQ	Futures	3140.14	3146.21	3133.49	3146.21	5025.0
2012-04-27 04:00:00	NQ	Futures	3146.21	3148.53	3143.32	3147.66	3067.0
2012-04-27 05:00:00	NQ	Futures	3147.66	3154.31	3147.08	3150.26	3503.0
2012-04-27 06:00:00	NQ	Futures	3150.26	3154.31	3147.37	3154.31	2941.0
2012-04-27 07:00:00	NQ	Futures	3154.02	3159.81	3151.71	3158.65	6434.0
2012-04-27 08:00:00	NQ	Futures	3158.07	3163.28	3153.73	3159.52	12249.0
2012-04-27 09:00:00	NQ	Futures	3159.52	3164.72	3148.82	3154.6	34698.0
2012-04-27 10:00:00	NQ	Futures	3154.6	3162.12	3144.48	3160.09	37633.0
2012-04-27 11:00:00	NQ	Futures	3159.81	3167.32	3158.94	3165.88	19527.0
2012-04-27 12:00:00	NQ	Futures	3165.88	3169.06	3162.41	3168.19	10415.0
2012-04-27 13:00:00	NQ	Futures	3168.19	3176.58	3167.04	3172.24	15476.0
2012-04-27 14:00:00	NQ	Futures	3172.24	3172.82	3164.72	3170.22	12806.0
2012-04-27 15:00:00	NQ	Futures	3170.22	3172.24	3160.09	3167.04	27402.0
2012-04-27 16:00:00	NQ	Futures	3166.75	3167.9	3162.41	3167.32	8564.0
2012-04-27 00:00:00	YM	Futures	13081.4	13085.4	13067.5	13073.4	667.0
2012-04-27 01:00:00	YM	Futures	13073.4	13077.4	13062.5	13069.5	936.0
2012-04-27 02:00:00	YM	Futures	13068.5	13073.4	13056.5	13066.5	1632.0
2012-04-27 03:00:00	YM	Futures	13065.5	13103.3	13039.6	13100.3	5650.0
2012-04-27 04:00:00	YM	Futures	13100.3	13106.3	13084.4	13098.4	2425.0
2012-04-27 05:00:00	YM	Futures	13098.4	13124.3	13096.4	13109.3	2356.0
2012-04-27 06:00:00	YM	Futures	13108.3	13127.2	13102.3	13122.3	1527.0
2012-04-27 07:00:00	YM	Futures	13122.3	13136.2	13108.3	13127.2	2696.0
2012-04-27 08:00:00	YM	Futures	13128.2	13144.2	13105.3	13127.2	7628.0
2012-04-27 09:00:00	YM	Futures	13128.2	13146.2	13102.3	13117.3	16078.0
2012-04-27 10:00:00	YM	Futures	13116.3	13132.2	13087.4	13126.2	22634.0
2012-04-27 11:00:00	YM	Futures	13126.2	13138.2	13118.3	13129.2	10823.0
2012-04-27 12:00:00	YM	Futures	13130.2	13139.2	13124.3	13130.2	5541.0
2012-04-27 13:00:00	YM	Futures	13130.2	13162.1	13128.2	13155.1	7618.0
2012-04-27 14:00:00	YM	Futures	13156.1	13158.1	13132.2	13142.2	3982.0
2012-04-27 15:00:00	YM	Futures	13142.2	13148.2	13114.3	13123.3	10191.0

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

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