PREVIEW / futures_1hour / 2009-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-02.parquet
  size:    45 KB
  rows:    1,362

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-11-02 00:00:00	ES	Futures	1004.25	1007.4	1004.25	1006.92	5618.0
2009-11-02 01:00:00	ES	Futures	1006.92	1006.92	1004.98	1005.22	5139.0
2009-11-02 02:00:00	ES	Futures	1005.22	1007.64	1004.25	1006.19	12239.0
2009-11-02 03:00:00	ES	Futures	1006.19	1009.1	1003.04	1008.37	55224.0
2009-11-02 04:00:00	ES	Futures	1008.37	1009.1	1004.74	1006.67	36000.0
2009-11-02 05:00:00	ES	Futures	1006.67	1008.13	1005.95	1007.64	23334.0
2009-11-02 06:00:00	ES	Futures	1007.64	1008.37	1006.19	1007.4	22075.0
2009-11-02 07:00:00	ES	Futures	1007.4	1007.64	1004.74	1005.46	21851.0
2009-11-02 08:00:00	ES	Futures	1005.46	1006.67	1004.25	1004.74	24211.0
2009-11-02 09:00:00	ES	Futures	1004.49	1008.13	1001.83	1007.64	294050.0
2009-11-02 10:00:00	ES	Futures	1007.64	1016.85	1007.4	1009.82	553348.0
2009-11-02 11:00:00	ES	Futures	1009.58	1014.67	1008.37	1011.76	240837.0
2009-11-02 12:00:00	ES	Futures	1011.76	1012.24	994.56	995.05	332516.0
2009-11-02 13:00:00	ES	Futures	995.05	1002.8	994.08	995.77	292450.0
2009-11-02 14:00:00	ES	Futures	995.77	1005.22	994.08	1002.07	362390.0
2009-11-02 15:00:00	ES	Futures	1002.31	1007.64	999.41	1006.43	367385.0
2009-11-02 16:00:00	ES	Futures	1006.43	1009.1	1005.46	1008.61	82527.0
2009-11-02 17:00:00	ES	Futures	1008.61	1009.1	1008.37	1008.61	1473.0
2009-11-02 18:00:00	ES	Futures	1008.13	1008.61	1007.64	1008.13	3115.0
2009-11-02 19:00:00	ES	Futures	1007.88	1011.52	1007.88	1010.55	7876.0
2009-11-02 20:00:00	ES	Futures	1010.55	1010.55	1009.1	1009.1	3174.0
2009-11-02 21:00:00	ES	Futures	1009.34	1009.82	1008.37	1009.1	3812.0
2009-11-02 22:00:00	ES	Futures	1008.85	1009.82	1008.13	1009.34	3638.0
2009-11-02 23:00:00	ES	Futures	1009.1	1010.31	1008.13	1008.61	2455.0
2009-11-02 00:00:00	NQ	Futures	1901.67	1906.81	1901.39	1905.95	372.0
2009-11-02 01:00:00	NQ	Futures	1905.95	1907.09	1903.67	1903.96	591.0
2009-11-02 02:00:00	NQ	Futures	1903.96	1908.23	1902.82	1905.38	1288.0
2009-11-02 03:00:00	NQ	Futures	1905.1	1910.23	1899.68	1909.37	4577.0
2009-11-02 04:00:00	NQ	Futures	1909.37	1910.23	1902.53	1905.67	2808.0
2009-11-02 05:00:00	NQ	Futures	1905.67	1907.66	1903.67	1906.81	1527.0
2009-11-02 06:00:00	NQ	Futures	1906.52	1907.66	1903.67	1905.67	1796.0
2009-11-02 07:00:00	NQ	Futures	1906.24	1906.81	1901.67	1903.39	2198.0
2009-11-02 08:00:00	NQ	Futures	1903.1	1905.67	1902.53	1903.1	3326.0
2009-11-02 09:00:00	NQ	Futures	1902.82	1905.1	1888.56	1901.39	57200.0
2009-11-02 10:00:00	NQ	Futures	1900.53	1925.35	1900.53	1910.23	95641.0
2009-11-02 11:00:00	NQ	Futures	1910.23	1919.64	1908.23	1915.93	44207.0
2009-11-02 12:00:00	NQ	Futures	1915.93	1917.08	1886.84	1889.13	57877.0
2009-11-02 13:00:00	NQ	Futures	1889.13	1901.67	1887.41	1888.84	43087.0
2009-11-02 14:00:00	NQ	Futures	1888.56	1904.53	1882.57	1900.82	67387.0
2009-11-02 15:00:00	NQ	Futures	1900.82	1907.38	1893.12	1904.81	60352.0
2009-11-02 16:00:00	NQ	Futures	1904.81	1907.95	1903.1	1907.09	9100.0
2009-11-02 17:00:00	NQ	Futures	1907.09	1907.66	1906.81	1907.38	26.0
2009-11-02 18:00:00	NQ	Futures	1906.81	1907.09	1905.67	1906.52	191.0
2009-11-02 19:00:00	NQ	Futures	1906.24	1911.66	1906.24	1909.66	794.0
2009-11-02 20:00:00	NQ	Futures	1910.23	1910.23	1907.38	1907.66	127.0
2009-11-02 21:00:00	NQ	Futures	1907.95	1908.52	1906.52	1907.09	250.0
2009-11-02 22:00:00	NQ	Futures	1907.38	1908.52	1905.67	1907.09	246.0
2009-11-02 23:00:00	NQ	Futures	1906.52	1909.37	1905.67	1906.24	86.0
2009-11-02 00:00:00	YM	Futures	9017.2	9045.1	9017.2	9038.6	669.0
2009-11-02 01:00:00	YM	Futures	9037.7	9039.5	9025.6	9027.4	393.0

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

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