PREVIEW / futures_1hour / 2013-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-07.parquet
  size:    52 KB
  rows:    1,566

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
2013-02-07 00:00:00	ES	Futures	1545.19	1546.22	1544.68	1545.19	4065.0
2013-02-07 01:00:00	ES	Futures	1545.19	1546.73	1544.93	1545.19	3560.0
2013-02-07 02:00:00	ES	Futures	1545.19	1545.96	1544.17	1544.42	5476.0
2013-02-07 03:00:00	ES	Futures	1544.17	1546.47	1543.65	1545.19	22640.0
2013-02-07 04:00:00	ES	Futures	1545.19	1547.76	1544.68	1547.5	15670.0
2013-02-07 05:00:00	ES	Futures	1547.5	1549.81	1547.5	1549.3	30907.0
2013-02-07 06:00:00	ES	Futures	1549.3	1550.84	1548.27	1548.53	23329.0
2013-02-07 07:00:00	ES	Futures	1548.53	1549.81	1546.99	1547.5	27971.0
2013-02-07 08:00:00	ES	Futures	1547.24	1549.55	1545.45	1548.01	97068.0
2013-02-07 09:00:00	ES	Futures	1547.76	1550.32	1544.93	1545.96	247473.0
2013-02-07 10:00:00	ES	Futures	1546.22	1546.73	1534.41	1538.26	514415.0
2013-02-07 11:00:00	ES	Futures	1538.26	1539.03	1533.9	1535.7	239830.0
2013-02-07 12:00:00	ES	Futures	1535.95	1540.57	1535.44	1539.29	139352.0
2013-02-07 13:00:00	ES	Futures	1539.55	1543.4	1538.26	1543.14	145838.0
2013-02-07 14:00:00	ES	Futures	1543.14	1544.42	1540.06	1543.4	140443.0
2013-02-07 15:00:00	ES	Futures	1543.4	1545.7	1541.6	1545.45	208849.0
2013-02-07 16:00:00	ES	Futures	1545.19	1546.47	1544.17	1545.7	57748.0
2013-02-07 17:00:00	ES	Futures	1545.7	1545.7	1544.17	1544.68	2685.0
2013-02-07 18:00:00	ES	Futures	1544.68	1544.68	1543.65	1544.17	3593.0
2013-02-07 19:00:00	ES	Futures	1544.17	1545.7	1543.65	1544.93	7482.0
2013-02-07 20:00:00	ES	Futures	1544.93	1545.45	1543.4	1545.45	6147.0
2013-02-07 21:00:00	ES	Futures	1545.19	1546.73	1544.93	1546.73	5317.0
2013-02-07 22:00:00	ES	Futures	1546.73	1548.01	1546.47	1546.99	6491.0
2013-02-07 23:00:00	ES	Futures	1547.24	1547.76	1546.73	1547.24	2336.0
2013-02-07 00:00:00	NQ	Futures	3187.21	3188.95	3186.33	3187.5	285.0
2013-02-07 01:00:00	NQ	Futures	3187.5	3190.12	3186.33	3186.33	213.0
2013-02-07 02:00:00	NQ	Futures	3186.92	3188.37	3184.3	3184.59	651.0
2013-02-07 03:00:00	NQ	Futures	3184.3	3190.12	3181.39	3188.37	3073.0
2013-02-07 04:00:00	NQ	Futures	3188.37	3192.45	3187.21	3192.15	1654.0
2013-02-07 05:00:00	NQ	Futures	3192.15	3195.94	3191.57	3194.77	2208.0
2013-02-07 06:00:00	NQ	Futures	3195.07	3198.56	3188.95	3190.12	2295.0
2013-02-07 07:00:00	NQ	Futures	3190.12	3193.32	3187.79	3188.95	2842.0
2013-02-07 08:00:00	NQ	Futures	3188.95	3198.56	3185.75	3196.81	11051.0
2013-02-07 09:00:00	NQ	Futures	3196.81	3200.3	3186.33	3190.99	29375.0
2013-02-07 10:00:00	NQ	Futures	3190.7	3191.86	3158.39	3165.67	71833.0
2013-02-07 11:00:00	NQ	Futures	3165.67	3171.78	3162.47	3165.38	34167.0
2013-02-07 12:00:00	NQ	Futures	3165.38	3180.22	3164.79	3177.02	22391.0
2013-02-07 13:00:00	NQ	Futures	3176.73	3180.8	3171.49	3180.22	18259.0
2013-02-07 14:00:00	NQ	Futures	3180.22	3184.0	3171.2	3179.64	21094.0
2013-02-07 15:00:00	NQ	Futures	3179.93	3195.07	3173.53	3194.19	43071.0
2013-02-07 16:00:00	NQ	Futures	3193.9	3197.98	3191.57	3196.52	5923.0
2013-02-07 17:00:00	NQ	Futures	3196.52	3196.52	3192.45	3192.74	372.0
2013-02-07 18:00:00	NQ	Futures	3192.45	3194.48	3192.15	3193.32	314.0
2013-02-07 19:00:00	NQ	Futures	3193.03	3194.19	3191.86	3193.03	522.0
2013-02-07 20:00:00	NQ	Futures	3192.74	3194.77	3191.28	3194.48	577.0
2013-02-07 21:00:00	NQ	Futures	3194.19	3197.39	3193.9	3197.1	496.0
2013-02-07 22:00:00	NQ	Futures	3197.1	3200.89	3196.81	3197.68	730.0
2013-02-07 23:00:00	NQ	Futures	3197.98	3199.43	3197.68	3197.68	204.0
2013-02-07 00:00:00	YM	Futures	14004.9	14010.9	14001.9	14005.9	298.0
2013-02-07 01:00:00	YM	Futures	14006.9	14018.0	14005.9	14005.9	348.0

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

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