PREVIEW / futures_1hour / 2013-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-21.parquet
  size:    35 KB
  rows:    1,058

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-21 00:00:00	ES	Futures	1519.53	1519.79	1518.51	1519.02	3822.0
2013-01-21 01:00:00	ES	Futures	1519.02	1519.28	1517.74	1517.99	2342.0
2013-01-21 02:00:00	ES	Futures	1517.99	1519.02	1517.48	1518.76	4907.0
2013-01-21 03:00:00	ES	Futures	1518.76	1519.79	1517.48	1517.74	13967.0
2013-01-21 04:00:00	ES	Futures	1517.48	1519.02	1517.22	1518.76	6753.0
2013-01-21 05:00:00	ES	Futures	1518.51	1519.02	1518.25	1518.76	5069.0
2013-01-21 06:00:00	ES	Futures	1518.51	1519.02	1518.25	1518.76	3336.0
2013-01-21 07:00:00	ES	Futures	1519.02	1519.28	1517.99	1517.99	6045.0
2013-01-21 08:00:00	ES	Futures	1518.25	1519.79	1517.74	1519.02	12917.0
2013-01-21 09:00:00	ES	Futures	1519.02	1519.79	1518.51	1519.79	10729.0
2013-01-21 10:00:00	ES	Futures	1519.79	1522.61	1519.53	1521.59	17535.0
2013-01-21 11:00:00	ES	Futures	1521.59	1522.87	1521.59	1522.61	9599.0
2013-01-21 18:00:00	ES	Futures	1522.1	1522.61	1521.33	1521.84	3434.0
2013-01-21 19:00:00	ES	Futures	1521.59	1521.84	1520.56	1521.07	3044.0
2013-01-21 20:00:00	ES	Futures	1521.07	1521.33	1519.53	1520.3	4816.0
2013-01-21 21:00:00	ES	Futures	1520.3	1521.07	1519.53	1519.79	2983.0
2013-01-21 22:00:00	ES	Futures	1519.79	1523.38	1519.79	1521.59	8368.0
2013-01-21 23:00:00	ES	Futures	1521.59	1523.12	1518.51	1519.28	14277.0
2013-01-21 00:00:00	NQ	Futures	3188.95	3189.53	3187.5	3188.66	202.0
2013-01-21 01:00:00	NQ	Futures	3188.66	3188.66	3186.62	3187.21	146.0
2013-01-21 02:00:00	NQ	Futures	3186.92	3187.79	3185.17	3186.92	391.0
2013-01-21 03:00:00	NQ	Futures	3186.62	3188.95	3184.3	3184.59	1086.0
2013-01-21 04:00:00	NQ	Futures	3184.3	3185.17	3183.42	3184.0	1229.0
2013-01-21 05:00:00	NQ	Futures	3184.0	3184.3	3182.55	3184.0	570.0
2013-01-21 06:00:00	NQ	Futures	3184.3	3184.3	3181.39	3183.13	486.0
2013-01-21 07:00:00	NQ	Futures	3182.84	3184.88	3182.84	3184.59	405.0
2013-01-21 08:00:00	NQ	Futures	3184.3	3186.33	3183.71	3185.17	1710.0
2013-01-21 09:00:00	NQ	Futures	3185.17	3186.33	3183.42	3186.04	990.0
2013-01-21 10:00:00	NQ	Futures	3186.04	3191.86	3186.04	3189.83	1175.0
2013-01-21 11:00:00	NQ	Futures	3190.41	3193.61	3189.83	3193.61	580.0
2013-01-21 18:00:00	NQ	Futures	3191.57	3193.03	3191.28	3192.74	209.0
2013-01-21 19:00:00	NQ	Futures	3192.74	3193.03	3190.99	3191.86	277.0
2013-01-21 20:00:00	NQ	Futures	3191.57	3192.15	3190.12	3190.99	509.0
2013-01-21 21:00:00	NQ	Futures	3190.99	3191.86	3190.12	3190.12	444.0
2013-01-21 22:00:00	NQ	Futures	3190.41	3197.98	3190.41	3193.9	1562.0
2013-01-21 23:00:00	NQ	Futures	3193.9	3196.52	3187.79	3188.95	1786.0
2013-01-21 00:00:00	YM	Futures	13664.8	13667.9	13659.8	13663.8	215.0
2013-01-21 01:00:00	YM	Futures	13662.8	13664.8	13656.8	13657.8	151.0
2013-01-21 02:00:00	YM	Futures	13658.8	13661.8	13652.8	13658.8	349.0
2013-01-21 03:00:00	YM	Futures	13658.8	13669.9	13650.8	13651.8	974.0
2013-01-21 04:00:00	YM	Futures	13650.8	13660.8	13649.7	13659.8	335.0
2013-01-21 05:00:00	YM	Futures	13658.8	13664.8	13656.8	13661.8	460.0
2013-01-21 06:00:00	YM	Futures	13660.8	13662.8	13658.8	13661.8	152.0
2013-01-21 07:00:00	YM	Futures	13661.8	13661.8	13657.8	13658.8	274.0
2013-01-21 08:00:00	YM	Futures	13657.8	13663.8	13656.8	13661.8	647.0
2013-01-21 09:00:00	YM	Futures	13660.8	13664.8	13655.8	13663.8	511.0
2013-01-21 10:00:00	YM	Futures	13662.8	13685.0	13661.8	13679.9	1089.0
2013-01-21 11:00:00	YM	Futures	13679.9	13692.0	13679.9	13684.0	820.0
2013-01-21 18:00:00	YM	Futures	13685.0	13690.0	13682.9	13684.0	289.0
2013-01-21 19:00:00	YM	Futures	13682.9	13684.0	13676.9	13678.9	383.0

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

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