PREVIEW / futures_1hour / 2013-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-22.parquet
  size:    50 KB
  rows:    1,540

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-01-22 00:00:00	ES	Futures	1519.28	1521.84	1519.28	1521.59	4741.0
2013-01-22 01:00:00	ES	Futures	1521.33	1521.33	1519.79	1520.05	3692.0
2013-01-22 02:00:00	ES	Futures	1520.05	1521.07	1519.53	1520.05	7624.0
2013-01-22 03:00:00	ES	Futures	1520.05	1521.33	1515.43	1515.94	37932.0
2013-01-22 04:00:00	ES	Futures	1515.94	1516.97	1513.89	1516.45	51614.0
2013-01-22 05:00:00	ES	Futures	1516.71	1520.05	1516.45	1519.28	32975.0
2013-01-22 06:00:00	ES	Futures	1519.28	1520.05	1516.45	1517.99	27607.0
2013-01-22 07:00:00	ES	Futures	1517.99	1519.28	1516.45	1517.22	21756.0
2013-01-22 08:00:00	ES	Futures	1517.22	1517.74	1515.43	1517.22	36879.0
2013-01-22 09:00:00	ES	Futures	1517.22	1520.56	1516.97	1519.28	144791.0
2013-01-22 10:00:00	ES	Futures	1519.28	1519.53	1514.66	1517.74	213790.0
2013-01-22 11:00:00	ES	Futures	1517.48	1520.05	1516.45	1519.53	120321.0
2013-01-22 12:00:00	ES	Futures	1519.28	1522.87	1519.28	1521.59	123358.0
2013-01-22 13:00:00	ES	Futures	1521.33	1523.64	1521.07	1522.35	79062.0
2013-01-22 14:00:00	ES	Futures	1522.61	1525.43	1521.84	1525.18	91000.0
2013-01-22 15:00:00	ES	Futures	1525.18	1526.72	1523.12	1526.2	181556.0
2013-01-22 16:00:00	ES	Futures	1525.95	1529.28	1525.18	1529.28	126583.0
2013-01-22 17:00:00	ES	Futures	1529.28	1530.82	1529.03	1530.31	6070.0
2013-01-22 18:00:00	ES	Futures	1529.8	1530.57	1528.26	1528.77	9067.0
2013-01-22 19:00:00	ES	Futures	1528.77	1529.54	1528.51	1529.03	5825.0
2013-01-22 20:00:00	ES	Futures	1529.03	1529.54	1528.26	1528.77	4907.0
2013-01-22 21:00:00	ES	Futures	1528.51	1528.77	1527.74	1527.74	2997.0
2013-01-22 22:00:00	ES	Futures	1528.0	1528.0	1526.97	1526.97	3394.0
2013-01-22 23:00:00	ES	Futures	1527.23	1527.49	1526.46	1526.72	2955.0
2013-01-22 00:00:00	NQ	Futures	3188.95	3193.61	3188.37	3193.32	725.0
2013-01-22 01:00:00	NQ	Futures	3192.74	3193.32	3190.41	3190.7	513.0
2013-01-22 02:00:00	NQ	Futures	3190.7	3191.86	3189.53	3189.53	641.0
2013-01-22 03:00:00	NQ	Futures	3189.53	3192.15	3177.31	3179.06	3915.0
2013-01-22 04:00:00	NQ	Futures	3178.47	3180.22	3173.82	3179.35	3980.0
2013-01-22 05:00:00	NQ	Futures	3179.64	3191.57	3179.64	3190.12	3550.0
2013-01-22 06:00:00	NQ	Futures	3190.41	3191.28	3184.59	3186.33	2130.0
2013-01-22 07:00:00	NQ	Futures	3186.33	3189.53	3184.59	3185.46	3709.0
2013-01-22 08:00:00	NQ	Futures	3185.17	3188.37	3181.39	3187.21	5240.0
2013-01-22 09:00:00	NQ	Futures	3187.21	3191.86	3180.22	3182.55	23799.0
2013-01-22 10:00:00	NQ	Futures	3182.26	3182.55	3169.16	3173.53	33704.0
2013-01-22 11:00:00	NQ	Futures	3173.82	3175.56	3167.7	3172.07	18946.0
2013-01-22 12:00:00	NQ	Futures	3172.07	3180.22	3172.07	3175.56	16433.0
2013-01-22 13:00:00	NQ	Futures	3175.85	3181.09	3175.27	3179.06	11676.0
2013-01-22 14:00:00	NQ	Futures	3179.35	3188.08	3178.47	3186.62	13353.0
2013-01-22 15:00:00	NQ	Futures	3186.92	3190.7	3179.64	3189.83	19127.0
2013-01-22 16:00:00	NQ	Futures	3189.83	3206.71	3183.13	3206.13	17745.0
2013-01-22 17:00:00	NQ	Futures	3206.13	3211.07	3205.83	3210.49	867.0
2013-01-22 18:00:00	NQ	Futures	3209.33	3210.78	3207.87	3208.75	1045.0
2013-01-22 19:00:00	NQ	Futures	3208.75	3209.91	3207.87	3209.04	390.0
2013-01-22 20:00:00	NQ	Futures	3209.04	3209.33	3207.87	3208.45	407.0
2013-01-22 21:00:00	NQ	Futures	3208.45	3208.45	3206.42	3206.71	393.0
2013-01-22 22:00:00	NQ	Futures	3206.42	3207.0	3205.54	3205.54	223.0
2013-01-22 23:00:00	NQ	Futures	3205.83	3207.58	3205.54	3205.54	523.0
2013-01-22 00:00:00	YM	Futures	13665.8	13680.9	13664.8	13679.9	559.0
2013-01-22 01:00:00	YM	Futures	13677.9	13677.9	13666.8	13667.9	412.0

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

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