PREVIEW / futures_1hour / 2013-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-22.parquet
  size:    42 KB
  rows:    1,237

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-22 00:00:00	ES	Futures	1545.19	1545.45	1543.91	1544.68	4232.0
2013-02-22 01:00:00	ES	Futures	1544.93	1545.7	1544.42	1545.45	4928.0
2013-02-22 02:00:00	ES	Futures	1545.45	1545.96	1543.65	1544.93	9705.0
2013-02-22 03:00:00	ES	Futures	1544.93	1546.73	1544.17	1545.96	30672.0
2013-02-22 04:00:00	ES	Futures	1545.96	1547.24	1544.93	1545.7	35274.0
2013-02-22 05:00:00	ES	Futures	1545.7	1546.22	1544.17	1545.96	22515.0
2013-02-22 06:00:00	ES	Futures	1545.96	1548.01	1544.93	1547.24	46867.0
2013-02-22 07:00:00	ES	Futures	1547.5	1549.3	1547.24	1548.78	36822.0
2013-02-22 08:00:00	ES	Futures	1548.78	1549.55	1548.01	1548.27	37182.0
2013-02-22 09:00:00	ES	Futures	1548.27	1549.3	1544.17	1545.45	315236.0
2013-02-22 10:00:00	ES	Futures	1545.7	1547.5	1543.65	1544.93	266991.0
2013-02-22 11:00:00	ES	Futures	1544.93	1548.53	1542.88	1547.5	214588.0
2013-02-22 12:00:00	ES	Futures	1547.76	1551.86	1546.73	1551.09	140833.0
2013-02-22 13:00:00	ES	Futures	1551.35	1551.86	1549.04	1550.84	95499.0
2013-02-22 14:00:00	ES	Futures	1550.58	1550.84	1548.53	1550.07	83745.0
2013-02-22 15:00:00	ES	Futures	1550.07	1554.17	1549.55	1554.17	236722.0
2013-02-22 16:00:00	ES	Futures	1554.17	1554.94	1552.89	1553.15	120283.0
2013-02-22 17:00:00	ES	Futures	1553.4	1554.17	1553.15	1553.92	1125.0
2013-02-22 00:00:00	NQ	Futures	3168.29	3168.29	3165.67	3167.12	372.0
2013-02-22 01:00:00	NQ	Futures	3166.83	3168.87	3166.54	3168.29	249.0
2013-02-22 02:00:00	NQ	Futures	3168.0	3169.16	3165.67	3168.58	716.0
2013-02-22 03:00:00	NQ	Futures	3168.29	3173.24	3166.25	3170.62	3290.0
2013-02-22 04:00:00	NQ	Futures	3170.91	3172.36	3169.16	3169.74	1813.0
2013-02-22 05:00:00	NQ	Futures	3170.03	3172.07	3167.41	3170.91	1284.0
2013-02-22 06:00:00	NQ	Futures	3171.2	3173.24	3168.58	3171.78	2847.0
2013-02-22 07:00:00	NQ	Futures	3172.07	3174.98	3171.2	3174.4	2699.0
2013-02-22 08:00:00	NQ	Futures	3174.4	3177.89	3173.82	3176.44	3513.0
2013-02-22 09:00:00	NQ	Futures	3176.44	3178.18	3160.14	3167.7	40881.0
2013-02-22 10:00:00	NQ	Futures	3167.7	3172.65	3164.5	3166.54	28991.0
2013-02-22 11:00:00	NQ	Futures	3166.54	3174.98	3162.17	3172.07	22743.0
2013-02-22 12:00:00	NQ	Futures	3171.78	3183.13	3170.62	3181.68	17722.0
2013-02-22 13:00:00	NQ	Futures	3181.39	3183.13	3177.31	3181.39	13353.0
2013-02-22 14:00:00	NQ	Futures	3181.39	3181.39	3176.15	3178.77	9670.0
2013-02-22 15:00:00	NQ	Futures	3179.06	3187.21	3178.18	3186.04	25614.0
2013-02-22 16:00:00	NQ	Futures	3186.33	3188.95	3184.59	3184.59	6559.0
2013-02-22 17:00:00	NQ	Futures	3184.88	3185.46	3184.88	3184.88	124.0
2013-02-22 00:00:00	YM	Futures	13988.8	13989.8	13979.7	13984.8	418.0
2013-02-22 01:00:00	YM	Futures	13983.7	13989.8	13975.7	13977.7	1116.0
2013-02-22 02:00:00	YM	Futures	13979.7	13986.8	13967.6	13977.7	681.0
2013-02-22 03:00:00	YM	Futures	13976.7	13990.8	13972.7	13984.8	1973.0
2013-02-22 04:00:00	YM	Futures	13985.8	13996.8	13981.7	13983.7	2620.0
2013-02-22 05:00:00	YM	Futures	13984.8	13990.8	13973.7	13988.8	1815.0
2013-02-22 06:00:00	YM	Futures	13988.8	14002.9	13980.7	13999.8	2756.0
2013-02-22 07:00:00	YM	Futures	13999.8	14024.0	13998.8	14021.0	4266.0
2013-02-22 08:00:00	YM	Futures	14021.0	14034.0	14019.0	14024.0	5327.0
2013-02-22 09:00:00	YM	Futures	14024.0	14026.0	13975.7	13983.7	24348.0
2013-02-22 10:00:00	YM	Futures	13983.7	14013.9	13973.7	13995.8	19359.0
2013-02-22 11:00:00	YM	Futures	13995.8	14015.9	13980.7	14009.9	14883.0
2013-02-22 12:00:00	YM	Futures	14009.9	14063.2	14003.9	14057.2	15616.0
2013-02-22 13:00:00	YM	Futures	14057.2	14060.2	14040.1	14051.1	9977.0

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

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