PREVIEW / futures_1hour / 2011-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-10.parquet
  size:    46 KB
  rows:    1,406

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
2011-01-10 00:00:00	ES	Futures	1254.7	1254.95	1253.22	1253.22	2265.0
2011-01-10 01:00:00	ES	Futures	1252.97	1254.46	1251.98	1252.48	3371.0
2011-01-10 02:00:00	ES	Futures	1252.23	1252.72	1250.0	1250.25	8806.0
2011-01-10 03:00:00	ES	Futures	1250.5	1250.99	1246.79	1248.02	34953.0
2011-01-10 04:00:00	ES	Futures	1248.02	1249.75	1247.53	1248.52	14358.0
2011-01-10 05:00:00	ES	Futures	1248.52	1248.76	1246.04	1247.53	18199.0
2011-01-10 06:00:00	ES	Futures	1247.53	1249.01	1246.79	1248.52	15757.0
2011-01-10 07:00:00	ES	Futures	1248.52	1249.26	1247.28	1247.77	14902.0
2011-01-10 08:00:00	ES	Futures	1247.77	1250.0	1247.03	1249.26	38458.0
2011-01-10 09:00:00	ES	Futures	1249.26	1251.24	1245.05	1245.8	284968.0
2011-01-10 10:00:00	ES	Futures	1245.8	1251.98	1245.05	1248.76	416190.0
2011-01-10 11:00:00	ES	Futures	1248.76	1251.49	1246.79	1250.99	255565.0
2011-01-10 12:00:00	ES	Futures	1250.99	1252.23	1249.01	1250.99	218936.0
2011-01-10 13:00:00	ES	Futures	1251.24	1253.22	1250.99	1252.23	115057.0
2011-01-10 14:00:00	ES	Futures	1252.48	1253.71	1250.5	1253.47	125014.0
2011-01-10 15:00:00	ES	Futures	1253.22	1254.95	1252.23	1253.22	201478.0
2011-01-10 16:00:00	ES	Futures	1252.97	1253.71	1251.98	1252.23	84140.0
2011-01-10 17:00:00	ES	Futures	1252.23	1252.72	1251.73	1252.72	1405.0
2011-01-10 18:00:00	ES	Futures	1252.48	1253.47	1251.73	1253.47	3930.0
2011-01-10 19:00:00	ES	Futures	1253.47	1253.96	1251.24	1251.49	5130.0
2011-01-10 20:00:00	ES	Futures	1251.49	1254.21	1250.99	1252.23	8816.0
2011-01-10 21:00:00	ES	Futures	1252.48	1253.96	1252.23	1253.96	2655.0
2011-01-10 22:00:00	ES	Futures	1253.96	1254.46	1253.22	1253.96	3375.0
2011-01-10 23:00:00	ES	Futures	1254.21	1254.7	1253.96	1254.21	2429.0
2011-01-10 00:00:00	NQ	Futures	2611.42	2612.0	2609.41	2609.41	88.0
2011-01-10 01:00:00	NQ	Futures	2609.12	2610.85	2607.12	2607.4	200.0
2011-01-10 02:00:00	NQ	Futures	2606.83	2608.26	2603.67	2603.96	512.0
2011-01-10 03:00:00	NQ	Futures	2603.67	2605.39	2597.93	2600.23	2275.0
2011-01-10 04:00:00	NQ	Futures	2600.51	2601.66	2598.5	2598.79	2194.0
2011-01-10 05:00:00	NQ	Futures	2599.37	2599.94	2595.63	2598.79	1641.0
2011-01-10 06:00:00	NQ	Futures	2599.08	2601.66	2597.36	2600.51	1489.0
2011-01-10 07:00:00	NQ	Futures	2600.51	2602.81	2599.37	2600.23	1442.0
2011-01-10 08:00:00	NQ	Futures	2600.51	2605.68	2599.37	2603.96	3250.0
2011-01-10 09:00:00	NQ	Futures	2604.25	2612.28	2599.37	2601.38	39484.0
2011-01-10 10:00:00	NQ	Futures	2601.38	2612.57	2598.5	2605.68	36610.0
2011-01-10 11:00:00	NQ	Futures	2605.68	2613.43	2603.67	2612.57	22533.0
2011-01-10 12:00:00	NQ	Futures	2612.86	2615.15	2608.55	2611.42	22947.0
2011-01-10 13:00:00	NQ	Futures	2611.42	2620.32	2611.42	2617.74	16298.0
2011-01-10 14:00:00	NQ	Futures	2617.74	2621.18	2614.87	2620.61	12559.0
2011-01-10 15:00:00	NQ	Futures	2620.61	2625.77	2619.17	2621.75	24638.0
2011-01-10 16:00:00	NQ	Futures	2621.75	2621.75	2618.31	2620.03	7903.0
2011-01-10 17:00:00	NQ	Futures	2620.03	2620.61	2618.02	2620.03	414.0
2011-01-10 18:00:00	NQ	Futures	2619.75	2621.18	2618.6	2621.18	134.0
2011-01-10 19:00:00	NQ	Futures	2621.18	2622.62	2618.6	2618.88	281.0
2011-01-10 20:00:00	NQ	Futures	2618.88	2624.62	2618.6	2621.18	773.0
2011-01-10 21:00:00	NQ	Futures	2621.75	2624.34	2621.18	2624.05	407.0
2011-01-10 22:00:00	NQ	Futures	2624.05	2625.77	2622.9	2625.2	224.0
2011-01-10 23:00:00	NQ	Futures	2624.91	2625.49	2624.91	2624.91	77.0
2011-01-10 00:00:00	YM	Futures	11135.2	11136.1	11125.6	11125.6	67.0
2011-01-10 01:00:00	YM	Futures	11125.6	11132.3	11117.0	11117.9	188.0

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

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