PREVIEW / futures_1hour / 2009-06-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	884.11	884.36	883.87	884.11	1364.0
2009-06-16 01:00:00	ES	Futures	884.11	884.6	884.11	884.36	1432.0
2009-06-16 02:00:00	ES	Futures	884.11	887.25	884.11	886.53	5126.0
2009-06-16 03:00:00	ES	Futures	886.53	887.73	884.84	886.53	12067.0
2009-06-16 04:00:00	ES	Futures	886.53	887.01	884.36	886.77	9522.0
2009-06-16 05:00:00	ES	Futures	886.77	888.7	886.77	888.7	13981.0
2009-06-16 06:00:00	ES	Futures	888.7	889.18	887.73	888.7	9292.0
2009-06-16 07:00:00	ES	Futures	888.45	890.63	887.97	890.38	22186.0
2009-06-16 08:00:00	ES	Futures	890.63	892.07	888.7	890.14	51650.0
2009-06-16 09:00:00	ES	Futures	889.9	891.35	887.73	888.7	230448.0
2009-06-16 10:00:00	ES	Futures	888.94	891.35	886.77	889.42	226253.0
2009-06-16 11:00:00	ES	Futures	889.18	891.35	884.84	885.32	169995.0
2009-06-16 12:00:00	ES	Futures	885.32	886.28	878.33	880.01	246872.0
2009-06-16 13:00:00	ES	Futures	879.77	880.01	876.16	878.08	167775.0
2009-06-16 14:00:00	ES	Futures	878.08	879.29	874.47	878.57	252540.0
2009-06-16 15:00:00	ES	Futures	878.57	881.46	874.95	875.19	348044.0
2009-06-16 16:00:00	ES	Futures	875.43	876.4	874.71	875.43	90368.0
2009-06-16 17:00:00	ES	Futures	875.19	875.67	873.74	874.23	2745.0
2009-06-16 18:00:00	ES	Futures	874.47	875.43	873.98	874.71	2382.0
2009-06-16 19:00:00	ES	Futures	874.71	875.43	873.98	874.95	2715.0
2009-06-16 20:00:00	ES	Futures	874.71	879.53	874.71	878.57	8253.0
2009-06-16 21:00:00	ES	Futures	878.33	879.05	877.6	878.81	4095.0
2009-06-16 22:00:00	ES	Futures	878.81	879.05	876.88	877.12	3343.0
2009-06-16 23:00:00	ES	Futures	877.36	878.33	876.64	877.84	2350.0
2009-06-16 00:00:00	NQ	Futures	1654.18	1656.46	1654.18	1654.46	57.0
2009-06-16 01:00:00	NQ	Futures	1654.75	1656.74	1654.46	1656.17	320.0
2009-06-16 02:00:00	NQ	Futures	1656.17	1660.73	1655.03	1660.16	591.0
2009-06-16 03:00:00	NQ	Futures	1660.16	1661.3	1657.31	1660.73	1203.0
2009-06-16 04:00:00	NQ	Futures	1660.44	1661.3	1657.03	1660.44	1500.0
2009-06-16 05:00:00	NQ	Futures	1660.73	1664.43	1660.16	1663.29	1451.0
2009-06-16 06:00:00	NQ	Futures	1663.29	1665.29	1662.15	1665.0	1036.0
2009-06-16 07:00:00	NQ	Futures	1665.0	1668.7	1664.72	1668.42	2556.0
2009-06-16 08:00:00	NQ	Futures	1668.7	1670.13	1664.43	1666.43	5189.0
2009-06-16 09:00:00	NQ	Futures	1666.71	1670.41	1659.31	1666.14	40346.0
2009-06-16 10:00:00	NQ	Futures	1666.14	1672.41	1661.87	1669.84	39054.0
2009-06-16 11:00:00	NQ	Futures	1669.56	1672.69	1662.15	1662.15	25002.0
2009-06-16 12:00:00	NQ	Futures	1662.15	1665.57	1647.34	1651.62	36371.0
2009-06-16 13:00:00	NQ	Futures	1651.9	1654.46	1647.63	1651.05	28722.0
2009-06-16 14:00:00	NQ	Futures	1650.76	1651.9	1642.79	1651.62	33886.0
2009-06-16 15:00:00	NQ	Futures	1651.62	1654.18	1641.93	1642.5	47874.0
2009-06-16 16:00:00	NQ	Futures	1642.22	1646.2	1642.22	1645.07	9454.0
2009-06-16 17:00:00	NQ	Futures	1644.78	1644.78	1642.79	1643.36	162.0
2009-06-16 18:00:00	NQ	Futures	1643.64	1644.21	1642.5	1643.93	104.0
2009-06-16 19:00:00	NQ	Futures	1643.93	1644.21	1642.79	1643.36	184.0
2009-06-16 20:00:00	NQ	Futures	1643.93	1652.19	1643.93	1649.91	1092.0
2009-06-16 21:00:00	NQ	Futures	1650.76	1651.9	1649.62	1651.05	393.0
2009-06-16 22:00:00	NQ	Futures	1651.05	1651.62	1648.48	1648.48	182.0
2009-06-16 23:00:00	NQ	Futures	1648.48	1650.48	1647.91	1649.34	185.0
2009-06-16 00:00:00	YM	Futures	7891.8	7892.7	7888.1	7890.9	83.0
2009-06-16 01:00:00	YM	Futures	7892.7	7894.6	7889.9	7894.6	99.0

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

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