PREVIEW / futures_1hour / 2012-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-19.parquet
  size:    49 KB
  rows:    1,496

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-19 00:00:00	ES	Futures	1397.23	1397.49	1395.97	1396.73	1907.0
2012-04-19 01:00:00	ES	Futures	1396.98	1397.99	1396.73	1397.99	3397.0
2012-04-19 02:00:00	ES	Futures	1397.74	1400.52	1397.49	1400.02	9036.0
2012-04-19 03:00:00	ES	Futures	1399.76	1403.81	1399.76	1402.55	36448.0
2012-04-19 04:00:00	ES	Futures	1402.55	1406.59	1399.0	1401.79	65504.0
2012-04-19 05:00:00	ES	Futures	1401.53	1404.82	1399.51	1404.57	30680.0
2012-04-19 06:00:00	ES	Futures	1404.57	1404.57	1400.77	1401.79	18869.0
2012-04-19 07:00:00	ES	Futures	1401.79	1403.3	1394.7	1398.24	92757.0
2012-04-19 08:00:00	ES	Futures	1397.99	1401.28	1393.44	1395.21	127068.0
2012-04-19 09:00:00	ES	Futures	1394.96	1400.52	1393.94	1399.0	276031.0
2012-04-19 10:00:00	ES	Futures	1399.26	1403.05	1390.91	1400.77	620363.0
2012-04-19 11:00:00	ES	Futures	1400.77	1402.55	1395.21	1398.24	287727.0
2012-04-19 12:00:00	ES	Futures	1397.99	1398.5	1391.41	1392.43	257032.0
2012-04-19 13:00:00	ES	Futures	1392.43	1394.2	1388.38	1388.63	166103.0
2012-04-19 14:00:00	ES	Futures	1388.88	1390.15	1381.8	1385.34	258295.0
2012-04-19 15:00:00	ES	Futures	1385.6	1390.91	1383.82	1388.88	253509.0
2012-04-19 16:00:00	ES	Futures	1388.88	1390.91	1388.38	1390.66	99101.0
2012-04-19 17:00:00	ES	Futures	1390.4	1390.91	1389.39	1389.39	2272.0
2012-04-19 18:00:00	ES	Futures	1389.64	1390.15	1389.14	1389.9	1812.0
2012-04-19 19:00:00	ES	Futures	1389.64	1391.67	1389.64	1391.67	3444.0
2012-04-19 20:00:00	ES	Futures	1391.41	1391.67	1389.64	1389.9	4886.0
2012-04-19 21:00:00	ES	Futures	1390.15	1390.4	1387.87	1389.14	5617.0
2012-04-19 22:00:00	ES	Futures	1388.88	1389.39	1387.62	1388.38	3597.0
2012-04-19 23:00:00	ES	Futures	1388.13	1391.16	1388.13	1390.91	4024.0
2012-04-19 00:00:00	NQ	Futures	3130.02	3130.31	3128.28	3130.02	263.0
2012-04-19 01:00:00	NQ	Futures	3130.31	3133.49	3130.02	3132.33	432.0
2012-04-19 02:00:00	NQ	Futures	3131.75	3135.22	3130.31	3134.07	1187.0
2012-04-19 03:00:00	NQ	Futures	3134.36	3141.59	3133.78	3138.12	3379.0
2012-04-19 04:00:00	NQ	Futures	3138.12	3145.63	3129.73	3135.8	7714.0
2012-04-19 05:00:00	NQ	Futures	3135.22	3145.35	3130.89	3144.19	3053.0
2012-04-19 06:00:00	NQ	Futures	3144.19	3144.48	3136.96	3139.85	2651.0
2012-04-19 07:00:00	NQ	Futures	3139.85	3144.19	3123.08	3131.75	10188.0
2012-04-19 08:00:00	NQ	Futures	3131.46	3138.4	3117.58	3118.45	15853.0
2012-04-19 09:00:00	NQ	Futures	3118.45	3150.26	3117.87	3145.63	67024.0
2012-04-19 10:00:00	NQ	Futures	3145.06	3163.85	3127.7	3154.02	92332.0
2012-04-19 11:00:00	NQ	Futures	3154.02	3157.49	3136.09	3141.59	40119.0
2012-04-19 12:00:00	NQ	Futures	3141.59	3142.16	3120.18	3120.47	38499.0
2012-04-19 13:00:00	NQ	Futures	3120.47	3126.55	3109.48	3110.35	33373.0
2012-04-19 14:00:00	NQ	Futures	3110.35	3113.82	3090.4	3101.1	46517.0
2012-04-19 15:00:00	NQ	Futures	3101.1	3108.33	3092.42	3103.7	54057.0
2012-04-19 16:00:00	NQ	Futures	3103.41	3110.93	3101.1	3110.06	14271.0
2012-04-19 17:00:00	NQ	Futures	3110.06	3110.93	3107.17	3107.17	523.0
2012-04-19 18:00:00	NQ	Futures	3106.88	3108.91	3106.88	3107.46	207.0
2012-04-19 19:00:00	NQ	Futures	3107.75	3111.51	3107.17	3110.93	208.0
2012-04-19 20:00:00	NQ	Futures	3111.22	3111.22	3106.01	3107.17	643.0
2012-04-19 21:00:00	NQ	Futures	3107.46	3107.75	3103.12	3105.44	459.0
2012-04-19 22:00:00	NQ	Futures	3105.44	3106.59	3103.12	3103.7	686.0
2012-04-19 23:00:00	NQ	Futures	3103.41	3109.48	3103.41	3108.33	372.0
2012-04-19 00:00:00	YM	Futures	12932.0	12933.0	12924.0	12930.0	206.0
2012-04-19 01:00:00	YM	Futures	12931.0	12938.9	12931.0	12935.0	150.0

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

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