PREVIEW / futures_1hour / 2013-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-15.parquet
  size:    51 KB
  rows:    1,552

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-05-15 00:00:00	ES	Futures	1696.45	1697.22	1696.19	1696.71	2194.0
2013-05-15 01:00:00	ES	Futures	1696.71	1698.51	1696.45	1696.71	7780.0
2013-05-15 02:00:00	ES	Futures	1696.45	1697.22	1695.42	1695.94	12610.0
2013-05-15 03:00:00	ES	Futures	1695.68	1696.97	1694.39	1696.19	27569.0
2013-05-15 04:00:00	ES	Futures	1696.45	1696.71	1694.39	1694.9	14703.0
2013-05-15 05:00:00	ES	Futures	1694.65	1696.71	1693.87	1696.71	14055.0
2013-05-15 06:00:00	ES	Futures	1696.71	1698.25	1696.19	1698.0	31707.0
2013-05-15 07:00:00	ES	Futures	1698.0	1698.25	1695.68	1696.45	22552.0
2013-05-15 08:00:00	ES	Futures	1696.45	1696.71	1694.13	1695.68	39760.0
2013-05-15 09:00:00	ES	Futures	1695.68	1697.48	1692.59	1696.19	247270.0
2013-05-15 10:00:00	ES	Futures	1696.45	1699.28	1695.68	1699.03	287181.0
2013-05-15 11:00:00	ES	Futures	1698.77	1705.47	1698.77	1704.95	309582.0
2013-05-15 12:00:00	ES	Futures	1705.21	1710.1	1704.44	1708.56	259559.0
2013-05-15 13:00:00	ES	Futures	1708.3	1708.56	1702.63	1702.89	222693.0
2013-05-15 14:00:00	ES	Futures	1702.89	1703.92	1698.51	1700.57	223372.0
2013-05-15 15:00:00	ES	Futures	1700.57	1707.53	1699.03	1706.24	271054.0
2013-05-15 16:00:00	ES	Futures	1706.5	1706.75	1703.66	1704.95	82301.0
2013-05-15 17:00:00	ES	Futures	1704.95	1705.72	1704.69	1705.47	2702.0
2013-05-15 18:00:00	ES	Futures	1705.47	1705.98	1703.66	1704.18	4060.0
2013-05-15 19:00:00	ES	Futures	1704.18	1705.72	1704.18	1704.95	2542.0
2013-05-15 20:00:00	ES	Futures	1705.21	1705.98	1702.89	1704.95	7735.0
2013-05-15 21:00:00	ES	Futures	1704.95	1704.95	1702.89	1704.18	4216.0
2013-05-15 22:00:00	ES	Futures	1704.18	1704.95	1703.15	1703.66	3309.0
2013-05-15 23:00:00	ES	Futures	1703.92	1704.69	1703.41	1703.41	2377.0
2013-05-15 00:00:00	NQ	Futures	3494.47	3495.35	3494.18	3494.47	186.0
2013-05-15 01:00:00	NQ	Futures	3494.47	3497.97	3494.47	3494.47	463.0
2013-05-15 02:00:00	NQ	Futures	3494.18	3495.64	3491.85	3492.14	1181.0
2013-05-15 03:00:00	NQ	Futures	3492.14	3496.22	3490.39	3494.18	2889.0
2013-05-15 04:00:00	NQ	Futures	3493.89	3495.35	3490.1	3490.1	1283.0
2013-05-15 05:00:00	NQ	Futures	3490.39	3493.89	3489.52	3493.89	1400.0
2013-05-15 06:00:00	NQ	Futures	3493.89	3496.52	3493.31	3496.22	2313.0
2013-05-15 07:00:00	NQ	Futures	3495.93	3496.22	3492.43	3493.31	2115.0
2013-05-15 08:00:00	NQ	Futures	3493.31	3495.93	3490.1	3491.85	4188.0
2013-05-15 09:00:00	NQ	Futures	3491.85	3500.6	3485.72	3491.27	30333.0
2013-05-15 10:00:00	NQ	Futures	3491.56	3500.02	3488.06	3499.72	26679.0
2013-05-15 11:00:00	NQ	Futures	3499.72	3505.27	3498.27	3500.02	22497.0
2013-05-15 12:00:00	NQ	Futures	3499.72	3504.97	3497.39	3502.06	19935.0
2013-05-15 13:00:00	NQ	Futures	3501.77	3502.35	3488.06	3488.35	21117.0
2013-05-15 14:00:00	NQ	Futures	3488.06	3491.85	3479.6	3485.14	25731.0
2013-05-15 15:00:00	NQ	Futures	3485.14	3503.52	3480.77	3501.47	33747.0
2013-05-15 16:00:00	NQ	Futures	3501.18	3506.14	3498.85	3505.85	7316.0
2013-05-15 17:00:00	NQ	Futures	3505.56	3508.77	3505.56	3508.18	613.0
2013-05-15 18:00:00	NQ	Futures	3504.97	3507.89	3504.39	3506.14	1264.0
2013-05-15 19:00:00	NQ	Futures	3505.56	3508.77	3505.56	3508.47	513.0
2013-05-15 20:00:00	NQ	Futures	3508.47	3509.64	3503.52	3507.02	896.0
2013-05-15 21:00:00	NQ	Futures	3507.02	3507.02	3503.52	3504.97	666.0
2013-05-15 22:00:00	NQ	Futures	3505.56	3506.72	3503.52	3504.97	426.0
2013-05-15 23:00:00	NQ	Futures	3505.56	3507.02	3504.1	3504.97	516.0
2013-05-15 00:00:00	YM	Futures	15334.0	15339.1	15332.0	15336.0	285.0
2013-05-15 01:00:00	YM	Futures	15336.0	15349.2	15336.0	15336.0	666.0

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

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