PREVIEW / futures_1hour / 2013-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-07.parquet
  size:    52 KB
  rows:    1,565

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-11-07 00:00:00	ES	Futures	1819.39	1820.43	1818.88	1819.39	2840.0
2013-11-07 01:00:00	ES	Futures	1819.65	1820.43	1819.14	1820.17	1431.0
2013-11-07 02:00:00	ES	Futures	1820.17	1820.17	1819.14	1819.65	2843.0
2013-11-07 03:00:00	ES	Futures	1819.91	1820.94	1818.62	1820.17	11898.0
2013-11-07 04:00:00	ES	Futures	1820.17	1820.68	1818.36	1819.39	11500.0
2013-11-07 05:00:00	ES	Futures	1819.39	1820.68	1818.62	1818.62	8911.0
2013-11-07 06:00:00	ES	Futures	1818.62	1819.65	1818.36	1819.14	10196.0
2013-11-07 07:00:00	ES	Futures	1819.14	1831.0	1818.88	1828.17	99522.0
2013-11-07 08:00:00	ES	Futures	1828.42	1830.49	1825.84	1827.91	101677.0
2013-11-07 09:00:00	ES	Futures	1827.91	1828.17	1822.23	1822.75	230683.0
2013-11-07 10:00:00	ES	Futures	1823.01	1823.78	1812.43	1813.72	462343.0
2013-11-07 11:00:00	ES	Futures	1813.72	1815.78	1808.04	1814.75	348749.0
2013-11-07 12:00:00	ES	Futures	1814.75	1817.59	1812.95	1812.95	160538.0
2013-11-07 13:00:00	ES	Futures	1812.95	1813.98	1806.5	1807.53	165846.0
2013-11-07 14:00:00	ES	Futures	1807.53	1807.79	1800.82	1805.72	298172.0
2013-11-07 15:00:00	ES	Futures	1805.98	1806.5	1797.73	1799.79	389221.0
2013-11-07 16:00:00	ES	Futures	1800.05	1802.37	1799.79	1801.08	126981.0
2013-11-07 17:00:00	ES	Futures	1801.08	1801.34	1799.79	1800.31	3344.0
2013-11-07 18:00:00	ES	Futures	1800.31	1801.6	1797.98	1801.34	10928.0
2013-11-07 19:00:00	ES	Futures	1801.34	1804.18	1800.82	1803.14	9429.0
2013-11-07 20:00:00	ES	Futures	1802.89	1804.43	1802.89	1803.66	4387.0
2013-11-07 21:00:00	ES	Futures	1803.66	1804.95	1802.89	1803.4	6468.0
2013-11-07 22:00:00	ES	Futures	1803.4	1804.43	1803.14	1803.4	3081.0
2013-11-07 23:00:00	ES	Futures	1803.66	1804.43	1803.4	1804.18	4296.0
2013-11-07 00:00:00	NQ	Futures	3917.93	3919.68	3916.48	3918.52	652.0
2013-11-07 01:00:00	NQ	Futures	3918.52	3920.26	3917.93	3919.68	399.0
2013-11-07 02:00:00	NQ	Futures	3919.68	3919.68	3917.64	3918.52	455.0
2013-11-07 03:00:00	NQ	Futures	3918.81	3921.42	3915.32	3919.39	1874.0
2013-11-07 04:00:00	NQ	Futures	3919.39	3919.97	3914.45	3917.35	1478.0
2013-11-07 05:00:00	NQ	Futures	3917.06	3919.39	3914.45	3915.03	1225.0
2013-11-07 06:00:00	NQ	Futures	3915.32	3917.35	3914.16	3915.9	1191.0
2013-11-07 07:00:00	NQ	Futures	3915.9	3934.2	3915.03	3930.71	10474.0
2013-11-07 08:00:00	NQ	Futures	3930.71	3934.78	3926.65	3928.68	11332.0
2013-11-07 09:00:00	NQ	Futures	3928.68	3933.91	3912.13	3913.87	41991.0
2013-11-07 10:00:00	NQ	Futures	3913.87	3916.48	3878.73	3887.15	90793.0
2013-11-07 11:00:00	NQ	Futures	3887.15	3892.09	3872.34	3885.99	46402.0
2013-11-07 12:00:00	NQ	Futures	3885.99	3893.25	3883.95	3884.24	28564.0
2013-11-07 13:00:00	NQ	Futures	3884.24	3887.15	3871.47	3874.95	27570.0
2013-11-07 14:00:00	NQ	Futures	3874.95	3875.24	3860.72	3871.47	57221.0
2013-11-07 15:00:00	NQ	Futures	3871.17	3872.63	3850.26	3853.46	65779.0
2013-11-07 16:00:00	NQ	Futures	3853.75	3862.75	3853.17	3859.85	12565.0
2013-11-07 17:00:00	NQ	Futures	3859.85	3860.43	3857.52	3858.11	170.0
2013-11-07 18:00:00	NQ	Futures	3858.98	3860.72	3854.04	3860.43	1210.0
2013-11-07 19:00:00	NQ	Futures	3860.43	3864.2	3858.98	3861.3	1103.0
2013-11-07 20:00:00	NQ	Futures	3861.01	3864.49	3861.01	3863.04	495.0
2013-11-07 21:00:00	NQ	Futures	3863.04	3865.66	3860.72	3862.17	1153.0
2013-11-07 22:00:00	NQ	Futures	3862.17	3864.2	3861.88	3862.75	409.0
2013-11-07 23:00:00	NQ	Futures	3862.75	3864.79	3862.46	3864.2	296.0
2013-11-07 00:00:00	YM	Futures	16005.0	16013.2	15999.9	16007.0	706.0
2013-11-07 01:00:00	YM	Futures	16008.0	16012.1	16005.0	16010.1	382.0

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

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