PREVIEW / futures_1hour / 2013-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-30.parquet
  size:    48 KB
  rows:    1,527

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-07-30 00:00:00	ES	Futures	1742.26	1742.26	1741.74	1741.74	1006.0
2013-07-30 01:00:00	ES	Futures	1741.74	1742.51	1741.48	1741.74	2250.0
2013-07-30 02:00:00	ES	Futures	1741.74	1743.03	1741.48	1742.0	5072.0
2013-07-30 03:00:00	ES	Futures	1742.26	1743.55	1740.7	1743.03	14333.0
2013-07-30 04:00:00	ES	Futures	1743.03	1744.32	1739.67	1740.96	22270.0
2013-07-30 05:00:00	ES	Futures	1741.22	1742.0	1739.41	1739.93	11893.0
2013-07-30 06:00:00	ES	Futures	1739.67	1743.81	1739.41	1743.81	17986.0
2013-07-30 07:00:00	ES	Futures	1743.81	1744.58	1742.51	1743.81	18615.0
2013-07-30 08:00:00	ES	Futures	1743.81	1745.36	1743.29	1745.1	24351.0
2013-07-30 09:00:00	ES	Futures	1745.1	1745.87	1741.22	1742.77	155481.0
2013-07-30 10:00:00	ES	Futures	1743.03	1744.84	1740.45	1740.96	184263.0
2013-07-30 11:00:00	ES	Futures	1740.96	1743.55	1740.19	1742.51	137124.0
2013-07-30 12:00:00	ES	Futures	1742.51	1742.51	1739.67	1741.22	105259.0
2013-07-30 13:00:00	ES	Futures	1741.22	1741.22	1734.24	1736.31	184527.0
2013-07-30 14:00:00	ES	Futures	1736.05	1738.64	1735.02	1737.34	123184.0
2013-07-30 15:00:00	ES	Futures	1737.34	1741.74	1736.57	1738.38	217245.0
2013-07-30 16:00:00	ES	Futures	1738.38	1742.26	1738.12	1741.74	67993.0
2013-07-30 17:00:00	ES	Futures	1741.74	1741.74	1741.22	1741.48	2192.0
2013-07-30 18:00:00	ES	Futures	1741.22	1742.0	1740.7	1741.74	3636.0
2013-07-30 19:00:00	ES	Futures	1741.74	1742.0	1741.22	1741.48	1319.0
2013-07-30 20:00:00	ES	Futures	1741.48	1741.48	1740.19	1740.96	3047.0
2013-07-30 21:00:00	ES	Futures	1741.22	1743.81	1740.7	1743.81	3745.0
2013-07-30 22:00:00	ES	Futures	1743.81	1744.06	1743.03	1743.81	1925.0
2013-07-30 23:00:00	ES	Futures	1743.55	1744.32	1743.29	1743.55	2185.0
2013-07-30 00:00:00	NQ	Futures	3590.99	3592.46	3590.12	3591.29	336.0
2013-07-30 01:00:00	NQ	Futures	3591.58	3591.87	3590.41	3590.7	284.0
2013-07-30 02:00:00	NQ	Futures	3590.41	3592.75	3590.41	3591.29	535.0
2013-07-30 03:00:00	NQ	Futures	3590.99	3595.38	3589.24	3595.09	3352.0
2013-07-30 04:00:00	NQ	Futures	3594.79	3597.13	3587.78	3589.83	4353.0
2013-07-30 05:00:00	NQ	Futures	3590.12	3592.16	3587.2	3588.07	1896.0
2013-07-30 06:00:00	NQ	Futures	3587.78	3597.42	3587.49	3595.96	3341.0
2013-07-30 07:00:00	NQ	Futures	3596.25	3597.13	3593.33	3595.38	2861.0
2013-07-30 08:00:00	NQ	Futures	3595.67	3599.47	3594.79	3598.3	3443.0
2013-07-30 09:00:00	NQ	Futures	3598.01	3599.18	3591.58	3591.87	22122.0
2013-07-30 10:00:00	NQ	Futures	3592.46	3606.19	3591.58	3601.22	29716.0
2013-07-30 11:00:00	NQ	Futures	3601.22	3617.59	3598.88	3615.54	43829.0
2013-07-30 12:00:00	NQ	Futures	3615.54	3615.54	3607.36	3610.28	21615.0
2013-07-30 13:00:00	NQ	Futures	3610.57	3610.87	3588.95	3591.58	27928.0
2013-07-30 14:00:00	NQ	Futures	3591.29	3601.22	3589.53	3597.72	28058.0
2013-07-30 15:00:00	NQ	Futures	3597.42	3609.11	3595.96	3600.93	35352.0
2013-07-30 16:00:00	NQ	Futures	3600.64	3607.94	3600.64	3605.61	5612.0
2013-07-30 17:00:00	NQ	Futures	3605.31	3605.9	3604.73	3604.73	165.0
2013-07-30 18:00:00	NQ	Futures	3603.27	3605.61	3602.68	3604.44	294.0
2013-07-30 19:00:00	NQ	Futures	3604.44	3605.9	3604.14	3605.31	173.0
2013-07-30 20:00:00	NQ	Futures	3604.73	3605.61	3602.68	3605.31	481.0
2013-07-30 21:00:00	NQ	Futures	3605.31	3609.11	3603.56	3608.53	531.0
2013-07-30 22:00:00	NQ	Futures	3608.53	3609.7	3607.36	3608.24	354.0
2013-07-30 23:00:00	NQ	Futures	3608.53	3609.11	3607.94	3607.94	265.0
2013-07-30 00:00:00	YM	Futures	15742.0	15745.1	15741.0	15743.1	156.0
2013-07-30 01:00:00	YM	Futures	15742.0	15746.1	15739.0	15743.1	386.0

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

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