PREVIEW / stock_30min / 2013-10-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-08.parquet
  size:    1.6 MB
  rows:    81,494
  symbols: 3,520

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-10-08 04:00:00	AAPL	Stock	17.4196	17.4196	17.4196	17.4196	2800.0
2013-10-08 06:00:00	AAPL	Stock	17.4021	17.425	17.4021	17.425	5600.0
2013-10-08 06:30:00	AAPL	Stock	17.4279	17.4279	17.4279	17.4279	2800.0
2013-10-08 07:00:00	AAPL	Stock	17.4286	17.4289	17.3929	17.4036	67200.0
2013-10-08 07:30:00	AAPL	Stock	17.4154	17.4439	17.4107	17.4439	171640.0
2013-10-08 08:00:00	AAPL	Stock	17.4511	17.5075	17.3929	17.4875	1058148.0
2013-10-08 08:30:00	AAPL	Stock	17.4814	17.4875	17.4643	17.4779	914284.0
2013-10-08 09:00:00	AAPL	Stock	17.4811	17.5064	17.4757	17.4843	942732.0
2013-10-08 09:30:00	AAPL	Stock	17.4875	17.5089	17.3968	17.4782	45580388.0
2013-10-08 10:00:00	AAPL	Stock	17.4768	17.5229	17.4107	17.4227	33603192.0
2013-10-08 10:30:00	AAPL	Stock	17.4271	17.4511	17.3086	17.33	35805420.0
2013-10-08 11:00:00	AAPL	Stock	17.3286	17.3382	17.2704	17.2768	23010876.0
2013-10-08 11:30:00	AAPL	Stock	17.2768	17.2768	17.1982	17.27	27308652.0
2013-10-08 12:00:00	AAPL	Stock	17.2693	17.27	17.1868	17.2114	16241652.0
2013-10-08 12:30:00	AAPL	Stock	17.2089	17.2668	17.1911	17.2536	11471796.0
2013-10-08 13:00:00	AAPL	Stock	17.2514	17.2764	17.2225	17.2368	10832388.0
2013-10-08 13:30:00	AAPL	Stock	17.2368	17.2536	17.1964	17.2054	8838116.0
2013-10-08 14:00:00	AAPL	Stock	17.2054	17.2379	17.1679	17.2093	14537068.0
2013-10-08 14:30:00	AAPL	Stock	17.2093	17.2227	17.1839	17.2125	7451108.0
2013-10-08 15:00:00	AAPL	Stock	17.2125	17.2482	17.1857	17.2343	13061216.0
2013-10-08 15:30:00	AAPL	Stock	17.2364	17.2393	17.1621	17.1789	24021424.0
2013-10-08 16:00:00	AAPL	Stock	17.1764	17.3185	17.1763	17.1764	7800044.0
2013-10-08 16:30:00	AAPL	Stock	17.1875	17.2521	17.1764	17.2429	1131676.0
2013-10-08 17:00:00	AAPL	Stock	17.2293	17.25	17.1764	17.2143	687288.0
2013-10-08 17:30:00	AAPL	Stock	17.215	17.23	17.2143	17.2143	45276.0
2013-10-08 18:00:00	AAPL	Stock	17.2289	17.2411	17.2193	17.2411	156800.0
2013-10-08 18:30:00	AAPL	Stock	17.2411	17.25	17.1764	17.25	663376.0
2013-10-08 19:00:00	AAPL	Stock	17.2436	17.2714	17.2429	17.2714	586852.0
2013-10-08 19:30:00	AAPL	Stock	17.2721	17.275	17.2596	17.2714	284452.0
2013-10-08 08:00:00	MSFT	Stock	33.31	33.42	33.31	33.35	5090.0
2013-10-08 08:30:00	MSFT	Stock	33.35	33.37	33.35	33.37	2200.0
2013-10-08 09:00:00	MSFT	Stock	33.37	33.42	33.34	33.34	74948.0
2013-10-08 09:30:00	MSFT	Stock	33.32	33.33	33.01	33.21	6816204.0
2013-10-08 10:00:00	MSFT	Stock	33.2	33.22	33.02	33.03	2191647.0
2013-10-08 10:30:00	MSFT	Stock	33.025	33.11	32.9	32.94	3179099.0
2013-10-08 11:00:00	MSFT	Stock	32.93	33.105	32.92	33.101	2591272.0
2013-10-08 11:30:00	MSFT	Stock	33.1	33.12	32.82	32.91	3234505.0
2013-10-08 12:00:00	MSFT	Stock	32.91	32.91	32.8	32.9	1515274.0
2013-10-08 12:30:00	MSFT	Stock	32.9	33.006	32.86	33.0	1750262.0
2013-10-08 13:00:00	MSFT	Stock	32.995	33.07	32.9	33.0	2230638.0
2013-10-08 13:30:00	MSFT	Stock	33.0	33.01	32.89	32.92	1366340.0
2013-10-08 14:00:00	MSFT	Stock	32.915	32.92	32.8	32.88	1769457.0
2013-10-08 14:30:00	MSFT	Stock	32.885	32.96	32.83	32.96	2230293.0
2013-10-08 15:00:00	MSFT	Stock	32.965	33.16	32.95	33.12	2960164.0
2013-10-08 15:30:00	MSFT	Stock	33.115	33.13	32.96	33.0	4602641.0
2013-10-08 16:00:00	MSFT	Stock	33.01	33.07	32.92	33.04	2271269.0
2013-10-08 16:30:00	MSFT	Stock	33.04	33.11	33.01	33.01	64566.0
2013-10-08 17:00:00	MSFT	Stock	33.03	33.05	33.01	33.05	98952.0
2013-10-08 17:30:00	MSFT	Stock	33.04	33.05	33.01	33.03	1625.0
2013-10-08 18:00:00	MSFT	Stock	33.02	33.05	33.02	33.05	500.0

> showing 50 of 81,494 rows — these rows as CSV

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