PREVIEW / futures_1hour / 2013-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-27.parquet
  size:    42 KB
  rows:    1,247

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-27 00:00:00	ES	Futures	1746.39	1746.65	1745.88	1746.39	1539.0
2013-09-27 01:00:00	ES	Futures	1746.39	1746.65	1744.84	1745.36	4313.0
2013-09-27 02:00:00	ES	Futures	1745.36	1746.13	1745.1	1745.88	4279.0
2013-09-27 03:00:00	ES	Futures	1746.13	1746.65	1742.01	1742.52	21538.0
2013-09-27 04:00:00	ES	Futures	1742.26	1743.04	1741.49	1741.75	10693.0
2013-09-27 05:00:00	ES	Futures	1741.75	1742.26	1738.91	1739.69	23934.0
2013-09-27 06:00:00	ES	Futures	1739.69	1741.49	1738.14	1738.4	26261.0
2013-09-27 07:00:00	ES	Futures	1738.65	1739.94	1737.88	1739.17	26678.0
2013-09-27 08:00:00	ES	Futures	1739.17	1739.94	1738.14	1739.94	30324.0
2013-09-27 09:00:00	ES	Futures	1739.94	1740.2	1734.78	1736.33	257392.0
2013-09-27 10:00:00	ES	Futures	1736.33	1739.43	1733.49	1737.88	252902.0
2013-09-27 11:00:00	ES	Futures	1738.14	1740.46	1735.3	1738.65	191261.0
2013-09-27 12:00:00	ES	Futures	1738.65	1740.46	1737.36	1739.17	100479.0
2013-09-27 13:00:00	ES	Futures	1739.43	1740.46	1737.62	1738.14	64579.0
2013-09-27 14:00:00	ES	Futures	1738.14	1738.65	1735.82	1736.59	100303.0
2013-09-27 15:00:00	ES	Futures	1736.59	1740.2	1735.3	1738.4	192204.0
2013-09-27 16:00:00	ES	Futures	1738.4	1740.72	1738.14	1738.91	100775.0
2013-09-27 17:00:00	ES	Futures	1738.91	1739.69	1738.65	1738.91	3478.0
2013-09-27 00:00:00	NQ	Futures	3750.06	3750.94	3750.06	3750.94	185.0
2013-09-27 01:00:00	NQ	Futures	3751.23	3751.23	3749.19	3749.77	500.0
2013-09-27 02:00:00	NQ	Futures	3749.77	3750.35	3749.19	3750.06	403.0
2013-09-27 03:00:00	NQ	Futures	3750.35	3752.97	3743.38	3743.97	3092.0
2013-09-27 04:00:00	NQ	Futures	3743.97	3746.29	3742.8	3742.8	1316.0
2013-09-27 05:00:00	NQ	Futures	3743.09	3744.26	3733.22	3735.25	3875.0
2013-09-27 06:00:00	NQ	Futures	3735.54	3739.32	3733.22	3734.09	3778.0
2013-09-27 07:00:00	NQ	Futures	3733.8	3737.29	3732.64	3734.38	2945.0
2013-09-27 08:00:00	NQ	Futures	3734.67	3735.54	3731.77	3735.25	4688.0
2013-09-27 09:00:00	NQ	Futures	3735.25	3735.83	3721.02	3728.57	42510.0
2013-09-27 10:00:00	NQ	Futures	3728.57	3745.71	3724.8	3743.09	34609.0
2013-09-27 11:00:00	NQ	Futures	3743.38	3750.06	3738.16	3745.71	20613.0
2013-09-27 12:00:00	NQ	Futures	3745.42	3750.65	3743.97	3748.9	11024.0
2013-09-27 13:00:00	NQ	Futures	3748.9	3750.06	3743.38	3745.13	9880.0
2013-09-27 14:00:00	NQ	Futures	3745.13	3745.42	3737.29	3738.16	13870.0
2013-09-27 15:00:00	NQ	Futures	3738.16	3747.45	3734.67	3743.68	29750.0
2013-09-27 16:00:00	NQ	Futures	3743.97	3747.45	3743.38	3744.26	6544.0
2013-09-27 17:00:00	NQ	Futures	3743.68	3748.32	3743.38	3747.16	608.0
2013-09-27 00:00:00	YM	Futures	15600.6	15602.6	15598.5	15601.6	430.0
2013-09-27 01:00:00	YM	Futures	15601.6	15601.6	15589.3	15589.3	620.0
2013-09-27 02:00:00	YM	Futures	15589.3	15598.5	15588.3	15597.5	636.0
2013-09-27 03:00:00	YM	Futures	15597.5	15597.5	15561.8	15565.8	2200.0
2013-09-27 04:00:00	YM	Futures	15563.8	15569.9	15559.7	15559.7	996.0
2013-09-27 05:00:00	YM	Futures	15558.7	15566.9	15534.2	15539.3	2635.0
2013-09-27 06:00:00	YM	Futures	15539.3	15553.6	15527.0	15531.1	2554.0
2013-09-27 07:00:00	YM	Futures	15530.1	15540.3	15527.0	15535.2	2576.0
2013-09-27 08:00:00	YM	Futures	15536.2	15543.4	15526.0	15543.4	3386.0
2013-09-27 09:00:00	YM	Futures	15543.4	15547.5	15473.9	15491.3	37653.0
2013-09-27 10:00:00	YM	Futures	15491.3	15505.6	15455.6	15493.3	22894.0
2013-09-27 11:00:00	YM	Futures	15493.3	15519.9	15473.9	15505.6	12920.0
2013-09-27 12:00:00	YM	Futures	15504.6	15514.8	15486.2	15507.6	7603.0
2013-09-27 13:00:00	YM	Futures	15507.6	15524.0	15495.4	15501.5	7082.0

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

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