PREVIEW / futures_1hour / 2013-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-11.parquet
  size:    49 KB
  rows:    1,466

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-06-11 00:00:00	ES	Futures	1688.98	1690.27	1688.47	1689.24	3869.0
2013-06-11 01:00:00	ES	Futures	1689.24	1690.27	1688.47	1688.72	3897.0
2013-06-11 02:00:00	ES	Futures	1688.72	1691.04	1688.72	1689.75	7661.0
2013-06-11 03:00:00	ES	Futures	1689.24	1689.24	1685.12	1686.92	36329.0
2013-06-11 04:00:00	ES	Futures	1686.92	1687.69	1685.12	1685.89	15387.0
2013-06-11 05:00:00	ES	Futures	1685.89	1686.4	1676.87	1678.68	58589.0
2013-06-11 06:00:00	ES	Futures	1678.42	1679.45	1676.36	1677.39	40823.0
2013-06-11 07:00:00	ES	Futures	1677.13	1679.19	1674.81	1676.36	66379.0
2013-06-11 08:00:00	ES	Futures	1676.36	1678.16	1674.3	1677.39	59648.0
2013-06-11 09:00:00	ES	Futures	1677.39	1677.9	1670.69	1676.1	422731.0
2013-06-11 10:00:00	ES	Futures	1676.36	1683.31	1673.27	1681.51	404496.0
2013-06-11 11:00:00	ES	Futures	1681.51	1689.5	1679.97	1686.4	341153.0
2013-06-11 12:00:00	ES	Futures	1686.4	1688.21	1684.34	1685.12	144364.0
2013-06-11 13:00:00	ES	Futures	1685.12	1686.4	1675.84	1675.84	244394.0
2013-06-11 14:00:00	ES	Futures	1676.1	1682.28	1674.81	1682.28	197584.0
2013-06-11 15:00:00	ES	Futures	1682.28	1683.31	1673.78	1674.81	275684.0
2013-06-11 16:00:00	ES	Futures	1674.81	1677.65	1674.81	1677.39	83418.0
2013-06-11 17:00:00	ES	Futures	1677.39	1677.9	1676.87	1677.13	2047.0
2013-06-11 18:00:00	ES	Futures	1676.87	1677.65	1675.59	1676.36	4777.0
2013-06-11 19:00:00	ES	Futures	1676.36	1677.65	1676.1	1677.65	1673.0
2013-06-11 20:00:00	ES	Futures	1677.65	1679.19	1677.13	1677.65	4909.0
2013-06-11 21:00:00	ES	Futures	1677.9	1679.45	1676.62	1678.16	6084.0
2013-06-11 22:00:00	ES	Futures	1678.42	1679.19	1677.9	1678.42	1949.0
2013-06-11 23:00:00	ES	Futures	1678.16	1679.19	1677.9	1678.93	1704.0
2013-06-11 00:00:00	NQ	Futures	3480.77	3483.39	3480.47	3482.81	590.0
2013-06-11 01:00:00	NQ	Futures	3482.81	3483.1	3480.47	3480.47	474.0
2013-06-11 02:00:00	NQ	Futures	3480.47	3484.56	3480.47	3482.52	896.0
2013-06-11 03:00:00	NQ	Futures	3482.22	3482.22	3475.22	3478.43	4065.0
2013-06-11 04:00:00	NQ	Futures	3478.72	3479.89	3474.35	3476.97	2748.0
2013-06-11 05:00:00	NQ	Futures	3476.97	3477.27	3455.1	3457.43	6590.0
2013-06-11 06:00:00	NQ	Futures	3457.43	3459.18	3453.64	3455.39	3928.0
2013-06-11 07:00:00	NQ	Futures	3455.39	3458.31	3450.43	3455.1	6778.0
2013-06-11 08:00:00	NQ	Futures	3455.1	3456.56	3449.85	3453.93	6276.0
2013-06-11 09:00:00	NQ	Futures	3453.93	3460.64	3441.1	3457.72	56293.0
2013-06-11 10:00:00	NQ	Futures	3457.72	3473.18	3449.27	3469.39	61756.0
2013-06-11 11:00:00	NQ	Futures	3469.97	3484.85	3467.06	3477.27	42313.0
2013-06-11 12:00:00	NQ	Futures	3477.27	3484.27	3476.1	3479.02	16097.0
2013-06-11 13:00:00	NQ	Futures	3478.72	3481.93	3458.31	3458.6	29630.0
2013-06-11 14:00:00	NQ	Futures	3458.31	3469.1	3456.27	3468.81	23976.0
2013-06-11 15:00:00	NQ	Futures	3468.81	3471.72	3451.02	3453.93	33975.0
2013-06-11 16:00:00	NQ	Futures	3454.22	3461.52	3453.35	3460.64	6075.0
2013-06-11 17:00:00	NQ	Futures	3460.64	3461.81	3460.35	3460.64	148.0
2013-06-11 18:00:00	NQ	Futures	3459.77	3461.52	3457.43	3459.18	460.0
2013-06-11 19:00:00	NQ	Futures	3459.18	3461.52	3458.6	3460.64	244.0
2013-06-11 20:00:00	NQ	Futures	3460.93	3464.14	3460.64	3462.1	725.0
2013-06-11 21:00:00	NQ	Futures	3462.1	3465.31	3460.06	3463.27	655.0
2013-06-11 22:00:00	NQ	Futures	3463.56	3465.02	3462.97	3463.27	256.0
2013-06-11 23:00:00	NQ	Futures	3463.27	3464.72	3462.39	3463.85	226.0
2013-06-11 00:00:00	YM	Futures	15361.2	15361.2	15361.2	15361.2	1.0
2013-06-11 02:00:00	YM	Futures	15367.3	15388.6	15366.2	15380.5	29.0

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

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