PREVIEW / futures_1hour / 2013-07-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	1746.13	1746.39	1745.36	1745.36	1826.0
2013-07-24 01:00:00	ES	Futures	1745.36	1746.39	1745.36	1745.87	2268.0
2013-07-24 02:00:00	ES	Futures	1745.87	1746.65	1745.62	1746.65	3540.0
2013-07-24 03:00:00	ES	Futures	1746.39	1750.53	1746.13	1748.98	23174.0
2013-07-24 04:00:00	ES	Futures	1748.98	1750.27	1748.2	1750.01	9813.0
2013-07-24 05:00:00	ES	Futures	1750.01	1751.04	1747.94	1748.2	20520.0
2013-07-24 06:00:00	ES	Futures	1747.94	1751.04	1747.68	1750.53	14036.0
2013-07-24 07:00:00	ES	Futures	1750.53	1752.85	1750.27	1751.56	26519.0
2013-07-24 08:00:00	ES	Futures	1751.82	1752.34	1749.23	1750.27	33101.0
2013-07-24 09:00:00	ES	Futures	1750.01	1752.08	1744.06	1744.06	203474.0
2013-07-24 10:00:00	ES	Futures	1744.32	1745.87	1739.41	1741.48	293496.0
2013-07-24 11:00:00	ES	Futures	1741.74	1744.32	1740.19	1741.74	153348.0
2013-07-24 12:00:00	ES	Futures	1741.48	1742.26	1737.09	1738.12	133053.0
2013-07-24 13:00:00	ES	Futures	1738.12	1739.41	1734.24	1736.31	158016.0
2013-07-24 14:00:00	ES	Futures	1736.31	1738.89	1736.05	1737.86	107547.0
2013-07-24 15:00:00	ES	Futures	1737.86	1738.64	1734.76	1738.12	212577.0
2013-07-24 16:00:00	ES	Futures	1738.12	1741.74	1737.86	1741.22	86249.0
2013-07-24 17:00:00	ES	Futures	1741.22	1741.48	1740.96	1741.22	1856.0
2013-07-24 18:00:00	ES	Futures	1741.22	1741.48	1740.19	1740.45	4490.0
2013-07-24 19:00:00	ES	Futures	1740.19	1740.7	1739.67	1739.93	2064.0
2013-07-24 20:00:00	ES	Futures	1739.93	1739.93	1738.38	1738.64	4952.0
2013-07-24 21:00:00	ES	Futures	1738.64	1740.19	1737.86	1739.41	4898.0
2013-07-24 22:00:00	ES	Futures	1739.41	1739.93	1738.64	1738.89	2650.0
2013-07-24 23:00:00	ES	Futures	1738.89	1740.19	1738.64	1740.19	1547.0
2013-07-24 00:00:00	NQ	Futures	3553.3	3553.88	3552.71	3552.71	229.0
2013-07-24 01:00:00	NQ	Futures	3552.71	3554.46	3552.42	3553.88	414.0
2013-07-24 02:00:00	NQ	Futures	3553.59	3556.51	3552.71	3555.63	775.0
2013-07-24 03:00:00	NQ	Futures	3555.63	3567.03	3553.88	3564.69	4844.0
2013-07-24 04:00:00	NQ	Futures	3564.69	3567.32	3562.94	3566.74	2357.0
2013-07-24 05:00:00	NQ	Futures	3567.03	3568.78	3564.11	3564.11	2416.0
2013-07-24 06:00:00	NQ	Futures	3564.4	3569.66	3563.23	3567.91	2689.0
2013-07-24 07:00:00	NQ	Futures	3567.62	3573.75	3567.62	3571.41	3162.0
2013-07-24 08:00:00	NQ	Futures	3571.12	3573.46	3569.95	3570.83	6803.0
2013-07-24 09:00:00	NQ	Futures	3570.83	3573.75	3554.17	3554.17	34700.0
2013-07-24 10:00:00	NQ	Futures	3554.17	3558.85	3543.65	3555.05	42360.0
2013-07-24 11:00:00	NQ	Futures	3555.05	3566.45	3554.17	3558.85	26825.0
2013-07-24 12:00:00	NQ	Futures	3558.85	3561.48	3548.04	3550.96	18993.0
2013-07-24 13:00:00	NQ	Futures	3550.67	3552.42	3540.44	3545.99	66977.0
2013-07-24 14:00:00	NQ	Futures	3545.99	3552.42	3545.41	3550.08	27423.0
2013-07-24 15:00:00	NQ	Futures	3549.79	3552.13	3543.65	3547.74	55563.0
2013-07-24 16:00:00	NQ	Futures	3547.74	3569.66	3547.45	3568.49	14270.0
2013-07-24 17:00:00	NQ	Futures	3568.78	3569.66	3568.49	3569.37	231.0
2013-07-24 18:00:00	NQ	Futures	3568.2	3569.37	3566.74	3567.91	503.0
2013-07-24 19:00:00	NQ	Futures	3567.62	3567.91	3566.15	3567.03	250.0
2013-07-24 20:00:00	NQ	Futures	3566.45	3566.45	3563.82	3564.69	638.0
2013-07-24 21:00:00	NQ	Futures	3564.69	3568.2	3563.23	3566.15	639.0
2013-07-24 22:00:00	NQ	Futures	3566.15	3567.32	3564.69	3565.28	679.0
2013-07-24 23:00:00	NQ	Futures	3565.28	3567.32	3565.28	3567.03	244.0
2013-07-24 00:00:00	YM	Futures	15760.3	15762.4	15756.3	15756.3	238.0
2013-07-24 01:00:00	YM	Futures	15756.3	15765.4	15756.3	15761.3	383.0

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

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