PREVIEW / futures_1hour / 2009-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-05.parquet
  size:    37 KB
  rows:    999

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-05 00:00:00	ES	Futures	902.7	902.94	901.5	902.22	2189.0
2009-06-05 01:00:00	ES	Futures	902.46	902.7	901.98	902.46	1159.0
2009-06-05 02:00:00	ES	Futures	902.7	904.38	902.46	902.94	6262.0
2009-06-05 03:00:00	ES	Futures	902.94	906.3	902.94	905.58	19446.0
2009-06-05 04:00:00	ES	Futures	905.82	906.53	903.9	904.62	7804.0
2009-06-05 05:00:00	ES	Futures	904.38	906.06	903.66	905.1	7723.0
2009-06-05 06:00:00	ES	Futures	904.86	905.82	903.66	905.58	6910.0
2009-06-05 07:00:00	ES	Futures	905.82	907.73	905.34	906.77	15420.0
2009-06-05 08:00:00	ES	Futures	906.53	917.8	905.34	912.53	192121.0
2009-06-05 09:00:00	ES	Futures	912.77	915.88	900.54	902.94	436126.0
2009-06-05 10:00:00	ES	Futures	902.94	905.34	894.55	904.62	529090.0
2009-06-05 11:00:00	ES	Futures	904.62	907.73	901.74	904.86	245155.0
2009-06-05 12:00:00	ES	Futures	904.86	906.77	902.7	906.3	123778.0
2009-06-05 13:00:00	ES	Futures	906.3	906.53	901.74	902.7	111373.0
2009-06-05 14:00:00	ES	Futures	902.94	903.42	895.75	899.82	252791.0
2009-06-05 15:00:00	ES	Futures	899.82	904.14	898.15	901.5	298709.0
2009-06-05 16:00:00	ES	Futures	901.5	902.22	900.3	901.5	75915.0
2009-06-05 00:00:00	NQ	Futures	1698.3	1698.59	1696.88	1697.74	98.0
2009-06-05 01:00:00	NQ	Futures	1697.74	1698.59	1697.45	1698.02	101.0
2009-06-05 02:00:00	NQ	Futures	1698.59	1701.15	1698.3	1698.59	416.0
2009-06-05 03:00:00	NQ	Futures	1699.44	1701.71	1698.02	1699.16	1419.0
2009-06-05 04:00:00	NQ	Futures	1699.16	1702.0	1697.45	1698.59	807.0
2009-06-05 05:00:00	NQ	Futures	1698.87	1702.0	1697.17	1700.58	864.0
2009-06-05 06:00:00	NQ	Futures	1700.58	1702.28	1698.87	1701.15	656.0
2009-06-05 07:00:00	NQ	Futures	1701.43	1703.99	1699.72	1702.28	2064.0
2009-06-05 08:00:00	NQ	Futures	1702.28	1719.61	1700.29	1709.95	15419.0
2009-06-05 09:00:00	NQ	Futures	1710.24	1715.07	1687.22	1693.47	71092.0
2009-06-05 10:00:00	NQ	Futures	1693.47	1698.87	1680.4	1695.75	57968.0
2009-06-05 11:00:00	NQ	Futures	1695.75	1702.28	1690.63	1696.6	27337.0
2009-06-05 12:00:00	NQ	Futures	1696.6	1703.13	1694.04	1702.28	19382.0
2009-06-05 13:00:00	NQ	Futures	1702.0	1702.57	1695.75	1696.88	16325.0
2009-06-05 14:00:00	NQ	Futures	1696.6	1697.74	1684.38	1690.63	28692.0
2009-06-05 15:00:00	NQ	Futures	1690.92	1701.15	1688.36	1697.45	37951.0
2009-06-05 16:00:00	NQ	Futures	1697.45	1700.86	1694.33	1698.87	6621.0
2009-06-05 00:00:00	YM	Futures	8027.9	8028.9	8020.6	8025.2	146.0
2009-06-05 01:00:00	YM	Futures	8025.2	8029.8	8021.5	8027.9	120.0
2009-06-05 02:00:00	YM	Futures	8030.7	8044.5	8030.7	8035.3	368.0
2009-06-05 03:00:00	YM	Futures	8036.2	8065.6	8036.2	8053.7	1450.0
2009-06-05 04:00:00	YM	Futures	8056.4	8064.7	8044.5	8048.2	684.0
2009-06-05 05:00:00	YM	Futures	8046.3	8059.2	8040.8	8050.9	466.0
2009-06-05 06:00:00	YM	Futures	8051.8	8058.3	8039.0	8053.7	683.0
2009-06-05 07:00:00	YM	Futures	8053.7	8077.6	8052.8	8066.5	1187.0
2009-06-05 08:00:00	YM	Futures	8065.6	8178.6	8050.0	8111.6	9793.0
2009-06-05 09:00:00	YM	Futures	8112.5	8134.5	8034.4	8052.8	31028.0
2009-06-05 10:00:00	YM	Futures	8052.8	8083.1	7986.6	8077.6	36968.0
2009-06-05 11:00:00	YM	Futures	8078.5	8100.5	8050.9	8076.6	16143.0
2009-06-05 12:00:00	YM	Futures	8076.6	8096.9	8058.3	8092.3	9943.0
2009-06-05 13:00:00	YM	Futures	8092.3	8093.2	8062.9	8069.3	8036.0
2009-06-05 14:00:00	YM	Futures	8068.4	8071.1	8016.0	8050.9	18245.0
2009-06-05 15:00:00	YM	Futures	8050.9	8086.8	8032.5	8051.8	21764.0

> showing 50 of 999 rows — these rows as CSV

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