PREVIEW / stock_30min / 2013-12-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-04.parquet
  size:    1.6 MB
  rows:    82,303
  symbols: 3,535

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-12-04 04:00:00	AAPL	Stock	20.2771	20.2771	20.2771	20.2771	5600.0
2013-12-04 04:30:00	AAPL	Stock	20.2936	20.2936	20.2936	20.2936	7924.0
2013-12-04 05:30:00	AAPL	Stock	20.2986	20.2986	20.2986	20.2986	11088.0
2013-12-04 06:00:00	AAPL	Stock	20.3125	20.3125	20.3	20.3036	24080.0
2013-12-04 06:30:00	AAPL	Stock	20.3036	20.3118	20.2707	20.2757	98784.0
2013-12-04 07:00:00	AAPL	Stock	20.2757	20.3214	20.2646	20.3089	474432.0
2013-12-04 07:30:00	AAPL	Stock	20.3032	20.3386	20.2664	20.275	817152.0
2013-12-04 08:00:00	AAPL	Stock	20.275	20.3382	20.1679	20.2107	2057916.0
2013-12-04 08:30:00	AAPL	Stock	20.2114	20.2718	20.2114	20.2371	1283716.0
2013-12-04 09:00:00	AAPL	Stock	20.2371	20.2371	20.1893	20.1964	630588.0
2013-12-04 09:30:00	AAPL	Stock	20.1964	20.2143	20.0293	20.0725	63187964.0
2013-12-04 10:00:00	AAPL	Stock	20.0725	20.1661	20.05	20.1414	35311668.0
2013-12-04 10:30:00	AAPL	Stock	20.1414	20.3282	20.1321	20.3022	48271328.0
2013-12-04 11:00:00	AAPL	Stock	20.3014	20.3029	20.1632	20.1707	31848404.0
2013-12-04 11:30:00	AAPL	Stock	20.1664	20.1996	20.1514	20.1557	14661052.0
2013-12-04 12:00:00	AAPL	Stock	20.1557	20.1585	20.0814	20.1186	17962392.0
2013-12-04 12:30:00	AAPL	Stock	20.1209	20.1732	20.1054	20.1657	10556952.0
2013-12-04 13:00:00	AAPL	Stock	20.1661	20.1893	20.0832	20.0889	11107628.0
2013-12-04 13:30:00	AAPL	Stock	20.0877	20.0979	20.0446	20.08	16634716.0
2013-12-04 14:00:00	AAPL	Stock	20.08	20.1736	20.0751	20.1564	14481712.0
2013-12-04 14:30:00	AAPL	Stock	20.1568	20.1671	20.1221	20.1507	10395840.0
2013-12-04 15:00:00	AAPL	Stock	20.1486	20.1882	20.0968	20.1671	24930472.0
2013-12-04 15:30:00	AAPL	Stock	20.1711	20.2418	20.1661	20.1736	33688088.0
2013-12-04 16:00:00	AAPL	Stock	20.1786	20.2	20.08	20.1661	23997540.0
2013-12-04 16:30:00	AAPL	Stock	20.1779	20.2281	20.1607	20.1786	317268.0
2013-12-04 17:00:00	AAPL	Stock	20.1786	20.1864	20.1718	20.1729	82348.0
2013-12-04 17:30:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	276136.0
2013-12-04 18:00:00	AAPL	Stock	20.1786	20.1832	20.1664	20.1664	98196.0
2013-12-04 18:30:00	AAPL	Stock	20.1786	20.1786	20.1743	20.1743	11200.0
2013-12-04 19:00:00	AAPL	Stock	20.1696	20.1786	20.1607	20.1607	196560.0
2013-12-04 19:30:00	AAPL	Stock	20.1532	20.1607	20.1464	20.1575	111664.0
2013-12-04 05:00:00	MSFT	Stock	38.25	38.27	38.25	38.27	385.0
2013-12-04 07:00:00	MSFT	Stock	38.27	38.27	38.27	38.27	1000.0
2013-12-04 07:30:00	MSFT	Stock	38.27	38.27	38.26	38.26	482.0
2013-12-04 08:00:00	MSFT	Stock	38.24	38.24	38.16	38.21	9106.0
2013-12-04 08:30:00	MSFT	Stock	38.23	38.23	38.2	38.22	4880.0
2013-12-04 09:00:00	MSFT	Stock	38.21	38.24	38.18	38.23	23782.0
2013-12-04 09:30:00	MSFT	Stock	38.21	38.53	38.12	38.53	5810587.0
2013-12-04 10:00:00	MSFT	Stock	38.52	38.84	38.52	38.829	3987641.0
2013-12-04 10:30:00	MSFT	Stock	38.821	38.92	38.59	38.86	8277242.0
2013-12-04 11:00:00	MSFT	Stock	38.86	38.88	38.78	38.87	2188966.0
2013-12-04 11:30:00	MSFT	Stock	38.88	38.92	38.72	38.81	2941817.0
2013-12-04 12:00:00	MSFT	Stock	38.8	38.81	38.73	38.78	2414618.0
2013-12-04 12:30:00	MSFT	Stock	38.79	38.84	38.75	38.755	1379012.0
2013-12-04 13:00:00	MSFT	Stock	38.755	38.78	38.6	38.6	1886712.0
2013-12-04 13:30:00	MSFT	Stock	38.6	38.65	38.48	38.5	3518154.0
2013-12-04 14:00:00	MSFT	Stock	38.5	38.68	38.5	38.67	1977018.0
2013-12-04 14:30:00	MSFT	Stock	38.67	38.75	38.652	38.716	1896710.0
2013-12-04 15:00:00	MSFT	Stock	38.71	38.81	38.67	38.802	1978589.0
2013-12-04 15:30:00	MSFT	Stock	38.81	38.98	38.78	38.97	7306049.0

> showing 50 of 82,303 rows — these rows as CSV

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