PREVIEW / futures_1hour / 2009-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-12.parquet
  size:    35 KB
  rows:    977

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-12 00:00:00	ES	Futures	904.14	904.62	903.42	904.38	1147.0
2009-06-12 01:00:00	ES	Futures	904.62	905.1	903.66	904.62	1540.0
2009-06-12 02:00:00	ES	Futures	904.62	905.1	902.22	902.46	5671.0
2009-06-12 03:00:00	ES	Futures	902.7	904.38	900.54	903.42	8274.0
2009-06-12 04:00:00	ES	Futures	903.42	905.1	903.42	904.62	3148.0
2009-06-12 05:00:00	ES	Futures	904.38	904.62	901.5	901.74	4858.0
2009-06-12 06:00:00	ES	Futures	901.74	903.42	901.74	903.18	3590.0
2009-06-12 07:00:00	ES	Futures	903.42	903.42	898.63	900.78	8868.0
2009-06-12 08:00:00	ES	Futures	900.78	901.02	897.19	898.87	9940.0
2009-06-12 09:00:00	ES	Futures	898.87	901.5	897.91	898.87	59701.0
2009-06-12 10:00:00	ES	Futures	898.63	904.38	896.47	902.7	54355.0
2009-06-12 11:00:00	ES	Futures	902.7	903.18	899.35	900.3	25723.0
2009-06-12 12:00:00	ES	Futures	900.06	902.22	899.35	901.74	26737.0
2009-06-12 13:00:00	ES	Futures	901.74	903.42	900.3	902.94	21530.0
2009-06-12 14:00:00	ES	Futures	902.94	907.25	901.02	905.58	39331.0
2009-06-12 15:00:00	ES	Futures	905.34	907.01	902.22	907.01	45367.0
2009-06-12 16:00:00	ES	Futures	907.01	907.49	904.86	905.34	10480.0
2009-06-12 00:00:00	NQ	Futures	1696.31	1698.59	1695.75	1698.3	48.0
2009-06-12 01:00:00	NQ	Futures	1698.3	1699.16	1696.03	1698.02	98.0
2009-06-12 02:00:00	NQ	Futures	1698.02	1699.44	1696.03	1696.03	164.0
2009-06-12 03:00:00	NQ	Futures	1696.6	1700.29	1692.91	1698.3	392.0
2009-06-12 04:00:00	NQ	Futures	1698.02	1701.43	1698.02	1701.15	244.0
2009-06-12 05:00:00	NQ	Futures	1700.01	1702.0	1695.18	1695.75	393.0
2009-06-12 06:00:00	NQ	Futures	1696.6	1698.87	1696.31	1698.59	225.0
2009-06-12 07:00:00	NQ	Futures	1698.87	1698.87	1689.5	1692.62	736.0
2009-06-12 08:00:00	NQ	Futures	1692.05	1692.05	1687.79	1690.92	848.0
2009-06-12 09:00:00	NQ	Futures	1691.2	1694.33	1676.99	1678.98	8082.0
2009-06-12 10:00:00	NQ	Futures	1678.7	1687.22	1670.46	1680.97	12551.0
2009-06-12 11:00:00	NQ	Futures	1680.97	1682.11	1673.3	1674.72	5893.0
2009-06-12 12:00:00	NQ	Futures	1675.0	1680.69	1674.15	1680.12	4131.0
2009-06-12 13:00:00	NQ	Futures	1680.12	1681.82	1675.29	1680.4	5554.0
2009-06-12 14:00:00	NQ	Futures	1680.4	1692.05	1677.85	1688.93	8301.0
2009-06-12 15:00:00	NQ	Futures	1688.64	1692.91	1682.96	1692.62	8886.0
2009-06-12 16:00:00	NQ	Futures	1692.34	1693.19	1688.36	1689.5	2067.0
2009-06-12 00:00:00	YM	Futures	8051.8	8061.9	8049.9	8058.2	108.0
2009-06-12 01:00:00	YM	Futures	8061.0	8064.7	8054.5	8059.1	324.0
2009-06-12 02:00:00	YM	Futures	8064.7	8066.5	8040.7	8042.5	557.0
2009-06-12 03:00:00	YM	Futures	8044.4	8056.4	8026.8	8047.1	1118.0
2009-06-12 04:00:00	YM	Futures	8049.0	8061.9	8048.1	8057.3	391.0
2009-06-12 05:00:00	YM	Futures	8055.5	8056.4	8032.3	8036.0	512.0
2009-06-12 06:00:00	YM	Futures	8037.0	8049.0	8035.1	8046.2	343.0
2009-06-12 07:00:00	YM	Futures	8049.0	8050.8	8012.0	8031.4	1056.0
2009-06-12 08:00:00	YM	Futures	8030.5	8031.4	7998.1	8009.2	2928.0
2009-06-12 09:00:00	YM	Futures	8009.2	8046.2	8008.3	8024.0	10964.0
2009-06-12 10:00:00	YM	Futures	8024.0	8072.1	8009.2	8058.2	19879.0
2009-06-12 11:00:00	YM	Futures	8059.1	8064.7	8033.3	8043.4	7920.0
2009-06-12 12:00:00	YM	Futures	8042.5	8059.1	8037.0	8055.5	6589.0
2009-06-12 13:00:00	YM	Futures	8054.5	8068.4	8040.7	8060.1	8230.0
2009-06-12 14:00:00	YM	Futures	8061.0	8097.1	8038.8	8078.6	14073.0
2009-06-12 15:00:00	YM	Futures	8080.4	8097.1	8047.1	8094.3	11598.0

> showing 50 of 977 rows — these rows as CSV

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