PREVIEW / futures_1hour / 2012-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-19.parquet
  size:    41 KB
  rows:    1,212

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-10-19 00:00:00	ES	Futures	1482.71	1483.99	1482.71	1483.48	2589.0
2012-10-19 01:00:00	ES	Futures	1483.22	1483.73	1482.71	1482.97	3217.0
2012-10-19 02:00:00	ES	Futures	1482.97	1483.73	1481.94	1482.71	5097.0
2012-10-19 03:00:00	ES	Futures	1482.46	1484.24	1482.2	1483.22	20991.0
2012-10-19 04:00:00	ES	Futures	1482.97	1483.22	1480.16	1480.92	23257.0
2012-10-19 05:00:00	ES	Futures	1480.67	1482.46	1480.67	1481.18	17449.0
2012-10-19 06:00:00	ES	Futures	1481.18	1481.69	1479.13	1480.41	30465.0
2012-10-19 07:00:00	ES	Futures	1480.41	1480.92	1478.88	1480.67	30047.0
2012-10-19 08:00:00	ES	Futures	1480.41	1481.18	1478.88	1480.41	41353.0
2012-10-19 09:00:00	ES	Futures	1480.41	1481.94	1474.28	1476.58	264129.0
2012-10-19 10:00:00	ES	Futures	1476.32	1477.09	1472.75	1473.51	246624.0
2012-10-19 11:00:00	ES	Futures	1473.77	1474.03	1465.6	1467.38	443740.0
2012-10-19 12:00:00	ES	Futures	1467.38	1467.64	1462.02	1464.06	263422.0
2012-10-19 13:00:00	ES	Futures	1464.06	1465.85	1458.19	1459.72	189275.0
2012-10-19 14:00:00	ES	Futures	1459.72	1461.25	1455.63	1459.21	235449.0
2012-10-19 15:00:00	ES	Futures	1459.46	1462.53	1457.16	1458.7	400515.0
2012-10-19 16:00:00	ES	Futures	1458.44	1458.7	1454.61	1454.87	147834.0
2012-10-19 00:00:00	NQ	Futures	3176.58	3177.74	3175.13	3175.71	467.0
2012-10-19 01:00:00	NQ	Futures	3175.71	3176.58	3174.55	3174.84	395.0
2012-10-19 02:00:00	NQ	Futures	3175.13	3176.29	3173.09	3173.97	915.0
2012-10-19 03:00:00	NQ	Futures	3173.68	3177.45	3173.68	3174.84	1845.0
2012-10-19 04:00:00	NQ	Futures	3174.55	3175.13	3168.44	3169.32	2571.0
2012-10-19 05:00:00	NQ	Futures	3169.32	3171.93	3168.15	3169.03	2152.0
2012-10-19 06:00:00	NQ	Futures	3169.32	3170.19	3166.12	3167.86	2269.0
2012-10-19 07:00:00	NQ	Futures	3167.86	3170.77	3164.38	3170.48	3006.0
2012-10-19 08:00:00	NQ	Futures	3170.48	3171.93	3169.32	3171.35	4516.0
2012-10-19 09:00:00	NQ	Futures	3171.64	3180.36	3155.08	3164.67	48960.0
2012-10-19 10:00:00	NQ	Futures	3164.67	3165.83	3144.62	3148.1	44966.0
2012-10-19 11:00:00	NQ	Futures	3148.1	3149.27	3118.76	3124.57	57582.0
2012-10-19 12:00:00	NQ	Futures	3124.57	3125.73	3111.49	3116.14	38197.0
2012-10-19 13:00:00	NQ	Futures	3116.43	3121.95	3105.97	3109.75	28842.0
2012-10-19 14:00:00	NQ	Futures	3110.04	3113.24	3101.03	3107.42	33814.0
2012-10-19 15:00:00	NQ	Futures	3107.42	3114.11	3102.19	3105.39	51649.0
2012-10-19 16:00:00	NQ	Futures	3105.68	3105.68	3096.38	3099.0	11336.0
2012-10-19 00:00:00	YM	Futures	13489.9	13493.9	13487.9	13488.9	242.0
2012-10-19 01:00:00	YM	Futures	13489.9	13493.9	13487.9	13490.9	345.0
2012-10-19 02:00:00	YM	Futures	13491.9	13493.9	13481.9	13484.9	573.0
2012-10-19 03:00:00	YM	Futures	13483.9	13501.9	13483.9	13492.9	1874.0
2012-10-19 04:00:00	YM	Futures	13490.9	13492.9	13474.9	13476.9	2057.0
2012-10-19 05:00:00	YM	Futures	13475.9	13487.9	13475.9	13482.9	1382.0
2012-10-19 06:00:00	YM	Futures	13481.9	13484.9	13465.9	13478.9	2413.0
2012-10-19 07:00:00	YM	Futures	13478.9	13483.9	13460.9	13461.9	2579.0
2012-10-19 08:00:00	YM	Futures	13460.9	13461.9	13443.9	13454.9	4607.0
2012-10-19 09:00:00	YM	Futures	13453.9	13460.9	13389.9	13405.9	21225.0
2012-10-19 10:00:00	YM	Futures	13402.9	13408.9	13378.9	13392.9	19537.0
2012-10-19 11:00:00	YM	Futures	13391.9	13394.9	13337.9	13347.9	24990.0
2012-10-19 12:00:00	YM	Futures	13348.9	13348.9	13311.9	13326.9	17634.0
2012-10-19 13:00:00	YM	Futures	13325.9	13341.9	13279.8	13291.8	14791.0
2012-10-19 14:00:00	YM	Futures	13292.8	13302.8	13256.8	13284.8	16901.0
2012-10-19 15:00:00	YM	Futures	13284.8	13317.9	13264.8	13285.8	23353.0

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

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