PREVIEW / futures_30min / 2013-07-04

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-04.parquet
  size:    54 KB
  rows:    1,863

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-07-04 00:00:00	ES	Futures	1665.48	1665.48	1664.71	1665.48	345.0
2013-07-04 00:30:00	ES	Futures	1665.22	1666.77	1664.97	1666.77	1199.0
2013-07-04 01:00:00	ES	Futures	1666.77	1666.77	1664.71	1666.77	1231.0
2013-07-04 01:30:00	ES	Futures	1666.77	1667.29	1666.52	1667.03	974.0
2013-07-04 02:00:00	ES	Futures	1667.03	1668.84	1666.26	1666.26	4997.0
2013-07-04 02:30:00	ES	Futures	1666.26	1668.07	1666.0	1667.55	2300.0
2013-07-04 03:00:00	ES	Futures	1667.29	1669.62	1666.26	1669.36	11809.0
2013-07-04 03:30:00	ES	Futures	1669.36	1669.88	1668.33	1668.84	6022.0
2013-07-04 04:00:00	ES	Futures	1668.84	1669.36	1667.55	1668.58	4586.0
2013-07-04 04:30:00	ES	Futures	1668.58	1669.1	1668.07	1669.1	4060.0
2013-07-04 05:00:00	ES	Futures	1668.84	1669.62	1668.33	1668.84	3481.0
2013-07-04 05:30:00	ES	Futures	1668.58	1669.62	1668.07	1669.1	2267.0
2013-07-04 06:00:00	ES	Futures	1669.1	1669.62	1668.33	1669.1	2479.0
2013-07-04 06:30:00	ES	Futures	1669.1	1670.91	1668.84	1669.88	6509.0
2013-07-04 07:00:00	ES	Futures	1670.13	1672.72	1669.88	1671.43	8595.0
2013-07-04 07:30:00	ES	Futures	1671.17	1671.69	1669.36	1670.39	5235.0
2013-07-04 08:00:00	ES	Futures	1670.39	1672.2	1670.13	1671.94	7317.0
2013-07-04 08:30:00	ES	Futures	1671.69	1677.11	1670.65	1676.86	31071.0
2013-07-04 09:00:00	ES	Futures	1677.11	1679.7	1675.3	1676.34	21773.0
2013-07-04 09:30:00	ES	Futures	1676.6	1679.44	1676.08	1678.15	16784.0
2013-07-04 10:00:00	ES	Futures	1678.15	1678.67	1676.6	1676.86	8480.0
2013-07-04 10:30:00	ES	Futures	1676.6	1678.92	1676.34	1678.41	6226.0
2013-07-04 11:00:00	ES	Futures	1678.41	1679.44	1676.34	1678.92	10507.0
2013-07-04 18:00:00	ES	Futures	1678.92	1679.18	1676.86	1677.63	1793.0
2013-07-04 18:30:00	ES	Futures	1677.63	1678.67	1677.63	1678.15	531.0
2013-07-04 19:00:00	ES	Futures	1678.15	1678.41	1677.63	1677.63	415.0
2013-07-04 19:30:00	ES	Futures	1677.63	1678.67	1677.37	1677.37	1241.0
2013-07-04 20:00:00	ES	Futures	1677.37	1678.41	1677.37	1678.15	1317.0
2013-07-04 20:30:00	ES	Futures	1678.15	1678.15	1677.11	1677.37	800.0
2013-07-04 21:00:00	ES	Futures	1677.37	1678.92	1677.11	1678.92	2123.0
2013-07-04 21:30:00	ES	Futures	1678.67	1679.7	1678.41	1679.18	2180.0
2013-07-04 22:00:00	ES	Futures	1679.44	1679.44	1678.15	1678.67	972.0
2013-07-04 22:30:00	ES	Futures	1678.41	1678.92	1677.89	1678.67	1043.0
2013-07-04 23:00:00	ES	Futures	1678.67	1679.44	1678.41	1679.18	3142.0
2013-07-04 23:30:00	ES	Futures	1679.44	1679.44	1678.92	1679.18	413.0
2013-07-04 00:00:00	NQ	Futures	3440.49	3441.08	3439.91	3440.49	63.0
2013-07-04 00:30:00	NQ	Futures	3440.49	3442.54	3439.91	3442.54	107.0
2013-07-04 01:00:00	NQ	Futures	3442.25	3442.25	3438.74	3441.66	245.0
2013-07-04 01:30:00	NQ	Futures	3441.66	3442.54	3441.08	3441.95	142.0
2013-07-04 02:00:00	NQ	Futures	3441.95	3445.46	3441.95	3442.25	399.0
2013-07-04 02:30:00	NQ	Futures	3441.95	3443.42	3440.2	3443.12	227.0
2013-07-04 03:00:00	NQ	Futures	3443.42	3445.75	3439.32	3445.17	2217.0
2013-07-04 03:30:00	NQ	Futures	3445.75	3446.92	3443.71	3444.88	846.0
2013-07-04 04:00:00	NQ	Futures	3444.58	3446.34	3442.83	3444.29	641.0
2013-07-04 04:30:00	NQ	Futures	3444.0	3445.17	3442.83	3444.88	481.0
2013-07-04 05:00:00	NQ	Futures	3445.46	3446.05	3444.0	3445.46	493.0
2013-07-04 05:30:00	NQ	Futures	3445.46	3446.34	3444.0	3445.46	404.0
2013-07-04 06:00:00	NQ	Futures	3445.46	3447.51	3445.46	3447.21	354.0
2013-07-04 06:30:00	NQ	Futures	3447.21	3450.14	3446.92	3447.8	384.0
2013-07-04 07:00:00	NQ	Futures	3448.09	3452.77	3447.51	3450.72	714.0

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

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