PREVIEW / futures_1hour / 2009-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-03.parquet
  size:    45 KB
  rows:    1,260

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-03 00:00:00	ES	Futures	903.66	906.06	902.94	904.62	5280.0
2009-06-03 01:00:00	ES	Futures	904.62	905.82	904.14	904.38	2703.0
2009-06-03 02:00:00	ES	Futures	904.62	906.53	904.38	906.3	5892.0
2009-06-03 03:00:00	ES	Futures	906.3	906.3	899.82	900.06	21678.0
2009-06-03 04:00:00	ES	Futures	900.06	901.26	898.15	898.39	19743.0
2009-06-03 05:00:00	ES	Futures	898.39	900.06	897.19	898.15	16092.0
2009-06-03 06:00:00	ES	Futures	898.15	899.59	897.43	898.63	8315.0
2009-06-03 07:00:00	ES	Futures	898.39	899.82	897.19	899.11	15336.0
2009-06-03 08:00:00	ES	Futures	899.11	900.54	895.51	896.23	42689.0
2009-06-03 09:00:00	ES	Futures	896.23	897.67	891.68	893.35	284843.0
2009-06-03 10:00:00	ES	Futures	893.12	893.59	889.52	893.35	266422.0
2009-06-03 11:00:00	ES	Futures	893.59	894.55	890.72	891.44	151272.0
2009-06-03 12:00:00	ES	Futures	891.44	892.16	887.84	888.56	152815.0
2009-06-03 13:00:00	ES	Futures	888.32	888.56	884.73	886.17	230377.0
2009-06-03 14:00:00	ES	Futures	886.17	889.04	884.97	888.08	197867.0
2009-06-03 15:00:00	ES	Futures	888.08	893.35	884.25	893.12	384136.0
2009-06-03 16:00:00	ES	Futures	893.12	893.83	891.2	892.16	105211.0
2009-06-03 17:00:00	ES	Futures	892.16	892.4	891.2	891.92	2152.0
2009-06-03 18:00:00	ES	Futures	891.92	892.16	891.2	891.68	2266.0
2009-06-03 19:00:00	ES	Futures	891.68	891.68	890.96	891.2	1760.0
2009-06-03 20:00:00	ES	Futures	890.96	892.88	890.96	892.88	3327.0
2009-06-03 21:00:00	ES	Futures	892.64	894.79	892.64	893.59	4396.0
2009-06-03 22:00:00	ES	Futures	893.83	895.03	892.64	894.07	3329.0
2009-06-03 23:00:00	ES	Futures	894.07	894.55	892.4	892.4	2925.0
2009-06-03 00:00:00	NQ	Futures	1682.11	1686.37	1681.82	1683.53	346.0
2009-06-03 01:00:00	NQ	Futures	1683.53	1686.09	1682.68	1682.68	106.0
2009-06-03 02:00:00	NQ	Futures	1683.53	1687.22	1683.53	1686.37	170.0
2009-06-03 03:00:00	NQ	Futures	1685.8	1686.09	1675.86	1676.43	1221.0
2009-06-03 04:00:00	NQ	Futures	1676.71	1678.98	1674.15	1674.44	1107.0
2009-06-03 05:00:00	NQ	Futures	1674.44	1677.28	1671.59	1674.15	1242.0
2009-06-03 06:00:00	NQ	Futures	1674.15	1675.86	1672.45	1673.02	1188.0
2009-06-03 07:00:00	NQ	Futures	1672.73	1676.43	1671.59	1675.0	1142.0
2009-06-03 08:00:00	NQ	Futures	1675.29	1677.56	1668.47	1670.74	3854.0
2009-06-03 09:00:00	NQ	Futures	1670.46	1676.43	1665.91	1668.75	39072.0
2009-06-03 10:00:00	NQ	Futures	1668.75	1674.72	1663.07	1674.72	37318.0
2009-06-03 11:00:00	NQ	Futures	1674.72	1678.7	1669.04	1673.3	23760.0
2009-06-03 12:00:00	NQ	Futures	1673.02	1675.29	1664.21	1665.06	19404.0
2009-06-03 13:00:00	NQ	Futures	1665.06	1666.76	1657.96	1663.07	28678.0
2009-06-03 14:00:00	NQ	Futures	1662.79	1669.32	1659.94	1666.76	25930.0
2009-06-03 15:00:00	NQ	Futures	1667.05	1678.13	1661.93	1678.13	46378.0
2009-06-03 16:00:00	NQ	Futures	1678.13	1679.27	1675.29	1677.85	9501.0
2009-06-03 17:00:00	NQ	Futures	1677.85	1677.85	1676.43	1676.43	93.0
2009-06-03 18:00:00	NQ	Futures	1676.43	1677.28	1675.86	1677.28	338.0
2009-06-03 19:00:00	NQ	Futures	1676.71	1677.28	1676.14	1677.28	78.0
2009-06-03 20:00:00	NQ	Futures	1676.43	1679.55	1676.43	1679.27	214.0
2009-06-03 21:00:00	NQ	Futures	1679.55	1681.54	1678.98	1680.12	364.0
2009-06-03 22:00:00	NQ	Futures	1680.12	1681.82	1678.98	1680.69	122.0
2009-06-03 23:00:00	NQ	Futures	1680.97	1680.97	1677.28	1677.28	228.0
2009-06-03 00:00:00	YM	Futures	8015.1	8031.6	8012.3	8023.3	262.0
2009-06-03 01:00:00	YM	Futures	8023.3	8031.6	8017.8	8019.7	155.0

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

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