PREVIEW / futures_1hour / 2013-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-21.parquet
  size:    50 KB
  rows:    1,541

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-21 00:00:00	ES	Futures	1545.45	1546.22	1544.93	1545.7	8293.0
2013-02-21 01:00:00	ES	Futures	1545.45	1546.73	1544.93	1546.73	7182.0
2013-02-21 02:00:00	ES	Futures	1546.73	1548.53	1546.22	1547.76	16482.0
2013-02-21 03:00:00	ES	Futures	1548.01	1548.01	1541.86	1542.63	85141.0
2013-02-21 04:00:00	ES	Futures	1542.88	1543.14	1540.57	1543.14	45280.0
2013-02-21 05:00:00	ES	Futures	1543.14	1543.65	1540.57	1541.34	39201.0
2013-02-21 06:00:00	ES	Futures	1541.6	1543.91	1541.34	1543.65	39576.0
2013-02-21 07:00:00	ES	Futures	1543.65	1544.68	1542.11	1543.91	37751.0
2013-02-21 08:00:00	ES	Futures	1543.91	1545.7	1542.63	1544.68	77670.0
2013-02-21 09:00:00	ES	Futures	1544.42	1546.47	1538.01	1539.8	397109.0
2013-02-21 10:00:00	ES	Futures	1539.8	1543.91	1536.72	1541.86	477957.0
2013-02-21 11:00:00	ES	Futures	1541.86	1542.63	1538.78	1540.83	216487.0
2013-02-21 12:00:00	ES	Futures	1540.83	1541.34	1536.47	1539.29	156674.0
2013-02-21 13:00:00	ES	Futures	1539.29	1540.32	1536.72	1538.01	149889.0
2013-02-21 14:00:00	ES	Futures	1537.75	1539.8	1534.41	1539.55	226355.0
2013-02-21 15:00:00	ES	Futures	1539.8	1544.42	1538.52	1539.29	371525.0
2013-02-21 16:00:00	ES	Futures	1539.55	1541.86	1539.29	1541.6	85830.0
2013-02-21 17:00:00	ES	Futures	1541.86	1541.86	1541.34	1541.6	1224.0
2013-02-21 18:00:00	ES	Futures	1541.86	1543.14	1541.6	1542.11	10271.0
2013-02-21 19:00:00	ES	Futures	1542.11	1543.91	1542.11	1542.63	8288.0
2013-02-21 20:00:00	ES	Futures	1542.63	1543.65	1541.6	1543.65	5645.0
2013-02-21 21:00:00	ES	Futures	1543.4	1545.7	1542.88	1544.42	10789.0
2013-02-21 22:00:00	ES	Futures	1544.42	1546.47	1544.42	1545.45	10315.0
2013-02-21 23:00:00	ES	Futures	1545.7	1546.47	1545.19	1545.45	4531.0
2013-02-21 00:00:00	NQ	Futures	3184.0	3184.88	3181.97	3181.97	569.0
2013-02-21 01:00:00	NQ	Futures	3182.26	3186.04	3181.68	3185.75	700.0
2013-02-21 02:00:00	NQ	Futures	3186.04	3187.79	3185.17	3187.21	1266.0
2013-02-21 03:00:00	NQ	Futures	3186.92	3187.79	3173.24	3175.27	9640.0
2013-02-21 04:00:00	NQ	Futures	3174.98	3177.31	3172.94	3177.02	2495.0
2013-02-21 05:00:00	NQ	Futures	3177.31	3177.31	3170.32	3170.91	3153.0
2013-02-21 06:00:00	NQ	Futures	3170.91	3174.98	3169.74	3174.4	4061.0
2013-02-21 07:00:00	NQ	Futures	3174.69	3176.15	3173.24	3176.15	2659.0
2013-02-21 08:00:00	NQ	Futures	3176.15	3180.22	3174.69	3177.6	6380.0
2013-02-21 09:00:00	NQ	Futures	3177.31	3181.68	3162.17	3166.25	46538.0
2013-02-21 10:00:00	NQ	Futures	3166.25	3175.27	3157.81	3169.16	48331.0
2013-02-21 11:00:00	NQ	Futures	3168.87	3170.91	3158.1	3161.01	22452.0
2013-02-21 12:00:00	NQ	Futures	3160.72	3161.01	3148.2	3154.9	26067.0
2013-02-21 13:00:00	NQ	Futures	3154.61	3157.81	3146.17	3150.53	22286.0
2013-02-21 14:00:00	NQ	Futures	3150.53	3156.64	3142.96	3156.64	28969.0
2013-02-21 15:00:00	NQ	Futures	3156.64	3166.25	3153.44	3154.9	45140.0
2013-02-21 16:00:00	NQ	Futures	3154.9	3162.76	3154.02	3162.17	8973.0
2013-02-21 17:00:00	NQ	Futures	3162.17	3163.34	3162.17	3162.17	153.0
2013-02-21 18:00:00	NQ	Futures	3162.17	3165.09	3162.17	3163.92	747.0
2013-02-21 19:00:00	NQ	Futures	3164.21	3167.12	3164.21	3164.21	574.0
2013-02-21 20:00:00	NQ	Futures	3164.21	3166.83	3163.92	3166.83	513.0
2013-02-21 21:00:00	NQ	Futures	3166.83	3170.91	3165.67	3168.0	850.0
2013-02-21 22:00:00	NQ	Futures	3168.0	3170.91	3167.7	3169.16	850.0
2013-02-21 23:00:00	NQ	Futures	3168.87	3170.03	3167.7	3168.58	487.0
2013-02-21 00:00:00	YM	Futures	13963.6	13968.7	13960.6	13964.6	757.0
2013-02-21 01:00:00	YM	Futures	13965.6	13969.7	13956.6	13969.7	1145.0

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

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