PREVIEW / futures_1hour / 2009-06-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	902.2	902.92	901.96	902.44	913.0
2009-06-15 01:00:00	ES	Futures	902.68	902.92	901.96	902.2	1283.0
2009-06-15 02:00:00	ES	Futures	902.44	902.44	899.55	899.79	8071.0
2009-06-15 03:00:00	ES	Futures	899.79	899.79	895.69	896.65	22916.0
2009-06-15 04:00:00	ES	Futures	896.41	897.62	895.69	897.14	9684.0
2009-06-15 05:00:00	ES	Futures	896.9	897.38	894.73	896.41	9718.0
2009-06-15 06:00:00	ES	Futures	896.41	898.34	896.41	896.9	7831.0
2009-06-15 07:00:00	ES	Futures	896.9	897.86	895.45	896.65	11330.0
2009-06-15 08:00:00	ES	Futures	896.41	899.07	895.45	897.86	27533.0
2009-06-15 09:00:00	ES	Futures	898.1	898.58	890.38	894.0	261139.0
2009-06-15 10:00:00	ES	Futures	894.0	894.48	885.8	887.73	313555.0
2009-06-15 11:00:00	ES	Futures	887.73	888.45	884.11	886.28	238855.0
2009-06-15 12:00:00	ES	Futures	886.04	887.01	884.11	886.53	125660.0
2009-06-15 13:00:00	ES	Futures	886.53	886.77	882.91	884.6	142404.0
2009-06-15 14:00:00	ES	Futures	884.6	886.53	882.91	884.36	138619.0
2009-06-15 15:00:00	ES	Futures	884.6	888.45	882.91	887.25	273615.0
2009-06-15 16:00:00	ES	Futures	887.25	888.21	885.56	886.77	90095.0
2009-06-15 17:00:00	ES	Futures	887.01	887.01	886.28	886.53	1261.0
2009-06-15 18:00:00	ES	Futures	886.53	887.01	886.53	886.53	1527.0
2009-06-15 19:00:00	ES	Futures	886.77	887.49	885.8	887.25	2149.0
2009-06-15 20:00:00	ES	Futures	887.49	887.49	885.56	885.56	3656.0
2009-06-15 21:00:00	ES	Futures	885.8	887.25	885.08	887.01	4312.0
2009-06-15 22:00:00	ES	Futures	887.25	887.49	886.04	886.53	2841.0
2009-06-15 23:00:00	ES	Futures	886.53	887.01	883.87	884.11	5453.0
2009-06-15 00:00:00	NQ	Futures	1682.66	1683.51	1682.09	1683.23	136.0
2009-06-15 01:00:00	NQ	Futures	1682.94	1683.8	1682.09	1682.09	71.0
2009-06-15 02:00:00	NQ	Futures	1682.66	1685.22	1680.38	1680.95	780.0
2009-06-15 03:00:00	NQ	Futures	1680.67	1680.67	1672.98	1673.83	1772.0
2009-06-15 04:00:00	NQ	Futures	1673.55	1676.39	1672.12	1674.4	1292.0
2009-06-15 05:00:00	NQ	Futures	1674.12	1675.25	1670.98	1674.69	1371.0
2009-06-15 06:00:00	NQ	Futures	1674.97	1678.1	1674.69	1675.54	755.0
2009-06-15 07:00:00	NQ	Futures	1674.97	1677.82	1673.26	1674.69	1225.0
2009-06-15 08:00:00	NQ	Futures	1674.4	1680.1	1673.55	1677.82	3040.0
2009-06-15 09:00:00	NQ	Futures	1677.82	1679.24	1662.15	1665.57	44750.0
2009-06-15 10:00:00	NQ	Futures	1665.57	1667.57	1646.77	1650.48	60512.0
2009-06-15 11:00:00	NQ	Futures	1650.48	1651.9	1644.5	1649.34	36081.0
2009-06-15 12:00:00	NQ	Futures	1649.05	1654.18	1646.77	1653.61	21942.0
2009-06-15 13:00:00	NQ	Futures	1653.32	1654.18	1644.5	1649.91	21103.0
2009-06-15 14:00:00	NQ	Futures	1649.62	1655.32	1647.34	1651.9	23143.0
2009-06-15 15:00:00	NQ	Futures	1651.9	1660.73	1648.77	1659.31	50210.0
2009-06-15 16:00:00	NQ	Futures	1659.31	1660.73	1654.75	1660.16	10887.0
2009-06-15 17:00:00	NQ	Futures	1660.16	1660.16	1658.17	1658.17	50.0
2009-06-15 18:00:00	NQ	Futures	1658.74	1659.59	1658.17	1658.45	155.0
2009-06-15 19:00:00	NQ	Futures	1658.45	1659.88	1657.03	1658.74	139.0
2009-06-15 20:00:00	NQ	Futures	1659.59	1660.44	1657.31	1658.45	502.0
2009-06-15 21:00:00	NQ	Futures	1658.45	1661.01	1657.6	1660.16	378.0
2009-06-15 22:00:00	NQ	Futures	1659.88	1661.01	1659.02	1659.88	140.0
2009-06-15 23:00:00	NQ	Futures	1659.88	1659.88	1653.61	1654.18	524.0
2009-06-15 00:00:00	YM	Futures	8037.0	8041.6	8035.1	8037.9	64.0
2009-06-15 01:00:00	YM	Futures	8037.9	8041.6	8034.2	8036.0	138.0

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

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