PREVIEW / futures_1hour / 2013-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-13.parquet
  size:    51 KB
  rows:    1,556

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-13 00:00:00	ES	Futures	1814.49	1816.04	1814.24	1815.01	5916.0
2013-11-13 01:00:00	ES	Futures	1815.27	1817.33	1814.24	1816.56	3896.0
2013-11-13 02:00:00	ES	Futures	1816.56	1817.07	1815.27	1817.07	7674.0
2013-11-13 03:00:00	ES	Futures	1816.82	1820.94	1816.56	1819.65	23956.0
2013-11-13 04:00:00	ES	Futures	1819.65	1819.65	1817.07	1818.11	20686.0
2013-11-13 05:00:00	ES	Futures	1818.36	1820.43	1817.85	1818.62	15299.0
2013-11-13 06:00:00	ES	Futures	1818.62	1818.88	1815.53	1816.04	16451.0
2013-11-13 07:00:00	ES	Futures	1816.3	1817.07	1813.72	1814.49	37224.0
2013-11-13 08:00:00	ES	Futures	1814.75	1814.75	1810.11	1811.4	80260.0
2013-11-13 09:00:00	ES	Futures	1811.4	1818.11	1810.88	1817.59	209681.0
2013-11-13 10:00:00	ES	Futures	1817.85	1820.94	1815.01	1819.39	226231.0
2013-11-13 11:00:00	ES	Futures	1819.39	1820.17	1817.59	1819.91	122117.0
2013-11-13 12:00:00	ES	Futures	1819.91	1826.36	1818.62	1825.59	206042.0
2013-11-13 13:00:00	ES	Futures	1825.84	1830.23	1824.55	1828.68	158135.0
2013-11-13 14:00:00	ES	Futures	1828.68	1829.46	1826.62	1826.88	87467.0
2013-11-13 15:00:00	ES	Futures	1827.13	1835.65	1826.88	1834.87	267507.0
2013-11-13 16:00:00	ES	Futures	1835.13	1839.0	1833.84	1837.19	137540.0
2013-11-13 17:00:00	ES	Futures	1837.19	1837.97	1835.65	1836.16	6771.0
2013-11-13 18:00:00	ES	Futures	1836.42	1840.03	1835.65	1839.26	19472.0
2013-11-13 19:00:00	ES	Futures	1839.26	1840.03	1838.74	1839.52	5759.0
2013-11-13 20:00:00	ES	Futures	1839.26	1839.77	1837.45	1837.45	7630.0
2013-11-13 21:00:00	ES	Futures	1837.45	1840.03	1837.45	1839.52	5318.0
2013-11-13 22:00:00	ES	Futures	1839.52	1840.55	1839.26	1839.52	8121.0
2013-11-13 23:00:00	ES	Futures	1839.52	1840.29	1838.74	1839.77	4466.0
2013-11-13 00:00:00	NQ	Futures	3890.34	3893.25	3889.76	3891.8	924.0
2013-11-13 01:00:00	NQ	Futures	3891.8	3896.44	3890.92	3896.15	490.0
2013-11-13 02:00:00	NQ	Futures	3895.57	3896.44	3892.09	3894.41	960.0
2013-11-13 03:00:00	NQ	Futures	3894.12	3904.87	3894.12	3901.09	3608.0
2013-11-13 04:00:00	NQ	Futures	3900.8	3900.8	3894.41	3897.6	3082.0
2013-11-13 05:00:00	NQ	Futures	3897.6	3903.41	3897.6	3900.51	2622.0
2013-11-13 06:00:00	NQ	Futures	3900.51	3902.54	3895.57	3896.73	2682.0
2013-11-13 07:00:00	NQ	Futures	3896.73	3899.64	3891.8	3894.12	4375.0
2013-11-13 08:00:00	NQ	Futures	3894.12	3894.41	3878.15	3879.89	13311.0
2013-11-13 09:00:00	NQ	Futures	3879.89	3900.22	3879.31	3898.77	36123.0
2013-11-13 10:00:00	NQ	Futures	3898.77	3911.25	3893.83	3908.64	38168.0
2013-11-13 11:00:00	NQ	Futures	3908.64	3910.96	3904.28	3908.35	17512.0
2013-11-13 12:00:00	NQ	Futures	3908.64	3928.68	3905.74	3926.94	35703.0
2013-11-13 13:00:00	NQ	Futures	3927.23	3935.65	3924.32	3933.04	24147.0
2013-11-13 14:00:00	NQ	Futures	3932.75	3935.07	3930.13	3931.58	15448.0
2013-11-13 15:00:00	NQ	Futures	3931.58	3953.95	3931.29	3953.66	41967.0
2013-11-13 16:00:00	NQ	Futures	3953.66	3957.72	3948.72	3950.17	20935.0
2013-11-13 17:00:00	NQ	Futures	3949.88	3951.33	3943.49	3944.36	2110.0
2013-11-13 18:00:00	NQ	Futures	3941.17	3949.01	3938.56	3948.43	1763.0
2013-11-13 19:00:00	NQ	Futures	3948.14	3948.43	3946.4	3948.14	886.0
2013-11-13 20:00:00	NQ	Futures	3948.14	3949.3	3943.2	3943.49	1128.0
2013-11-13 21:00:00	NQ	Futures	3943.49	3949.3	3943.2	3949.01	1036.0
2013-11-13 22:00:00	NQ	Futures	3949.01	3951.04	3947.56	3947.85	1385.0
2013-11-13 23:00:00	NQ	Futures	3948.14	3949.59	3946.69	3948.72	617.0
2013-11-13 00:00:00	YM	Futures	15993.8	16004.0	15992.7	15999.9	949.0
2013-11-13 01:00:00	YM	Futures	15999.9	16017.2	15995.8	16014.2	1078.0

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

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