PREVIEW / futures_1hour / 2009-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-25.parquet
  size:    28 KB
  rows:    770

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-05-25 00:00:00	ES	Futures	847.11	850.46	846.63	849.26	3002.0
2009-05-25 01:00:00	ES	Futures	849.26	852.14	849.26	850.94	2199.0
2009-05-25 02:00:00	ES	Futures	850.94	852.86	850.94	852.38	2213.0
2009-05-25 03:00:00	ES	Futures	852.38	852.86	843.99	844.71	8525.0
2009-05-25 04:00:00	ES	Futures	844.95	848.54	843.27	847.11	6584.0
2009-05-25 05:00:00	ES	Futures	847.11	848.78	845.91	848.3	2961.0
2009-05-25 06:00:00	ES	Futures	848.3	849.98	847.58	848.54	2102.0
2009-05-25 07:00:00	ES	Futures	848.54	848.78	846.39	847.11	1731.0
2009-05-25 08:00:00	ES	Futures	846.87	848.54	845.91	848.3	2418.0
2009-05-25 09:00:00	ES	Futures	848.3	850.22	847.11	850.22	4654.0
2009-05-25 10:00:00	ES	Futures	850.22	851.9	849.98	850.46	6480.0
2009-05-25 11:00:00	ES	Futures	850.46	853.58	849.74	853.34	6103.0
2009-05-25 18:00:00	ES	Futures	852.14	852.14	849.26	849.74	3127.0
2009-05-25 19:00:00	ES	Futures	849.5	850.94	848.78	850.94	1945.0
2009-05-25 20:00:00	ES	Futures	850.94	850.94	845.91	847.11	4848.0
2009-05-25 21:00:00	ES	Futures	847.11	848.78	846.63	848.3	3397.0
2009-05-25 22:00:00	ES	Futures	848.06	849.02	847.82	848.3	1558.0
2009-05-25 23:00:00	ES	Futures	848.06	848.54	846.87	847.11	1490.0
2009-05-25 00:00:00	NQ	Futures	1543.45	1548.28	1542.31	1546.86	93.0
2009-05-25 01:00:00	NQ	Futures	1546.86	1551.69	1546.86	1551.12	263.0
2009-05-25 02:00:00	NQ	Futures	1550.27	1553.68	1548.85	1551.69	175.0
2009-05-25 03:00:00	NQ	Futures	1552.26	1553.39	1538.33	1538.9	792.0
2009-05-25 04:00:00	NQ	Futures	1538.9	1545.44	1536.34	1541.74	543.0
2009-05-25 05:00:00	NQ	Futures	1542.31	1544.58	1539.75	1543.45	409.0
2009-05-25 06:00:00	NQ	Futures	1543.73	1546.0	1542.6	1542.88	501.0
2009-05-25 07:00:00	NQ	Futures	1542.6	1542.88	1539.19	1540.04	400.0
2009-05-25 08:00:00	NQ	Futures	1539.19	1543.73	1537.76	1542.6	413.0
2009-05-25 09:00:00	NQ	Futures	1543.16	1545.44	1540.04	1544.02	985.0
2009-05-25 10:00:00	NQ	Futures	1544.02	1546.86	1542.6	1542.6	1855.0
2009-05-25 11:00:00	NQ	Futures	1542.88	1549.7	1541.17	1549.7	1341.0
2009-05-25 18:00:00	NQ	Futures	1548.56	1548.56	1542.03	1542.31	227.0
2009-05-25 19:00:00	NQ	Futures	1542.31	1543.45	1540.61	1543.45	609.0
2009-05-25 20:00:00	NQ	Futures	1543.45	1543.45	1535.21	1537.76	486.0
2009-05-25 21:00:00	NQ	Futures	1537.48	1540.04	1536.06	1538.9	143.0
2009-05-25 22:00:00	NQ	Futures	1538.9	1540.61	1538.62	1538.9	114.0
2009-05-25 23:00:00	NQ	Futures	1538.33	1539.47	1536.91	1536.91	64.0
2009-05-25 00:00:00	YM	Futures	7581.3	7608.0	7581.3	7597.9	487.0
2009-05-25 01:00:00	YM	Futures	7598.8	7619.9	7598.8	7610.7	277.0
2009-05-25 02:00:00	YM	Futures	7613.5	7631.0	7610.7	7624.5	324.0
2009-05-25 03:00:00	YM	Futures	7624.5	7628.2	7554.7	7560.2	1487.0
2009-05-25 04:00:00	YM	Futures	7562.0	7595.1	7549.2	7578.6	583.0
2009-05-25 05:00:00	YM	Futures	7578.6	7595.1	7568.5	7591.4	177.0
2009-05-25 06:00:00	YM	Futures	7594.2	7603.4	7584.1	7589.6	229.0
2009-05-25 07:00:00	YM	Futures	7587.8	7590.5	7575.8	7577.7	126.0
2009-05-25 08:00:00	YM	Futures	7577.7	7597.9	7571.2	7591.4	310.0
2009-05-25 09:00:00	YM	Futures	7594.2	7608.9	7582.2	7608.9	452.0
2009-05-25 10:00:00	YM	Futures	7608.0	7619.9	7604.3	7605.2	567.0
2009-05-25 11:00:00	YM	Futures	7606.1	7637.4	7602.5	7631.0	434.0
2009-05-25 18:00:00	YM	Futures	7625.4	7626.4	7598.8	7599.7	201.0
2009-05-25 19:00:00	YM	Futures	7601.5	7614.4	7594.2	7613.5	131.0

> showing 50 of 770 rows — these rows as CSV

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