PREVIEW / stock_30min / 2014-04-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-01.parquet
  size:    1.6 MB
  rows:    84,611
  symbols: 3,566

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
2014-04-01 04:30:00	AAPL	Stock	19.1854	19.1889	19.1854	19.1889	5600.0
2014-04-01 05:00:00	AAPL	Stock	19.1786	19.1786	19.1786	19.1786	2800.0
2014-04-01 06:30:00	AAPL	Stock	19.1786	19.1893	19.1786	19.1893	11760.0
2014-04-01 07:00:00	AAPL	Stock	19.1968	19.2143	19.1964	19.1964	113204.0
2014-04-01 07:30:00	AAPL	Stock	19.2014	19.2086	19.1964	19.2054	48300.0
2014-04-01 08:00:00	AAPL	Stock	19.2057	19.21	19.1964	19.2029	184940.0
2014-04-01 08:30:00	AAPL	Stock	19.2018	19.2321	19.1693	19.2321	260316.0
2014-04-01 09:00:00	AAPL	Stock	19.2257	19.2321	19.1968	19.23	442904.0
2014-04-01 09:30:00	AAPL	Stock	19.2136	19.2604	19.1804	19.1929	24385284.0
2014-04-01 10:00:00	AAPL	Stock	19.1893	19.2154	19.1704	19.1968	12683160.0
2014-04-01 10:30:00	AAPL	Stock	19.195	19.2379	19.1939	19.2296	10313520.0
2014-04-01 11:00:00	AAPL	Stock	19.2321	19.2429	19.1971	19.2286	12192180.0
2014-04-01 11:30:00	AAPL	Stock	19.2293	19.2821	19.2129	19.2629	16207660.0
2014-04-01 12:00:00	AAPL	Stock	19.2654	19.2743	19.2164	19.2677	10202444.0
2014-04-01 12:30:00	AAPL	Stock	19.2686	19.2782	19.2361	19.24	5592076.0
2014-04-01 13:00:00	AAPL	Stock	19.2379	19.2475	19.22	19.2446	3799572.0
2014-04-01 13:30:00	AAPL	Stock	19.2443	19.246	19.2221	19.2339	3202920.0
2014-04-01 14:00:00	AAPL	Stock	19.2343	19.2796	19.2343	19.2768	6440924.0
2014-04-01 14:30:00	AAPL	Stock	19.2789	19.2884	19.2518	19.2837	11461044.0
2014-04-01 15:00:00	AAPL	Stock	19.2836	19.2996	19.2554	19.2932	8567944.0
2014-04-01 15:30:00	AAPL	Stock	19.2946	19.3525	19.2768	19.3479	24008460.0
2014-04-01 16:00:00	AAPL	Stock	19.3473	19.355	19.2197	19.2699	18127816.0
2014-04-01 16:30:00	AAPL	Stock	19.3482	19.3546	19.3461	19.3532	233128.0
2014-04-01 17:00:00	AAPL	Stock	19.3532	19.355	19.2498	19.3536	96852.0
2014-04-01 17:30:00	AAPL	Stock	19.3536	19.3546	19.3486	19.3493	89432.0
2014-04-01 18:00:00	AAPL	Stock	19.3486	19.35	19.3482	19.3496	50260.0
2014-04-01 18:30:00	AAPL	Stock	19.3493	19.355	19.3486	19.355	59920.0
2014-04-01 19:00:00	AAPL	Stock	19.355	19.3568	19.355	19.3568	22400.0
2014-04-01 19:30:00	AAPL	Stock	19.3514	19.3554	19.3486	19.3486	185108.0
2014-04-01 07:00:00	MSFT	Stock	41.08	41.09	41.06	41.06	1054.0
2014-04-01 07:30:00	MSFT	Stock	41.07	41.07	41.07	41.07	100.0
2014-04-01 08:00:00	MSFT	Stock	41.09	41.19	40.92	41.19	18665.0
2014-04-01 08:30:00	MSFT	Stock	41.19	41.19	41.06	41.14	11014.0
2014-04-01 09:00:00	MSFT	Stock	41.13	41.14	41.06	41.14	41493.0
2014-04-01 09:30:00	MSFT	Stock	41.14	41.44	41.07	41.41	4292272.0
2014-04-01 10:00:00	MSFT	Stock	41.41	41.53	41.36	41.52	4146258.0
2014-04-01 10:30:00	MSFT	Stock	41.53	41.59	41.435	41.436	2908845.0
2014-04-01 11:00:00	MSFT	Stock	41.44	41.44	41.32	41.37	2471734.0
2014-04-01 11:30:00	MSFT	Stock	41.37	41.44	41.31	41.325	1226055.0
2014-04-01 12:00:00	MSFT	Stock	41.324	41.325	41.2	41.32	1362063.0
2014-04-01 12:30:00	MSFT	Stock	41.32	41.38	41.24	41.38	1041326.0
2014-04-01 13:00:00	MSFT	Stock	41.38	41.4	41.275	41.395	1190641.0
2014-04-01 13:30:00	MSFT	Stock	41.4	41.41	41.35	41.39	1263602.0
2014-04-01 14:00:00	MSFT	Stock	41.384	41.46	41.38	41.41	861587.0
2014-04-01 14:30:00	MSFT	Stock	41.415	41.455	41.385	41.44	1422556.0
2014-04-01 15:00:00	MSFT	Stock	41.445	41.45	41.28	41.33	2143342.0
2014-04-01 15:30:00	MSFT	Stock	41.33	41.44	41.232	41.41	5102866.0
2014-04-01 16:00:00	MSFT	Stock	41.42	41.42	41.33	41.38	1696218.0
2014-04-01 16:30:00	MSFT	Stock	41.38	41.42	41.35	41.38	8101.0
2014-04-01 17:00:00	MSFT	Stock	41.4	41.45	41.368	41.44	44539.0

> showing 50 of 84,611 rows — these rows as CSV

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