PREVIEW / futures_1hour / 2013-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-25.parquet
  size:    50 KB
  rows:    1,518

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-25 00:00:00	ES	Futures	1740.19	1740.19	1739.15	1739.93	2003.0
2013-07-25 01:00:00	ES	Futures	1739.93	1740.19	1739.15	1739.67	2683.0
2013-07-25 02:00:00	ES	Futures	1739.67	1739.93	1738.38	1739.15	3978.0
2013-07-25 03:00:00	ES	Futures	1739.15	1739.93	1735.53	1736.83	21622.0
2013-07-25 04:00:00	ES	Futures	1736.83	1737.6	1732.69	1732.69	34069.0
2013-07-25 05:00:00	ES	Futures	1732.95	1733.72	1728.55	1729.59	42554.0
2013-07-25 06:00:00	ES	Futures	1729.59	1731.4	1728.55	1731.14	26270.0
2013-07-25 07:00:00	ES	Futures	1731.14	1734.76	1730.88	1733.72	28822.0
2013-07-25 08:00:00	ES	Futures	1733.72	1736.05	1732.17	1733.47	62532.0
2013-07-25 09:00:00	ES	Futures	1733.72	1738.12	1732.17	1736.83	180019.0
2013-07-25 10:00:00	ES	Futures	1736.83	1739.41	1735.53	1737.34	197713.0
2013-07-25 11:00:00	ES	Futures	1737.34	1737.34	1731.66	1733.98	162249.0
2013-07-25 12:00:00	ES	Futures	1733.98	1741.22	1733.21	1740.7	142436.0
2013-07-25 13:00:00	ES	Futures	1740.96	1741.48	1739.41	1739.93	70670.0
2013-07-25 14:00:00	ES	Futures	1739.93	1742.26	1737.09	1737.34	105784.0
2013-07-25 15:00:00	ES	Futures	1737.34	1743.81	1737.09	1742.51	243769.0
2013-07-25 16:00:00	ES	Futures	1742.26	1743.03	1740.45	1743.03	68170.0
2013-07-25 17:00:00	ES	Futures	1743.03	1743.81	1742.26	1743.55	2748.0
2013-07-25 18:00:00	ES	Futures	1743.03	1744.06	1742.26	1743.55	5699.0
2013-07-25 19:00:00	ES	Futures	1743.55	1744.06	1743.03	1743.03	1530.0
2013-07-25 20:00:00	ES	Futures	1743.03	1743.29	1740.7	1742.26	5947.0
2013-07-25 21:00:00	ES	Futures	1742.26	1744.06	1742.0	1744.06	3582.0
2013-07-25 22:00:00	ES	Futures	1744.06	1744.32	1743.55	1743.55	3335.0
2013-07-25 23:00:00	ES	Futures	1743.55	1744.84	1743.55	1744.58	4158.0
2013-07-25 00:00:00	NQ	Futures	3567.03	3567.32	3565.28	3566.74	388.0
2013-07-25 01:00:00	NQ	Futures	3566.74	3567.03	3565.28	3565.86	371.0
2013-07-25 02:00:00	NQ	Futures	3565.86	3566.15	3563.82	3565.28	455.0
2013-07-25 03:00:00	NQ	Futures	3565.57	3567.91	3559.73	3561.48	4551.0
2013-07-25 04:00:00	NQ	Futures	3561.48	3563.52	3550.96	3551.25	5121.0
2013-07-25 05:00:00	NQ	Futures	3551.25	3552.71	3539.56	3540.15	8166.0
2013-07-25 06:00:00	NQ	Futures	3539.85	3545.99	3538.98	3545.7	4781.0
2013-07-25 07:00:00	NQ	Futures	3545.7	3564.69	3545.7	3564.11	7340.0
2013-07-25 08:00:00	NQ	Futures	3564.4	3570.25	3563.82	3567.32	7779.0
2013-07-25 09:00:00	NQ	Futures	3567.32	3570.54	3550.08	3562.94	31690.0
2013-07-25 10:00:00	NQ	Futures	3563.23	3568.49	3558.85	3560.02	24086.0
2013-07-25 11:00:00	NQ	Futures	3560.31	3560.6	3546.57	3552.13	23356.0
2013-07-25 12:00:00	NQ	Futures	3552.13	3571.41	3551.54	3570.25	20743.0
2013-07-25 13:00:00	NQ	Futures	3570.25	3571.71	3566.15	3567.03	10665.0
2013-07-25 14:00:00	NQ	Futures	3567.03	3570.54	3561.77	3562.06	13108.0
2013-07-25 15:00:00	NQ	Futures	3562.06	3574.92	3561.19	3571.41	35420.0
2013-07-25 16:00:00	NQ	Futures	3571.12	3571.41	3562.06	3570.25	13685.0
2013-07-25 17:00:00	NQ	Futures	3570.83	3571.12	3568.2	3570.83	237.0
2013-07-25 18:00:00	NQ	Futures	3568.78	3569.95	3567.62	3569.08	373.0
2013-07-25 19:00:00	NQ	Futures	3569.37	3571.12	3569.08	3569.95	340.0
2013-07-25 20:00:00	NQ	Futures	3569.66	3570.83	3567.32	3569.37	809.0
2013-07-25 21:00:00	NQ	Futures	3569.37	3572.0	3569.08	3571.41	582.0
2013-07-25 22:00:00	NQ	Futures	3571.41	3572.29	3570.54	3571.41	512.0
2013-07-25 23:00:00	NQ	Futures	3571.12	3572.29	3569.95	3572.29	391.0
2013-07-25 00:00:00	YM	Futures	15734.9	15734.9	15726.8	15731.9	231.0
2013-07-25 01:00:00	YM	Futures	15731.9	15732.9	15725.8	15729.9	339.0

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

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