PREVIEW / futures_1hour / 2009-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-30.parquet
  size:    43 KB
  rows:    1,268

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-04-30 00:00:00	ES	Futures	837.76	838.0	834.88	837.52	5945.0
2009-04-30 01:00:00	ES	Futures	837.76	838.0	837.28	837.76	2479.0
2009-04-30 02:00:00	ES	Futures	837.76	840.16	836.32	840.16	12666.0
2009-04-30 03:00:00	ES	Futures	839.92	847.82	839.68	845.91	40363.0
2009-04-30 04:00:00	ES	Futures	846.15	846.87	843.99	846.39	16264.0
2009-04-30 05:00:00	ES	Futures	846.39	847.82	845.43	846.39	13901.0
2009-04-30 06:00:00	ES	Futures	846.39	850.22	846.15	847.35	28821.0
2009-04-30 07:00:00	ES	Futures	847.35	848.06	845.19	846.15	24712.0
2009-04-30 08:00:00	ES	Futures	846.15	846.63	843.75	845.19	41231.0
2009-04-30 09:00:00	ES	Futures	844.95	846.39	840.4	843.75	304222.0
2009-04-30 10:00:00	ES	Futures	843.75	847.82	843.27	847.11	308322.0
2009-04-30 11:00:00	ES	Futures	847.35	849.02	841.83	842.07	287458.0
2009-04-30 12:00:00	ES	Futures	842.07	843.27	833.93	835.84	303117.0
2009-04-30 13:00:00	ES	Futures	835.84	837.04	830.81	835.6	275571.0
2009-04-30 14:00:00	ES	Futures	835.84	838.96	833.93	837.28	220432.0
2009-04-30 15:00:00	ES	Futures	837.52	838.0	828.65	833.45	594571.0
2009-04-30 16:00:00	ES	Futures	833.45	835.12	828.89	830.57	198450.0
2009-04-30 17:00:00	ES	Futures	830.33	830.57	828.17	828.41	5538.0
2009-04-30 18:00:00	ES	Futures	828.65	831.77	828.17	831.53	5164.0
2009-04-30 19:00:00	ES	Futures	831.53	832.01	831.29	831.53	2331.0
2009-04-30 20:00:00	ES	Futures	831.53	833.45	831.53	832.97	4564.0
2009-04-30 21:00:00	ES	Futures	832.97	833.93	831.29	832.01	2876.0
2009-04-30 22:00:00	ES	Futures	832.01	833.45	831.77	832.73	1458.0
2009-04-30 23:00:00	ES	Futures	832.73	833.21	832.01	833.21	1468.0
2009-04-30 00:00:00	NQ	Futures	1575.27	1575.27	1570.73	1574.42	215.0
2009-04-30 01:00:00	NQ	Futures	1574.7	1575.27	1573.28	1574.13	161.0
2009-04-30 02:00:00	NQ	Futures	1573.0	1578.68	1572.15	1578.68	590.0
2009-04-30 03:00:00	NQ	Futures	1578.4	1596.01	1578.11	1592.89	4001.0
2009-04-30 04:00:00	NQ	Futures	1592.89	1594.31	1589.48	1593.74	1490.0
2009-04-30 05:00:00	NQ	Futures	1594.02	1594.88	1591.18	1591.75	1124.0
2009-04-30 06:00:00	NQ	Futures	1591.75	1598.0	1591.75	1595.16	3132.0
2009-04-30 07:00:00	NQ	Futures	1595.16	1596.3	1591.75	1593.17	2313.0
2009-04-30 08:00:00	NQ	Futures	1593.17	1593.17	1586.35	1588.91	4793.0
2009-04-30 09:00:00	NQ	Futures	1588.91	1599.71	1582.94	1598.0	48761.0
2009-04-30 10:00:00	NQ	Futures	1597.72	1608.8	1597.43	1606.53	45668.0
2009-04-30 11:00:00	NQ	Futures	1606.81	1610.79	1601.13	1601.98	33823.0
2009-04-30 12:00:00	NQ	Futures	1601.98	1603.69	1586.64	1590.33	42290.0
2009-04-30 13:00:00	NQ	Futures	1590.33	1593.74	1574.42	1583.8	49649.0
2009-04-30 14:00:00	NQ	Futures	1583.51	1590.61	1579.82	1585.78	28806.0
2009-04-30 15:00:00	NQ	Futures	1585.5	1586.64	1571.01	1582.37	62622.0
2009-04-30 16:00:00	NQ	Futures	1582.37	1586.64	1576.69	1580.1	18674.0
2009-04-30 17:00:00	NQ	Futures	1579.82	1580.1	1575.56	1575.84	502.0
2009-04-30 18:00:00	NQ	Futures	1576.12	1581.81	1575.84	1581.24	308.0
2009-04-30 19:00:00	NQ	Futures	1580.67	1582.09	1579.82	1580.39	122.0
2009-04-30 20:00:00	NQ	Futures	1580.67	1583.51	1580.67	1583.23	371.0
2009-04-30 21:00:00	NQ	Futures	1583.23	1584.36	1580.1	1580.95	222.0
2009-04-30 22:00:00	NQ	Futures	1581.81	1584.08	1581.52	1582.37	83.0
2009-04-30 23:00:00	NQ	Futures	1581.81	1583.8	1581.52	1583.23	98.0
2009-04-30 00:00:00	YM	Futures	7494.9	7498.6	7475.7	7496.8	491.0
2009-04-30 01:00:00	YM	Futures	7498.6	7506.0	7494.0	7498.6	311.0

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

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