PREVIEW / futures_1hour / 2013-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-17.parquet
  size:    51 KB
  rows:    1,559

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
2013-10-17 00:00:00	ES	Futures	1767.03	1767.54	1765.74	1765.74	3606.0
2013-10-17 01:00:00	ES	Futures	1765.74	1766.0	1764.71	1764.97	7374.0
2013-10-17 02:00:00	ES	Futures	1764.97	1766.77	1764.71	1764.71	9446.0
2013-10-17 03:00:00	ES	Futures	1764.71	1766.77	1762.64	1762.64	44408.0
2013-10-17 04:00:00	ES	Futures	1762.9	1764.45	1760.58	1763.93	31227.0
2013-10-17 05:00:00	ES	Futures	1763.93	1764.71	1762.64	1763.68	10967.0
2013-10-17 06:00:00	ES	Futures	1763.93	1766.77	1763.42	1766.51	17626.0
2013-10-17 07:00:00	ES	Futures	1766.51	1767.03	1765.22	1766.51	21596.0
2013-10-17 08:00:00	ES	Futures	1766.25	1766.77	1762.39	1762.64	54906.0
2013-10-17 09:00:00	ES	Futures	1762.39	1767.8	1760.84	1765.74	217038.0
2013-10-17 10:00:00	ES	Futures	1766.25	1771.41	1765.74	1770.38	243758.0
2013-10-17 11:00:00	ES	Futures	1770.38	1776.83	1770.12	1775.54	248916.0
2013-10-17 12:00:00	ES	Futures	1775.54	1779.67	1774.77	1779.67	145627.0
2013-10-17 13:00:00	ES	Futures	1779.67	1779.67	1776.06	1776.06	118375.0
2013-10-17 14:00:00	ES	Futures	1776.06	1778.12	1775.54	1777.86	98411.0
2013-10-17 15:00:00	ES	Futures	1777.61	1783.54	1776.57	1782.25	257282.0
2013-10-17 16:00:00	ES	Futures	1782.25	1783.8	1781.99	1782.76	83367.0
2013-10-17 17:00:00	ES	Futures	1783.02	1783.54	1782.76	1783.28	1781.0
2013-10-17 18:00:00	ES	Futures	1782.51	1785.09	1781.99	1784.31	8650.0
2013-10-17 19:00:00	ES	Futures	1784.31	1788.7	1783.8	1786.63	13581.0
2013-10-17 20:00:00	ES	Futures	1786.63	1786.89	1785.34	1786.12	4301.0
2013-10-17 21:00:00	ES	Futures	1786.38	1786.38	1785.6	1785.86	4056.0
2013-10-17 22:00:00	ES	Futures	1786.12	1786.63	1784.31	1785.86	4487.0
2013-10-17 23:00:00	ES	Futures	1786.12	1786.38	1784.57	1785.09	2249.0
2013-10-17 00:00:00	NQ	Futures	3793.05	3793.34	3790.14	3790.73	244.0
2013-10-17 01:00:00	NQ	Futures	3790.73	3790.73	3788.4	3789.27	1440.0
2013-10-17 02:00:00	NQ	Futures	3788.98	3792.76	3788.98	3789.85	1514.0
2013-10-17 03:00:00	NQ	Futures	3789.85	3795.08	3787.24	3787.24	4430.0
2013-10-17 04:00:00	NQ	Futures	3787.24	3790.73	3782.88	3788.98	3577.0
2013-10-17 05:00:00	NQ	Futures	3788.98	3791.02	3786.37	3788.69	1729.0
2013-10-17 06:00:00	NQ	Futures	3788.69	3793.92	3788.11	3793.34	2414.0
2013-10-17 07:00:00	NQ	Futures	3793.63	3794.5	3791.31	3792.76	2249.0
2013-10-17 08:00:00	NQ	Futures	3792.76	3793.34	3785.21	3785.5	4839.0
2013-10-17 09:00:00	NQ	Futures	3785.5	3798.57	3781.72	3793.05	29825.0
2013-10-17 10:00:00	NQ	Futures	3793.34	3803.79	3791.02	3802.05	27105.0
2013-10-17 11:00:00	NQ	Futures	3802.34	3816.86	3802.05	3815.12	28205.0
2013-10-17 12:00:00	NQ	Futures	3814.83	3822.96	3813.67	3821.51	18849.0
2013-10-17 13:00:00	NQ	Futures	3821.8	3822.09	3813.38	3813.67	14343.0
2013-10-17 14:00:00	NQ	Futures	3813.38	3817.44	3811.64	3816.57	12562.0
2013-10-17 15:00:00	NQ	Futures	3816.57	3827.61	3814.54	3824.71	33570.0
2013-10-17 16:00:00	NQ	Futures	3825.0	3841.55	3822.38	3841.26	16875.0
2013-10-17 17:00:00	NQ	Futures	3841.26	3845.91	3841.26	3844.46	843.0
2013-10-17 18:00:00	NQ	Futures	3842.42	3847.36	3841.55	3846.49	1208.0
2013-10-17 19:00:00	NQ	Futures	3845.91	3855.2	3845.62	3852.3	1469.0
2013-10-17 20:00:00	NQ	Futures	3852.3	3852.59	3849.39	3850.26	541.0
2013-10-17 21:00:00	NQ	Futures	3850.55	3850.84	3849.1	3850.55	401.0
2013-10-17 22:00:00	NQ	Futures	3850.84	3851.72	3847.36	3850.26	585.0
2013-10-17 23:00:00	NQ	Futures	3850.84	3851.14	3847.07	3847.65	357.0
2013-10-17 00:00:00	YM	Futures	15567.9	15569.9	15556.7	15556.7	359.0
2013-10-17 01:00:00	YM	Futures	15558.7	15558.7	15550.5	15552.6	691.0

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

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