PREVIEW / futures_1hour / 2013-06-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	1689.01	1689.78	1688.75	1689.52	1433.0
2013-06-18 01:00:00	ES	Futures	1689.26	1691.59	1689.01	1691.59	3165.0
2013-06-18 02:00:00	ES	Futures	1691.33	1691.59	1690.56	1691.07	4026.0
2013-06-18 03:00:00	ES	Futures	1691.07	1693.92	1688.75	1693.4	23214.0
2013-06-18 04:00:00	ES	Futures	1693.4	1694.43	1691.07	1691.85	10483.0
2013-06-18 05:00:00	ES	Futures	1691.85	1695.21	1691.85	1694.43	13101.0
2013-06-18 06:00:00	ES	Futures	1694.17	1694.43	1691.85	1693.4	11971.0
2013-06-18 07:00:00	ES	Futures	1693.14	1693.4	1689.78	1690.81	16456.0
2013-06-18 08:00:00	ES	Futures	1691.07	1693.4	1689.01	1689.78	36191.0
2013-06-18 09:00:00	ES	Futures	1689.78	1693.92	1688.23	1691.59	148945.0
2013-06-18 10:00:00	ES	Futures	1691.59	1698.31	1690.3	1697.79	212915.0
2013-06-18 11:00:00	ES	Futures	1697.79	1701.67	1695.98	1698.31	182262.0
2013-06-18 12:00:00	ES	Futures	1698.31	1702.45	1697.28	1702.19	101439.0
2013-06-18 13:00:00	ES	Futures	1702.19	1702.45	1698.57	1701.41	95810.0
2013-06-18 14:00:00	ES	Futures	1701.67	1704.77	1700.12	1704.0	117921.0
2013-06-18 15:00:00	ES	Futures	1704.0	1704.0	1699.34	1701.93	167412.0
2013-06-18 16:00:00	ES	Futures	1701.93	1703.22	1700.38	1702.45	60658.0
2013-06-18 17:00:00	ES	Futures	1702.45	1703.22	1702.45	1702.71	2044.0
2013-06-18 18:00:00	ES	Futures	1702.45	1703.22	1701.67	1702.45	2785.0
2013-06-18 19:00:00	ES	Futures	1702.19	1702.71	1701.41	1701.93	1373.0
2013-06-18 20:00:00	ES	Futures	1701.93	1702.19	1701.41	1701.67	2147.0
2013-06-18 21:00:00	ES	Futures	1701.67	1702.19	1700.64	1701.67	3202.0
2013-06-18 22:00:00	ES	Futures	1701.67	1701.93	1698.05	1698.05	7353.0
2013-06-18 23:00:00	ES	Futures	1698.05	1698.83	1698.05	1698.05	4895.0
2013-06-18 00:00:00	NQ	Futures	3467.96	3470.01	3467.38	3469.72	203.0
2013-06-18 01:00:00	NQ	Futures	3469.13	3472.93	3468.84	3472.93	237.0
2013-06-18 02:00:00	NQ	Futures	3472.64	3473.22	3470.59	3472.35	314.0
2013-06-18 03:00:00	NQ	Futures	3472.05	3478.78	3466.79	3475.56	3199.0
2013-06-18 04:00:00	NQ	Futures	3475.85	3478.19	3470.3	3471.47	1973.0
2013-06-18 05:00:00	NQ	Futures	3471.47	3479.36	3471.47	3476.44	1972.0
2013-06-18 06:00:00	NQ	Futures	3476.15	3476.44	3472.93	3475.27	1150.0
2013-06-18 07:00:00	NQ	Futures	3474.98	3474.98	3468.26	3471.18	1834.0
2013-06-18 08:00:00	NQ	Futures	3471.18	3478.19	3469.13	3472.05	4342.0
2013-06-18 09:00:00	NQ	Futures	3471.76	3485.5	3469.42	3480.24	25321.0
2013-06-18 10:00:00	NQ	Futures	3480.24	3498.06	3478.48	3495.73	30211.0
2013-06-18 11:00:00	NQ	Futures	3496.02	3502.74	3493.1	3495.73	22654.0
2013-06-18 12:00:00	NQ	Futures	3495.43	3500.69	3491.34	3499.82	15352.0
2013-06-18 13:00:00	NQ	Futures	3499.82	3500.11	3493.97	3498.36	12578.0
2013-06-18 14:00:00	NQ	Futures	3498.65	3504.2	3495.14	3503.62	12688.0
2013-06-18 15:00:00	NQ	Futures	3503.32	3503.62	3493.1	3497.19	20420.0
2013-06-18 16:00:00	NQ	Futures	3497.19	3499.23	3493.1	3498.36	5257.0
2013-06-18 17:00:00	NQ	Futures	3498.36	3500.11	3498.36	3499.82	61.0
2013-06-18 18:00:00	NQ	Futures	3498.94	3499.52	3497.19	3498.06	184.0
2013-06-18 19:00:00	NQ	Futures	3497.77	3498.65	3496.6	3496.89	66.0
2013-06-18 20:00:00	NQ	Futures	3497.19	3497.48	3495.73	3496.89	177.0
2013-06-18 21:00:00	NQ	Futures	3496.31	3497.19	3494.85	3496.31	247.0
2013-06-18 22:00:00	NQ	Futures	3496.31	3496.31	3491.93	3492.22	894.0
2013-06-18 23:00:00	NQ	Futures	3492.51	3493.68	3491.93	3493.1	502.0
2013-06-18 00:00:00	YM	Futures	15359.1	15365.2	15354.1	15360.1	273.0
2013-06-18 01:00:00	YM	Futures	15361.2	15377.4	15357.1	15376.4	315.0

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

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