PREVIEW / futures_1hour / 2013-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-30.parquet
  size:    50 KB
  rows:    1,530

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-30 00:00:00	ES	Futures	1824.04	1824.04	1823.01	1823.26	882.0
2013-10-30 01:00:00	ES	Futures	1823.26	1824.04	1823.01	1823.78	2086.0
2013-10-30 02:00:00	ES	Futures	1823.78	1825.84	1823.52	1825.07	3741.0
2013-10-30 03:00:00	ES	Futures	1825.07	1826.1	1824.3	1825.59	6095.0
2013-10-30 04:00:00	ES	Futures	1825.59	1828.17	1824.55	1827.91	23974.0
2013-10-30 05:00:00	ES	Futures	1828.17	1829.71	1827.91	1828.94	19329.0
2013-10-30 06:00:00	ES	Futures	1828.94	1829.2	1827.91	1828.42	9539.0
2013-10-30 07:00:00	ES	Futures	1828.68	1828.94	1827.13	1827.91	15771.0
2013-10-30 08:00:00	ES	Futures	1827.91	1827.91	1825.33	1826.1	33302.0
2013-10-30 09:00:00	ES	Futures	1825.84	1826.88	1822.75	1824.3	169795.0
2013-10-30 10:00:00	ES	Futures	1824.3	1825.07	1821.72	1824.04	206168.0
2013-10-30 11:00:00	ES	Futures	1824.04	1824.81	1817.59	1818.88	181468.0
2013-10-30 12:00:00	ES	Futures	1818.88	1821.46	1818.11	1820.94	110173.0
2013-10-30 13:00:00	ES	Futures	1821.2	1821.46	1816.3	1817.33	109790.0
2013-10-30 14:00:00	ES	Futures	1817.33	1822.49	1807.53	1813.46	507125.0
2013-10-30 15:00:00	ES	Futures	1813.72	1817.07	1812.17	1814.75	249868.0
2013-10-30 16:00:00	ES	Futures	1814.49	1817.07	1813.2	1815.53	101212.0
2013-10-30 17:00:00	ES	Futures	1815.53	1815.78	1815.01	1815.01	1819.0
2013-10-30 18:00:00	ES	Futures	1813.72	1813.98	1809.08	1809.59	13648.0
2013-10-30 19:00:00	ES	Futures	1809.59	1811.14	1809.08	1810.37	8606.0
2013-10-30 20:00:00	ES	Futures	1810.37	1811.14	1809.33	1810.11	5907.0
2013-10-30 21:00:00	ES	Futures	1810.11	1810.37	1807.79	1808.56	10091.0
2013-10-30 22:00:00	ES	Futures	1808.82	1809.33	1808.3	1809.33	7139.0
2013-10-30 23:00:00	ES	Futures	1809.33	1811.4	1808.04	1810.37	5131.0
2013-10-30 00:00:00	NQ	Futures	3938.26	3938.56	3937.1	3937.1	167.0
2013-10-30 01:00:00	NQ	Futures	3937.39	3938.85	3936.23	3937.97	394.0
2013-10-30 02:00:00	NQ	Futures	3937.68	3940.59	3937.1	3940.01	927.0
2013-10-30 03:00:00	NQ	Futures	3939.72	3940.88	3936.81	3938.85	733.0
2013-10-30 04:00:00	NQ	Futures	3938.56	3946.4	3937.39	3945.53	2842.0
2013-10-30 05:00:00	NQ	Futures	3945.24	3949.88	3944.94	3948.14	2140.0
2013-10-30 06:00:00	NQ	Futures	3948.14	3948.72	3945.53	3947.85	1643.0
2013-10-30 07:00:00	NQ	Futures	3948.14	3950.17	3947.56	3949.59	2648.0
2013-10-30 08:00:00	NQ	Futures	3949.59	3949.59	3943.2	3944.65	4117.0
2013-10-30 09:00:00	NQ	Futures	3944.36	3951.92	3940.01	3946.11	32609.0
2013-10-30 10:00:00	NQ	Futures	3946.4	3947.27	3933.04	3943.2	34938.0
2013-10-30 11:00:00	NQ	Futures	3943.2	3946.69	3925.78	3930.13	26527.0
2013-10-30 12:00:00	NQ	Futures	3929.84	3936.81	3926.94	3936.52	15420.0
2013-10-30 13:00:00	NQ	Futures	3936.23	3937.68	3925.78	3930.13	12345.0
2013-10-30 14:00:00	NQ	Futures	3930.13	3941.46	3908.35	3919.97	86964.0
2013-10-30 15:00:00	NQ	Futures	3920.26	3930.71	3917.06	3926.94	41374.0
2013-10-30 16:00:00	NQ	Futures	3927.23	3942.33	3921.71	3937.1	16904.0
2013-10-30 17:00:00	NQ	Futures	3936.81	3936.81	3933.33	3933.91	444.0
2013-10-30 18:00:00	NQ	Futures	3926.65	3926.65	3916.77	3916.77	3084.0
2013-10-30 19:00:00	NQ	Futures	3916.77	3919.68	3914.16	3917.93	1200.0
2013-10-30 20:00:00	NQ	Futures	3917.64	3920.26	3916.19	3917.35	815.0
2013-10-30 21:00:00	NQ	Futures	3917.64	3918.22	3913.58	3916.48	1173.0
2013-10-30 22:00:00	NQ	Futures	3916.48	3917.35	3915.03	3916.77	753.0
2013-10-30 23:00:00	NQ	Futures	3916.77	3922.0	3915.32	3919.1	788.0
2013-10-30 00:00:00	YM	Futures	15948.8	15949.8	15943.7	15944.7	145.0
2013-10-30 01:00:00	YM	Futures	15944.7	15950.9	15942.7	15948.8	472.0

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

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