PREVIEW / stock_30min / 2013-03-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-21.parquet
  size:    1.5 MB
  rows:    78,187
  symbols: 3,462

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-03-21 04:00:00	AAPL	Stock	16.0707	16.0707	16.0707	16.0707	4200.0
2013-03-21 04:30:00	AAPL	Stock	16.0593	16.0593	16.0593	16.0593	2800.0
2013-03-21 05:30:00	AAPL	Stock	16.0718	16.0718	16.0718	16.0718	2800.0
2013-03-21 06:00:00	AAPL	Stock	16.0893	16.0893	16.0893	16.0893	8400.0
2013-03-21 07:00:00	AAPL	Stock	16.0729	16.1429	16.0729	16.1411	69188.0
2013-03-21 07:30:00	AAPL	Stock	16.1411	16.1607	16.1304	16.15	278180.0
2013-03-21 08:00:00	AAPL	Stock	16.1429	16.1536	16.1086	16.1321	568344.0
2013-03-21 08:30:00	AAPL	Stock	16.1375	16.1429	16.0929	16.1036	219604.0
2013-03-21 09:00:00	AAPL	Stock	16.0989	16.1064	16.0714	16.0821	825608.0
2013-03-21 09:30:00	AAPL	Stock	16.0793	16.23	16.075	16.1421	55952176.0
2013-03-21 10:00:00	AAPL	Stock	16.1475	16.1918	16.1029	16.1246	24694824.0
2013-03-21 10:30:00	AAPL	Stock	16.1268	16.1661	16.1036	16.1596	19656112.0
2013-03-21 11:00:00	AAPL	Stock	16.1604	16.1857	16.1357	16.1804	18228784.0
2013-03-21 11:30:00	AAPL	Stock	16.1803	16.1886	16.1564	16.1736	16244816.0
2013-03-21 12:00:00	AAPL	Stock	16.1739	16.1739	16.1361	16.1643	10069612.0
2013-03-21 12:30:00	AAPL	Stock	16.1682	16.3393	16.1604	16.3068	58290624.0
2013-03-21 13:00:00	AAPL	Stock	16.3071	16.3564	16.2868	16.2975	33732272.0
2013-03-21 13:30:00	AAPL	Stock	16.2982	16.3257	16.2593	16.2982	25839380.0
2013-03-21 14:00:00	AAPL	Stock	16.2939	16.2957	16.2082	16.2721	31180240.0
2013-03-21 14:30:00	AAPL	Stock	16.2725	16.2839	16.2314	16.2464	13234312.0
2013-03-21 15:00:00	AAPL	Stock	16.2489	16.2836	16.2079	16.2578	19612824.0
2013-03-21 15:30:00	AAPL	Stock	16.2586	16.2607	16.1247	16.1707	33412288.0
2013-03-21 16:00:00	AAPL	Stock	16.1689	16.301	16.1657	16.1714	9789612.0
2013-03-21 16:30:00	AAPL	Stock	16.1775	16.2546	16.1597	16.1786	380492.0
2013-03-21 17:00:00	AAPL	Stock	16.1786	16.1936	16.1689	16.185	199780.0
2013-03-21 17:30:00	AAPL	Stock	16.1796	16.1864	16.1793	16.1864	22400.0
2013-03-21 18:00:00	AAPL	Stock	16.1857	16.1868	16.1804	16.1857	84476.0
2013-03-21 18:30:00	AAPL	Stock	16.1857	16.301	16.1804	16.1825	1029364.0
2013-03-21 19:00:00	AAPL	Stock	16.1825	16.1879	16.1825	16.1825	95732.0
2013-03-21 19:30:00	AAPL	Stock	16.1825	16.1896	16.1825	16.1896	69972.0
2013-03-21 06:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	2000.0
2013-03-21 07:30:00	MSFT	Stock	28.18	28.18	28.18	28.18	2000.0
2013-03-21 08:00:00	MSFT	Stock	28.18	28.26	28.15	28.15	6338.0
2013-03-21 08:30:00	MSFT	Stock	28.15	28.15	28.15	28.15	1700.0
2013-03-21 09:00:00	MSFT	Stock	28.15	28.15	28.06	28.14	19500.0
2013-03-21 09:30:00	MSFT	Stock	28.09	28.36	28.06	28.36	3850721.0
2013-03-21 10:00:00	MSFT	Stock	28.35	28.36	28.11	28.16	3176145.0
2013-03-21 10:30:00	MSFT	Stock	28.165	28.2	28.12	28.17	1871164.0
2013-03-21 11:00:00	MSFT	Stock	28.17	28.22	28.13	28.15	2081671.0
2013-03-21 11:30:00	MSFT	Stock	28.15	28.21	28.14	28.18	1176212.0
2013-03-21 12:00:00	MSFT	Stock	28.182	28.19	28.11	28.12	1279011.0
2013-03-21 12:30:00	MSFT	Stock	28.12	28.18	28.115	28.15	1627834.0
2013-03-21 13:00:00	MSFT	Stock	28.14	28.15	28.11	28.12	1797712.0
2013-03-21 13:30:00	MSFT	Stock	28.11	28.12	28.07	28.095	2423305.0
2013-03-21 14:00:00	MSFT	Stock	28.09	28.15	28.05	28.12	3257249.0
2013-03-21 14:30:00	MSFT	Stock	28.117	28.12	28.08	28.105	1007238.0
2013-03-21 15:00:00	MSFT	Stock	28.11	28.19	28.1	28.175	2019916.0
2013-03-21 15:30:00	MSFT	Stock	28.175	28.18	28.1	28.11	4233751.0
2013-03-21 16:00:00	MSFT	Stock	28.11	28.153	28.09	28.104	3994316.0
2013-03-21 16:30:00	MSFT	Stock	28.11	28.532	28.11	28.13	82236.0

> showing 50 of 78,187 rows — these rows as CSV

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