PREVIEW / futures_1hour / 2009-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-08.parquet
  size:    37 KB
  rows:    1,017

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-08 00:00:00	ES	Futures	876.1	877.06	875.38	876.82	2981.0
2009-05-08 01:00:00	ES	Futures	876.58	877.06	875.62	876.82	2331.0
2009-05-08 02:00:00	ES	Futures	876.82	877.06	875.38	876.1	6973.0
2009-05-08 03:00:00	ES	Futures	876.1	878.98	873.7	877.06	20763.0
2009-05-08 04:00:00	ES	Futures	877.06	878.02	873.23	877.06	15882.0
2009-05-08 05:00:00	ES	Futures	877.06	879.7	876.58	878.5	11454.0
2009-05-08 06:00:00	ES	Futures	878.26	881.37	877.78	880.65	19309.0
2009-05-08 07:00:00	ES	Futures	880.41	883.53	879.94	881.61	30703.0
2009-05-08 08:00:00	ES	Futures	881.37	884.25	875.86	879.22	120841.0
2009-05-08 09:00:00	ES	Futures	878.98	885.45	876.82	881.37	321292.0
2009-05-08 10:00:00	ES	Futures	881.61	882.09	872.03	873.7	477278.0
2009-05-08 11:00:00	ES	Futures	873.7	880.41	873.47	880.41	222406.0
2009-05-08 12:00:00	ES	Futures	880.17	884.73	879.22	884.25	241667.0
2009-05-08 13:00:00	ES	Futures	884.25	885.21	880.41	881.13	189388.0
2009-05-08 14:00:00	ES	Futures	881.13	889.28	880.89	887.36	277384.0
2009-05-08 15:00:00	ES	Futures	887.12	888.32	882.33	887.6	489125.0
2009-05-08 16:00:00	ES	Futures	887.12	888.08	885.69	885.93	119666.0
2009-05-08 00:00:00	NQ	Futures	1590.61	1592.6	1588.91	1591.47	194.0
2009-05-08 01:00:00	NQ	Futures	1592.04	1592.04	1589.76	1591.18	58.0
2009-05-08 02:00:00	NQ	Futures	1591.75	1595.16	1590.05	1593.46	813.0
2009-05-08 03:00:00	NQ	Futures	1593.46	1597.72	1588.63	1594.59	1616.0
2009-05-08 04:00:00	NQ	Futures	1594.31	1596.87	1584.36	1590.61	1877.0
2009-05-08 05:00:00	NQ	Futures	1590.9	1596.3	1590.33	1593.17	1256.0
2009-05-08 06:00:00	NQ	Futures	1593.74	1597.15	1591.47	1596.01	1087.0
2009-05-08 07:00:00	NQ	Futures	1596.01	1600.84	1595.45	1599.99	2906.0
2009-05-08 08:00:00	NQ	Futures	1599.99	1602.55	1592.6	1596.3	13466.0
2009-05-08 09:00:00	NQ	Futures	1596.3	1602.83	1583.8	1592.6	55326.0
2009-05-08 10:00:00	NQ	Futures	1592.32	1593.17	1563.62	1567.32	86094.0
2009-05-08 11:00:00	NQ	Futures	1567.03	1577.26	1567.03	1575.56	33161.0
2009-05-08 12:00:00	NQ	Futures	1575.27	1586.64	1572.43	1584.93	37799.0
2009-05-08 13:00:00	NQ	Futures	1584.93	1586.92	1574.42	1575.84	31843.0
2009-05-08 14:00:00	NQ	Futures	1575.84	1593.17	1575.56	1590.61	41420.0
2009-05-08 15:00:00	NQ	Futures	1590.61	1592.32	1578.4	1581.52	53471.0
2009-05-08 16:00:00	NQ	Futures	1581.52	1582.37	1577.54	1577.54	10676.0
2009-05-08 00:00:00	YM	Futures	7759.6	7769.7	7751.3	7764.2	234.0
2009-05-08 01:00:00	YM	Futures	7762.4	7766.0	7755.9	7762.4	237.0
2009-05-08 02:00:00	YM	Futures	7763.3	7765.1	7754.1	7761.4	413.0
2009-05-08 03:00:00	YM	Futures	7761.4	7782.6	7741.2	7763.3	1593.0
2009-05-08 04:00:00	YM	Futures	7763.3	7774.3	7734.8	7762.4	1409.0
2009-05-08 05:00:00	YM	Futures	7765.1	7787.2	7762.4	7776.1	908.0
2009-05-08 06:00:00	YM	Futures	7775.2	7799.1	7771.6	7793.6	1607.0
2009-05-08 07:00:00	YM	Futures	7794.5	7814.7	7789.9	7808.3	2413.0
2009-05-08 08:00:00	YM	Futures	7806.5	7820.3	7765.1	7785.3	7504.0
2009-05-08 09:00:00	YM	Futures	7786.3	7823.0	7768.8	7801.0	19109.0
2009-05-08 10:00:00	YM	Futures	7801.0	7807.4	7731.1	7748.6	32060.0
2009-05-08 11:00:00	YM	Futures	7747.7	7796.4	7747.7	7796.4	17060.0
2009-05-08 12:00:00	YM	Futures	7796.4	7820.3	7785.3	7816.6	17433.0
2009-05-08 13:00:00	YM	Futures	7815.7	7820.3	7785.3	7789.0	15936.0
2009-05-08 14:00:00	YM	Futures	7789.9	7858.9	7789.9	7840.5	20087.0
2009-05-08 15:00:00	YM	Futures	7841.4	7848.7	7791.8	7836.8	24860.0

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

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