PREVIEW / futures_1hour / 2009-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-08.parquet
  size:    44 KB
  rows:    1,263

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-06-08 00:00:00	ES	Futures	898.63	899.35	897.67	897.91	1279.0
2009-06-08 01:00:00	ES	Futures	897.91	900.78	897.43	899.59	3318.0
2009-06-08 02:00:00	ES	Futures	899.35	899.82	895.99	898.63	5713.0
2009-06-08 03:00:00	ES	Futures	898.87	899.82	893.35	894.79	23737.0
2009-06-08 04:00:00	ES	Futures	894.55	894.79	891.2	892.16	17800.0
2009-06-08 05:00:00	ES	Futures	891.92	894.55	890.0	890.96	14390.0
2009-06-08 06:00:00	ES	Futures	890.72	893.59	890.48	893.12	9239.0
2009-06-08 07:00:00	ES	Futures	893.35	894.79	891.68	893.35	23720.0
2009-06-08 08:00:00	ES	Futures	893.35	893.83	891.68	893.12	19183.0
2009-06-08 09:00:00	ES	Futures	892.88	896.47	889.76	890.48	219283.0
2009-06-08 10:00:00	ES	Futures	890.48	894.79	888.56	892.88	298923.0
2009-06-08 11:00:00	ES	Futures	893.12	894.31	889.28	890.48	210978.0
2009-06-08 12:00:00	ES	Futures	890.72	890.96	887.12	889.52	163994.0
2009-06-08 13:00:00	ES	Futures	889.28	893.59	889.28	892.4	126890.0
2009-06-08 14:00:00	ES	Futures	892.4	893.59	890.72	892.64	125088.0
2009-06-08 15:00:00	ES	Futures	892.88	907.25	892.64	899.59	547384.0
2009-06-08 16:00:00	ES	Futures	899.35	901.26	897.19	900.78	94763.0
2009-06-08 17:00:00	ES	Futures	900.78	901.26	900.06	900.3	1315.0
2009-06-08 18:00:00	ES	Futures	900.3	901.02	899.82	900.06	2069.0
2009-06-08 19:00:00	ES	Futures	900.06	901.5	900.06	901.02	1918.0
2009-06-08 20:00:00	ES	Futures	901.02	903.42	900.78	902.22	6566.0
2009-06-08 21:00:00	ES	Futures	902.22	903.66	901.5	902.94	3473.0
2009-06-08 22:00:00	ES	Futures	902.94	903.42	898.39	898.63	6932.0
2009-06-08 23:00:00	ES	Futures	898.87	899.11	896.71	897.43	6154.0
2009-06-08 00:00:00	NQ	Futures	1694.04	1695.18	1692.34	1692.91	70.0
2009-06-08 01:00:00	NQ	Futures	1693.19	1696.6	1690.63	1694.61	185.0
2009-06-08 02:00:00	NQ	Futures	1694.89	1695.75	1686.94	1691.48	810.0
2009-06-08 03:00:00	NQ	Futures	1692.34	1694.04	1682.96	1685.52	1519.0
2009-06-08 04:00:00	NQ	Futures	1685.52	1685.52	1679.55	1681.26	2076.0
2009-06-08 05:00:00	NQ	Futures	1680.97	1685.52	1678.13	1678.98	1274.0
2009-06-08 06:00:00	NQ	Futures	1678.98	1684.38	1678.41	1683.53	977.0
2009-06-08 07:00:00	NQ	Futures	1683.24	1684.67	1678.98	1683.24	1790.0
2009-06-08 08:00:00	NQ	Futures	1683.24	1684.67	1679.83	1683.53	2145.0
2009-06-08 09:00:00	NQ	Futures	1683.53	1688.36	1671.88	1673.02	37719.0
2009-06-08 10:00:00	NQ	Futures	1673.02	1677.56	1667.9	1674.15	40433.0
2009-06-08 11:00:00	NQ	Futures	1674.15	1677.28	1669.32	1671.03	23949.0
2009-06-08 12:00:00	NQ	Futures	1671.03	1674.15	1667.05	1670.74	18502.0
2009-06-08 13:00:00	NQ	Futures	1670.74	1679.27	1669.32	1675.86	21749.0
2009-06-08 14:00:00	NQ	Futures	1676.14	1678.13	1671.03	1676.71	21532.0
2009-06-08 15:00:00	NQ	Futures	1676.71	1705.12	1676.43	1691.77	73476.0
2009-06-08 16:00:00	NQ	Futures	1692.05	1698.02	1691.48	1696.31	9562.0
2009-06-08 17:00:00	NQ	Futures	1697.45	1698.02	1696.03	1696.88	106.0
2009-06-08 18:00:00	NQ	Futures	1696.88	1698.02	1696.31	1696.6	165.0
2009-06-08 19:00:00	NQ	Futures	1696.88	1700.01	1696.88	1699.16	311.0
2009-06-08 20:00:00	NQ	Futures	1699.44	1702.28	1698.3	1700.29	373.0
2009-06-08 21:00:00	NQ	Futures	1700.29	1702.85	1699.16	1702.0	226.0
2009-06-08 22:00:00	NQ	Futures	1702.0	1702.57	1694.89	1694.89	423.0
2009-06-08 23:00:00	NQ	Futures	1694.89	1695.75	1690.92	1691.77	624.0
2009-06-08 00:00:00	YM	Futures	8031.6	8035.3	8022.4	8026.1	132.0
2009-06-08 01:00:00	YM	Futures	8025.2	8044.5	8022.4	8039.9	189.0

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

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