PREVIEW / futures_1hour / 2009-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-28.parquet
  size:    35 KB
  rows:    1,000

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
2009-08-28 00:00:00	ES	Futures	991.43	992.64	991.19	991.92	1516.0
2009-08-28 01:00:00	ES	Futures	992.16	993.36	991.67	992.64	1975.0
2009-08-28 02:00:00	ES	Futures	992.4	994.57	991.67	994.09	8373.0
2009-08-28 03:00:00	ES	Futures	994.09	994.57	992.4	993.12	17429.0
2009-08-28 04:00:00	ES	Futures	993.36	997.22	992.88	996.98	18973.0
2009-08-28 05:00:00	ES	Futures	996.74	997.94	996.5	996.5	11514.0
2009-08-28 06:00:00	ES	Futures	996.74	998.43	996.26	998.19	8005.0
2009-08-28 07:00:00	ES	Futures	998.19	999.63	996.98	997.22	17175.0
2009-08-28 08:00:00	ES	Futures	997.22	998.43	995.53	996.5	38655.0
2009-08-28 09:00:00	ES	Futures	996.5	1002.04	993.84	994.33	322566.0
2009-08-28 10:00:00	ES	Futures	994.33	996.5	990.47	993.84	293024.0
2009-08-28 11:00:00	ES	Futures	993.84	994.57	989.74	990.95	153460.0
2009-08-28 12:00:00	ES	Futures	990.95	991.92	985.89	987.09	179283.0
2009-08-28 13:00:00	ES	Futures	987.33	991.19	987.09	990.23	92666.0
2009-08-28 14:00:00	ES	Futures	989.99	992.4	989.02	991.67	127389.0
2009-08-28 15:00:00	ES	Futures	991.67	993.36	989.26	992.64	183297.0
2009-08-28 16:00:00	ES	Futures	992.4	993.12	990.95	991.19	61611.0
2009-08-28 00:00:00	NQ	Futures	1866.36	1868.64	1865.79	1867.79	203.0
2009-08-28 01:00:00	NQ	Futures	1867.79	1869.78	1866.65	1868.36	265.0
2009-08-28 02:00:00	NQ	Futures	1868.36	1871.77	1867.5	1870.63	416.0
2009-08-28 03:00:00	NQ	Futures	1870.63	1871.77	1866.65	1868.64	1854.0
2009-08-28 04:00:00	NQ	Futures	1868.93	1875.19	1868.36	1875.19	1778.0
2009-08-28 05:00:00	NQ	Futures	1875.19	1876.9	1874.34	1875.48	782.0
2009-08-28 06:00:00	NQ	Futures	1875.76	1877.47	1874.91	1876.9	487.0
2009-08-28 07:00:00	NQ	Futures	1877.19	1878.04	1874.62	1875.19	1419.0
2009-08-28 08:00:00	NQ	Futures	1875.19	1879.18	1872.06	1876.62	6575.0
2009-08-28 09:00:00	NQ	Futures	1876.62	1900.82	1876.62	1881.46	80186.0
2009-08-28 10:00:00	NQ	Futures	1881.17	1886.58	1870.07	1878.61	57024.0
2009-08-28 11:00:00	NQ	Futures	1878.32	1879.18	1870.07	1872.06	24474.0
2009-08-28 12:00:00	NQ	Futures	1872.06	1874.62	1857.53	1858.39	43994.0
2009-08-28 13:00:00	NQ	Futures	1858.39	1869.21	1858.1	1866.65	21387.0
2009-08-28 14:00:00	NQ	Futures	1866.36	1873.77	1864.08	1872.34	20644.0
2009-08-28 15:00:00	NQ	Futures	1872.63	1878.32	1865.79	1871.2	30965.0
2009-08-28 16:00:00	NQ	Futures	1871.2	1874.62	1870.35	1871.49	6193.0
2009-08-28 00:00:00	YM	Futures	8833.1	8843.2	8832.1	8839.5	101.0
2009-08-28 01:00:00	YM	Futures	8838.6	8848.8	8836.8	8841.4	93.0
2009-08-28 02:00:00	YM	Futures	8840.5	8859.0	8837.7	8855.3	533.0
2009-08-28 03:00:00	YM	Futures	8855.3	8859.0	8838.6	8845.1	1181.0
2009-08-28 04:00:00	YM	Futures	8846.0	8874.7	8843.2	8872.8	849.0
2009-08-28 05:00:00	YM	Futures	8871.9	8882.1	8868.2	8870.1	388.0
2009-08-28 06:00:00	YM	Futures	8872.8	8879.3	8867.3	8879.3	738.0
2009-08-28 07:00:00	YM	Futures	8879.3	8889.5	8871.0	8872.8	772.0
2009-08-28 08:00:00	YM	Futures	8871.9	8881.2	8859.9	8865.4	3007.0
2009-08-28 09:00:00	YM	Futures	8865.4	8911.7	8832.1	8833.1	29140.0
2009-08-28 10:00:00	YM	Futures	8834.0	8854.3	8804.4	8834.9	27628.0
2009-08-28 11:00:00	YM	Futures	8834.0	8836.8	8804.4	8810.9	13365.0
2009-08-28 12:00:00	YM	Futures	8810.9	8821.1	8770.2	8784.1	18430.0
2009-08-28 13:00:00	YM	Futures	8784.1	8815.5	8784.1	8804.4	9035.0
2009-08-28 14:00:00	YM	Futures	8804.4	8822.9	8791.5	8810.0	12724.0
2009-08-28 15:00:00	YM	Futures	8810.0	8828.4	8796.1	8820.1	14421.0

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

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