PREVIEW / futures_1hour / 2013-10-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1812.69	1813.72	1811.91	1813.46	1947.0
2013-10-29 01:00:00	ES	Futures	1813.2	1813.98	1812.17	1813.72	2834.0
2013-10-29 02:00:00	ES	Futures	1813.98	1814.24	1813.46	1813.98	1278.0
2013-10-29 03:00:00	ES	Futures	1814.24	1814.24	1812.17	1812.43	4056.0
2013-10-29 04:00:00	ES	Futures	1812.43	1817.33	1812.43	1816.56	18198.0
2013-10-29 05:00:00	ES	Futures	1816.56	1816.82	1813.98	1815.01	10896.0
2013-10-29 06:00:00	ES	Futures	1815.01	1815.78	1813.98	1814.75	10390.0
2013-10-29 07:00:00	ES	Futures	1814.49	1817.33	1814.49	1816.56	18322.0
2013-10-29 08:00:00	ES	Futures	1816.3	1817.85	1815.27	1816.3	24765.0
2013-10-29 09:00:00	ES	Futures	1816.3	1820.17	1816.3	1817.33	189165.0
2013-10-29 10:00:00	ES	Futures	1817.07	1819.65	1815.01	1815.78	186407.0
2013-10-29 11:00:00	ES	Futures	1816.04	1819.14	1815.78	1818.36	121782.0
2013-10-29 12:00:00	ES	Futures	1818.36	1821.97	1817.85	1820.68	133782.0
2013-10-29 13:00:00	ES	Futures	1820.68	1822.23	1819.65	1820.94	80032.0
2013-10-29 14:00:00	ES	Futures	1820.94	1822.23	1820.43	1821.72	86465.0
2013-10-29 15:00:00	ES	Futures	1821.46	1824.04	1819.14	1823.78	186253.0
2013-10-29 16:00:00	ES	Futures	1823.78	1824.55	1822.49	1824.04	79420.0
2013-10-29 17:00:00	ES	Futures	1824.04	1825.07	1823.52	1824.81	3069.0
2013-10-29 18:00:00	ES	Futures	1824.55	1824.55	1823.26	1823.26	5495.0
2013-10-29 19:00:00	ES	Futures	1823.26	1823.52	1822.75	1823.01	2025.0
2013-10-29 20:00:00	ES	Futures	1823.26	1823.52	1821.97	1822.23	4856.0
2013-10-29 21:00:00	ES	Futures	1822.23	1823.78	1821.97	1823.52	3283.0
2013-10-29 22:00:00	ES	Futures	1823.52	1824.3	1823.01	1823.78	1963.0
2013-10-29 23:00:00	ES	Futures	1823.52	1824.3	1823.01	1824.04	1382.0
2013-10-29 00:00:00	NQ	Futures	3918.52	3921.71	3917.93	3921.42	275.0
2013-10-29 01:00:00	NQ	Futures	3920.84	3922.87	3918.81	3922.58	492.0
2013-10-29 02:00:00	NQ	Futures	3922.87	3923.16	3922.29	3922.87	208.0
2013-10-29 03:00:00	NQ	Futures	3923.16	3923.45	3919.1	3920.26	661.0
2013-10-29 04:00:00	NQ	Futures	3920.26	3933.33	3920.26	3931.29	2730.0
2013-10-29 05:00:00	NQ	Futures	3931.58	3932.17	3926.65	3929.26	1709.0
2013-10-29 06:00:00	NQ	Futures	3928.68	3931.88	3926.94	3930.42	1911.0
2013-10-29 07:00:00	NQ	Futures	3930.13	3935.65	3928.97	3934.49	2850.0
2013-10-29 08:00:00	NQ	Futures	3934.49	3935.36	3930.71	3933.33	3719.0
2013-10-29 09:00:00	NQ	Futures	3933.04	3940.88	3919.97	3922.0	39191.0
2013-10-29 10:00:00	NQ	Futures	3922.0	3930.42	3913.87	3918.52	42119.0
2013-10-29 11:00:00	NQ	Futures	3918.52	3928.97	3915.61	3924.32	24366.0
2013-10-29 12:00:00	NQ	Futures	3924.32	3935.65	3923.16	3933.33	20408.0
2013-10-29 13:00:00	NQ	Futures	3933.62	3936.81	3928.68	3933.91	10684.0
2013-10-29 14:00:00	NQ	Futures	3933.91	3936.81	3930.42	3933.04	10180.0
2013-10-29 15:00:00	NQ	Futures	3933.04	3933.91	3922.87	3931.0	33762.0
2013-10-29 16:00:00	NQ	Futures	3931.0	3936.23	3928.1	3935.94	7157.0
2013-10-29 17:00:00	NQ	Futures	3936.23	3938.85	3935.65	3938.26	590.0
2013-10-29 18:00:00	NQ	Futures	3938.56	3938.85	3935.36	3935.36	615.0
2013-10-29 19:00:00	NQ	Futures	3935.36	3935.36	3933.91	3934.78	180.0
2013-10-29 20:00:00	NQ	Futures	3934.49	3934.78	3931.88	3933.04	860.0
2013-10-29 21:00:00	NQ	Futures	3932.46	3936.81	3932.17	3936.52	430.0
2013-10-29 22:00:00	NQ	Futures	3936.81	3937.97	3935.07	3937.39	658.0
2013-10-29 23:00:00	NQ	Futures	3937.39	3938.26	3936.52	3937.97	216.0
2013-10-29 00:00:00	YM	Futures	15834.4	15843.6	15829.3	15839.5	372.0
2013-10-29 01:00:00	YM	Futures	15839.5	15845.7	15831.4	15840.6	627.0

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

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