PREVIEW / futures_1hour / 2014-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-14.parquet
  size:    49 KB
  rows:    1,539

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
2014-04-14 00:00:00	ES	Futures	1878.46	1879.24	1877.68	1878.46	3104.0
2014-04-14 01:00:00	ES	Futures	1878.72	1879.76	1878.46	1878.72	2874.0
2014-04-14 02:00:00	ES	Futures	1878.72	1879.24	1877.42	1879.24	8976.0
2014-04-14 03:00:00	ES	Futures	1878.98	1883.65	1878.98	1880.54	36935.0
2014-04-14 04:00:00	ES	Futures	1880.8	1881.06	1877.68	1879.76	26647.0
2014-04-14 05:00:00	ES	Futures	1880.02	1880.02	1876.12	1878.46	20073.0
2014-04-14 06:00:00	ES	Futures	1878.46	1882.88	1877.94	1882.62	22968.0
2014-04-14 07:00:00	ES	Futures	1882.62	1886.25	1881.32	1885.99	35699.0
2014-04-14 08:00:00	ES	Futures	1885.99	1893.0	1885.73	1890.67	98633.0
2014-04-14 09:00:00	ES	Futures	1890.67	1895.34	1886.51	1887.55	290982.0
2014-04-14 10:00:00	ES	Futures	1887.29	1897.94	1885.73	1897.68	296374.0
2014-04-14 11:00:00	ES	Futures	1897.42	1897.94	1893.52	1894.3	159882.0
2014-04-14 12:00:00	ES	Futures	1894.56	1898.72	1893.26	1897.16	93254.0
2014-04-14 13:00:00	ES	Futures	1897.16	1897.42	1890.93	1891.19	107395.0
2014-04-14 14:00:00	ES	Futures	1891.19	1893.26	1885.99	1886.77	167732.0
2014-04-14 15:00:00	ES	Futures	1886.77	1895.6	1878.72	1894.3	366404.0
2014-04-14 16:00:00	ES	Futures	1894.3	1895.86	1893.78	1895.34	80620.0
2014-04-14 17:00:00	ES	Futures	1895.34	1895.86	1895.08	1895.6	2628.0
2014-04-14 18:00:00	ES	Futures	1895.6	1896.64	1894.82	1895.08	5016.0
2014-04-14 19:00:00	ES	Futures	1895.08	1896.38	1895.08	1895.6	4096.0
2014-04-14 20:00:00	ES	Futures	1895.34	1895.6	1894.82	1895.34	3925.0
2014-04-14 21:00:00	ES	Futures	1895.34	1897.42	1895.08	1895.34	5922.0
2014-04-14 22:00:00	ES	Futures	1895.34	1896.12	1894.56	1895.6	2500.0
2014-04-14 23:00:00	ES	Futures	1895.6	1896.38	1895.08	1895.6	2726.0
2014-04-14 00:00:00	NQ	Futures	4005.47	4008.09	4004.31	4006.05	439.0
2014-04-14 01:00:00	NQ	Futures	4006.05	4009.55	4006.05	4007.51	478.0
2014-04-14 02:00:00	NQ	Futures	4007.51	4007.51	4003.72	4005.76	1452.0
2014-04-14 03:00:00	NQ	Futures	4006.05	4012.46	4005.18	4005.76	5221.0
2014-04-14 04:00:00	NQ	Futures	4005.47	4006.93	3997.9	4004.31	3419.0
2014-04-14 05:00:00	NQ	Futures	4004.31	4004.89	3994.4	4000.23	3325.0
2014-04-14 06:00:00	NQ	Futures	4000.81	4011.3	3998.19	4011.0	3747.0
2014-04-14 07:00:00	NQ	Futures	4011.0	4021.49	4008.97	4021.2	5614.0
2014-04-14 08:00:00	NQ	Futures	4021.2	4037.8	4019.74	4033.14	16830.0
2014-04-14 09:00:00	NQ	Futures	4033.14	4044.49	4015.96	4018.87	62440.0
2014-04-14 10:00:00	NQ	Futures	4019.16	4057.31	4013.92	4054.69	76947.0
2014-04-14 11:00:00	NQ	Futures	4054.69	4059.64	4046.24	4047.41	39769.0
2014-04-14 12:00:00	NQ	Futures	4047.41	4057.6	4041.29	4051.19	22976.0
2014-04-14 13:00:00	NQ	Futures	4051.48	4052.07	4028.19	4028.19	24753.0
2014-04-14 14:00:00	NQ	Futures	4028.19	4035.18	4017.99	4019.74	33148.0
2014-04-14 15:00:00	NQ	Futures	4020.03	4041.0	4000.81	4038.67	64756.0
2014-04-14 16:00:00	NQ	Futures	4038.38	4044.49	4037.51	4043.33	8597.0
2014-04-14 17:00:00	NQ	Futures	4043.04	4044.49	4043.04	4043.91	108.0
2014-04-14 18:00:00	NQ	Futures	4043.33	4046.82	4041.58	4041.87	1025.0
2014-04-14 19:00:00	NQ	Futures	4042.17	4045.37	4042.17	4043.33	638.0
2014-04-14 20:00:00	NQ	Futures	4043.04	4044.49	4041.87	4043.62	493.0
2014-04-14 21:00:00	NQ	Futures	4043.91	4047.41	4042.46	4043.33	1162.0
2014-04-14 22:00:00	NQ	Futures	4043.04	4044.79	4041.29	4044.2	947.0
2014-04-14 23:00:00	NQ	Futures	4044.49	4046.24	4043.04	4044.2	524.0
2014-04-14 00:00:00	YM	Futures	16427.3	16435.5	16423.2	16429.3	245.0
2014-04-14 01:00:00	YM	Futures	16431.4	16439.6	16425.2	16425.2	479.0

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

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