PREVIEW / futures_1hour / 2013-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-24.parquet
  size:    49 KB
  rows:    1,552

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-10-24 00:00:00	ES	Futures	1801.6	1802.11	1801.08	1801.85	1391.0
2013-10-24 01:00:00	ES	Futures	1801.6	1805.46	1801.34	1805.21	8612.0
2013-10-24 02:00:00	ES	Futures	1804.95	1807.53	1804.43	1804.43	15279.0
2013-10-24 03:00:00	ES	Futures	1804.43	1805.98	1802.63	1804.69	19799.0
2013-10-24 04:00:00	ES	Futures	1804.43	1804.43	1801.85	1803.4	13962.0
2013-10-24 05:00:00	ES	Futures	1803.14	1803.4	1801.6	1803.4	8512.0
2013-10-24 06:00:00	ES	Futures	1803.4	1806.75	1802.63	1804.69	18574.0
2013-10-24 07:00:00	ES	Futures	1804.95	1805.72	1802.37	1803.14	16975.0
2013-10-24 08:00:00	ES	Futures	1803.14	1803.4	1800.31	1800.56	35757.0
2013-10-24 09:00:00	ES	Futures	1800.31	1801.85	1795.4	1798.24	201811.0
2013-10-24 10:00:00	ES	Futures	1798.5	1800.82	1795.92	1799.53	214775.0
2013-10-24 11:00:00	ES	Futures	1799.79	1802.37	1799.02	1801.34	124682.0
2013-10-24 12:00:00	ES	Futures	1801.34	1802.89	1798.76	1802.89	106259.0
2013-10-24 13:00:00	ES	Futures	1802.89	1802.89	1800.05	1801.08	74709.0
2013-10-24 14:00:00	ES	Futures	1801.08	1804.43	1800.82	1804.43	79885.0
2013-10-24 15:00:00	ES	Futures	1804.43	1804.69	1800.82	1802.37	162357.0
2013-10-24 16:00:00	ES	Futures	1802.37	1805.98	1802.11	1804.69	96701.0
2013-10-24 17:00:00	ES	Futures	1804.43	1804.95	1803.92	1804.43	3265.0
2013-10-24 18:00:00	ES	Futures	1803.66	1804.95	1803.66	1804.43	4189.0
2013-10-24 19:00:00	ES	Futures	1804.69	1804.69	1804.18	1804.43	919.0
2013-10-24 20:00:00	ES	Futures	1804.43	1804.69	1803.14	1803.4	4654.0
2013-10-24 21:00:00	ES	Futures	1803.4	1805.46	1803.14	1803.66	4938.0
2013-10-24 22:00:00	ES	Futures	1803.92	1805.46	1802.89	1803.66	5505.0
2013-10-24 23:00:00	ES	Futures	1803.66	1804.43	1802.63	1802.89	3189.0
2013-10-24 00:00:00	NQ	Futures	3890.34	3892.09	3889.18	3891.51	573.0
2013-10-24 01:00:00	NQ	Futures	3891.21	3899.06	3891.21	3898.48	1302.0
2013-10-24 02:00:00	NQ	Futures	3898.48	3903.12	3897.6	3898.48	1986.0
2013-10-24 03:00:00	NQ	Futures	3897.89	3899.35	3891.8	3895.86	3336.0
2013-10-24 04:00:00	NQ	Futures	3895.28	3895.57	3889.47	3892.96	2522.0
2013-10-24 05:00:00	NQ	Futures	3892.67	3894.12	3889.18	3893.54	1206.0
2013-10-24 06:00:00	NQ	Futures	3893.54	3899.35	3892.38	3895.86	2044.0
2013-10-24 07:00:00	NQ	Futures	3895.86	3895.86	3890.92	3892.38	2718.0
2013-10-24 08:00:00	NQ	Futures	3892.09	3892.38	3881.63	3883.08	4644.0
2013-10-24 09:00:00	NQ	Futures	3882.5	3887.44	3874.95	3885.99	35641.0
2013-10-24 10:00:00	NQ	Futures	3885.99	3891.51	3881.63	3890.92	31254.0
2013-10-24 11:00:00	NQ	Futures	3891.21	3901.96	3890.05	3897.31	19614.0
2013-10-24 12:00:00	NQ	Futures	3897.02	3903.99	3894.41	3903.12	14713.0
2013-10-24 13:00:00	NQ	Futures	3902.83	3903.12	3895.28	3896.15	10812.0
2013-10-24 14:00:00	NQ	Futures	3896.44	3903.99	3895.57	3903.12	8514.0
2013-10-24 15:00:00	NQ	Futures	3903.12	3903.41	3892.67	3896.15	21717.0
2013-10-24 16:00:00	NQ	Futures	3896.44	3926.36	3894.99	3923.45	23013.0
2013-10-24 17:00:00	NQ	Futures	3923.45	3924.61	3921.71	3922.29	526.0
2013-10-24 18:00:00	NQ	Futures	3922.87	3924.61	3919.97	3922.58	1421.0
2013-10-24 19:00:00	NQ	Futures	3922.87	3923.45	3921.71	3922.29	355.0
2013-10-24 20:00:00	NQ	Futures	3922.87	3922.87	3920.26	3920.55	819.0
2013-10-24 21:00:00	NQ	Futures	3921.13	3925.49	3920.26	3922.58	1078.0
2013-10-24 22:00:00	NQ	Futures	3922.58	3924.03	3920.84	3921.42	707.0
2013-10-24 23:00:00	NQ	Futures	3921.71	3923.45	3919.1	3919.39	508.0
2013-10-24 00:00:00	YM	Futures	15710.9	15715.0	15705.8	15710.9	278.0
2013-10-24 01:00:00	YM	Futures	15709.8	15741.5	15708.8	15738.4	870.0

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

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