PREVIEW / futures_1hour / 2011-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-07.parquet
  size:    41 KB
  rows:    1,163

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-07 00:00:00	ES	Futures	1258.17	1258.17	1256.43	1257.18	1632.0
2011-01-07 01:00:00	ES	Futures	1257.18	1257.67	1256.43	1256.68	2036.0
2011-01-07 02:00:00	ES	Futures	1256.93	1257.18	1255.94	1256.19	5099.0
2011-01-07 03:00:00	ES	Futures	1256.19	1257.92	1253.47	1254.46	44043.0
2011-01-07 04:00:00	ES	Futures	1254.21	1255.94	1253.71	1255.69	20105.0
2011-01-07 05:00:00	ES	Futures	1255.69	1255.94	1254.46	1255.2	12533.0
2011-01-07 06:00:00	ES	Futures	1254.95	1257.92	1254.21	1257.67	23435.0
2011-01-07 07:00:00	ES	Futures	1257.42	1257.92	1256.19	1256.68	18756.0
2011-01-07 08:00:00	ES	Futures	1256.68	1259.65	1251.49	1256.93	178239.0
2011-01-07 09:00:00	ES	Futures	1257.18	1260.89	1254.7	1255.69	318963.0
2011-01-07 10:00:00	ES	Futures	1255.94	1259.65	1253.71	1254.95	323603.0
2011-01-07 11:00:00	ES	Futures	1254.95	1255.2	1248.76	1251.73	324898.0
2011-01-07 12:00:00	ES	Futures	1251.98	1251.98	1244.81	1248.02	246614.0
2011-01-07 13:00:00	ES	Futures	1248.02	1251.24	1247.53	1249.26	156769.0
2011-01-07 14:00:00	ES	Futures	1249.26	1253.22	1249.01	1252.23	119873.0
2011-01-07 15:00:00	ES	Futures	1251.98	1255.44	1251.24	1254.46	264639.0
2011-01-07 16:00:00	ES	Futures	1254.46	1255.94	1253.96	1254.21	82919.0
2011-01-07 00:00:00	NQ	Futures	2614.58	2614.87	2612.86	2614.29	108.0
2011-01-07 01:00:00	NQ	Futures	2614.29	2614.58	2612.57	2613.72	103.0
2011-01-07 02:00:00	NQ	Futures	2613.43	2613.72	2609.99	2610.56	753.0
2011-01-07 03:00:00	NQ	Futures	2610.85	2614.58	2607.4	2609.41	3169.0
2011-01-07 04:00:00	NQ	Futures	2609.12	2612.28	2607.69	2611.71	1208.0
2011-01-07 05:00:00	NQ	Futures	2611.71	2612.28	2609.12	2610.85	767.0
2011-01-07 06:00:00	NQ	Futures	2610.56	2615.44	2608.84	2614.87	1147.0
2011-01-07 07:00:00	NQ	Futures	2614.87	2615.73	2613.14	2614.87	1776.0
2011-01-07 08:00:00	NQ	Futures	2615.15	2620.32	2603.67	2615.44	17080.0
2011-01-07 09:00:00	NQ	Futures	2615.73	2620.32	2605.97	2610.27	49557.0
2011-01-07 10:00:00	NQ	Futures	2610.27	2619.17	2608.55	2610.85	39847.0
2011-01-07 11:00:00	NQ	Futures	2610.85	2612.0	2601.95	2608.84	39552.0
2011-01-07 12:00:00	NQ	Futures	2608.84	2608.84	2585.59	2597.36	48621.0
2011-01-07 13:00:00	NQ	Futures	2597.07	2605.68	2594.77	2601.09	24510.0
2011-01-07 14:00:00	NQ	Futures	2601.09	2609.12	2600.51	2605.68	12793.0
2011-01-07 15:00:00	NQ	Futures	2605.68	2614.0	2605.39	2612.0	29674.0
2011-01-07 16:00:00	NQ	Futures	2611.71	2613.72	2609.12	2609.7	6761.0
2011-01-07 00:00:00	YM	Futures	11165.8	11165.8	11155.3	11159.1	117.0
2011-01-07 01:00:00	YM	Futures	11161.0	11161.0	11152.4	11153.4	110.0
2011-01-07 02:00:00	YM	Futures	11153.4	11157.2	11146.7	11149.5	290.0
2011-01-07 03:00:00	YM	Futures	11149.5	11163.9	11130.4	11137.1	1882.0
2011-01-07 04:00:00	YM	Futures	11136.1	11149.5	11132.3	11147.6	847.0
2011-01-07 05:00:00	YM	Futures	11147.6	11148.6	11139.0	11144.8	749.0
2011-01-07 06:00:00	YM	Futures	11141.9	11163.0	11136.1	11160.1	809.0
2011-01-07 07:00:00	YM	Futures	11160.1	11165.8	11153.4	11158.2	1227.0
2011-01-07 08:00:00	YM	Futures	11159.1	11180.2	11116.0	11155.3	7650.0
2011-01-07 09:00:00	YM	Futures	11155.3	11182.1	11139.0	11146.7	15772.0
2011-01-07 10:00:00	YM	Futures	11145.7	11172.5	11128.5	11140.9	16850.0
2011-01-07 11:00:00	YM	Futures	11140.0	11143.8	11093.0	11112.2	17844.0
2011-01-07 12:00:00	YM	Futures	11113.1	11113.1	11057.6	11086.3	16641.0
2011-01-07 13:00:00	YM	Futures	11086.3	11110.3	11081.5	11096.9	9677.0
2011-01-07 14:00:00	YM	Futures	11096.9	11122.7	11095.9	11115.1	7527.0
2011-01-07 15:00:00	YM	Futures	11114.1	11135.2	11108.4	11131.3	14766.0

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

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