PREVIEW / futures_1hour / 2013-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-03.parquet
  size:    51 KB
  rows:    1,547

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-03 00:00:00	ES	Futures	1491.31	1491.31	1490.54	1490.54	2235.0
2013-01-03 01:00:00	ES	Futures	1490.54	1491.82	1490.54	1491.31	3160.0
2013-01-03 02:00:00	ES	Futures	1491.31	1491.56	1490.54	1491.05	6333.0
2013-01-03 03:00:00	ES	Futures	1491.05	1493.1	1490.79	1492.33	17650.0
2013-01-03 04:00:00	ES	Futures	1492.59	1493.1	1491.05	1492.08	11596.0
2013-01-03 05:00:00	ES	Futures	1492.08	1492.59	1491.05	1491.56	13717.0
2013-01-03 06:00:00	ES	Futures	1491.56	1492.08	1490.79	1490.79	10559.0
2013-01-03 07:00:00	ES	Futures	1491.05	1491.56	1490.54	1491.31	15125.0
2013-01-03 08:00:00	ES	Futures	1491.31	1495.41	1490.54	1494.39	68964.0
2013-01-03 09:00:00	ES	Futures	1494.13	1495.16	1491.05	1492.85	169927.0
2013-01-03 10:00:00	ES	Futures	1493.1	1495.93	1492.85	1494.39	191931.0
2013-01-03 11:00:00	ES	Futures	1494.13	1498.24	1493.87	1496.95	178499.0
2013-01-03 12:00:00	ES	Futures	1496.95	1498.49	1495.93	1497.47	97480.0
2013-01-03 13:00:00	ES	Futures	1497.21	1499.01	1496.18	1498.49	74619.0
2013-01-03 14:00:00	ES	Futures	1498.49	1498.49	1491.31	1493.87	256810.0
2013-01-03 15:00:00	ES	Futures	1493.62	1494.39	1488.23	1492.85	346569.0
2013-01-03 16:00:00	ES	Futures	1492.59	1493.1	1490.02	1492.59	101323.0
2013-01-03 17:00:00	ES	Futures	1492.59	1493.36	1492.33	1492.59	1596.0
2013-01-03 18:00:00	ES	Futures	1492.33	1492.85	1491.05	1491.31	4984.0
2013-01-03 19:00:00	ES	Futures	1491.31	1493.87	1491.05	1492.59	10293.0
2013-01-03 20:00:00	ES	Futures	1492.59	1493.1	1491.56	1492.59	8376.0
2013-01-03 21:00:00	ES	Futures	1492.59	1492.85	1491.31	1491.31	4320.0
2013-01-03 22:00:00	ES	Futures	1491.31	1491.56	1490.28	1490.79	4886.0
2013-01-03 23:00:00	ES	Futures	1490.54	1490.79	1489.77	1490.02	3777.0
2013-01-03 00:00:00	NQ	Futures	3183.42	3183.42	3181.39	3181.39	303.0
2013-01-03 01:00:00	NQ	Futures	3181.39	3183.42	3180.51	3182.26	576.0
2013-01-03 02:00:00	NQ	Futures	3182.55	3184.59	3182.26	3184.3	539.0
2013-01-03 03:00:00	NQ	Futures	3184.3	3189.83	3184.0	3188.95	2813.0
2013-01-03 04:00:00	NQ	Futures	3189.24	3190.7	3186.04	3187.5	2275.0
2013-01-03 05:00:00	NQ	Futures	3187.21	3187.79	3184.59	3184.88	1479.0
2013-01-03 06:00:00	NQ	Futures	3184.88	3185.17	3182.26	3182.84	1360.0
2013-01-03 07:00:00	NQ	Futures	3182.84	3185.17	3181.68	3182.26	1520.0
2013-01-03 08:00:00	NQ	Futures	3182.55	3190.12	3181.09	3187.5	8304.0
2013-01-03 09:00:00	NQ	Futures	3187.79	3192.15	3181.97	3190.7	30005.0
2013-01-03 10:00:00	NQ	Futures	3190.7	3197.39	3186.33	3188.37	28549.0
2013-01-03 11:00:00	NQ	Futures	3188.37	3198.27	3187.5	3193.32	23558.0
2013-01-03 12:00:00	NQ	Futures	3193.32	3196.23	3190.41	3190.99	15329.0
2013-01-03 13:00:00	NQ	Futures	3190.99	3195.65	3188.08	3193.32	12842.0
2013-01-03 14:00:00	NQ	Futures	3193.61	3193.61	3177.02	3181.97	33566.0
2013-01-03 15:00:00	NQ	Futures	3181.68	3182.55	3165.67	3176.44	43553.0
2013-01-03 16:00:00	NQ	Futures	3175.85	3176.73	3171.78	3175.27	6816.0
2013-01-03 17:00:00	NQ	Futures	3175.27	3176.44	3174.69	3175.56	102.0
2013-01-03 18:00:00	NQ	Futures	3174.4	3175.56	3171.2	3172.07	377.0
2013-01-03 19:00:00	NQ	Futures	3171.78	3176.73	3171.2	3174.98	1118.0
2013-01-03 20:00:00	NQ	Futures	3175.27	3175.85	3170.32	3174.11	1201.0
2013-01-03 21:00:00	NQ	Futures	3174.4	3174.98	3171.78	3172.36	477.0
2013-01-03 22:00:00	NQ	Futures	3172.36	3172.36	3169.74	3170.91	370.0
2013-01-03 23:00:00	NQ	Futures	3170.32	3170.91	3169.74	3169.74	188.0
2013-01-03 00:00:00	YM	Futures	13380.1	13382.1	13374.1	13374.1	228.0
2013-01-03 01:00:00	YM	Futures	13374.1	13387.2	13374.1	13382.1	522.0

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

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