PREVIEW / futures_1hour / 2013-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-30.parquet
  size:    49 KB
  rows:    1,516

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-09-30 00:00:00	ES	Futures	1729.37	1729.37	1727.82	1728.08	2047.0
2013-09-30 01:00:00	ES	Futures	1728.33	1729.37	1728.08	1728.59	4648.0
2013-09-30 02:00:00	ES	Futures	1728.59	1728.59	1724.47	1726.01	15841.0
2013-09-30 03:00:00	ES	Futures	1726.01	1728.85	1725.24	1726.27	28130.0
2013-09-30 04:00:00	ES	Futures	1726.53	1728.85	1725.76	1727.82	16897.0
2013-09-30 05:00:00	ES	Futures	1728.08	1729.11	1726.53	1726.79	11350.0
2013-09-30 06:00:00	ES	Futures	1726.79	1727.82	1723.95	1724.98	21278.0
2013-09-30 07:00:00	ES	Futures	1724.98	1727.04	1723.69	1723.95	29682.0
2013-09-30 08:00:00	ES	Futures	1724.21	1725.24	1722.66	1724.21	50255.0
2013-09-30 09:00:00	ES	Futures	1724.21	1727.3	1719.82	1724.47	258257.0
2013-09-30 10:00:00	ES	Futures	1724.72	1731.69	1724.47	1730.4	263402.0
2013-09-30 11:00:00	ES	Futures	1730.4	1731.95	1727.56	1731.43	217739.0
2013-09-30 12:00:00	ES	Futures	1731.69	1731.69	1727.82	1729.62	147012.0
2013-09-30 13:00:00	ES	Futures	1729.62	1734.53	1727.82	1729.62	238464.0
2013-09-30 14:00:00	ES	Futures	1729.62	1732.72	1728.85	1730.14	145095.0
2013-09-30 15:00:00	ES	Futures	1730.14	1730.4	1724.47	1729.11	472491.0
2013-09-30 16:00:00	ES	Futures	1729.11	1732.98	1728.59	1731.17	156910.0
2013-09-30 17:00:00	ES	Futures	1731.17	1732.46	1730.91	1732.2	2704.0
2013-09-30 18:00:00	ES	Futures	1731.95	1733.24	1730.91	1731.17	7932.0
2013-09-30 19:00:00	ES	Futures	1731.43	1731.95	1730.66	1730.91	3582.0
2013-09-30 20:00:00	ES	Futures	1730.66	1732.46	1730.66	1731.95	7057.0
2013-09-30 21:00:00	ES	Futures	1731.95	1735.3	1730.91	1734.78	10929.0
2013-09-30 22:00:00	ES	Futures	1734.78	1737.62	1732.46	1732.98	21597.0
2013-09-30 23:00:00	ES	Futures	1732.98	1732.98	1729.88	1729.88	9066.0
2013-09-30 00:00:00	NQ	Futures	3727.99	3728.28	3725.09	3725.67	359.0
2013-09-30 01:00:00	NQ	Futures	3725.96	3727.7	3725.09	3726.25	432.0
2013-09-30 02:00:00	NQ	Futures	3725.96	3725.96	3717.54	3719.57	1991.0
2013-09-30 03:00:00	NQ	Futures	3719.86	3725.96	3717.54	3720.44	2834.0
2013-09-30 04:00:00	NQ	Futures	3720.15	3725.67	3718.7	3723.05	1959.0
2013-09-30 05:00:00	NQ	Futures	3723.34	3725.09	3719.28	3719.57	1601.0
2013-09-30 06:00:00	NQ	Futures	3719.86	3721.02	3713.76	3716.96	2637.0
2013-09-30 07:00:00	NQ	Futures	3716.66	3719.57	3713.76	3714.05	2827.0
2013-09-30 08:00:00	NQ	Futures	3714.34	3715.5	3707.08	3709.98	8491.0
2013-09-30 09:00:00	NQ	Futures	3709.69	3716.37	3692.27	3713.18	43572.0
2013-09-30 10:00:00	NQ	Futures	3713.47	3736.41	3713.18	3734.09	39809.0
2013-09-30 11:00:00	NQ	Futures	3734.09	3742.51	3727.12	3741.64	25012.0
2013-09-30 12:00:00	NQ	Futures	3741.64	3741.93	3730.61	3734.96	15734.0
2013-09-30 13:00:00	NQ	Futures	3734.96	3744.55	3728.86	3731.77	32113.0
2013-09-30 14:00:00	NQ	Futures	3732.06	3739.9	3730.02	3733.8	20821.0
2013-09-30 15:00:00	NQ	Futures	3733.8	3733.8	3722.76	3732.93	61504.0
2013-09-30 16:00:00	NQ	Futures	3732.64	3742.8	3732.35	3740.19	11900.0
2013-09-30 17:00:00	NQ	Futures	3739.9	3741.93	3739.32	3741.06	260.0
2013-09-30 18:00:00	NQ	Futures	3742.22	3743.97	3737.87	3738.16	924.0
2013-09-30 19:00:00	NQ	Futures	3737.87	3739.61	3736.41	3737.0	425.0
2013-09-30 20:00:00	NQ	Futures	3737.29	3740.77	3737.0	3739.9	778.0
2013-09-30 21:00:00	NQ	Futures	3739.9	3747.45	3737.87	3746.87	1023.0
2013-09-30 22:00:00	NQ	Futures	3746.87	3752.68	3740.77	3742.8	2469.0
2013-09-30 23:00:00	NQ	Futures	3742.8	3742.8	3734.96	3735.25	1442.0
2013-09-30 00:00:00	YM	Futures	15422.9	15422.9	15384.1	15412.7	317.0
2013-09-30 01:00:00	YM	Futures	15412.7	15421.9	15412.7	15416.7	707.0

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

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