PREVIEW / futures_1hour / 2013-06-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1683.83	1685.12	1683.06	1684.6	3393.0
2013-06-04 01:00:00	ES	Futures	1684.86	1686.92	1684.34	1685.37	7027.0
2013-06-04 02:00:00	ES	Futures	1685.63	1687.69	1684.86	1686.15	17353.0
2013-06-04 03:00:00	ES	Futures	1686.15	1688.72	1684.34	1685.63	41900.0
2013-06-04 04:00:00	ES	Futures	1685.37	1687.18	1683.83	1684.09	21128.0
2013-06-04 05:00:00	ES	Futures	1684.34	1685.89	1683.83	1685.37	13751.0
2013-06-04 06:00:00	ES	Futures	1685.63	1687.43	1683.83	1686.4	28799.0
2013-06-04 07:00:00	ES	Futures	1686.15	1687.18	1684.6	1686.15	17709.0
2013-06-04 08:00:00	ES	Futures	1686.15	1690.27	1685.63	1688.47	45280.0
2013-06-04 09:00:00	ES	Futures	1688.21	1694.65	1686.92	1692.84	245634.0
2013-06-04 10:00:00	ES	Futures	1693.1	1695.68	1687.69	1687.95	277229.0
2013-06-04 11:00:00	ES	Futures	1687.95	1690.53	1685.89	1689.5	220399.0
2013-06-04 12:00:00	ES	Futures	1689.24	1689.75	1682.03	1684.6	209520.0
2013-06-04 13:00:00	ES	Futures	1684.34	1686.66	1673.53	1676.62	271386.0
2013-06-04 14:00:00	ES	Futures	1676.36	1679.71	1670.69	1676.87	268545.0
2013-06-04 15:00:00	ES	Futures	1676.87	1685.37	1675.59	1678.93	300711.0
2013-06-04 16:00:00	ES	Futures	1678.93	1682.28	1678.93	1680.48	77887.0
2013-06-04 17:00:00	ES	Futures	1680.22	1680.48	1679.19	1679.45	2831.0
2013-06-04 18:00:00	ES	Futures	1678.68	1680.74	1677.9	1680.22	3956.0
2013-06-04 19:00:00	ES	Futures	1680.22	1680.74	1678.93	1679.45	1328.0
2013-06-04 20:00:00	ES	Futures	1679.19	1681.77	1678.42	1680.74	6826.0
2013-06-04 21:00:00	ES	Futures	1680.74	1681.0	1678.68	1680.22	8082.0
2013-06-04 22:00:00	ES	Futures	1680.22	1680.48	1678.93	1679.45	2858.0
2013-06-04 23:00:00	ES	Futures	1679.71	1681.25	1678.93	1679.71	5540.0
2013-06-04 00:00:00	NQ	Futures	3481.35	3483.97	3480.18	3483.39	601.0
2013-06-04 01:00:00	NQ	Futures	3483.39	3487.18	3482.52	3485.14	776.0
2013-06-04 02:00:00	NQ	Futures	3485.43	3488.35	3484.27	3485.72	992.0
2013-06-04 03:00:00	NQ	Futures	3485.72	3490.1	3482.81	3485.72	4657.0
2013-06-04 04:00:00	NQ	Futures	3486.31	3488.06	3481.93	3481.93	2458.0
2013-06-04 05:00:00	NQ	Futures	3481.93	3486.31	3481.64	3485.72	1730.0
2013-06-04 06:00:00	NQ	Futures	3485.72	3489.22	3482.81	3486.89	2625.0
2013-06-04 07:00:00	NQ	Futures	3486.6	3488.06	3483.97	3486.02	2037.0
2013-06-04 08:00:00	NQ	Futures	3486.31	3494.77	3485.43	3491.85	5239.0
2013-06-04 09:00:00	NQ	Futures	3491.85	3504.1	3489.22	3502.35	35916.0
2013-06-04 10:00:00	NQ	Futures	3502.35	3508.18	3494.77	3494.77	34978.0
2013-06-04 11:00:00	NQ	Futures	3494.47	3502.35	3488.64	3498.85	24431.0
2013-06-04 12:00:00	NQ	Futures	3498.85	3500.02	3481.64	3486.89	28844.0
2013-06-04 13:00:00	NQ	Futures	3486.89	3488.93	3462.68	3467.64	36707.0
2013-06-04 14:00:00	NQ	Futures	3467.64	3470.27	3454.52	3464.72	37186.0
2013-06-04 15:00:00	NQ	Futures	3464.72	3479.89	3459.18	3468.52	47875.0
2013-06-04 16:00:00	NQ	Futures	3468.52	3475.81	3468.52	3472.6	5406.0
2013-06-04 17:00:00	NQ	Futures	3472.6	3472.6	3466.18	3467.35	1476.0
2013-06-04 18:00:00	NQ	Futures	3465.89	3471.43	3463.56	3470.27	1226.0
2013-06-04 19:00:00	NQ	Futures	3470.56	3470.56	3467.64	3468.81	200.0
2013-06-04 20:00:00	NQ	Futures	3469.1	3472.6	3467.06	3471.43	832.0
2013-06-04 21:00:00	NQ	Futures	3471.14	3471.72	3467.35	3469.97	1077.0
2013-06-04 22:00:00	NQ	Futures	3469.97	3470.85	3467.93	3469.97	542.0
2013-06-04 23:00:00	NQ	Futures	3469.97	3474.06	3468.52	3469.68	941.0
2013-06-04 00:00:00	YM	Futures	15371.4	15382.5	15367.4	15381.5	568.0
2013-06-04 01:00:00	YM	Futures	15380.5	15389.6	15373.4	15381.5	1172.0

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

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